From 1a162c3d3b8d489344845b7d22d9e7dbfaeb72e8 Mon Sep 17 00:00:00 2001
From: yanghui <2536613402@qq.com>
Date: 星期四, 20 十月 2022 15:44:44 +0800
Subject: [PATCH] #feat 修改双报道统计查询
---
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbCheckUnitMapper.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbCheckUnitMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbCheckUnitMapper.xml
index 9bfb651..8bcdfcc 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbCheckUnitMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbCheckUnitMapper.xml
@@ -145,7 +145,7 @@
) AS businessTotal,
(SELECT COUNT( m.id ) FROM com_pb_member m LEFT JOIN com_pb_check_unit as cpcu ON m.check_unit_id = cpcu.id WHERE m.audit_result = 1
<if test="communityIds != null and communityIds.size() >0">
- AND community_id IN
+ AND m.community_id IN
<foreach collection="communityIds" item="item" open="(" separator="," close=")">
#{item}
</foreach>
@@ -176,7 +176,7 @@
AND belong_to = temp.belong_to) AS businessTotal,
(SELECT COUNT( m.id ) FROM com_pb_member m LEFT JOIN com_pb_check_unit as cpcu ON m.check_unit_id = cpcu.id WHERE m.audit_result = 1
<if test="commonDto.communityIds != null and commonDto.communityIds.size() >0">
- AND community_id IN
+ AND m.community_id IN
<foreach collection="commonDto.communityIds" item="item" open="(" separator="," close=")">
#{item}
</foreach>
--
Gitblit v1.7.1