From 18d57a650e29bbadefbca3022192fcac93c438ec Mon Sep 17 00:00:00 2001 From: Flex <q1406482700@163.com> Date: 星期四, 26 六月 2025 15:10:44 +0800 Subject: [PATCH] Merge branch 'main' of http://yykjgit.sdyyst.com/r/school-ai --- ruoyi-modules-api/ruoyi-system-api/src/main/resources/mapper/SysUserMapper.xml | 12 ++++++++++++ 1 files changed, 12 insertions(+), 0 deletions(-) diff --git a/ruoyi-modules-api/ruoyi-system-api/src/main/resources/mapper/SysUserMapper.xml b/ruoyi-modules-api/ruoyi-system-api/src/main/resources/mapper/SysUserMapper.xml index 8d39f48..67d648e 100644 --- a/ruoyi-modules-api/ruoyi-system-api/src/main/resources/mapper/SysUserMapper.xml +++ b/ruoyi-modules-api/ruoyi-system-api/src/main/resources/mapper/SysUserMapper.xml @@ -143,6 +143,18 @@ <include refid="selectUserVo"/> where u.del_flag = '0' and u.user_id = #{userId} </select> + <select id="selectUserByRoleIds" resultMap="SysUserResult"> + <include refid="selectUserVo"/> + where u.del_flag = '0' and r.role_id in <foreach item="item" collection="list" separator="," open="(" close=")" index=""> + #{item} + </foreach> + </select> + <select id="selectUserByDeptIds" resultMap="SysUserResult"> + <include refid="selectUserVo"/> + where u.del_flag = '0' and u.dept_id in <foreach item="item" collection="list" separator="," open="(" close=")" index=""> + #{item} + </foreach> + </select> </mapper> -- Gitblit v1.9.3