From a22caa7f73776410989ec4cec5fe7923f8ba3504 Mon Sep 17 00:00:00 2001 From: 101captain <237651143@qq.com> Date: 星期二, 15 三月 2022 09:51:15 +0800 Subject: [PATCH] 党建bug修改 --- 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 665b76a..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 areaCode !='''> and cs.area_code = #{areaCode} </if> </script> ") + "where ca.state = 0 and ca.name like concat('%',#{name},'%') <if test='areaCode !=null and areaCode !=""'> 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