From 60daae4c3f216bc9af6b9efa38450d44413de8ff Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期三, 29 十二月 2021 14:11:03 +0800
Subject: [PATCH] 12/29 河门口大屏特殊修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/BigScreenDAO.java | 4 ++--
1 files changed, 2 insertions(+), 2 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 e52a783..aa84906 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
@@ -88,7 +88,7 @@
+ " when photo_path IS NOT NULL then photo_path "
+ " when CAST(SUBSTRING(id_card , 17, 1) AS SIGNED)%2=1 then 'https://www.psciio.com/idcard/tst/idcard/a723e5bcbd594a48956ef9354c8b477c.jpg' "
+ " ELSE 'https://www.psciio.com/idcard/tst/idcard/cfb9b58913074068bba8c7002f91e7ff.jpg' END AS photo_path , "
- + " 0 AS total " + " FROM com_pb_member " + " WHERE community_id=#{communityId} "
+ + " 0 AS total " + " FROM com_pb_member " + " WHERE community_id = #{communityId} "
+ " ORDER BY join_time ASC " + " LIMIT 3 " + "</script>")
List<PartyBuildingMemberVO> defaultPartyactivity(@Param("communityId") Long communityId);
@@ -99,7 +99,7 @@
+ " ORDER BY idxName " + ")m LEFT JOIN " + "( " + "SELECT "
+ " date_format(activity_time_begin, '%Y-%m') AS idxName, " + " COUNT(id) AS total "
+ " FROM com_pb_activity " + " WHERE "
- + " community_id=#{queryDTO.communityId} AND STATUS IN ( 3, 4, 5 ) AND "
+ + " community_id = #{queryDTO.communityId} AND STATUS IN ( 3, 4, 5 ) AND "
+ " activity_time_begin < DATE_FORMAT( DATE_ADD( STR_TO_DATE(#{queryDTO.date}, '%Y-%m-%d'), INTERVAL 1 MONTH ), '%Y-%m-%d' ) AND "
+ " activity_time_begin > DATE_FORMAT( DATE_ADD( STR_TO_DATE(#{queryDTO.date}, '%Y-%m-%d'), INTERVAL - 12 MONTH ), '%Y-%m-%d') "
+ " GROUP BY idxName " + " ORDER BY idxName ASC " + " ) d ON m.idxName = d.idxName "
--
Gitblit v1.7.1