| | |
| | | private RoleMapper mapper; |
| | | @Resource |
| | | private UserRoleMapper userRoleMapper; |
| | | @Resource |
| | | private UserMapper userMapper; |
| | | |
| | | |
| | | public List<Role> getAll() { |
| | | return mapper.selectList(null); |
| | | QueryWrapper<Role> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.ne("name","superuser"); |
| | | return mapper.selectList(queryWrapper); |
| | | } |
| | | |
| | | |
| | |
| | | QueryWrapper<Role> queryWrapper = new QueryWrapper<>(role); |
| | | queryWrapper.or().like(StringUtils.isNotEmpty(role.getSearch()) ,"label",role.getSearch()); |
| | | queryWrapper.or().like(StringUtils.isNotEmpty(role.getSearch()) ,"description",role.getSearch()); |
| | | queryWrapper.ne("name","superuser"); |
| | | List<Role> list = mapper.selectList(queryWrapper); |
| | | for (Role role1: list) { |
| | | QueryWrapper<UserRole> userRoleQueryWrapper = new QueryWrapper<>(); |
| | |
| | | } |
| | | |
| | | } |
| | | //绑定用户 |
| | | public Response getUsersByRoleId(int roleId){ |
| | | List<User> userList = userMapper.selectList(null); |
| | | QueryWrapper<UserRole> queryWrapper= new QueryWrapper(); |
| | | queryWrapper.eq("role_id",roleId); |
| | | List<UserRole> userRoleList = userRoleMapper.selectList(queryWrapper); |
| | | for (UserRole ur:userRoleList) { |
| | | for (User u:userList) { |
| | | if(ur.getUserId().equals(u.getId())){ |
| | | u.setSelected(true); |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | return new Response().set(1,userList); |
| | | |
| | | } |
| | | |
| | | public void updateRoleUser(int roleId,List<User> users){ |
| | | QueryWrapper<UserRole> queryWrapper = new QueryWrapper<UserRole>().eq("role_id",roleId); |
| | | userRoleMapper.delete(queryWrapper); |
| | | for (User user:users) { |
| | | if(user.isSelected()){ |
| | | UserRole userRole = new UserRole(); |
| | | userRole.setUserId(user.getId()); |
| | | userRole.setRoleId(roleId); |
| | | userRoleMapper.insert(userRole); |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | |
| | | } |
| | | |
| | | |
| | | public Response<PageInfo<User>> getUserByRoleId(int pageNum,int pageSize,int roleId){ |
| | | PageHelper.startPage(pageNum,pageSize); |
| | | QueryWrapper queryWrapper = new QueryWrapper(); |
| | | queryWrapper.select("user_id").eq("role_id",roleId); |
| | | List<UserRole> userIds = userRoleMapper.selectList(queryWrapper); |
| | | List<User> userList = new ArrayList<>(); |
| | | for (UserRole userRole:userIds) { |
| | | User user = userMapper.selectById(userRole.getUserId()); |
| | | userList.add(user); |
| | | } |
| | | PageInfo<User> pageInfo = new PageInfo<>(userList); |
| | | return new Response<PageInfo<User>>().set(1,pageInfo); |
| | | } |
| | | |
| | | |
| | | public Response updateRoleState(int roleId,int state){ |
| | | Role role = mapper.selectById(roleId); |
| | | if ("superuser".equals(role.getName())){ |
| | | return new Response().setMsg(0,"更新失败"); |
| | | } |
| | | role.setState(state); |
| | | if(mapper.updateById(role)>0){ |
| | | if (state==0){ |
| | |
| | | } |
| | | |
| | | public Response deleteRole(int roleId){ |
| | | Role role = mapper.selectById(roleId); |
| | | if ("superuser".equals(role.getName())){ |
| | | return new Response().setMsg(0,"删除失败"); |
| | | } |
| | | if(mapper.deleteById(roleId)>0){ |
| | | return new Response().setMsg(1, "删除成功"); |
| | | }else{ |