From cd7bec2448443f88eee6f73df68df829fc95eed9 Mon Sep 17 00:00:00 2001
From: 罗元桥 <2376770955@qq.com>
Date: 星期二, 29 六月 2021 11:25:24 +0800
Subject: [PATCH] Merge branch 'test' into 'master'
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 55 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 7413c4b..68829d7 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
@@ -5,6 +5,7 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.dtos.community.ComMngPopulationDTO;
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;
import com.panzhihua.common.model.vos.area.AreaAddressVO;
import com.panzhihua.common.model.vos.community.ComActMessageVO;
@@ -17,6 +18,7 @@
import com.panzhihua.common.model.vos.grid.EventGridDataVO;
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;
import com.panzhihua.common.model.vos.user.*;
import com.panzhihua.common.model.vos.community.PageComActMessageVO;
import com.panzhihua.common.model.vos.user.ComHouseMemberVo;
@@ -910,4 +912,57 @@
" id = #{populationId}")
PopulationDetailVO getPopulationDetailApp(@Param("populationId") Long populationId);
+ @Select("<script> " +
+ "SELECT " +
+ " * " +
+ "FROM " +
+ " ( " +
+ " SELECT " +
+ " cmp.id, " +
+ " cmp.`name` AS userName, " +
+ " cmp.label, " +
+ " cmp.card_no, " +
+ " cmp.card_no_str, " +
+ " cmp.sex, " +
+ " cmp.address, " +
+ " cmp.political_outlook, " +
+ " cmp.census_register, " +
+ " cmp.house_id, " +
+ " cmp.phone, " +
+ " IFNULL(cmp.house_id,0) as isHouse, " +
+ " ( SELECT event_status FROM event_visiting_tasks WHERE event_status in (1,2,3,5) AND visiter_id = cmp.id ORDER BY create_at DESC LIMIT 1 ) AS eventStatus, " +
+ " ( SELECT create_at FROM event_visiting_tasks WHERE event_status in (1,2,3,5) AND visiter_id = cmp.id ORDER BY create_at DESC LIMIT 1 ) AS createAt " +
+ " FROM " +
+ " com_mng_population AS cmp where 1=1 " +
+ "<if test='populationListDTO.keyWord != null and populationListDTO.keyWord != ""'>" +
+ "AND (cmp.name like concat (#{populationListDTO.keyWord},'%') or cmp.card_no_str like concat (#{populationListDTO.keyWord},'%') or cmp.address like concat (#{populationListDTO.keyWord},'%')) " +
+ " </if> " +
+ "<if test='populationListDTO.label != null and populationListDTO.label != ""'>" +
+ "AND cmp.label like concat ('%',#{populationListDTO.label},'%') " +
+ " </if> " +
+ "<if test='populationListDTO.sex != null'>" +
+ "AND cmp.sex = #{populationListDTO.sex} " +
+ " </if> " +
+ "<if test='populationListDTO.isHouse != null and populationListDTO.isHouse == 1'>" +
+ "AND cmp.house_id is not null " +
+ " </if> " +
+ "<if test='populationListDTO.isHouse != null and populationListDTO.isHouse == 2'>" +
+ "AND cmp.house_id is null " +
+ " </if> " +
+ "<if test='populationListDTO.communityId != null'>" +
+ "AND cmp.community_id = #{populationListDTO.communityId} " +
+ " </if> " +
+ "<if test='populationListDTO.politicalOutlook != null'>" +
+ "AND cmp.political_outlook = #{populationListDTO.politicalOutlook} " +
+ " </if> " +
+ " ) as population where 1=1 " +
+ "<if test='populationListDTO.eventStatus != null'>" +
+ "AND population.eventStatus = #{populationListDTO.eventStatus} " +
+ " </if> " +
+ " </script>")
+ IPage<ComMngPopulationListVO> getGridPopulationAdminList(Page page,@Param("populationListDTO") ComMngPopulationListDTO populationListDTO);
+
+ @Select("select relation from com_mng_population_house_user where house_id = #{houseId} and popul_id = #{populationId}")
+ Integer getPopulationRelationByHouseId(@Param("houseId") Long houseId, @Param("populationId") Long populationId);
+
}
--
Gitblit v1.7.1