From 5a8a90c095280fbd2106869ecd2bad10e01a57a6 Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期四, 23 十二月 2021 18:10:22 +0800
Subject: [PATCH] 12/23 大屏修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java | 66 ++++++++++++++++++++++++++------
1 files changed, 53 insertions(+), 13 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java
index 6389bf6..7bc7c58 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java
@@ -7,6 +7,8 @@
import com.panzhihua.common.model.dtos.community.CascadeHouseDTO;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.community.*;
+import com.panzhihua.common.model.vos.community.bigscreen.WestScreenStatics;
+import com.panzhihua.common.model.vos.community.screen.civil.*;
import com.panzhihua.common.model.vos.community.bigscreen.BaseInfo;
import com.panzhihua.common.model.vos.community.bigscreen.IndexDynamic;
import com.panzhihua.service_community.model.dos.ComMngPopulationCommunityTagsDO;
@@ -27,8 +29,6 @@
import com.panzhihua.common.model.dtos.grid.admin.PageComMngVillagePopulationDTO;
import com.panzhihua.common.model.dtos.user.PageInputUserDTO;
import com.panzhihua.common.model.vos.area.AreaAddressVO;
-import com.panzhihua.common.model.vos.community.screen.civil.CivilPopulationStatisticsVO;
-import com.panzhihua.common.model.vos.community.screen.civil.CivilVillageStatisticsVO;
import com.panzhihua.common.model.vos.community.screen.event.*;
import com.panzhihua.common.model.vos.community.screen.index.*;
import com.panzhihua.common.model.vos.grid.EventGridDataVO;
@@ -213,13 +213,10 @@
" where cmpct.community_id = #{communityId}")
IndexBasicsStatisticsVO getScreenIndexByBasics(@Param("communityId") Long communityId);
- @Select("SELECT " + " IFNULL( NULL, 1 ) AS type, " + " count( cmpct.id ) AS sum " + "FROM "
- + " com_mng_population_community_tags as cmpct "
- + " left join com_mng_population as cmp on cmpct.population_id = cmp.id " + "WHERE " + " cmp.sex = 1 "
- + " AND cmpct.community_id = #{communityId} UNION ALL " + "SELECT " + " IFNULL( NULL, 2 ) AS type, "
- + " count( cmpct.id ) AS sum " + "FROM " + " com_mng_population_community_tags as cmpct "
- + " left join com_mng_population as cmp on cmpct.population_id = cmp.id " + "WHERE " + " cmp.sex = 2 "
- + " AND cmpct.community_id = #{communityId}")
+ @Select("SELECT cmp.sex as type, count( cmpct.id ) AS sum, count( cmpct.id )*100/(select count(*) from com_mng_population_community_tags as cmpct \n" +
+ " left join com_mng_population as cmp on cmpct.population_id = cmp.id WHERE cmpct.community_id = #{communityId} ) as percent FROM \n" +
+ " com_mng_population_community_tags as cmpct \n" +
+ " left join com_mng_population as cmp on cmpct.population_id = cmp.id WHERE cmp.sex is not null and cmpct.community_id = #{communityId} GROUP BY cmp.sex")
List<IndexPopulationSexStatisticsVO> getScreenIndexByPopulationSex(@Param("communityId") Long communityId);
@Select("SELECT " + " e.happen_time as createAt, " + " e.event_des, " + " e.event_deal_status " + "FROM "
@@ -283,6 +280,10 @@
+ " community_id = #{communityId} and label like concat('%',#{label},'%')")
Integer getSpecialStatisticsByLabel(@Param("label") String label,@Param("communityId") Long communityId);
+ @Select("SELECT " + " count( id ) " + "FROM " + " com_mng_population_community_tags " + "WHERE "
+ + " community_id = #{communityId} ")
+ Integer getSpecialStatistics(@Param("communityId") Long communityId);
+
@Select("<script> " + "SELECT " + " count( egd.id ) AS gridTotal, "
+ " ( 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 = egd.grid_community_id ) AS gridMemberTotal, "
@@ -339,7 +340,7 @@
+ "FROM " + " event_grid_data AS egd " + "WHERE " + " egd.grid_community_id = #{communityId}")
List<EventGridStatisticsVO> getEventScreenGridData(@Param("communityId") Long communityId);
- @Select("<script> " + "SELECT " + " event_type AS type, " + " e.id AS eventId, " + " happent_lat_lng AS latLng "
+ @Select("<script> " + "(SELECT " + " event_type AS type, " + " e.id AS eventId, " + " happent_lat_lng AS latLng,e.create_at as createAt "
+ "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 IN ( 1, 2, 3, 4, 5, 6 ) " + " AND e.event_status = 2 "
+ " AND egd.grid_community_id = #{screenEventDTO.communityId} "
@@ -351,14 +352,14 @@
+ " AND e.event_process_status = #{screenEventDTO.eventProcessStatus} " + " </if> "
+ "<if test='screenEventDTO.redCard != null'>" + " AND e.red_card = #{screenEventDTO.redCard} " + " </if> "
+ "<if test='screenEventDTO.yellowCard != null'>" + " AND e.yellow_card = #{screenEventDTO.yellowCard} "
- + " </if> " + "UNION ALL SELECT " + " IFNULL( NULL, 7 ) AS type, " + " id AS eventId, " + " lng_lat AS latLng "
+ + " </if> )" + "UNION ALL (SELECT " + " IFNULL( NULL, 7 ) AS type, " + " id AS eventId, " + " lng_lat AS latLng,create_at as createAt "
+ "FROM " + " com_act_easy_photo " + "WHERE " + " community_id = #{screenEventDTO.communityId} "
+ "<if test='screenEventDTO.startTime != null and screenEventDTO.startTime != ""'>"
+ " AND create_at <![CDATA[>=]]> #{screenEventDTO.startTime} " + " </if> "
+ "<if test='screenEventDTO.endTime != null and screenEventDTO.endTime != ""'>"
+ " AND create_at <![CDATA[<=]]> #{screenEventDTO.endTime} " + " </if> "
+ "<if test='screenEventDTO.eventProcessStatus != null'>"
- + " AND handle_status = #{screenEventDTO.eventProcessStatus} " + " </if> " + " </script>")
+ + " AND handle_status = #{screenEventDTO.eventProcessStatus} " + " </if> )" + "order by createAt desc </script>")
List<EventGridIncidentStatisticsVO>
getEventScreenEventList(@Param("screenEventDTO") BigScreenEventDTO screenEventDTO);
@@ -369,7 +370,7 @@
CivilPopulationStatisticsVO getCivilScreenPopulation(@Param("communityId") Long communityId,
@Param("lastMonth") Date lastMonth);
- @Select("SELECT `NAME`, " + " user_sum, " + " lng, " + " lat, " + " village_images, " + " village_id " + "FROM "
+ @Select("SELECT `NAME`, " + "user_sum, " + " lng, " + " lat, " + " village_images, " + " village_id " + "FROM "
+ " com_mng_village AS cmv " + "WHERE " + " community_id = #{communityId}")
List<CivilVillageStatisticsVO> getCivilScreenVillageList(@Param("communityId") Long communityId);
@@ -619,6 +620,38 @@
void updatePopulationUnit(@Param("villageId") Long villageId, @Param("floor") String floor,@Param("oldUnitNo") String oldUnitNo,@Param("newUnitNo") String newUnitNo);
/**
+ * 根据villageId查询特殊人群数
+ * @param villageId
+ * @param label
+ * @return
+ */
+ Integer selectCountByVillageId(@Param("villageId") Long villageId,@Param("label")String label);
+
+ CivilPartyStatisticsVO getCivilParty(@Param("communityId") Long communityId);
+
+ CivilGovernmentStatisticsVO getCivilGovernment(@Param("communityId") Long communityId);
+
+ CivilGridStatisticsVO getCivilGrid(@Param("communityId") Long communityId);
+
+ CivilConvenienceStatisticsVO getCivilConvenience(@Param("communityId") Long communityId);
+
+ /**
+ * 西区治理数据统计
+ * @return
+ */
+ WestScreenStatics westScreenStatics();
+
+ List<EventPopulationBasicsStatisticsVO> getBasicsList(@Param("streetId") Long streetId);
+
+ EventPopulationSpecialStatisticsVO getPopulationSpecial(@Param("streetId") Long streetId);
+
+ List<String> getPopulationListCardNo(@Param("streetId") Long streetId);
+
+ Integer getPopulationAge(@Param("streetId") Long streetId, @Param("age") Integer age);
+
+ List<EventPopulationStreetVO> getComprehensiveStreetList();
+
+ /**
* 基础数据统计
* @param communityId
* @return
@@ -631,4 +664,11 @@
* @return
*/
IndexDynamic indexDynamic(Long communityId);
+
+ /**
+ * 大屏事件数据
+ * @param communityId
+ * @return
+ */
+ List<EventGridIncidentStatisticsVO> getGridsGovernanceEventList(@Param("communityId") Long communityId);
}
--
Gitblit v1.7.1