| | |
| | | <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> |