#

luxiaotao1123

2024-02-21 c270989672d8c3ff8b1cabe7453b01a972ac69f2

#

 zy-asrs-wcs/src/main/resources/mapper/system/UserMapper.xml

@@ -22,7 +22,27 @@
        <if test="param.deptId != null">
            and (FIND_IN_SET(#{param.deptId}, sd.`path`) OR sd.`id` = #{param.deptId})
        </if>
        <if test="param.username != null">
            and su.username like concat('%',#{param.username},'%')
        </if>
        <if test="param.nickname != null">
            and su.nickname like concat('%',#{param.nickname},'%')
        </if>
        <if test="param.phone != null">
            and su.phone like concat('%',#{param.phone},'%')
        </if>
        <if test="param.sex != null">
            and su.sex = #{param.sex}
        </if>
        <if test="param.status != null">
            and su.status = #{param.status}
        </if>
        <if test="param.condition != null">
            and (
                   su.username like concat('%',#{param.condition},'%')
                or su.nickname like concat('%',#{param.condition},'%')
                or su.phone like concat('%',#{param.condition},'%')
            )
        </if>
        order by su.create_time desc
    </select>