springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java
@@ -7829,29 +7829,28 @@ if (userTag != null) { if (userTag.getSysFlag().equals(0)) { Integer count = comMngPopulationDAO.getSpecialStatisticsByLabel(userTag.getTagName(),communityId); otherSpecialVO.setSum(otherSpecialVO.getSum() + count); otherSpecialVO.setPercent(otherSpecialVO.getSum()*100/countAll); IndexSpecialStatisticsVO specialStatisticsVO = new IndexSpecialStatisticsVO(); otherSpecialVO.setSum(otherSpecialVO.getSum()+count); specialStatisticsVO.setTitle(userTag.getTagName()); specialStatisticsVO.setSum(count); specialStatisticsVO.setPercent(specialStatisticsVO.getSum()*100/countAll); specialStatisticsVOList.add(specialStatisticsVO); } else { if (StringUtils.isNotEmpty(userTag.getTagName())) { if (userTag.getTagName().equals("高龄老人")) { IndexSpecialStatisticsVO specialStatisticsVO = new IndexSpecialStatisticsVO(); specialStatisticsVO.setTitle(userTag.getTagName()); specialStatisticsVO.setSum(comMngPopulationDAO.getStatisticsCount(communityId)); specialStatisticsVO.setPercent(specialStatisticsVO.getSum()*100/countAll); specialStatisticsVOList.add(specialStatisticsVO); } else { IndexSpecialStatisticsVO specialStatisticsVO = new IndexSpecialStatisticsVO(); specialStatisticsVO.setTitle(userTag.getTagName()); Integer count = comMngPopulationDAO.getSpecialStatisticsByLabel(userTag.getTagName(),communityId); otherSpecialVO.setSum(otherSpecialVO.getSum()+count); specialStatisticsVO.setSum(count); specialStatisticsVO.setPercent(specialStatisticsVO.getSum()*100/countAll); specialStatisticsVOList.add(specialStatisticsVO); } } } } }); } otherSpecialVO.setSum(countAll-otherSpecialVO.getSum()); otherSpecialVO.setPercent(otherSpecialVO.getSum()*100/countAll); specialStatisticsVOList.add(otherSpecialVO); indexInfo.setSpecialStatisticsVOList(specialStatisticsVOList); // 查询网格化治理 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml
@@ -1057,8 +1057,8 @@ IFNULL((select count(id) from com_mng_real_company where community_id = cmpct.community_id),0) as company, IFNULL((select count(DISTINCT `name`) from com_mng_village where community_id = cmpct.community_id),0) as village, IFNULL((select count(user_id) from sys_user where community_id = cmpct.community_id and type=1),0) as user, IFNULL((select count(id) from com_pb_member where community_id = cmpct.community_id ),0) as partyMember, IFNULL((select count(user_id) from sys_user where community_id = cmpct.community_id and is_volunteer=1 and type=1),0) as volunteer, IFNULL((select count(id) from com_pb_member where community_id = cmpct.community_id and audit_result =1 ),0) as partyMember, IFNULL((select count(id) from com_mng_volunteer_mng where community_id = cmpct.community_id and state=2 ),0) as volunteer, IFNULL((select count(id) from com_pb_org where community_id = cmpct.community_id and parent_id = 0),0) as partyOrg from com_mng_population_community_tags AS cmpct where cmpct.community_id = #{communityId} @@ -1068,7 +1068,7 @@ SELECT count( id ) AS microWish, IFNULL(( SELECT count( id ) FROM com_act_easy_photo WHERE status = 4 AND community_id = camw.community_id ),0) AS easyPhoto, IFNULL(( SELECT count( id ) FROM com_pb_activity WHERE STATUS = 5 AND community_id = camw.community_id ),0) AS partyActivity, IFNULL(( SELECT count( id ) FROM com_act_questnaire WHERE community_id = camw.community_id ),0) AS questionnaire, IFNULL(( SELECT count( id ) FROM com_act_questnaire WHERE community_id = camw.community_id and is_hide=0 ),0) AS questionnaire, IFNULL(( SELECT count( id ) FROM com_act_dyn WHERE community_id = camw.community_id AND STATUS = 1 ),0) AS dynamic, IFNULL(( SELECT count( id ) FROM com_convenient_merchants WHERE community_id = camw.community_id AND is_del = 0 ),0) AS convenient, IFNULL(( SELECT count( id ) FROM com_act_neighbor_circle WHERE community_id = camw.community_id AND is_del = 2 ),0) AS neighbor
