From c7cb86db957dc7fbf6ca30270a71a43f5b31eccf Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期三, 13 四月 2022 09:29:03 +0800
Subject: [PATCH] 电动车商城-拼团活动接口开发

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

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java
index bf0c458..3b47cab 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java
@@ -82,7 +82,7 @@
     @Select("<script> select ca.`name`,ca.street_id,ca.community_id,cs.`name` as streetName " +
             "from com_act as ca " +
             "left join com_street as cs on cs.street_id = ca.street_id " +
-            "where ca.state = 0 and ca.name like '%#{name}%' <if test='areaCode !=null'> and cs.area_code = #{areaCode} </if> </script> ")
+            "where ca.state = 0 and ca.name like concat('%',#{name},'%') <if test='areaCode !=null and areaCode !=&quot;&quot;'> and cs.area_code = #{areaCode} </if> </script> ")
     List<CommunitySwitchAllAppletsVO> getCommunityListByName(@Param("name") String name,@Param("areaCode") String areaCode);
 
     @Select("SELECT   c.community_id,    c.`name`,    c.street_id,    cs.`name` as streetName," +

--
Gitblit v1.7.1