From c976225dd87518c6e34337f994c4651d096547d5 Mon Sep 17 00:00:00 2001 From: lidongdong <1459917685@qq.com> Date: 星期一, 24 六月 2024 15:33:26 +0800 Subject: [PATCH] 花城 修改党建分类标参数 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDAO.java | 8 ++++---- 1 files changed, 4 insertions(+), 4 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 de24a6d..ddd2ca4 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 @@ -88,10 +88,10 @@ @Select("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.street_id = #{streetId}") List<CommunitySwitchAllAppletsVO> getCommunityListByStreetId(@Param("streetId") Long streetId); - @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 concat('%',#{name},'%') <if test='appId !=null and appId !=""'> and cs.app_id = #{appId} </if> </script> ") +// @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 concat('%',#{name},'%') <if test='appId !=null and appId !=""'> and cs.app_id = #{appId} </if> </script> ") List<CommunitySwitchAllAppletsVO> getCommunityListByName(@Param("name") String name,@Param("appId") String appId); @Select("SELECT c.community_id, c.`name`, c.street_id, cs.`name` as streetName," + -- Gitblit v1.7.1