三说会堂事件搜索修改

张天森

2022-12-08 8f1b188a553c28d4be7357e8d1094ad98a8a5b96

三说会堂事件搜索修改

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

@@ -207,8 +207,9 @@
            <foreach collection="comEvent.communityIds" item="id" separator="," open="(" close=")">
                #{id}
            </foreach>
        </if><if test="comEvent.level != null and comEvent.level != ''">
            <if test="comEvent.searchId != null and comEvent.searchId != ''">
        </if>
            <if test="comEvent.level != null and comEvent.level != ''">
                <if test="comEvent.searchId != null and comEvent.searchId != ''">
                    <if test="comEvent.level == 1">
                        AND type=4 OR current_process_type=4
                    </if>
@@ -222,11 +223,12 @@
                    <if test="comEvent.level == 4">
                        AND request_user_community=#{comEvent.searchId} AND current_process_type in (2,5)
                    </if>
                </if>
            </if>
        </if>
    </where>
        group by event_process_status
    </select>

    <select id="caculateSum" resultType="int">
        select count(id) as  sum
        from com_sanshuo_event_info
@@ -259,16 +261,17 @@
            <if test="comEvent.level != null and comEvent.level != ''">
                <if test="comEvent.searchId != null and comEvent.searchId != ''">
                    <if test="comEvent.level == 1">
                        AND type=4
                        AND type=4 OR current_process_type=4
                    </if>
                    <if test="comEvent.level == 2">
                        AND center_id=#{comEvent.searchId} AND current_process_type=1
                        AND center_id=#{comEvent.searchId} AND current_process_type in(1,5)
                    </if>
                    <if test="comEvent.level == 3">
                        AND request_user_community in (select community_id from com_act where street_id=#{comEvent.searchId}) AND current_process_type=3
                        AND request_user_community in (select community_id from com_act where street_id=#{comEvent.searchId})
                        AND current_process_type in (3,5)
                    </if>
                    <if test="comEvent.level == 4">
                        AND request_user_community=#{comEvent.searchId} AND current_process_type=2
                        AND request_user_community=#{comEvent.searchId} AND current_process_type in (2,5)
                    </if>
                </if>
            </if>