From 151bfa7ab112a0675f4ca48cc414f4398b30cd0d Mon Sep 17 00:00:00 2001
From: 罗元桥 <2376770955@qq.com>
Date: 星期五, 16 七月 2021 21:37:45 +0800
Subject: [PATCH] Merge branch 'test' into 'master'

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java |    6 +++++-
 1 files changed, 5 insertions(+), 1 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 1e42251..528d697 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
@@ -69,10 +69,12 @@
             "cmp.remark, " +
             "cmv.alley, " +
             "cmp.native_place, " +
+            "cmphu.relation, " +
             "cmp.nation  " +
             "FROM  " +
             "com_mng_population AS cmp " +
             "LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmp.village_id " +
+            "LEFT JOIN com_mng_population_house_user AS cmphu ON cmphu.popul_id = cmp.id " +
             "<where>" +
             "<if test='comMngPopulationVO.name != null and comMngPopulationVO.name.trim() != &quot;&quot;'>" +
             "AND cmp.`name` LIKE concat(#{comMngPopulationVO.name},'%') " +
@@ -155,10 +157,12 @@
             "cmp.birthday,  " +
             "cmp.update_at,  " +
             "cmp.address,  " +
-            "cmp.is_rent  " +
+            "cmp.is_rent,  " +
+            "cmphu.relation  " +
             "FROM  " +
             "com_mng_population AS cmp " +
             "LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmp.village_id " +
+            "LEFT JOIN com_mng_population_house_user AS cmphu ON cmphu.popul_id = cmp.id " +
             "<where>" +
             "<if test='comMngPopulationVO.name != null and comMngPopulationVO.name != &quot;&quot;'>" +
             "AND cmp.`name` LIKE concat(#{comMngPopulationVO.name},'%') " +

--
Gitblit v1.7.1