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

张天森

2022-10-18 6c6528abbac5b3d1297565929e163819ff3ab76a

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

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

@@ -319,7 +319,7 @@
            AND current_process_type=4
        </if>) as expirences,
        (select count(id) FROM com_sanshuo_event_info
        where event_result=1
        where event_result=2
        AND user_event_status not in(3,4)
        <if test="dto.type == 2">
            AND current_process_type=1
@@ -343,7 +343,7 @@
            AND current_process_type=4
        </if>) as success,
        (select count(id) FROM com_sanshuo_event_info
        where event_result=2
        where event_result=1
        AND user_event_status not in(3,4)
        <if test="dto.type == 2">
            AND current_process_type=1
@@ -492,21 +492,21 @@
        </if>
    </select>
    <select id="eventRate" resultType="com.panzhihua.common.model.vos.sanshuo.EventRateVO">
        select count(id) as count,type from com_sanshuo_event_info
        where event_process_status not in(7.8)
        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
    </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
        left join com_sanshuo_expert t1 on t.specialist_id=t1.id
        where t.event_process_status not in(7.8)
        where t.event_process_status not in(7,8,9)
        group by t1.level
        having type is not null
    </select>
    <select id="mediateTypeRate" resultType="com.panzhihua.common.model.vos.sanshuo.EventRateVO">
        select count(t.id) as count,t1.name from com_sanshuo_event_info t
        left join com_mediate_type t1 on t.event_category=t1.id
        where t.event_process_status not in(7.8)
        where t.event_process_status not in(7,8,9)
        group by t.event_category
    </select>