/**
 * 获取导出用户列表
 *
 * @param queryParams 查询参数
 * @return {@link List<UserExportVO>} 导出用户列表
 */
@Override
public List<UserExportVO> listExportUsers(UserPageQuery queryParams) {
    return this.baseMapper.listExportUsers(queryParams);
}
/**
 * 获取导出用户列表
 *
 * @param queryParams
 * @return
 */
@DataPermission(deptAlias = "u")
List<UserExportVO> listExportUsers(UserPageQuery queryParams);
<!-- 获取用户导出列表 -->
<select id="listExportUsers" resultType="com.youlai.system.model.vo.UserExportVO">
    SELECT
        u.username,
        u.nickname,
        u.mobile,
        CASE u.gender
            WHEN 1 THEN '男'
            WHEN 2 THEN '女'
            ELSE '未知'
        END gender,
        d.NAME AS dept_name,
        u.create_time
    FROM
        sys_user u
            LEFT JOIN sys_dept d ON u.dept_id = d.id
    <where>
        u.deleted = 0 AND u.username != 'root'
        <if test='keywords!=null and keywords.trim() neq ""'>
            AND (u.username LIKE CONCAT('%',#{keywords},'%')
            OR u.nickname LIKE CONCAT('%',#{keywords},'%')
            OR u.mobile LIKE CONCAT('%',#{keywords},'%'))
        </if>
        <if test='status!=null'>
            AND u.status = #{status}
        </if>
        <if test='deptId!=null'>
            AND concat(',',concat(d.tree_path,',',d.id),',') like concat('%,',#{deptId},',%')
        </if>
    </where>
    GROUP BY u.id
</select>