From 91275344f85d2777be0f276e9d9da3f6f3fa6728 Mon Sep 17 00:00:00 2001
From: tangxiaobao <303826152@qq.com>
Date: 星期五, 20 八月 2021 18:48:44 +0800
Subject: [PATCH] 实有人口和社区关系以及对应标签修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java | 3 ++-
1 files changed, 2 insertions(+), 1 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 3d7862b..84930d7 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
@@ -229,7 +229,7 @@
" cmp.`name`, " +
" IFNULL( cmp.phone, '暂无' ) as phone, " +
" cmp.card_no, " +
- " cmp.label, " +
+ " cmpct.label, " +
" cmp.address, " +
" cmp.nation, " +
" cmphu.create_at, " +
@@ -237,6 +237,7 @@
"FROM " +
" com_mng_population_house_user AS cmphu " +
" LEFT JOIN com_mng_population AS cmp ON cmp.id = cmphu.popul_id " +
+ " left join com_mng_population_community_tags AS cmpct on cmp.id = cmpct.population_id " +
"WHERE " +
" cmphu.house_id = #{houseId} " +
"<if test='relation != null '>" +
--
Gitblit v1.7.1