From 80e3030281b8909de7ca060b1cd3869dbbca282e Mon Sep 17 00:00:00 2001
From: huanghongfa <18228131219@163.com>
Date: 星期四, 14 一月 2021 13:14:24 +0800
Subject: [PATCH] 社区后台微心愿查询修改为模糊查询

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMicroWishDAO.java |   18 ++++++++++++------
 1 files changed, 12 insertions(+), 6 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMicroWishDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMicroWishDAO.java
index 0c9bb41..e1f99ab 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMicroWishDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMicroWishDAO.java
@@ -47,18 +47,21 @@
             "left join com_act_micro_wish_user wu on w.id=wu.micro_wish_id "+
             "JOIN sys_user u ON w.sponsor_id = u.user_id \n" +
             "<if test='comActMicroWishVO.sponsorName != null and comActMicroWishVO.sponsorName.trim() != &quot;&quot;'>" +
-            "AND u.name = #{comActMicroWishVO.sponsorName} \n" +
+            "AND u.name like concat(#{comActMicroWishVO.sponsorName},'%')  \n" +
+            " JOIN sys_user su ON w.responsible_id = su.user_id \n" +
             " </if> " +
+            "<if test='comActMicroWishVO.sponsorName == null or comActMicroWishVO.sponsorName.trim() == &quot;&quot;'>" +
             "LEFT JOIN sys_user su ON w.responsible_id = su.user_id \n" +
+            " </if> " +
             "<if test='comActMicroWishVO.responsibleName != null and comActMicroWishVO.responsibleName.trim() != &quot;&quot;'>" +
-            "AND su.`name` = #{comActMicroWishVO.responsibleName} \n" +
+            "AND su.`name` like concat(#{comActMicroWishVO.responsibleName},'%')  \n" +
             " </if> " +
             "where w.status!=3 " +
             "<if test='comActMicroWishVO.communityId != null and comActMicroWishVO.communityId != 0'>" +
             " and w.community_id=#{comActMicroWishVO.communityId} \n" +
             " </if> " +
             "<if test='comActMicroWishVO.sponsorPhone != null and comActMicroWishVO.sponsorPhone.trim() != &quot;&quot;'>" +
-            "AND w.sponsor_phone = #{comActMicroWishVO.sponsorPhone} \n" +
+            "AND w.sponsor_phone like concat(#{comActMicroWishVO.sponsorPhone},'%')  \n" +
             " </if> " +
             "<if test='comActMicroWishVO.status != null and comActMicroWishVO.status!=0 '>" +
             "AND w.`status` = #{comActMicroWishVO.status} \n" +
@@ -102,11 +105,14 @@
             "left join com_act_micro_wish_user wu on w.id=wu.micro_wish_id "+
             "JOIN sys_user u ON w.sponsor_id = u.user_id \n" +
             "<if test='comActMicroWishVO.sponsorName != null and comActMicroWishVO.sponsorName.trim() != &quot;&quot;'>" +
-            "AND u.name = #{comActMicroWishVO.sponsorName} \n" +
+            "AND u.name like concat(#{comActMicroWishVO.sponsorName},'%')  \n" +
+            " JOIN sys_user su ON w.responsible_id = su.user_id \n" +
             " </if> " +
+            "<if test='comActMicroWishVO.sponsorName == null or comActMicroWishVO.sponsorName.trim() == &quot;&quot;'>" +
             "LEFT JOIN sys_user su ON w.responsible_id = su.user_id \n" +
+            " </if> " +
             "<if test='comActMicroWishVO.responsibleName != null and comActMicroWishVO.responsibleName.trim() != &quot;&quot;'>" +
-            "AND su.`name` = #{comActMicroWishVO.responsibleName} \n" +
+            "AND su.`name` like concat(#{comActMicroWishVO.responsibleName},'%')  \n" +
             " </if> " +
             "where w.status=3 and w.form=1 \n" +
             "<if test='comActMicroWishVO.backUserId != null and comActMicroWishVO.backUserId != 0'>" +
@@ -116,7 +122,7 @@
             " and w.community_id=#{comActMicroWishVO.communityId} \n" +
             " </if> " +
             "<if test='comActMicroWishVO.sponsorPhone != null and comActMicroWishVO.sponsorPhone.trim() != &quot;&quot;'>" +
-            "AND w.sponsor_phone = #{comActMicroWishVO.sponsorPhone} \n" +
+            "AND w.sponsor_phone like concat(#{comActMicroWishVO.sponsorPhone},'%')  \n" +
             " </if> " +
             "<if test='comActMicroWishVO.status != null and comActMicroWishVO.status!=0 '>" +
             "AND w.`status` = #{comActMicroWishVO.status} \n" +

--
Gitblit v1.7.1