From a3feb2cf14ccd885be490a27f57da063df7f5dad Mon Sep 17 00:00:00 2001
From: huanghongfa <18228131219@163.com>
Date: 星期三, 13 一月 2021 17:52:34 +0800
Subject: [PATCH] 党员管理搜索使用模糊查询
---
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbMemberDAO.java | 6 +++---
1 files changed, 3 insertions(+), 3 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 b23de36..a2634cd 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
@@ -57,13 +57,13 @@
"LEFT JOIN com_pb_org o ON m.org_id = o.id"+
" where m.community_id=#{pagePartyOrganizationVO.communityId} " +
"<if test='pagePartyOrganizationVO.orgName != null and pagePartyOrganizationVO.orgName.trim() != ""'>" +
- "and o.name=#{pagePartyOrganizationVO.orgName}"+
+ "and o.name = #{pagePartyOrganizationVO.orgName}"+
" </if> " +
"<if test='pagePartyOrganizationVO.account != null and pagePartyOrganizationVO.account.trim() != ""'>" +
- "and u.phone=#{pagePartyOrganizationVO.account}"+
+ "and u.phone like concat (#{pagePartyOrganizationVO.account},'%')"+
" </if> " +
"<if test='pagePartyOrganizationVO.name != null and pagePartyOrganizationVO.name.trim() != ""'>" +
- "and m.name=#{pagePartyOrganizationVO.name}"+
+ "and m.name like concat (#{pagePartyOrganizationVO.name},'%')"+
" </if> " +
"order by m.join_time desc "+
--
Gitblit v1.7.1