修改显示问题

lidongdong

2022-12-08 ba5b600ce958cc5758f400be42b03ec8f0fa999a

修改显示问题

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

@@ -120,28 +120,31 @@
    </sql>

    <select id="selectNum" parameterType="string" resultType="integer">
        select count(user_id) from automessage_sys_user
        <where>
            <if test="userType != null and userType != ''">
                AND user_type=#{userType}
            </if>
            <if test="ids != null">
                and department_id IN
                <foreach collection="ids" item="param"  open="(" close=")" separator=",">
                    #{param}
                </foreach>
            </if>
            <if test="isDivisionHead != null and isDivisionHead != ''">
                AND is_division_head=#{isDivisionHead}
            </if>
            <if test="userName != null and userName != ''">
                AND (user_name like concat('%', #{userName}, '%') or
                (department_id in (SELECT id FROM automessage_organization_chart
                WHERE organization_name like concat('%', #{userName}, '%'))) or
                phonenumber like concat('%', #{userName}, '%'))
            </if>

        </where>
        SET SESSION group_concat_max_len=10240

<!--        select count(user_id) from automessage_sys_user-->
<!--        <where>-->
<!--            <if test="userType != null and userType != ''">-->
<!--                AND user_type=#{userType}-->
<!--            </if>-->
<!--            <if test="ids != null">-->
<!--                and department_id IN-->
<!--                <foreach collection="ids" item="param"  open="(" close=")" separator=",">-->
<!--                    #{param}-->
<!--                </foreach>-->
<!--            </if>-->
<!--            <if test="isDivisionHead != null and isDivisionHead != ''">-->
<!--                AND is_division_head=#{isDivisionHead}-->
<!--            </if>-->
<!--            <if test="userName != null and userName != ''">-->
<!--                AND (user_name like concat('%', #{userName}, '%') or-->
<!--                (department_id in (SELECT id FROM automessage_organization_chart-->
<!--                WHERE organization_name like concat('%', #{userName}, '%'))) or-->
<!--                phonenumber like concat('%', #{userName}, '%'))-->
<!--            </if>-->

<!--        </where>-->
    </select>

    <select id="queryList"  resultMap="SysUserResult">