From 09a642d4f352bf8e80b071854314b0a99d427ee2 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期四, 27 十月 2022 10:48:10 +0800
Subject: [PATCH] 修改导办人员办结数量统计问题 图片上传9张报错 bug
---
flower_city/src/main/resources/application.properties | 2 --
flower_city/src/main/resources/mapper/SysUserMapper.xml | 3 ++-
2 files changed, 2 insertions(+), 3 deletions(-)
diff --git a/flower_city/src/main/resources/application.properties b/flower_city/src/main/resources/application.properties
index 2bbe9df..9cf2488 100644
--- a/flower_city/src/main/resources/application.properties
+++ b/flower_city/src/main/resources/application.properties
@@ -1,8 +1,6 @@
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=nahanMysqlPwd&&RemoteRemote2019nahan
-#spring.datasource.url=jdbc:mysql://10.8.0.74:3306/flower_city_automessage?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&allowMultiQueries=true&serverTimezone=GMT%2B8
-#spring.datasource.url=jdbc:mysql://localhost:3306/flower_city_automessage?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&allowMultiQueries=true&serverTimezone=GMT%2B8
#spring.datasource.url=jdbc:mysql://10.8.0.74:3306/huacheng_smart_life?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&allowMultiQueries=true&serverTimezone=GMT%2B8
spring.datasource.url=jdbc:mysql://182.151.2.19:3306/huacheng_smart_life?allowMultiQueries=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8
diff --git a/flower_city/src/main/resources/mapper/SysUserMapper.xml b/flower_city/src/main/resources/mapper/SysUserMapper.xml
index e490200..26f14f5 100644
--- a/flower_city/src/main/resources/mapper/SysUserMapper.xml
+++ b/flower_city/src/main/resources/mapper/SysUserMapper.xml
@@ -98,7 +98,8 @@
(select user_name from automessage_sys_user where automessage_sys_user.user_id=create_by) as createName,
transaction_num,
(select count(id) from automessage_guide_repair_order where automessage_guide_repair_order.state='3'
- and automessage_guide_repair_order.guide_user_id=user_id) as transactionEndNum,
+ and automessage_guide_repair_order.guide_user_id=user_id and
+ automessage_guide_repair_order.guide_department_id=automessage_sys_user.department_id) as transactionEndNum,
(select role_name from automessage_role_management where automessage_role_management.id=role_ids) as roleName,
(select permission from automessage_role_management where automessage_role_management.id=role_ids) as permission,
(select organization_name from automessage_organization_chart where automessage_sys_user.department_id=automessage_organization_chart.id) as department_name
--
Gitblit v1.7.1