修改部门数据统计导办人员排行榜问题

lidongdong

2022-11-22 57c7182dc085aec248b3742dde1e5a0ea40fab00

修改部门数据统计导办人员排行榜问题

 flower_city/src/main/resources/mapper/HomeStatisticsMapper.xml

@@ -7,7 +7,14 @@
        SELECT
            user_name as userName,
            (SELECT organization_name FROM automessage_organization_chart WHERE  automessage_organization_chart.id=department_id) as departmentNmae,
            (select count(id) from automessage_guide_repair_order WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id and automessage_guide_repair_order.state=3 ) as num
            (select count(id) from automessage_guide_repair_order WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id
                                                                    and automessage_guide_repair_order.state=3
                <if test="ids != null">
                    and guide_department_id IN
                    <foreach collection="ids" item="param"  open="(" close=")" separator=",">
                        #{param}
                    </foreach>
                </if>) as num
        FROM automessage_sys_user
        <where>
            user_type=2
@@ -29,7 +36,14 @@
            user_name,
            (SELECT organization_name FROM automessage_organization_chart WHERE  automessage_organization_chart.id=department_id) as departmentNmae,
            ((select sum(IF(evaluate_state='1',10,IF(evaluate_state='2',5,0))) from automessage_guide_repair_order
            WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id)/(select count(id) from automessage_guide_repair_order WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id)) as num
            WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id)/(select count(id) from automessage_guide_repair_order
            WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id)
            <if test="ids != null">
                and guide_department_id IN
                <foreach collection="ids" item="param"  open="(" close=")" separator=",">
                    #{param}
                </foreach>
            </if>) as num
        FROM automessage_sys_user
        <where>
            user_type=2
@@ -50,7 +64,13 @@
        SELECT
            user_name as userName,
            (SELECT organization_name FROM automessage_organization_chart WHERE  automessage_organization_chart.id=department_id) as departmentNmae,
            (select count(id) from automessage_guide_repair_order WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id and automessage_guide_repair_order.is_timeout=2
            (select count(id) from automessage_guide_repair_order WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id
                    and automessage_guide_repair_order.is_timeout=2 <if test="ids != null">
                and guide_department_id IN
                <foreach collection="ids" item="param"  open="(" close=")" separator=",">
                    #{param}
                </foreach>
            </if>
            ) as num
        FROM automessage_sys_user
        <where>
@@ -73,7 +93,14 @@
        SELECT
        user_name as userName,
        (SELECT organization_name FROM automessage_organization_chart WHERE  automessage_organization_chart.id=department_id) as departmentNmae,
        (select count(id) from automessage_guide_repair_order WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id and automessage_guide_repair_order.state=2
        (select count(id) from automessage_guide_repair_order WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id
                                                                and automessage_guide_repair_order.state=2
        <if test="ids != null">
            and guide_department_id IN
            <foreach collection="ids" item="param"  open="(" close=")" separator=",">
                #{param}
            </foreach>
        </if>
        ) as num
        FROM automessage_sys_user
        <where>
@@ -95,7 +122,13 @@
        SELECT
        user_name as userName,
        (SELECT organization_name FROM automessage_organization_chart WHERE  automessage_organization_chart.id=department_id) as departmentNmae,
        (select count(id) from automessage_guide_repair_order WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id) as num
        (select count(id) from automessage_guide_repair_order WHERE automessage_guide_repair_order.guide_user_id=automessage_sys_user.user_id
            <if test="ids != null">
                and guide_department_id IN
                <foreach collection="ids" item="param"  open="(" close=")" separator=",">
                    #{param}
                </foreach>
            </if>) as num
        FROM automessage_sys_user
        <where>
            user_type=2