From 34b537c6834d099a76ed0a9164809eed05022b04 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期三, 30 六月 2021 16:57:45 +0800
Subject: [PATCH] 综治app-小区模块接口开发

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

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java
index 358c114..393817a 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java
@@ -4,6 +4,7 @@
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.panzhihua.common.model.dtos.community.ComMngPopulationDTO;
+import com.panzhihua.common.model.dtos.grid.PageComMngPopulationDTO;
 import com.panzhihua.common.model.dtos.grid.PagePopulationListDTO;
 import com.panzhihua.common.model.dtos.grid.admin.ComMngPopulationListDTO;
 import com.panzhihua.common.model.dtos.user.PageInputUserDTO;
@@ -16,6 +17,7 @@
 import com.panzhihua.common.model.vos.community.screen.event.*;
 import com.panzhihua.common.model.vos.community.screen.index.*;
 import com.panzhihua.common.model.vos.grid.EventGridDataVO;
+import com.panzhihua.common.model.vos.grid.EventSpecialPopulationVO;
 import com.panzhihua.common.model.vos.grid.PopulationDetailVO;
 import com.panzhihua.common.model.vos.grid.PopulationListVO;
 import com.panzhihua.common.model.vos.grid.admin.ComMngPopulationListVO;
@@ -973,4 +975,22 @@
             " </script>")
     Integer getPopulationVisitingCount(@Param("ids") List<Long> ids);
 
+    @Select("<script> " +
+            "SELECT " +
+            "   cmp.id, " +
+            "   cmp.`name`, " +
+            "   cmp.card_no as idCard, " +
+            "   cmp.label, " +
+            "   cmp.sex, " +
+            "   cmp.phone, " +
+            "   cmp.address, " +
+            "   cmp.political_outlook " +
+            "  FROM " +
+            "   com_mng_population AS cmp where 1=1 " +
+            "<if test='populationDTO.keyWord != null'>" +
+            " AND (cmp.name like concat(#{populationDTO.keyWord},'%') or cmp.card_no_str like concat(#{populationDTO.keyWord},'%')) " +
+            " </if> " +
+            " </script>")
+    IPage<EventSpecialPopulationVO> getBuildingHousePopulationList(Page page,@Param("populationDTO") PageComMngPopulationDTO populationDTO);
+
 }

--
Gitblit v1.7.1