From 238cfba3051a28dd6908727e310d745b3c534dfe Mon Sep 17 00:00:00 2001 From: 101captain <237651143@qq.com> Date: 星期四, 16 十二月 2021 17:37:09 +0800 Subject: [PATCH] 12/16 大屏基础页面修改 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml index 124ead0..3af1a05 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml @@ -819,7 +819,7 @@ select ( SELECT count(*) FROM com_act_micro_wish AS camw LEFT JOIN com_act t1 on camw.community_id = t1.community_id where t1.area_code ='510423' and camw.STATUS = 6 ) microWish , (select count(user_id) from sys_user t LEFT JOIN com_act t1 on t.community_id = t1.community_id - where t.type=1 and t.community_id is not null and t.id_card is not null and t1.area_code ='510423') user, + where t.type=1 and t.community_id is not null and t1.area_code ='510423') user, (select count(id) from com_pb_org t LEFT JOIN com_act t1 on t.community_id = t1.community_id where parent_id = 0 and t1.area_code ='510423') partyOrg, (select count(id) from com_pb_member t LEFT JOIN com_act t1 on t.community_id = t1.community_id where audit_result = 1 and t1.area_code ='510423') partyMember, (select count(id) from com_mng_volunteer_mng t LEFT JOIN com_act t1 on t.community_id = t1.community_id where t.state = 2 and t1.area_code ='510423') volunteer, -- Gitblit v1.7.1