| | |
|---|
| | | */ |
|---|
| | | @Override |
|---|
| | | public TableDataInfo<SysUser> selectUnallocatedList(SysUser user, PageQuery pageQuery) { |
|---|
| | | List<Long> userId = userRoleMapper.selectUserIdsByRoleId(user.getRoleId()); |
|---|
| | | List<Long> userIds = userRoleMapper.selectUserIdsByRoleId(user.getRoleId()); |
|---|
| | | QueryWrapper<SysUser> wrapper = Wrappers.query(); |
|---|
| | | wrapper.eq("u.del_flag", UserConstants.USER_NORMAL) |
|---|
| | | .and(w -> w.ne("r.role_id", user.getRoleId()).or().isNull("r.role_id")) |
|---|
| | | .notIn("u.user_id", userId) |
|---|
| | | .notIn(CollUtil.isNotEmpty(userIds), "u.user_id", userIds) |
|---|
| | | .like(StringUtils.isNotBlank(user.getUserName()), "u.user_name", user.getUserName()) |
|---|
| | | .like(StringUtils.isNotBlank(user.getPhonenumber()), "u.phonenumber", user.getPhonenumber()); |
|---|
| | | Page<SysUser> page = baseMapper.selectUnallocatedList(pageQuery.build(), wrapper); |
|---|
