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/ComMngPopulationHouseDAO.java |   68 ++++++++++++++++++++++++++++++++++
 1 files changed, 68 insertions(+), 0 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java
index 36c98bd..068598f 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java
@@ -4,7 +4,11 @@
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.panzhihua.common.model.dtos.community.ComMngPopulationHouseAdminDTO;
+import com.panzhihua.common.model.dtos.grid.PageComMngVillageBuildHouseAppDTO;
 import com.panzhihua.common.model.vos.community.*;
+import com.panzhihua.common.model.vos.grid.ComMngVillageBuildingHouseDetailVO;
+import com.panzhihua.common.model.vos.grid.ComMngVillageBuildingHouseVO;
+import com.panzhihua.common.model.vos.grid.PopulationListVO;
 import com.panzhihua.common.model.vos.user.ComMngHouseVo;
 import com.panzhihua.service_community.model.dos.ComMngPopulationHouseDO;
 import org.apache.ibatis.annotations.Mapper;
@@ -173,5 +177,69 @@
             " from com_act as ca where ca.community_id = #{communityId}")
     ComMngVillageRegionVO getRegion(@Param("communityId") Long communityId);
 
+    @Select("<script> " +
+            "SELECT id, floor, unit_no, house_no, `status`,( SELECT count( id ) FROM com_mng_population_house_user WHERE house_id = cmph.id ) AS userNum " +
+            " FROM " +
+            " com_mng_population_house AS cmph " +
+            " <where> " +
+            "<if test='buildHouseAppDTO.villageId != null '>" +
+            " and cmph.village_id = #{buildHouseAppDTO.villageId}  " +
+            " </if> " +
+            "<if test='buildHouseAppDTO.floor != null and buildHouseAppDTO.floor !=&quot;&quot; '>" +
+            " and cmph.floor = #{buildHouseAppDTO.floor}  " +
+            " </if> " +
+            "<if test='buildHouseAppDTO.unitNo != null and buildHouseAppDTO.unitNo !=&quot;&quot; '>" +
+            " and cmph.unit_no = #{buildHouseAppDTO.unitNo}  " +
+            " </if> " +
+            "<if test='buildHouseAppDTO.houseNo != null and buildHouseAppDTO.houseNo !=&quot;&quot; '>" +
+            " and cmph.house_no like concat(#{buildHouseAppDTO.houseNo},'%')  " +
+            " </if> " +
+            " </where>" +
+            " </script>")
+    IPage<ComMngVillageBuildingHouseVO> getGridVillageBuildingHouseList(Page page, @Param("buildHouseAppDTO") PageComMngVillageBuildHouseAppDTO buildHouseAppDTO);
+
+    @Select("SELECT " +
+            " cmph.id, " +
+            " cmv.`name` AS villageName, " +
+            " cmph.floor, " +
+            " cmph.unit_no, " +
+            " cmph.house_no, " +
+            " cmph.address, " +
+            " cmph.`status`, " +
+            " cmv.lat, " +
+            " cmv.lng  " +
+            "FROM " +
+            " com_mng_population_house AS cmph " +
+            " LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmph.village_id  " +
+            "WHERE " +
+            " cmph.id = #{houseId}")
+    ComMngVillageBuildingHouseDetailVO getGridVillageBuildingHouseDetail(@Param("houseId") Long houseId);
+
+    @Select("<script> " +
+            "SELECT " +
+            " cmp.id, " +
+            " cmphu.id as housePopulationId, " +
+            " cmp.sex, " +
+            " cmp.`name`, " +
+            " cmp.phone, " +
+            " cmp.card_no, " +
+            " cmp.label, " +
+            " cmp.address, " +
+            " cmp.nation, " +
+            " cmphu.create_at, " +
+            " cmp.political_outlook  " +
+            "FROM " +
+            " com_mng_population_house_user AS cmphu " +
+            " LEFT JOIN com_mng_population AS cmp ON cmp.id = cmphu.popul_id  " +
+            "WHERE " +
+            " cmphu.house_id = #{houseId} " +
+            "<if test='relation != null '>" +
+            " AND cmphu.relation = #{relation}  " +
+            " </if> " +
+            "<if test='relationId != null '>" +
+            " AND cmphu.relation_id = #{relationId}  " +
+            " </if> " +
+            " </script>")
+    List<PopulationListVO> getGridVillageBuildingPopulationList(@Param("houseId") Long houseId,@Param("relation") Integer relation,@Param("relationId") Integer relationId);
 
 }

--
Gitblit v1.7.1