bug修改

101captain

2022-06-17 95c358dbe5865e9718870d030c745e2589c0becb

bug修改

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

@@ -724,19 +724,30 @@
               t1.contacts       as helpCommunityContactsName,
               t1.phone as helpCommunityContacts,
               t4.name           as communityName,
               t1.address
               t1.address,
               t1.village_name as unitVillageName
        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 t3 on t.help_community_id = t3.community_id
                 left join com_act t4 on t.community_id = t4.community_id
        where t.user_id = #{userId}
          and t.type = #{type}
    </select>
    <select id="getDetailByApp" resultType="com.panzhihua.common.model.vos.partybuilding.PartyBuildingMemberVO">
        select t.*,t1.village_name as unitVillageName,t1.help_community_name as helpCommunityName,t1.help_community_contacts as helpCommunityContacts,t1.help_community_contacts_name as helpCommunityContactsName,t1.nature_name,t2.name as villageName
        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 where t.id = #{id}
        select t.*,
               t1.contacts       as contactsName,
               t1.phone          as contacts,
               t1.name           as checkUnitName,
               t2.name           as villageName,
               t1.contacts       as helpCommunityContactsName,
               t1.phone as helpCommunityContacts,
               t4.name           as communityName,
               t1.address,
               t1.village_name as unitVillageName
        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}
    </select>
</mapper>