From 865dd9566ca19fd56421c33694c3b05e97c0533c Mon Sep 17 00:00:00 2001 From: lidongdong <1459917685@qq.com> Date: 星期五, 24 十一月 2023 10:44:36 +0800 Subject: [PATCH] 修改商家列表没数据 --- springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightComConvenientMerchantsMapper.xml | 4 +++- 1 files changed, 3 insertions(+), 1 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightComConvenientMerchantsMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightComConvenientMerchantsMapper.xml index 4dbf9c4..c4841fc 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightComConvenientMerchantsMapper.xml +++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightComConvenientMerchantsMapper.xml @@ -282,7 +282,9 @@ </update> <select id="selectUserList" resultType="com.panzhihua.common.model.vos.user.SysUserVO"> - select su.user_id,su.phone,su.nick_name,su.name,su.community_id from sys_user as su + select su.user_id,su.phone,su.nick_name,su.name,su.community_id,caiu.integral_available_sum as loveIntegral + from sys_user as su + left join com_act_integral_user as caiu on caiu.user_id=su.user_id <where> 1=1 <if test="communityId!=null and communityId !='' "> -- Gitblit v1.7.1