|  |  | 
 |  |  |         // 执行查询 | 
 |  |  |         PageHelper.startPage(pageWrap.getPage(), pageWrap.getCapacity()); | 
 |  |  |         List<SystemUserListVO> userList = systemUserMapper.selectManageList(pageWrap.getModel(), pageWrap.getOrderByClause()); | 
 |  |  |         String zhuboRoomUrl = systemDictDataBiz.queryByCode(Constants.SYSTEM, Constants.ZHUBO_ROOM_URL).getCode(); | 
 |  |  |  | 
 |  |  |         for (SystemUserListVO user : userList) { | 
 |  |  |             // 查询用户角色列表 | 
 |  |  |             user.setRoles(systemRoleService.findByUserId(user.getId())); | 
 |  |  |             // 查询用户岗位列表 | 
 |  |  | //            user.setPositions(systemPositionService.findByUserId(user.getId())); | 
 |  |  |             user.setZhuboRoomUrl(zhuboRoomUrl); | 
 |  |  |         } | 
 |  |  |         return PageData.from(new PageInfo<>(userList)); | 
 |  |  |     } | 
 |  |  | 
 |  |  |         MPJLambdaWrapper<SystemUser> queryWrapper = new MPJLambdaWrapper<>(); | 
 |  |  |  | 
 |  |  |         queryWrapper.selectAll(SystemUser.class); | 
 |  |  |         queryWrapper.eq(SystemUser::getDeleted, Constants.ZERO); | 
 |  |  |         queryWrapper.and(StringUtils.isNotBlank(pageWrap.getUsername()),ms->ms.like(SystemUser::getUsername,pageWrap.getUsername()) | 
 |  |  |                 .or().like(SystemUser::getMobile,pageWrap.getUsername()) | 
 |  |  |                 .or().like(SystemUser::getRealname,pageWrap.getUsername()) | 
 |  |  |         ); | 
 |  |  |         queryWrapper.eq(SystemUser::getDeleted, Constants.ZERO) | 
 |  |  |                     .eq(SystemUser::getType,pageWrap.getType()); | 
 |  |  |         queryWrapper.orderByDesc(SystemUser::getCreateTime); | 
 |  |  |         List<SystemUser> result = systemUserJoinMapper.selectJoinList(SystemUser.class, queryWrapper); | 
 |  |  |  |