From 2e64c232ab6b51b2cecf1ee96e1e9b709234f326 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期六, 21 八月 2021 16:35:14 +0800
Subject: [PATCH] 随手拍改版接口开发

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

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructAreaDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructAreaDAO.java
index 147f0e9..6decc93 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructAreaDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructAreaDAO.java
@@ -3,8 +3,6 @@
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
-import com.panzhihua.common.model.vos.R;
-import com.panzhihua.common.model.vos.community.ComActDynVO;
 import com.panzhihua.common.model.vos.community.ComMngStructAreaVO;
 import com.panzhihua.service_community.model.dos.ComMngStructAreaDO;
 import org.apache.ibatis.annotations.Mapper;
@@ -40,10 +38,12 @@
             "create_at \n" +
             "FROM\n" +
             "com_mng_struct_area \n" +
-            "WHERE\n" +
-            "community_id = #{comMngStructAreaVO.communityId} \n" +
+            "WHERE 1=1  \n" +
+            "<if test='comMngStructAreaVO.communityId != null '>" +
+            "AND community_id=#{comMngStructAreaVO.communityId} \n" +
+            " </if> " +
             "<if test='comMngStructAreaVO.areaName != null and comMngStructAreaVO.areaName.trim() != &quot;&quot;'>" +
-            "AND area_name = #{comMngStructAreaVO.areaName}" +
+            "AND area_name like concat( '%',#{comMngStructAreaVO.areaName}, '%' )" +
             " </if> " +
             "</script>")
     IPage<ComMngStructAreaVO> pageArea(Page page, @Param("comMngStructAreaVO") ComMngStructAreaVO comMngStructAreaVO);

--
Gitblit v1.7.1