修改导办人员登录系统导办列表数据不对 bug

lidongdong

2022-10-27 150bacb29c8ce6663e189e254b4e48f6984b4d0e

修改导办人员登录系统导办列表数据不对  bug

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

@@ -82,6 +82,15 @@
    <select id="selectConfigList"  resultMap="GuideRepairOrderResult">
        <include refid="selectGuideRepairOrderVo"/>
        <where>
            <if test="ids != null">
                and department_id IN
                <foreach collection="ids" item="param"  open="(" close=")" separator=",">
                    #{param}
                </foreach>
            </if>
            <if test="guideUserId != null and guideUserId != ''">
                AND a.guide_user_id=#{guideUserId}
            </if>
            <if test="matterName != null and matterName != ''">
                AND (matter_name like concat('%', #{matterName}, '%')) or
                ( classify_id in ( SELECT id FROM automessage_classify_administration WHERE classify_name like concat('%', #{matterName}, '%') ) )
@@ -96,15 +105,6 @@
            <if test="status != null and status != ''">
                AND a.state=#{status}
            </if>
            <if test="ids != null">
                and department_id IN
                <foreach collection="ids" item="param"  open="(" close=")" separator=",">
                    #{param}
                </foreach>
            </if>
            <if test="guideUserId != null and guideUserId != ''">
                AND a.guide_user_id=#{guideUserId}
            </if>
        </where>
        order by  update_time desc ,  create_time desc
    </select>
@@ -112,6 +112,15 @@
    <select id="countConfigList"  resultType="integer">
        select count(id) from automessage_guide_repair_order
        <where>
            <if test="ids != null">
                and department_id IN
                <foreach collection="ids" item="param"  open="(" close=")" separator=",">
                    #{param}
                </foreach>
            </if>
            <if test="guideUserId != null and guideUserId != ''">
                AND automessage_guide_repair_order.guide_user_id=#{guideUserId}
            </if>
            <if test="matterName != null and matterName != ''">
                AND (matter_name like concat('%', #{matterName}, '%')) or
                ( classify_id in ( SELECT id FROM automessage_classify_administration WHERE classify_name like concat('%', #{matterName}, '%') ) )
@@ -126,15 +135,7 @@
            <if test="status != null and status != ''">
                AND automessage_guide_repair_order.state=#{status}
            </if>
            <if test="ids != null">
                and department_id IN
                <foreach collection="ids" item="param"  open="(" close=")" separator=",">
                    #{param}
                </foreach>
            </if>
            <if test="guideUserId != null and guideUserId != ''">
                AND automessage_guide_repair_order.guide_user_id=#{guideUserId}
            </if>

        </where>
    </select>