From d04f9a82df7a0e0531a57368ba44aef233b72e7d Mon Sep 17 00:00:00 2001 From: 101captain <237651143@qq.com> Date: 星期二, 21 十二月 2021 17:27:59 +0800 Subject: [PATCH] 12/21 大屏临时修改 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java | 70 ++++++++++++++++++++++++++++++++++- 1 files changed, 68 insertions(+), 2 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java index ff6f552..749729e 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java @@ -9,8 +9,10 @@ import com.baomidou.mybatisplus.core.conditions.Wrapper; import com.baomidou.mybatisplus.core.conditions.segments.MergeSegments; +import com.panzhihua.common.model.vos.community.bigscreen.WestScreenStatics; import com.panzhihua.common.model.vos.community.screen.civil.*; import com.panzhihua.common.utlis.*; +import com.panzhihua.service_community.util.WxDataUtil; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Value; import org.springframework.context.annotation.Bean; @@ -7041,7 +7043,7 @@ // 查询特殊人群统计 List<IndexSpecialStatisticsVO> specialStatisticsVOList = new ArrayList<>(); - // 查询特殊人群标签列表 + //查询特殊人群标签列表 List<ComMngUserTagVO> userTagList = comMngPopulationDAO.getUserTagListByCommunityId(communityId); IndexSpecialStatisticsVO otherSpecialVO = new IndexSpecialStatisticsVO(); otherSpecialVO.setTitle("其他"); @@ -7125,6 +7127,27 @@ // 查询小区列表 List<CivilVillageStatisticsVO> villageStatisticsList = this.baseMapper.getCivilScreenVillageList(communityId); +// villageStatisticsList.forEach(civilVillageStatisticsVO -> { +// civilVillageStatisticsVO.setUserSum(comMngPopulationDAO.selectCount(new QueryWrapper<ComMngPopulationDO>().lambda().eq(ComMngPopulationDO::getVillageId,civilVillageStatisticsVO.getVillageId()))); +// List<IndexSpecialStatisticsVO> specialStatisticsVOS = new ArrayList<>(); +// IndexSpecialStatisticsVO otherSpecial = new IndexSpecialStatisticsVO(); +// otherSpecial.setTitle("其他"); +// otherSpecial.setSum(0); +// // 查询特殊人群标签列表 +// List<ComMngUserTagVO> userTagVOS = comMngPopulationDAO.getUserTagListByCommunityId(communityId); +// +// userTagVOS.forEach(comMngUserTagVO -> { +// Integer count=comMngPopulationDAO.selectCountByVillageId(civilVillageStatisticsVO.getVillageId(),comMngUserTagVO.getTagName()); +// IndexSpecialStatisticsVO indexSpecialStatisticsVO=new IndexSpecialStatisticsVO(); +// indexSpecialStatisticsVO.setTitle(comMngUserTagVO.getTagName()); +// indexSpecialStatisticsVO.setSum(count); +// otherSpecial.setSum(otherSpecial.getSum()+count); +// specialStatisticsVOS.add(indexSpecialStatisticsVO); +// }); +// otherSpecial.setSum(civilVillageStatisticsVO.getUserSum()-otherSpecial.getSum()); +// specialStatisticsVOS.add(otherSpecial); +// civilVillageStatisticsVO.setSpecialStatisticsList(specialStatisticsVOS); +// }); civilStatisticsVO.setVillageStatisticsList(villageStatisticsList); //查询党建引领数据 @@ -7143,7 +7166,10 @@ civilStatisticsVO.setCivilGridStatisticsVO(civilGrid); } //查询便民服务数据 - + CivilConvenienceStatisticsVO civilConvenience = this.baseMapper.getCivilConvenience(communityId); + if(civilConvenience != null){ + civilStatisticsVO.setCivilConvenienceStatisticsVO(civilConvenience); + } return R.ok(civilStatisticsVO); } @@ -7714,6 +7740,46 @@ return R.ok(this.comMngPopulationDAO.specialInputUserExport(pageInputUserDTO)); } + @Override + public R westScreenStatics() { + WestScreenStatics westScreenStatics=this.comMngPopulationDAO.westScreenStatics(); + WxDataUtil wxDataUtil=new WxDataUtil(); + westScreenStatics.setDayUser(wxDataUtil.getDayUser()); + westScreenStatics.setCountUser(wxDataUtil.getMonthUser()); + return R.ok(westScreenStatics); + } + + @Override + public R getComprehensivePopulationStatics(Long streetId){ + EventPopulationStatisticsVO statisticsVo = new EventPopulationStatisticsVO(); + //查询人口数据 + List<EventPopulationBasicsStatisticsVO> basicsList = comMngPopulationDAO.getBasicsList(streetId); + if(basicsList != null){ + for (EventPopulationBasicsStatisticsVO basics : basicsList) { + statisticsVo.setPopulationNum(statisticsVo.getPopulationNum() + basics.getPopulationNum()); + statisticsVo.setVillageNum(statisticsVo.getVillageNum() + basics.getVillageNum()); + statisticsVo.setHouseNum(statisticsVo.getHouseNum() + basics.getHouseNum()); + } + statisticsVo.setBasicsList(basicsList); + } + //查询特殊人群数据 + EventPopulationSpecialStatisticsVO populationSpecial = comMngPopulationDAO.getPopulationSpecial(streetId); + if(populationSpecial != null){ + populationSpecial.setOtherTotal(populationSpecial.getZjTotal() + populationSpecial.getSfTotal() + + populationSpecial.getXsTotal() + populationSpecial.getXjTotal() + + populationSpecial.getJzTotal() + populationSpecial.getXdTotal()); + populationSpecial.setLnTotal(comMngPopulationDAO.getPopulationAge(streetId,60)); + populationSpecial.setGlTotal(comMngPopulationDAO.getPopulationAge(streetId,80)); + statisticsVo.setSpecialStatisticsVo(populationSpecial); + } + return R.ok(statisticsVo); + } + + @Override + public R getComprehensiveStreetList(){ + return R.ok(comMngPopulationDAO.getComprehensiveStreetList()); + } + private void setMistake(ComMngPopulationMistakeExcelVO mvo, ComMngPopulationServeExcelVO vo) { mvo.setPoliticalOutlook(PopulPoliticalOutlookEnum.getCnDescByName(vo.getPoliticalOutlook())); mvo.setIsRent(PopulHouseUseEnum.getCnDescByName(vo.getIsRent())); -- Gitblit v1.7.1