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 | 78 +++++++++++++++++++++++++++++++++-----
1 files changed, 67 insertions(+), 11 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 2938354..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,10 @@
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;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
@@ -25,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;
@@ -211,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 "
@@ -280,6 +279,10 @@
@Select("SELECT " + " count( id ) " + "FROM " + " com_mng_population_community_tags " + "WHERE "
+ " 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"
@@ -349,7 +352,7 @@
+ " 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,create_at as createAt, "
+ + " </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> "
@@ -367,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);
@@ -615,4 +618,57 @@
* @param newUnitNo 新单元号
*/
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
+ */
+ BaseInfo baseInfo(Long communityId);
+
+ /**
+ * 业务数据统计
+ * @param communityId
+ * @return
+ */
+ IndexDynamic indexDynamic(Long communityId);
+
+ /**
+ * 大屏事件数据
+ * @param communityId
+ * @return
+ */
+ List<EventGridIncidentStatisticsVO> getGridsGovernanceEventList(@Param("communityId") Long communityId);
}
--
Gitblit v1.7.1