From a7b550f95172e29d71aa38dca45cacf7f31949b8 Mon Sep 17 00:00:00 2001
From: 罗元桥 <2376770955@qq.com>
Date: 星期四, 17 六月 2021 14:44:50 +0800
Subject: [PATCH] Merge branch 'test_screen' into 'master'
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java | 66 ++++++++++++++++++++++++++-------
1 files changed, 52 insertions(+), 14 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 a9faba8..87cc381 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
@@ -305,18 +305,17 @@
@Select("SELECT " +
" count( e.id ) AS eventTFTotal, " +
- " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 1 AND event_status = 2 AND event_deal_status in (1,2,3) AND grid_id = egd.id ),0) AS eventZATotal, " +
- " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 3 AND event_status = 2 AND event_deal_status in (1,2,3) AND grid_id = egd.id ),0) AS eventMDTotal, " +
- " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 6 AND event_status = 2 AND event_deal_status in (1,2,3) AND grid_id = egd.id ),0) AS eventTSTotal, " +
- " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 4 AND event_status = 2 AND event_deal_status in (1,2,3) AND grid_id = egd.id ),0) AS eventBWDTotal, " +
- " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 2 AND event_status = 2 AND event_deal_status in (1,2,3) AND grid_id = egd.id ),0) AS eventGGTotal " +
+ " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 1 AND event_status = 2 AND grid_id = egd.id ),0) AS eventZATotal, " +
+ " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 3 AND event_status = 2 AND grid_id = egd.id ),0) AS eventMDTotal, " +
+ " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 6 AND event_status = 2 AND grid_id = egd.id ),0) AS eventTSTotal, " +
+ " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 4 AND event_status = 2 AND grid_id = egd.id ),0) AS eventBWDTotal, " +
+ " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 2 AND event_status = 2 AND grid_id = egd.id ),0) AS eventGGTotal " +
"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_deal_status in (1,2,3) " +
" AND e.event_status = 2 " +
" AND egd.grid_community_id = #{communityId}")
IndexGridEventStatisticsVO getGridEventStatisticsList(@Param("communityId") Long communityId);
@@ -326,17 +325,16 @@
@Select("SELECT " +
" count( e.id ) AS eventTFTotal, " +
- " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 1 AND event_status = 2 AND event_deal_status in (1,2,3) AND grid_id = e.grid_id ),0) AS eventZATotal, " +
- " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 3 AND event_status = 2 AND event_deal_status in (1,2,3) AND grid_id = e.grid_id) ,0) AS eventMDTotal, " +
- " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 6 AND event_status = 2 AND event_deal_status in (1,2,3) AND grid_id = e.grid_id ),0) AS eventTSTotal, " +
- " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 4 AND event_status = 2 AND event_deal_status in (1,2,3) AND grid_id = e.grid_id ),0) AS eventBWDTotal, " +
- " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 2 AND event_status = 2 AND event_deal_status in (1,2,3) AND grid_id = e.grid_id ),0) AS eventGGTotal " +
+ " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 1 AND event_status = 2 AND grid_id = e.grid_id ),0) AS eventZATotal, " +
+ " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 3 AND event_status = 2 AND grid_id = e.grid_id) ,0) AS eventMDTotal, " +
+ " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 6 AND event_status = 2 AND grid_id = e.grid_id ),0) AS eventTSTotal, " +
+ " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 4 AND event_status = 2 AND grid_id = e.grid_id ),0) AS eventBWDTotal, " +
+ " IFNULL(( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 2 AND event_status = 2 AND grid_id = e.grid_id ),0) AS eventGGTotal " +
"FROM " +
" `event` AS e " +
"WHERE " +
" e.event_category = 1 " +
" AND e.event_type = 5 " +
- " AND e.event_deal_status in (1,2,3) " +
" AND e.event_status = 2 " +
" AND e.grid_id = #{gridId}")
IndexGridEventStatisticsVO getGridEventByGirdId(@Param("gridId") Long gridId);
@@ -625,6 +623,7 @@
@Select("SELECT " +
" event_type AS type, " +
+ " e.id AS eventId, " +
" happent_lat_lng AS latLng " +
"FROM " +
" `event` AS e " +
@@ -633,18 +632,17 @@
" e.event_category = 1 " +
" AND e.event_type IN ( 1, 2, 3, 4, 5, 6 ) " +
" AND e.event_status = 2 " +
- " AND e.event_deal_status = 1 " +
" AND egd.grid_community_id = #{communityId} " +
" AND e.happen_time BETWEEN date_add( curdate(), INTERVAL - DAY ( curdate())+ 1 DAY ) " +
" AND date_add( curdate()- DAY ( curdate())+ 1, INTERVAL 1 MONTH ) UNION ALL " +
"SELECT " +
" IFNULL( NULL, 7 ) AS type, " +
+ " id AS eventId, " +
" lng_lat AS latLng " +
"FROM " +
" com_act_easy_photo " +
"WHERE " +
" community_id = #{communityId} " +
- " AND handle_status = 1 " +
" AND del_tag = 0 " +
" AND lng_lat IS NOT NULL " +
" AND create_at BETWEEN date_add( curdate(), INTERVAL - DAY ( curdate())+ 1 DAY ) " +
@@ -724,4 +722,44 @@
"(SELECT (SELECT TIMESTAMPDIFF(YEAR, birthday, CURDATE()) ) AS age FROM com_mng_population WHERE act_id = #{communityId}) AS aa WHERE aa.age > 55) AS age55over")
Map<String, Long> indexCountByAge(@Param("communityId")Long communityId);
+
+ @Select("SELECT " +
+ " id, " +
+ " su.nick_name AS userName, " +
+ " su.image_url, " +
+ " caep.create_at, " +
+ " caep.detail AS eventDes, " +
+ " caep.happen_addr AS happenAddress, " +
+ " caep.lng_lat AS happentLatLng, " +
+ " caep.photo_path_list, " +
+ " IFNULL( NULL, 7 ) AS eventType, " +
+ " caep.handle_status AS eventDealStatus " +
+ "FROM " +
+ " com_act_easy_photo AS caep " +
+ " LEFT JOIN sys_user AS su ON su.user_id = caep.sponsor_id " +
+ "WHERE " +
+ " id = #{eventId}")
+ EventNewStatisticsVO getEventScreenSSPDateil(@Param("eventId")Long eventId);
+
+ @Select("SELECT " +
+ " su.nick_name AS userName, " +
+ " su.image_url AS imageUrl, " +
+ " e.happen_time as createAt, " +
+ " e.event_des, " +
+ " e.danger_level, " +
+ " e.urgent, " +
+ " e.major, " +
+ " e.happen_address, " +
+ " e.happent_lat_lng, " +
+ " e.event_type, " +
+ " e.id, " +
+ " e.event_deal_status " +
+ "FROM " +
+ " `event` AS e " +
+ " LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id " +
+ " LEFT JOIN sys_user AS su ON su.user_id = e.grid_member_id " +
+ "WHERE " +
+ " e.id = #{eventId}")
+ EventNewStatisticsVO getEventScreenEventDetail(@Param("eventId") Long eventId);
+
}
--
Gitblit v1.7.1