三说会堂事件操作权限处理

张天森

2022-10-18 5256c155f23376f8a81e3c4dc1c19d5b8b279393

三说会堂事件操作权限处理

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComEventServiceImpl.java

@@ -1055,8 +1055,6 @@
                return "社区调解站受理";
            case 4:
                return "区三说会堂受理";
            case 5:
                return "专家受理";
        }
        return null;
    }

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

@@ -294,29 +294,32 @@
        <if test="dto.type == 1">
            AND current_process_type=4
        </if>) as accepted,
        (SELECT count(id) FROM com_sanshuo_event_info
        where event_process_status in (6,7)
        AND user_event_status not in(3,4)
        (SELECT count(id) FROM com_sanshuo_event_info as  t
        left join com_sanshuo_event_transfer_record as  t1
        on t.id=t1.even_id
        where t.event_process_status in (6,7)
        AND t.user_event_status not in(3,4)
        AND t1.event_status=7
        <if test="dto.type == 2">
            AND current_process_type=1
            AND t.current_process_type=1
            <if test="dto.id != null">
                AND center_id=#{dto.id}
                AND t.center_id=#{dto.id}
            </if>
        </if>
        <if test="dto.type == 3">
            AND current_process_type=3
            AND t.current_process_type=3
            <if test="dto.id != null">
                AND request_user_community in (select com_act.community_id from com_act where street_id=#{dto.id})
                AND t.request_user_community in (select com_act.community_id from com_act where street_id=#{dto.id})
            </if>
        </if>
        <if test="dto.type == 4">
            AND current_process_type in(2,5)
            AND t.current_process_type in(2,5)
            <if test="dto.id != null">
                AND request_user_community=#{dto.id}
                AND t.request_user_community=#{dto.id}
            </if>
        </if>
        <if test="dto.type == 1">
            AND current_process_type=4
            AND t.current_process_type=4
        </if>) as expirences,
        (select count(id) FROM com_sanshuo_event_info
        where event_result=2
@@ -472,6 +475,7 @@
        select count(id) as count,current_process_type from com_sanshuo_event_info
        where event_process_status not in(7,8,9)
        group by current_process_type
        having current_process_type &lt;>5
    </select>
    <select id="expertRate" resultType="com.panzhihua.common.model.vos.sanshuo.EventRateVO">
        select count(t.id) as count,t1.level as type  from com_sanshuo_event_info t