From 9f8b84d78c9e4acb48df0355b579825dc9de706f Mon Sep 17 00:00:00 2001
From: 罗元桥 <2376770955@qq.com>
Date: 星期四, 17 六月 2021 14:58:03 +0800
Subject: [PATCH] Merge branch 'test_screen' into 'master'
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java | 75 +++++++++++++++++++++++++++++++++++--
1 files changed, 70 insertions(+), 5 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 87cc381..f4ceba7 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,11 +305,76 @@
@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 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 " +
+ " 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 " +
+ " ) 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 " +
+ " ) 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 " +
+ " ) AS eventTSTotal, " +
+ " IFNULL(( " +
+ " SELECT " +
+ " count( e4.id ) " +
+ " FROM " +
+ " `event` AS e4 " +
+ " LEFT JOIN event_grid_data AS egd4 ON egd4.id = e4.grid_id " +
+ " WHERE " +
+ " event_category = 1 " +
+ " AND event_type = 4 " +
+ " AND event_status = 2 " +
+ " AND egd4.grid_community_id = #{communityId} " +
+ " ), " +
+ " 0 " +
+ " ) AS eventBWDTotal, " +
+ " 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 " +
+ " ) AS eventGGTotal " +
"FROM " +
" `event` AS e " +
" LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id " +
--
Gitblit v1.7.1