From c3a41230c2f671cdb248df3fa5b64a936e12a3e6 Mon Sep 17 00:00:00 2001
From: CeDo <cedoogle@gmail.com>
Date: 星期四, 17 六月 2021 14:07:44 +0800
Subject: [PATCH] bugfixed: 党员人数纠错
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/BigScreenDAO.java | 6 ++++--
1 files changed, 4 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 b73818a..841d4af 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
@@ -60,8 +60,9 @@
" SELECT id, id_card, ROUND(DATEDIFF(CURDATE(), STR_TO_DATE(SUBSTRING(id_card,7,15), '%Y%m%d'))/365.2422) AS age " +
" FROM com_pb_member " +
" <where> " +
+ " audit_result = 1 " +
"<if test='queryDTO.communityId != null'> " +
- " community_id = #{queryDTO.communityId} " +
+ " AND community_id = #{queryDTO.communityId} " +
"</if> " +
" </where>" +
" ) t " +
@@ -82,8 +83,9 @@
" SELECT CONVERT(SUBSTRING(id_card,'17',1), UNSIGNED INTEGER)%2 AS sxi, COUNT(id_card) AS total " +
" FROM com_pb_member " +
" <where> " +
+ " audit_result = 1 " +
"<if test='queryDTO.communityId != null'>" +
- " community_id = #{queryDTO.communityId} " +
+ " AND community_id = #{queryDTO.communityId} " +
"</if> " +
" </where>" +
" GROUP BY sxi " +
--
Gitblit v1.7.1