From 6de6f55d8788f2fa6b642967917d308bb9aa97d3 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期五, 06 八月 2021 13:18:04 +0800
Subject: [PATCH] 修改bug

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

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructOtherBuildDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructOtherBuildDAO.java
index 49bc82c..7c31dc7 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructOtherBuildDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructOtherBuildDAO.java
@@ -45,9 +45,13 @@
             "join com_mng_struct_build_type t on b.type_id=t.id\n" +
             " <where>" +
             "<if test='comMngStructOtherBuildVO.name != null and comMngStructOtherBuildVO.name.trim() != &quot;&quot;'>" +
-            "b.name = #{comMngStructOtherBuildVO.name}"+
+            " and b.name like concat(#{comMngStructOtherBuildVO.name},'%') "+
+            " </if> " +
+            "<if test='comMngStructOtherBuildVO.communityId != null'>" +
+            " and b.community_id = #{comMngStructOtherBuildVO.communityId} "+
             " </if> " +
             " </where>" +
+            " order by b.create_at desc" +
             "</script>")
     IPage<ComMngStructOtherBuildVO> pageOtherBuild(Page page, @Param("comMngStructOtherBuildVO") ComMngStructOtherBuildVO comMngStructOtherBuildVO);
 

--
Gitblit v1.7.1