From 1440b9e4663ec6bbab0aa00ab6ad21e1fc6fc94c Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期一, 27 九月 2021 09:46:14 +0800
Subject: [PATCH] 修改关联小区名称
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActCommitteeMapper.xml | 2 +-
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPropertyMapper.xml | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActCommitteeMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActCommitteeMapper.xml
index b1c71f5..f1275ec 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActCommitteeMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActCommitteeMapper.xml
@@ -14,7 +14,7 @@
</resultMap>
<select id="pageList" resultType="com.panzhihua.common.model.vos.community.ComActCommiteeVO">
- select t.*,t1.account,t1.password,t2.name as areaName,t3.role_id as roleId from com_act_committee t
+ select t.*,t1.account,t1.password,t2.address as areaName,t3.role_id as roleId from com_act_committee t
left join sys_user t1 on t.user_id = t1.user_id
left join com_mng_village t2 on t.area_id = t2.village_id
left join sys_user_role t3 on t.user_id = t3.user_id
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPropertyMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPropertyMapper.xml
index 5f6ab64..e3afa29 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPropertyMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComPropertyMapper.xml
@@ -16,7 +16,7 @@
</resultMap>
<select id="pageList" resultType="com.panzhihua.common.model.vos.community.ComPropertyVO">
- select t.*,t1.account,t1.password,t2.name as areaName,t3.role_id as roleId from com_property t
+ select t.*,t1.account,t1.password,t2.address as areaName,t3.role_id as roleId from com_property t
left join sys_user t1 on t.user_id = t1.user_id
left join com_mng_village t2 on t.area_id = t2.village_id
left join sys_user_role t3 on t.user_id = t3.user_id
--
Gitblit v1.7.1