From c45d5cbd3dc0aafa19f03500c0c26331f56175e3 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期三, 23 六月 2021 18:21:59 +0800
Subject: [PATCH] 居民接口开发
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 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 30d4123..7413c4b 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
@@ -15,6 +15,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.PopulationDetailVO;
import com.panzhihua.common.model.vos.grid.PopulationListVO;
import com.panzhihua.common.model.vos.user.*;
import com.panzhihua.common.model.vos.community.PageComActMessageVO;
@@ -878,4 +879,35 @@
" </script>")
IPage<PopulationListVO> pagePopulationListApp(Page page, @Param("populationListDTO") PagePopulationListDTO populationListDTO);
+ @Select("SELECT " +
+ " cmp.id, " +
+ " cmp.`name`, " +
+ " cmp.phone, " +
+ " cmp.card_no, " +
+ " cmp.label, " +
+ " cmp.address, " +
+ " cmp.nation, " +
+ " cmp.political_outlook, " +
+ " cmp.sex, " +
+ " cmp.birthday, " +
+ " cmp.native_place, " +
+ " cmp.healthy, " +
+ " cmp.is_rent, " +
+ " cmv.alley AS road, " +
+ " cmv.house_num AS doorNo, " +
+ " cmp.floor, " +
+ " cmp.unit_no, " +
+ " cmp.house_no, " +
+ " cmp.work_company, " +
+ " cmp.census_register, " +
+ " cmp.out_or_local, " +
+ " cmp.remark, " +
+ " cmp.marriage " +
+ "FROM " +
+ " com_mng_population AS cmp " +
+ " LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmp.village_id " +
+ "WHERE " +
+ " id = #{populationId}")
+ PopulationDetailVO getPopulationDetailApp(@Param("populationId") Long populationId);
+
}
--
Gitblit v1.7.1