springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/screen/event/EventComprehensiveGovernanceStatisticsVO.java
New file @@ -0,0 +1,43 @@ package com.panzhihua.common.model.vos.community.screen.event; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; /** * @title: EventComprehensiveGovernanceStatisticsVO * @projectName: 成都呐喊信息技术有限公司-智慧社区项目 * @description: 西区大数据分析平台-综合治理信息 * @author: hans * @date: 2021/12/14 9:16 */ @Data @ApiModel("西区大数据分析平台-综合治理信息") public class EventComprehensiveGovernanceStatisticsVO { @ApiModelProperty("综合治理总数") private Integer governanceTotal = 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 eventSSPTotal = 0; public void generateGovernanceTotal() { this.governanceTotal = this.eventTFTotal + this.eventZATotal + this.eventMDTotal + this.eventTSTotal + this.eventMSTotal + this.eventSSPTotal; } } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/grid/GridService.java
@@ -1353,4 +1353,11 @@ */ @GetMapping("/screen/member/trajectory") R getGridsMemberTrajectory(@RequestParam("communityId") Long communityId); /** * 西区大数据分析平台-综合治理栏 * @return */ @GetMapping("/screen/comprehensive/governance") R getComprehensiveGovernanceStatics(); } springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/BigScreenStatisticsApi.java
@@ -193,4 +193,9 @@ } @ApiOperation(value = "西区大数据分析平台-综合治理栏", response = EventComprehensiveGovernanceStatisticsVO.class) @GetMapping("/comprehensive/governance") public R getComprehensiveGovernanceStatics() { return gridService.getComprehensiveGovernanceStatics(); } } springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/api/BigScreenApi.java
@@ -89,4 +89,13 @@ return eventGridMemberRelationService.getGridsMemberTrajectory(communityId); } /** * 西区大数据分析平台-综合治理栏 * @return */ @GetMapping("/comprehensive/governance") public R getComprehensiveGovernanceStatics() { return eventService.getComprehensiveGovernanceStatics(); } } springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/dao/EventMapper.java
@@ -3,6 +3,7 @@ import java.util.List; import java.util.Map; import com.panzhihua.common.model.vos.community.screen.event.EventComprehensiveGovernanceStatisticsVO; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @@ -164,4 +165,10 @@ List<Map<String, Object>> getMemberBuildName(@Param("userId") Long userId); Integer getPopulationByLabelCount(@Param("floor") String floor, @Param("villageId") Long villageId); /** * 西区大数据分析平台-综合治理栏数据 * @return */ EventComprehensiveGovernanceStatisticsVO selectComprehensiveGovernanceStatics(); } springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/EventService.java
@@ -351,4 +351,10 @@ * @return 网格员工作汇总数据 */ R gridMemberStatisticsAll(MemberStatisticsAdminDTO statisticsAdminDTO); /** * 西区大数据分析平台-综合治理栏 * @return */ R getComprehensiveGovernanceStatics(); } springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java
@@ -5,6 +5,7 @@ import javax.annotation.Resource; import com.panzhihua.common.model.vos.community.screen.event.EventComprehensiveGovernanceStatisticsVO; import org.springframework.beans.BeanUtils; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; @@ -2641,4 +2642,15 @@ public R gridMemberStatisticsAll(MemberStatisticsAdminDTO statisticsAdminDTO) { return R.ok(eventGridMemberRelationMapper.gridMemberStatisticsAll(statisticsAdminDTO)); } /** * 西区大数据分析平台-综合治理栏 * @return */ @Override public R getComprehensiveGovernanceStatics() { EventComprehensiveGovernanceStatisticsVO governanceStatisticsVO = this.baseMapper.selectComprehensiveGovernanceStatics(); governanceStatisticsVO.generateGovernanceTotal(); return R.ok(governanceStatisticsVO); } } springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventMapper.xml
@@ -1376,5 +1376,37 @@ left join com_mng_population AS cmp on cmp.id = cmpct.population_id where cmtct.label is not null and cmp.village_id = #{villageId} and floor = #{floor} </select> <select id="selectComprehensiveGovernanceStatics" resultType="com.panzhihua.common.model.vos.community.screen.event.EventComprehensiveGovernanceStatisticsVO"> SELECT (SELECT COUNT( e.id ) FROM `event` AS e LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id LEFT JOIN com_act AS a ON egd.grid_community_id = a.community_id WHERE e.event_category = 1 AND e.event_type = 5 AND e.event_deal_status = 4 AND a.area_code = 510423) AS eventTFTotal, (SELECT COUNT( e1.id ) FROM `event` AS e1 LEFT JOIN event_grid_data AS egd1 ON egd1.id = e1.grid_id LEFT JOIN com_act AS a1 ON egd1.grid_community_id = a1.community_id WHERE event_category = 1 AND event_type = 1 AND e1.event_deal_status = 4 AND a1.area_code = 510423) AS eventZATotal, (SELECT COUNT( e2.id ) FROM `event` AS e2 LEFT JOIN event_grid_data AS egd2 ON egd2.id = e2.grid_id LEFT JOIN com_act AS a2 ON egd2.grid_community_id = a2.community_id WHERE event_category = 1 AND event_type = 3 AND e2.event_deal_status = 4 AND a2.area_code = 510423) AS eventMDTotal, (SELECT COUNT( e3.id ) FROM `event` AS e3 LEFT JOIN event_grid_data AS egd3 ON egd3.id = e3.grid_id LEFT JOIN com_act AS a3 ON egd3.grid_community_id = a3.community_id WHERE event_category = 1 AND event_type = 6 AND e3.event_deal_status = 4 AND a3.area_code = 510423) AS eventTSTotal, (SELECT COUNT( e5.id ) FROM `event` AS e5 LEFT JOIN event_grid_data AS egd5 ON egd5.id = e5.grid_id LEFT JOIN com_act AS a5 ON egd5.grid_community_id = a5.community_id WHERE event_category = 1 AND event_type = 2 AND e5.event_deal_status = 4 AND a5.area_code = 510423) AS eventMSTotal, (SELECT COUNT(p.id) FROM com_act_easy_photo p LEFT JOIN com_act AS a ON p.community_id = a.community_id WHERE p.`status` = 4 AND p.del_tag = 0 AND a.area_code = 510423) AS eventSSPTotal </select> </mapper>
