添加微信昵称

puhanshu

2022-08-02 db30d47c4bcd88ba37bf5720f01563356ccac281

添加微信昵称

 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbMemberMapper.xml

@@ -759,11 +759,13 @@
               t4.name           as communityName,
               t1.address,
               t1.village_name as unitVillageName,
               t1.belong_to
               t1.belong_to,
               su.nick_name
        from com_pb_member t
                 left join com_pb_check_unit t1 on t.check_unit_id = t1.id
                 left join com_mng_village t2 on t.village_id = t2.village_id
                 left join com_act t4 on t.community_id = t4.community_id where t.id = #{id}
        LEFT JOIN sys_user su ON t.user_id = su.user_id
         left join com_pb_check_unit t1 on t.check_unit_id = t1.id
         left join com_mng_village t2 on t.village_id = t2.village_id
         left join com_act t4 on t.community_id = t4.community_id where t.id = #{id}
    </select>
</mapper>