From 018af6bed3da8be2e7b846aa3e654f16f8f71654 Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期三, 29 十二月 2021 16:29:30 +0800
Subject: [PATCH] 12/29 河门口大屏特殊修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/BigScreenDAO.java | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/BigScreenDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/BigScreenDAO.java
index aa84906..b636561 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/BigScreenDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/BigScreenDAO.java
@@ -62,15 +62,15 @@
+ " SUM(CASE TYPE WHEN 3 THEN total ELSE 0 END) as 'activityCount', "
+ " SUM(CASE TYPE WHEN 4 THEN total ELSE 0 END) as 'dynCount',SUM(CASE TYPE WHEN 5 THEN total ELSE 0 END) as 'committeeCount' " + " FROM ( "
+ " SELECT 1 AS TYPE , COUNT(id) total " + " FROM com_pb_org org "
- + " WHERE org.community_id = #{communityId} AND STATUS=1 " + " UNION ALL "
+ + " WHERE org.community_id = #{communityId} AND STATUS=1 " + " UNION ALL "
+ " SELECT 2 AS TYPE , COUNT(id) total " + " FROM com_pb_member "
- + " WHERE community_id = #{communityId} AND audit_result = 1 " + " UNION ALL "
+ + " WHERE community_id = #{communityId} AND audit_result = 1 " + " UNION ALL "
+ " SELECT 3 AS TYPE , COUNT(id) total " + " FROM com_pb_activity "
- + " WHERE community_id = #{communityId} AND STATUS IN (2,3,4,5) " + " UNION ALL "
+ + " WHERE community_id = #{communityId} AND STATUS IN (2,3,4,5) " + " UNION ALL "
+ " SELECT 4 AS TYPE , COUNT(id) total " + " FROM com_pb_dyn "
- + " WHERE community_id = #{communityId} AND TYPE = 1 UNION ALL " +
+ + " WHERE community_id = #{communityId} AND TYPE = 1 UNION ALL " +
"select 5 AS TYPE,count(id) total from com_pb_member_role " +
- "where community_id =#{communityId}" + ") t" + "</script>")
+ "where community_id = #{communityId}" + ") t" + "</script>")
BigScreenStatisticPartyBuild partybuild(@Param("communityId") Long communityId);
@Select("<script> " + " SELECT pm.id, pm.member_id, pm.user_id, pm.name, " + " case "
--
Gitblit v1.7.1