bug修改

puhanshu

2022-03-11 895e247dd31902c1af0968d8feda6be32521794d

bug修改

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngVolunteerMngDOMapper.xml

@@ -211,7 +211,12 @@
    </select>
    <select id="detailVolunteerExamine"
            resultType="com.panzhihua.common.model.vos.community.ComMngVolunteerMngVO">

        SELECT t1.*, t2.`name` AS orgName, t3.`name` AS teamName, t4.`name` AS skillName
        FROM com_mng_volunteer_mng t1
        LEFT JOIN com_mng_volunteer_org_team t2 ON t1.org_id = t2.id
        LEFT JOIN com_mng_volunteer_org_team t3 On t1.team_id = t3.id
        LEFT JOIN com_mng_volunteer_skill t4 ON t1.skill_id = t4.id
        WHERE t1.id = #{id}
    </select>

</mapper>