From d2baab8c43dca88365dac6e98a95ceee644001e2 Mon Sep 17 00:00:00 2001 From: 罗元桥 <2376770955@qq.com> Date: 星期四, 15 七月 2021 09:47:53 +0800 Subject: [PATCH] Merge branch 'test' into 'master' --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java | 155 ++++++++++++++++++++++++++++++++++++++++++++++----- 1 files changed, 140 insertions(+), 15 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 8d3a9bf..250b547 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 @@ -5,22 +5,23 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; +import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.google.common.base.Joiner; import com.google.common.collect.Lists; -import com.panzhihua.common.enums.PopulCultureLevelEnum; -import com.panzhihua.common.enums.PopulHouseUseEnum; -import com.panzhihua.common.enums.PopulIsOksEnum; -import com.panzhihua.common.enums.PopulMarriageEnum; +import com.panzhihua.common.enums.*; import com.panzhihua.common.exceptions.ServiceException; import com.panzhihua.common.model.dtos.community.*; +import com.panzhihua.common.model.dtos.community.bigscreen.BigScreenEventDTO; import com.panzhihua.common.model.dtos.community.bigscreen.BigScreenEventDetailDTO; import com.panzhihua.common.model.dtos.grid.PageComMngPopulationDTO; import com.panzhihua.common.model.dtos.grid.PagePopulationListDTO; import com.panzhihua.common.model.dtos.grid.admin.ComMngPopulationExportDTO; import com.panzhihua.common.model.dtos.grid.admin.ComMngPopulationListDTO; +import com.panzhihua.common.model.dtos.grid.admin.ComMngPopulationSubordinateDTO; +import com.panzhihua.common.model.dtos.grid.admin.PageComMngVillagePopulationDTO; import com.panzhihua.common.model.dtos.user.PageInputUserDTO; import com.panzhihua.common.model.helper.AESUtil; import com.panzhihua.common.model.vos.R; @@ -35,10 +36,14 @@ import com.panzhihua.common.model.vos.community.screen.index.*; import com.panzhihua.common.model.vos.grid.*; import com.panzhihua.common.model.vos.grid.admin.ComMngPopulationListVO; +import com.panzhihua.common.model.vos.grid.admin.ComMngPopulationVillageVO; +import com.panzhihua.common.model.vos.grid.admin.ComMngSubordinateVO; +import com.panzhihua.common.model.vos.grid.admin.excel.ComMngPopulationExportExcelVO; import com.panzhihua.common.model.vos.screen.ComActPopulationCultureVO; import com.panzhihua.common.model.vos.screen.ComActPopulationScreenVO; import com.panzhihua.common.model.vos.screen.ComMngPopulationAgeVO; import com.panzhihua.common.model.vos.user.*; +import com.panzhihua.common.model.vos.user.ComMngUserTagVO; import com.panzhihua.common.utlis.AgeUtils; import com.panzhihua.common.utlis.DateUtils; import com.panzhihua.common.utlis.Snowflake; @@ -47,6 +52,7 @@ import com.panzhihua.service_community.model.dos.*; import com.panzhihua.service_community.service.ComMngPopulationHouseUserService; import com.panzhihua.service_community.service.ComMngPopulationService; +import com.panzhihua.service_community.service.ComMngVillageService; import com.panzhihua.service_community.service.EventResourceService; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Value; @@ -57,10 +63,7 @@ import javax.annotation.Resource; import java.math.BigDecimal; -import java.util.ArrayList; -import java.util.Date; -import java.util.List; -import java.util.Map; +import java.util.*; import java.util.stream.Collectors; /** @@ -90,8 +93,11 @@ private EventResourceService eventResourceService; @Resource private BigScreenDAO bigScreenDAO; + @Resource + private ComMngUserTagDAO comMngUserTagDAO; @Value("${domain.aesKey:}") private String aesKey; + /** @@ -775,6 +781,62 @@ } } + @Override + public R specialInputUserTags(PageInputUserDTO comMngUserTagDTO) { + IPage<ComMngTagVO> iPage = populationDAO.specialInputUserTags(new Page<>(comMngUserTagDTO.getPageNum() + , comMngUserTagDTO.getPageSize()), comMngUserTagDTO); + return R.ok(iPage); + } + + @Override + public R saveSpecialInputUserTags(ComMngTagVO comMngTagVO) { + if (null != comMngTagVO.getId() && comMngTagVO.getId() != 0) { + //修改 + ComMngUserTagDO comMngUserTagDO = comMngUserTagDAO.selectById(comMngTagVO.getId()); + if (null == comMngUserTagDO) { + return R.fail("该标签不存在"); + } + ComMngUserTagDO checkCreditCode = comMngUserTagDAO.selectOne(new QueryWrapper<ComMngUserTagDO>().lambda().eq(ComMngUserTagDO::getTagName, comMngTagVO.getTagName())); + if (null != checkCreditCode && comMngUserTagDO.getId() != checkCreditCode.getId()) { + return R.fail("该标签已存在,标签名称重复"); + } + + BeanUtils.copyProperties(comMngTagVO, comMngUserTagDO); + int update = comMngUserTagDAO.updateById(comMngUserTagDO); + if (update > 0) { + return R.ok(); + } + } else { + //新增 + Integer count = comMngUserTagDAO.selectCount(new QueryWrapper<ComMngUserTagDO>().lambda().eq(ComMngUserTagDO::getTagName, comMngTagVO.getTagName())); + if (count > 0) { + return R.fail("该标签已存在,标签名称重复"); + } + ComMngUserTagDO comMngUserTagDO = new ComMngUserTagDO(); + BeanUtils.copyProperties(comMngTagVO, comMngUserTagDO); + int insert = comMngUserTagDAO.insert(comMngUserTagDO); + if (insert > 0) { + return R.ok(); + } + } + + return R.fail("添加失败"); + } + + @Override + public R deleteSpecialInputUserTags(Long id) { + //查询特殊群体人员 + ComMngUserTagDO comMngUserTagDO = comMngUserTagDAO.selectById(id); + if (comMngUserTagDO == null) { + return R.fail("该标签不存在"); + } + int delete = comMngUserTagDAO.deleteById(id); + if (delete > 0) { + return R.ok(); + } + return R.fail("删除失败"); + } + /** * 查询实有人口电子档信息 * @@ -1018,24 +1080,26 @@ /** * 事件大屏统计接口 * - * @param communityId 社区id + * @param screenEventDTO 请求参数 * @return 统计结果 */ @Override - public R getScreenEvent(Long communityId) { + public R getScreenEvent(BigScreenEventDTO screenEventDTO) { + + Long communityId = screenEventDTO.getCommunityId(); //创建统计返回参数 EventStatisticsVO statisticsVO = new EventStatisticsVO(); //查询页面左边数据 EventLeftStatisticsVO leftStatisticsVO = new EventLeftStatisticsVO(); //查询左上数据 - EventLeftTopStatisticsVO leftTopStatisticsVO = this.baseMapper.getEventScreenLeftTop(communityId); + EventLeftTopStatisticsVO leftTopStatisticsVO = this.baseMapper.getEventScreenLeftTop(screenEventDTO); //查询时间频发月份 List<Integer> monthList = this.baseMapper.getFrequentlyEventMonth(communityId); leftTopStatisticsVO.setOftenMonth(monthList); leftStatisticsVO.setLeftTopStatisticsVO(leftTopStatisticsVO); //查询左下数据 - EventLeftDownStatisticsVO leftDownStatisticsVO = this.baseMapper.getEventScreenLeftDown(communityId); + EventLeftDownStatisticsVO leftDownStatisticsVO = this.baseMapper.getEventScreenLeftDown(screenEventDTO); leftStatisticsVO.setLeftDownStatisticsVO(leftDownStatisticsVO); statisticsVO.setLeftStatisticsVO(leftStatisticsVO); @@ -1085,7 +1149,7 @@ statisticsVO.setGridStatisticsList(gridStatisticsList); //查询社区事件列表 - List<EventGridIncidentStatisticsVO> gridIncidentList = this.baseMapper.getEventScreenEventList(communityId); + List<EventGridIncidentStatisticsVO> gridIncidentList = this.baseMapper.getEventScreenEventList(screenEventDTO); statisticsVO.setGridIncidentList(gridIncidentList); //查询小区列表 @@ -1647,14 +1711,75 @@ } /** - * 综治后台-居民导出 + * 综治后台-居民导出查询居民数据 * @param populationExportDTO 请求参数 * @return 导出结果 */ @Override public R getGridPopulationExport(ComMngPopulationExportDTO populationExportDTO){ + //结果集 + List<ComMngPopulationExportExcelVO> resultPopulationList = new ArrayList<>(); + //查询人口信息 + List<ComMngPopulationListVO> populationListVOList = this.baseMapper.getGridPopulationAdminLists(populationExportDTO); + if(!populationListVOList.isEmpty()){ + populationListVOList.forEach(population -> { + ComMngPopulationExportExcelVO populationExportExcelVO = new ComMngPopulationExportExcelVO(); + BeanUtils.copyProperties(population,populationExportExcelVO); + if(population.getSex() != null){ + populationExportExcelVO.setSex(PopulSexEnum.getCnDescByName(population.getSex())); + } + if(population.getPoliticalOutlook() != null){ + populationExportExcelVO.setPoliticalOutlook(PopulPoliticalOutlookEnum.getCnDescByName(population.getPoliticalOutlook())); + } + if(population.getIsHouse() != null){ + if(!population.getIsHouse().equals(0L)){ + populationExportExcelVO.setIsHouse("是"); + }else{ + populationExportExcelVO.setIsHouse("否"); + } + } + if(population.getEventStatus() != null){ + populationExportExcelVO.setEventStatus(EventStatusEnum.getCnDescByName(population.getEventStatus())); + } + try { + Integer age = IdcardUtil.getAgeByIdCard(population.getCardNo()); + populationExportExcelVO.setAge(age); + }catch (Exception e){ + log.error("当前人口身份证获取年龄失败,实有人口id:" + population.getId()); + } + resultPopulationList.add(populationExportExcelVO); + }); + } + return R.ok(resultPopulationList); + } - return R.ok(); + /** + * 综治后台-居民管理小区列表 + * @param name 小区名字 + * @return 小区列表 + */ + @Override + public R relationVillage(String name){ + List<ComMngPopulationVillageVO> populationVillageList = new ArrayList<>(); + QueryWrapper<ComMngVillageDO> villageQuery = new QueryWrapper<>(); + if(StringUtils.isNotEmpty(name)){ + villageQuery.lambda().like(ComMngVillageDO::getName,name); + } + + List<ComMngVillageDO> villageList = comActVillageDAO.selectList(villageQuery); + if(!villageList.isEmpty()){ + villageList.forEach(village -> { + ComMngPopulationVillageVO populationVillageVO = new ComMngPopulationVillageVO(); + BeanUtils.copyProperties(village,populationVillageVO); + populationVillageList.add(populationVillageVO); + }); + } + return R.ok(populationVillageList); + } + + @Override + public R getVillagePopulationAdmin(PageComMngVillagePopulationDTO villagePopulationDTO){ + return R.ok(this.baseMapper.getVillagePopulationAdmin(new Page(villagePopulationDTO.getPageNum(),villagePopulationDTO.getPageSize()),villagePopulationDTO)); } } \ No newline at end of file -- Gitblit v1.7.1