From ffcd3e31c9938eb256d616c80edbe1821e9fb2bf Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期五, 02 七月 2021 16:15:34 +0800
Subject: [PATCH] 综治后台小区模块接口
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActVillageDAO.java | 81 +++++++++++++++++++++++++++++++++++++++-
1 files changed, 79 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActVillageDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActVillageDAO.java
index 50411e8..c86092a 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActVillageDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActVillageDAO.java
@@ -5,12 +5,15 @@
import com.panzhihua.common.model.dtos.grid.ComMngVillageListAppDTO;
import com.panzhihua.common.model.dtos.grid.PageComMngVillageBuildHouseAppDTO;
import com.panzhihua.common.model.dtos.grid.admin.ComMngPopulationListDTO;
+import com.panzhihua.common.model.dtos.grid.admin.ComMngVillageListExportAdminDTO;
import com.panzhihua.common.model.vos.community.ComMngVillageTotalVO;
import com.panzhihua.common.model.vos.community.ComMngVillageVO;
import com.panzhihua.common.model.vos.grid.ComMngVillageBuildingHouseVO;
import com.panzhihua.common.model.vos.grid.ComMngVillageBuildingVO;
import com.panzhihua.common.model.vos.grid.PageComMngVillageVO;
import com.panzhihua.common.model.vos.grid.PopulationDetailVO;
+import com.panzhihua.common.model.vos.grid.admin.ComMngVillageStatisticsVO;
+import com.panzhihua.common.model.vos.grid.admin.excel.ComMngVillageExportExcelVO;
import com.panzhihua.service_community.model.dos.ComMngVillageDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
@@ -56,15 +59,72 @@
" ( SELECT count( id ) FROM com_mng_population WHERE village_id = cmv.village_id AND out_or_local = 1 ) AS registerNum, " +
" ( SELECT count( id ) FROM com_mng_population WHERE village_id = cmv.village_id AND is_rent = 2 ) AS rentNum " +
"FROM " +
- " com_mng_village AS cmv where cmv.community_id = #{villageListAppDTO.communityId} " +
+ " com_mng_village AS cmv where 1=1 " +
+ "<if test='villageListAppDTO.communityId != null'>" +
+ " and cmv.community_id = #{villageListAppDTO.communityId} "+
+ " </if> " +
+ "<if test='villageListAppDTO.address != null and villageListAppDTO.address != ""'>" +
+ " and cmv.address like concat(#{villageListAppDTO.address},'%') "+
+ " </if> " +
+ "<if test='villageListAppDTO.alley != null and villageListAppDTO.alley != ""'>" +
+ " and cmv.alley like concat(#{villageListAppDTO.alley},'%') "+
+ " </if> " +
+ "<if test='villageListAppDTO.houseNum != null and villageListAppDTO.houseNum != ""'>" +
+ " and cmv.house_num like concat(#{villageListAppDTO.houseNum},'%') "+
+ " </if> " +
+ "<if test='villageListAppDTO.groupAt != null and villageListAppDTO.groupAt != ""'>" +
+ " and cmv.group_at like concat(#{villageListAppDTO.groupAt},'%') "+
+ " </if> " +
"<if test='villageListAppDTO.name != null and villageListAppDTO.name != ""'>" +
- " and cmv.name like concat(#{villageListAppDTO.name},'%')"+
+ " and cmv.name like concat(#{villageListAppDTO.name},'%') "+
" </if> " +
"<if test='villageListAppDTO.sortColumns!=null'>" +
" ORDER BY ${villageListAppDTO.sortColumns} ${villageListAppDTO.sortType} " +
" </if>" +
" </script>")
IPage<PageComMngVillageVO> getGridVillageList(Page page, @Param("villageListAppDTO") ComMngVillageListAppDTO villageListAppDTO);
+
+ @Select("<script> " +
+ "SELECT " +
+ " alley, " +
+ " house_num as doorNum, " +
+ " `name` AS userName, " +
+ " build_sum, " +
+ " address, " +
+ " create_at as createAt, " +
+ " ( SELECT count( id ) FROM com_mng_population WHERE village_id = cmv.village_id ) AS userSum, " +
+ " ( SELECT count( id ) FROM com_mng_population_house WHERE village_id = cmv.village_id ) AS houseNum " +
+ "FROM " +
+ " com_mng_village AS cmv where 1=1 " +
+ "<if test='villageListAppDTO.communityId != null'>" +
+ " and cmv.community_id = #{villageListAppDTO.communityId} "+
+ " </if> " +
+ "<if test='villageListAppDTO.villageIds != null and villageListAppDTO.villageIds.size > 0'>" +
+ " and cmv.village_id in "+
+ "<foreach item='item' collection='villageListAppDTO.villageIds' separator=',' open='(' close=')' index=''> " +
+ "#{item}" +
+ "</foreach>" +
+ " </if> " +
+ "<if test='villageListAppDTO.address != null and villageListAppDTO.address != ""'>" +
+ " and cmv.address like concat(#{villageListAppDTO.address},'%') "+
+ " </if> " +
+ "<if test='villageListAppDTO.alley != null and villageListAppDTO.alley != ""'>" +
+ " and cmv.alley like concat(#{villageListAppDTO.alley},'%') "+
+ " </if> " +
+ "<if test='villageListAppDTO.houseNum != null and villageListAppDTO.houseNum != ""'>" +
+ " and cmv.house_num like concat(#{villageListAppDTO.houseNum},'%') "+
+ " </if> " +
+ "<if test='villageListAppDTO.groupAt != null and villageListAppDTO.groupAt != ""'>" +
+ " and cmv.group_at like concat(#{villageListAppDTO.groupAt},'%') "+
+ " </if> " +
+ "<if test='villageListAppDTO.name != null and villageListAppDTO.name != ""'>" +
+ " and cmv.name like concat(#{villageListAppDTO.name},'%') "+
+ " </if> " +
+ "<if test='villageListAppDTO.sortColumns!=null'>" +
+ " ORDER BY ${villageListAppDTO.sortColumns} ${villageListAppDTO.sortType} " +
+ " </if>" +
+ " </script>")
+ List<ComMngVillageExportExcelVO> getGridVillageLists(@Param("villageListAppDTO") ComMngVillageListExportAdminDTO villageListAppDTO);
@Select("SELECT DISTINCT " +
" village_id," +
@@ -75,4 +135,21 @@
"WHERE " +
" village_id = #{villageId}")
List<ComMngVillageBuildingVO> getGridVillageBuildingList(@Param("villageId") Long villageId);
+
+ @Select("<script> " +
+ " select count(village_id) from com_mng_population_house where village_id in " +
+ "<foreach item='item' collection='villageIds' separator=',' open='(' close=')' index=''> " +
+ "#{item} " +
+ "</foreach>" +
+ "</script>")
+ Integer getVillageHouseCount(@Param("villageIds") List<Long> villageIds);
+
+ @Select("SELECT " +
+ " count( village_id ) AS villageNum, " +
+ " ( SELECT count( village_id ) FROM ( SELECT DISTINCT village_id, floor FROM com_mng_population_house ) AS floor ) AS floorNum, " +
+ " ( SELECT count( id ) FROM com_mng_population_house ) AS houseNum, " +
+ " ( SELECT count( id ) FROM com_mng_population ) AS userNum " +
+ "FROM " +
+ " com_mng_village")
+ ComMngVillageStatisticsVO getGridVillageStatistics();
}
--
Gitblit v1.7.1