三社功能修改

101captain

2022-03-03 5c08ec0943efb3e90e83867577768c2b387ce9b1

三社功能修改

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

@@ -55,11 +55,15 @@
        left join com_mng_volunteer_org_team as cmvot1 on cmvot1.id = cmvm.team_id
        left join com_mng_volunteer_skill as cmvs on cmvs.id = cmvm.skill_id
        left join com_mng_volunteer_service_type as cmvst on cmvst.id = cmvot1.service_type_id
        left join com_act t on cmvm.community_id = t1.community_id
        WHERE
        cmvm.state = 2
        <if test="comMngVolunteerMngVO.communityId !=null">
         and   cmvm.community_id = #{comMngVolunteerMngVO.communityId}
        </if>
        <if test="comMngVolunteerMngVO.streetId !=null">
            and   t.street_id = #{comMngVolunteerMngVO.streetId}
        </if>
        <if test='comMngVolunteerMngVO.name != null and comMngVolunteerMngVO.name != &quot;&quot;'>
            and cmvm.name like concat(#{comMngVolunteerMngVO.name},'%')
        </if>