From 757e5dc619ddf01fbd9ec2c8c75b6663d79835cb Mon Sep 17 00:00:00 2001
From: CeDo <cedoogle@gmail.com>
Date: 星期二, 11 五月 2021 14:10:55 +0800
Subject: [PATCH] Merge branch 'test'

---
 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbMemberDAO.java |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbMemberDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbMemberDAO.java
index a1c4b61..1adb8fb 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbMemberDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbMemberDAO.java
@@ -163,7 +163,7 @@
             " left join com_act as ca on ca.community_id = cpm.community_id " +
             " left join com_pb_org as cpo on cpo.id = cpm.org_id " +
             " LEFT JOIN sys_user u ON cpm.id_card = u.id_card " +
-            " where cpm.community_id = #{organizationVO.communityId} " +
+            " where cpm.community_id = #{organizationVO.communityId} and cpm.audit_result = 1 " +
             "<if test='organizationVO.orgName != null'>" +
             " and cpo.name LIKE CONCAT('%',#{organizationVO.orgName},'%') "+
             " </if> " +

--
Gitblit v1.7.1