springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDiscussDOMapper.xml
@@ -332,7 +332,7 @@ <select id="pageCourtyardDiscuss" resultType="com.panzhihua.common.model.vos.community.ComActDiscussVO"> SELECT id, `type`, discuss_subject, photo_pah, create_at FROM com_act_discuss WHERE community_id = #{pageBaseDTO.communityId} AND content_type = 2 AND is_del = 2 AND photo_pah IS NOT NULL AND content_type = 2 AND is_del = 2 <if test="pageBaseDTO.param3 != null"> AND `type` = #{pageBaseDTO.param3} </if> springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngVolunteerMngDOMapper.xml
@@ -175,7 +175,7 @@ FROM com_mng_volunteer_mng t1 INNER JOIN com_mng_volunteer_org_team t2 ON t1.team_id = t2.id INNER JOIN com_mng_volunteer_org_team t3 ON t1.org_id = t3.id WHERE t1.community_id = #{communityId} WHERE t1.community_id = #{communityId} AND t1.state = 2 </select> <select id="pageVolunteerExamine" resultType="com.panzhihua.common.model.vos.community.ComMngVolunteerMngVO">