| | |
| | | import org.dromara.system.domain.SysUserPost; |
| | | import org.dromara.system.domain.SysUserRole; |
| | | import org.dromara.system.domain.bo.SysUserBo; |
| | | import org.dromara.system.domain.vo.SysDeptVo; |
| | | import org.dromara.system.domain.vo.SysPostVo; |
| | | import org.dromara.system.domain.vo.SysRoleVo; |
| | | import org.dromara.system.domain.vo.SysUserVo; |
| | |
| | | List<Long> ids = StreamUtils.toList(deptList, SysDept::getDeptId); |
| | | ids.add(user.getDeptId()); |
| | | w.in("u.dept_id", ids); |
| | | }); |
| | | }).orderByAsc("u.user_id"); |
| | | return wrapper; |
| | | } |
| | | |
| | |
| | | .eq(ObjectUtil.isNotNull(user.getRoleId()), "r.role_id", user.getRoleId()) |
| | | .like(StringUtils.isNotBlank(user.getUserName()), "u.user_name", user.getUserName()) |
| | | .eq(StringUtils.isNotBlank(user.getStatus()), "u.status", user.getStatus()) |
| | | .like(StringUtils.isNotBlank(user.getPhonenumber()), "u.phonenumber", user.getPhonenumber()); |
| | | .like(StringUtils.isNotBlank(user.getPhonenumber()), "u.phonenumber", user.getPhonenumber()) |
| | | .orderByAsc("u.user_id"); |
| | | Page<SysUserVo> page = baseMapper.selectAllocatedList(pageQuery.build(), wrapper); |
| | | return TableDataInfo.build(page); |
| | | } |
| | |
| | | .and(w -> w.ne("r.role_id", user.getRoleId()).or().isNull("r.role_id")) |
| | | .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()); |
| | | .like(StringUtils.isNotBlank(user.getPhonenumber()), "u.phonenumber", user.getPhonenumber()) |
| | | .orderByAsc("u.user_id"); |
| | | Page<SysUserVo> page = baseMapper.selectUnallocatedList(pageQuery.build(), wrapper); |
| | | return TableDataInfo.build(page); |
| | | } |
| | |
| | | public List<SysUserVo> selectUserListByDept(Long deptId) { |
| | | LambdaQueryWrapper<SysUser> lqw = Wrappers.lambdaQuery(); |
| | | lqw.eq(SysUser::getDeptId, deptId); |
| | | lqw.orderByAsc(SysUser::getUserId); |
| | | return baseMapper.selectVoList(lqw); |
| | | } |
| | | |