springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/bigscreen/BigScreenGridStaticsReturn.java
New file @@ -0,0 +1,17 @@ package com.panzhihua.common.model.vos.community.bigscreen; import lombok.Data; import java.util.List; /** * @author zzj */ @Data public class BigScreenGridStaticsReturn { private Integer count; private Integer num; private Integer percent; private String title; private List<BigScreenGridStaticsReturn> bigScreenGridStaticsReturnList; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/bigscreen/BigscreenGridsGovernanceStatisticsVO.java
New file @@ -0,0 +1,55 @@ package com.panzhihua.common.model.vos.community.bigscreen; import com.panzhihua.common.model.vos.community.StatisticsCommVO; import com.panzhihua.common.model.vos.community.screen.civil.CivilVillageStatisticsVO; import com.panzhihua.common.model.vos.community.screen.event.EventGridIncidentStatisticsVO; import com.panzhihua.common.model.vos.community.screen.event.EventGridStatisticsVO; import com.panzhihua.common.model.vos.screen.ScreenDrawEventPopulationTotalVO; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.List; /** * @title: GridsGovernanceStatisticsVO * @projectName: 成都呐喊信息技术有限公司-智慧社区项目 * @description: 清网治格统计信息 * @author: hans * @date: 2021/12/08 14:38 */ @Data @ApiModel("清网治格统计信息") public class BigscreenGridsGovernanceStatisticsVO { @ApiModelProperty("事件总数") private Integer eventTotal = 0; @ApiModelProperty("突发事件报告总数") private Integer eventTFTotal = 0; @ApiModelProperty("治安防控事件总数") private Integer eventZATotal = 0; @ApiModelProperty("矛盾劝解事件总数") private Integer eventMDTotal = 0; @ApiModelProperty("特殊人群服务事件总数") private Integer eventTSTotal = 0; @ApiModelProperty("民生服务事件总数") private Integer eventMSTotal = 0; @ApiModelProperty("防灾减灾事件总数") private Integer eventFJTotal = 0; @ApiModelProperty("法规宣传事件总数") private Integer eventFGTotal = 0; @ApiModelProperty("安全巡查") private Integer safety=0; @ApiModelProperty("其他事件总数") private Integer otherTotal = 0; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/bigscreen/IndexInfo.java
@@ -27,4 +27,6 @@ private IndexReserve indexReserve; @ApiModelProperty("业务统计") private IndexDynamic indexDynamic; @ApiModelProperty("杨戬要求修改") private BigScreenGridStaticsReturn bigScreenGridStaticsReturn; } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java
@@ -6,6 +6,7 @@ import com.panzhihua.common.model.dtos.community.easyPhoto.ExportEasyPhotoDTO; import com.panzhihua.common.model.vos.community.ComActEasyPhotoVO; import com.panzhihua.common.model.vos.community.TodoEventsVO; import com.panzhihua.common.model.vos.community.bigscreen.BigscreenGridsGovernanceStatisticsVO; import com.panzhihua.common.model.vos.community.bigscreen.GridsGovernanceStatisticsVO; import com.panzhihua.common.model.vos.community.bigscreen.ResidentAutonomyStatisticsVO; import com.panzhihua.common.model.vos.community.easyPhoto.BannerVO; @@ -381,4 +382,9 @@ * @return */ GridsGovernanceStatisticsVO selectGridsGovernance(@Param("communityId") Long communityId); /** * 首页大屏获取网格统计数据 */ BigscreenGridsGovernanceStatisticsVO selectBigscreenGridsGovern(@Param("communityId")Long communityId); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java
@@ -133,6 +133,8 @@ private ComActReserveMapper comActReserveMapper; @Value("${domain.aesKey:}") private String aesKey; @Resource private ComActEasyPhotoDAO comActEasyPhotoDAO; /** * 新增实有人口 @@ -7830,6 +7832,8 @@ indexReserve.setIndexHomeQuarantine(indexHomeQuarantine); indexInfo.setIndexReserve(indexReserve); BigscreenGridsGovernanceStatisticsVO bigscreenGridsGovernanceStatisticsVO=comActEasyPhotoDAO.selectBigscreenGridsGovern(communityId); indexInfo.setBigScreenGridStaticsReturn(setData(bigscreenGridsGovernanceStatisticsVO)); return R.ok(indexInfo); } @@ -8074,4 +8078,58 @@ return ObjectUtils.isEmpty(hashMap.get(key)); } private BigScreenGridStaticsReturn setData(BigscreenGridsGovernanceStatisticsVO bigscreenGridsGovernanceStatisticsVO){ List<BigScreenGridStaticsReturn> bigScreenGridStaticsReturnList=new ArrayList<>(); BigScreenGridStaticsReturn bigScreenGridStaticsReturn=new BigScreenGridStaticsReturn(); bigScreenGridStaticsReturn.setCount(bigscreenGridsGovernanceStatisticsVO.getEventTotal()+bigscreenGridsGovernanceStatisticsVO.getOtherTotal()+bigscreenGridsGovernanceStatisticsVO.getSafety()); BigScreenGridStaticsReturn bigScreenGridStaticsReturn1=new BigScreenGridStaticsReturn(); bigScreenGridStaticsReturn1.setTitle("突发事件报告"); bigScreenGridStaticsReturn1.setNum(bigscreenGridsGovernanceStatisticsVO.getEventTFTotal()); bigScreenGridStaticsReturn1.setPercent(bigscreenGridsGovernanceStatisticsVO.getEventTFTotal()*100/bigScreenGridStaticsReturn.getCount()); bigScreenGridStaticsReturnList.add(bigScreenGridStaticsReturn1); BigScreenGridStaticsReturn bigScreenGridStaticsReturn2=new BigScreenGridStaticsReturn(); bigScreenGridStaticsReturn2.setTitle("特殊人群服务"); bigScreenGridStaticsReturn2.setNum(bigscreenGridsGovernanceStatisticsVO.getEventTSTotal()); bigScreenGridStaticsReturn2.setPercent(bigscreenGridsGovernanceStatisticsVO.getEventTSTotal()*100/bigScreenGridStaticsReturn.getCount()); bigScreenGridStaticsReturnList.add(bigScreenGridStaticsReturn2); BigScreenGridStaticsReturn bigScreenGridStaticsReturn3=new BigScreenGridStaticsReturn(); bigScreenGridStaticsReturn3.setTitle("治安防控"); bigScreenGridStaticsReturn3.setNum(bigscreenGridsGovernanceStatisticsVO.getEventZATotal()); bigScreenGridStaticsReturn3.setPercent(bigscreenGridsGovernanceStatisticsVO.getEventZATotal()*100/bigScreenGridStaticsReturn.getCount()); bigScreenGridStaticsReturnList.add(bigScreenGridStaticsReturn3); BigScreenGridStaticsReturn bigScreenGridStaticsReturn4=new BigScreenGridStaticsReturn(); bigScreenGridStaticsReturn4.setTitle("民生服务"); bigScreenGridStaticsReturn4.setNum(bigscreenGridsGovernanceStatisticsVO.getEventMSTotal()); bigScreenGridStaticsReturn4.setPercent(bigscreenGridsGovernanceStatisticsVO.getEventMSTotal()*100/bigScreenGridStaticsReturn.getCount()); bigScreenGridStaticsReturnList.add(bigScreenGridStaticsReturn4); BigScreenGridStaticsReturn bigScreenGridStaticsReturn5=new BigScreenGridStaticsReturn(); bigScreenGridStaticsReturn5.setTitle("矛盾劝解"); bigScreenGridStaticsReturn5.setNum(bigscreenGridsGovernanceStatisticsVO.getEventMDTotal()); bigScreenGridStaticsReturn5.setPercent(bigscreenGridsGovernanceStatisticsVO.getEventMDTotal()*100/bigScreenGridStaticsReturn.getCount()); bigScreenGridStaticsReturnList.add(bigScreenGridStaticsReturn5); BigScreenGridStaticsReturn bigScreenGridStaticsReturn6=new BigScreenGridStaticsReturn(); bigScreenGridStaticsReturn6.setTitle("防灾减灾"); bigScreenGridStaticsReturn6.setNum(bigscreenGridsGovernanceStatisticsVO.getEventFJTotal()); bigScreenGridStaticsReturn6.setPercent(bigscreenGridsGovernanceStatisticsVO.getEventFJTotal()*100/bigScreenGridStaticsReturn.getCount()); bigScreenGridStaticsReturnList.add(bigScreenGridStaticsReturn6); BigScreenGridStaticsReturn bigScreenGridStaticsReturn7=new BigScreenGridStaticsReturn(); bigScreenGridStaticsReturn7.setTitle("政策法规宣传"); bigScreenGridStaticsReturn7.setNum(bigscreenGridsGovernanceStatisticsVO.getEventFGTotal()); bigScreenGridStaticsReturn7.setPercent(bigscreenGridsGovernanceStatisticsVO.getEventFGTotal()*100/bigScreenGridStaticsReturn.getCount()); bigScreenGridStaticsReturnList.add(bigScreenGridStaticsReturn7); BigScreenGridStaticsReturn bigScreenGridStaticsReturn8=new BigScreenGridStaticsReturn(); bigScreenGridStaticsReturn8.setTitle("安全巡查"); bigScreenGridStaticsReturn8.setNum(bigscreenGridsGovernanceStatisticsVO.getSafety()); bigScreenGridStaticsReturn8.setPercent(bigscreenGridsGovernanceStatisticsVO.getSafety()*100/bigScreenGridStaticsReturn.getCount()); bigScreenGridStaticsReturnList.add(bigScreenGridStaticsReturn8); BigScreenGridStaticsReturn bigScreenGridStaticsReturn9=new BigScreenGridStaticsReturn(); bigScreenGridStaticsReturn9.setTitle("其他"); bigScreenGridStaticsReturn9.setNum(bigscreenGridsGovernanceStatisticsVO.getOtherTotal()); bigScreenGridStaticsReturn9.setPercent(bigscreenGridsGovernanceStatisticsVO.getOtherTotal()*100/bigScreenGridStaticsReturn.getCount()); bigScreenGridStaticsReturnList.add(bigScreenGridStaticsReturn9); bigScreenGridStaticsReturn.setBigScreenGridStaticsReturnList(bigScreenGridStaticsReturnList); return bigScreenGridStaticsReturn; } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml
@@ -382,4 +382,45 @@ IFNULL((select count(egmr.id) from event_grid_member_relation as egmr left join event_grid_data as egd1 on egd1.id = egmr.grid_id where egd1.grid_community_id = #{communityId}), 0) AS gridMemberTotal </select> <select id="selectBigscreenGridsGovern" resultType="com.panzhihua.common.model.vos.community.bigscreen.BigscreenGridsGovernanceStatisticsVO"> SELECT IFNULL((SELECT count( e.id ) FROM `event` AS e LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id WHERE e.event_category = 1 AND e.event_type = 5 AND e.event_status = 2 AND egd.grid_community_id = #{communityId}), 0) + IFNULL((SELECT COUNT(1) FROM com_act_easy_photo WHERE community_id = #{communityId} AND `status` IN (1,2,4) AND del_tag = 0 AND classify_id = 7), 0) AS eventTFTotal, IFNULL(( SELECT count( e1.id ) FROM `event` AS e1 LEFT JOIN event_grid_data AS egd1 ON egd1.id = e1.grid_id WHERE event_category = 1 AND event_type = 1 AND event_status = 2 AND egd1.grid_community_id = #{communityId} ), 0 ) + IFNULL((SELECT COUNT(1) FROM com_act_easy_photo WHERE community_id = #{communityId} AND `status` IN (1,2,4) AND del_tag = 0 AND classify_id = 4), 0) AS eventZATotal, IFNULL(( SELECT count( e2.id ) FROM `event` AS e2 LEFT JOIN event_grid_data AS egd2 ON egd2.id = e2.grid_id WHERE event_category = 1 AND event_type = 3 AND event_status = 2 AND egd2.grid_community_id = #{communityId} ), 0 ) + IFNULL((SELECT COUNT(1) FROM com_act_easy_photo WHERE community_id = #{communityId} AND `status` IN (1,2,4) AND del_tag = 0 AND classify_id = 5), 0) AS eventMDTotal, IFNULL(( SELECT count( e3.id ) FROM `event` AS e3 LEFT JOIN event_grid_data AS egd3 ON egd3.id = e3.grid_id WHERE event_category = 1 AND event_type = 6 AND event_status = 2 AND egd3.grid_community_id = #{communityId} ), 0 ) + IFNULL((SELECT COUNT(1) FROM com_act_easy_photo WHERE community_id = #{communityId} AND `status` IN (1,2,4) AND del_tag = 0 AND classify_id = 3), 0) AS eventTSTotal, IFNULL((SELECT COUNT(1) FROM com_act_easy_photo WHERE community_id = #{communityId} AND `status` IN (1,2,4) AND del_tag = 0 AND classify_id = 8), 0) AS eventFJTotal, IFNULL(( SELECT count( e5.id ) FROM `event` AS e5 LEFT JOIN event_grid_data AS egd5 ON egd5.id = e5.grid_id WHERE event_category = 1 AND event_type = 2 AND event_status = 2 AND egd5.grid_community_id = #{communityId} ), 0 ) + IFNULL((SELECT COUNT(1) FROM com_act_easy_photo WHERE community_id = #{communityId} AND `status` IN (1,2,4) AND del_tag = 0 AND classify_id = 6), 0) AS eventMSTotal, IFNULL(( SELECT count( e5.id ) FROM `event` AS e5 LEFT JOIN event_grid_data AS egd5 ON egd5.id = e5.grid_id WHERE event_category = 1 AND event_type = 8 AND event_status = 2 AND egd5.grid_community_id = #{communityId} ), 0 ) + IFNULL((SELECT COUNT(1) FROM com_act_easy_photo WHERE community_id = #{communityId} AND `status` IN (1,2,4) AND del_tag = 0 AND classify_id = 2), 0) AS eventFGTotal, IFNULL((SELECT COUNT(1) FROM com_act_easy_photo WHERE community_id = #{communityId} AND `status` IN (1,2,4) AND del_tag = 0 AND classify_id = 1), 0) AS otherTotal, IFNULL((SELECT count( e.id ) FROM `event` AS e LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id WHERE e.event_category = 1 AND e.event_status = 2 AND egd.grid_community_id = #{communityId}), 0) AS eventTotal, IFNULL((SELECT count(id) FROM com_sw_patrol_record WHERE community_id = #{communityId}), 0) AS safety </select> </mapper>
