From fe748ee9ccc6844669a86b2844542883d927aa9c Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期四, 30 九月 2021 10:44:21 +0800
Subject: [PATCH] 修改四长四员功能
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActFourMemberMapper.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActFourMemberMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActFourMemberMapper.xml
index 99923b0..4fbc03c 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActFourMemberMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActFourMemberMapper.xml
@@ -21,7 +21,7 @@
</resultMap>
<select id="pageList" resultMap="baseResultMap">
- select t.*,t1.* from com_act_four_member t left join sys_user t1 on t.user_id = t1.user_id
+ select t.*,t1.*,t2.role_id from com_act_four_member t left join sys_user t1 on t.user_id = t1.user_id left join sys_user_role t2 on t.user_id =t2.user_id
<where>
1=1
<if test="commonPage.paramId !=null">
@@ -45,7 +45,7 @@
</select>
<select id="getById" resultMap="baseResultMap">
- select t.*,t1.* from com_act_four_member t left join sys_user t1 on t.user_id = t1.user_id where t.id =#{id}
+ select t.*,t1.*,t2.role_id from com_act_four_member t left join sys_user t1 on t.user_id = t1.user_id left join sys_user_role t2 on t.user_id =t2.user_id where t.id =#{id}
</select>
</mapper>
--
Gitblit v1.7.1