修改花城 随手拍接口新增分类筛选

lidongdong

2024-05-17 70a403f1a8146f28021fb3f20363c56f0f876ad3

修改花城 随手拍接口新增分类筛选

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

@@ -539,30 +539,33 @@
        LEFT JOIN com_act_easy_photo_classify class ON p.classify_id = class.id
        LEFT JOIN (SELECT * FROM com_act_easy_photo_feedback WHERE `type` = 2) f ON p.id = f.easy_id
        <where> p.del_tag = 0
        <if test = 'comActEasyPhotoVO.communityId != null and comActEasyPhotoVO.communityId != 0' >
            AND p.community_id = ${comActEasyPhotoVO.communityId}
        </if>
        <if test="comActEasyPhotoVO.addType != null and comActEasyPhotoVO.addType != ''">
            AND p.add_type=${comActEasyPhotoVO.addType}
        </if>
        <if test = 'comActEasyPhotoVO.status != null and comActEasyPhotoVO.status!=0' >
            AND p.`status` = #{comActEasyPhotoVO.status}
        </if>
        <if test='comActEasyPhotoVO.sponsorId != null and comActEasyPhotoVO.sponsorId != 0'>
            AND p.sponsor_id = #{comActEasyPhotoVO.sponsorId}
        </if>
        <if test='comActEasyPhotoVO.sponsorId == null or comActEasyPhotoVO.sponsorId==0'>
            AND p.`status` in (2,4,5)
            <if test="comActEasyPhotoVO.isFeedBackForDpc == null or comActEasyPhotoVO.isDpcMember == 0">
                AND p.is_publicity = 1
            <if test = 'comActEasyPhotoVO.communityId != null and comActEasyPhotoVO.communityId != 0' >
                AND p.community_id = ${comActEasyPhotoVO.communityId}
            </if>
        </if>
        <if test='comActEasyPhotoVO.isReportDpc != null' >
            AND p.`is_report_dpc` = #{comActEasyPhotoVO.isReportDpc}
        </if>
        <if test='comActEasyPhotoVO.keyWord != null and comActEasyPhotoVO.keyWord != &quot;&quot;'>
            AND (class.`name` like concat(#{comActEasyPhotoVO.keyWord},'%') or p.detail like concat(#{comActEasyPhotoVO.keyWord},'%'))
        </if>
            <if test="comActEasyPhotoVO.addType != null and comActEasyPhotoVO.addType != ''">
                AND p.add_type=${comActEasyPhotoVO.addType}
            </if>
            <if test = 'comActEasyPhotoVO.status != null and comActEasyPhotoVO.status!=0' >
                AND p.`status` = #{comActEasyPhotoVO.status}
            </if>
            <if test='comActEasyPhotoVO.sponsorId != null and comActEasyPhotoVO.sponsorId != 0'>
                AND p.sponsor_id = #{comActEasyPhotoVO.sponsorId}
            </if>
            <if test='comActEasyPhotoVO.sponsorId == null or comActEasyPhotoVO.sponsorId==0'>
                AND p.`status` in (2,4,5)
                <if test="comActEasyPhotoVO.isFeedBackForDpc == null or comActEasyPhotoVO.isDpcMember == 0">
                    AND p.is_publicity = 1
                </if>
            </if>
            <if test='comActEasyPhotoVO.isReportDpc != null' >
                AND p.`is_report_dpc` = #{comActEasyPhotoVO.isReportDpc}
            </if>
            <if test='comActEasyPhotoVO.keyWord != null and comActEasyPhotoVO.keyWord != &quot;&quot;'>
                AND (class.`name` like concat(#{comActEasyPhotoVO.keyWord},'%') or p.detail like concat(#{comActEasyPhotoVO.keyWord},'%'))
            </if>
            <if test='comActEasyPhotoVO.classifyId != null and comActEasyPhotoVO.classifyId != &quot;&quot;'>
                AND p.classify_id =#{comActEasyPhotoVO.classifyId}
            </if>
        </where>
        group by p.id
        <if test="comActEasyPhotoVO.isFeedBackForDpc != null">