角色管理界面 /system/role

SysRoleController进行Controller层控制

/*** 角色信息* * @author ruoyi*/
@Controller
@RequestMapping("/system/role")
public class SysRoleController extends BaseController
{private String prefix = "system/role";/*** 角色管理的service*/@Autowiredprivate ISysRoleService roleService;/*** 用户管理的service*/@Autowiredprivate ISysUserService userService;//之后为各种控制方法...
}

进入role()方法，跳转到role.html页面

 /*** 接收/system/role请求，跳转到system/role/role.html页面* @return*/@RequiresPermissions("system:role:view")@GetMapping()public String role(){/*String str = prefix + "/role";System.out.println(str);*/return prefix + "/role";}

页面元素显示（调用字典的逻辑）——以“角色状态”复选框为例

<li><!--查询相关字典--><!--根据字典的类型查询相关数据--><!--th:with用于定义一个局部变量-->角色状态：<select name="status" th:with="type=${@dict.getType('sys_normal_disable')}"><option value="">所有</option><!--遍历type，展示相关属性--><option th:each="dict : ${type}" th:text="${dict.dictLabel}" th:value="${dict.dictValue}"></option></select>
</li>

pojo - 字典数据表

/*** 字典数据表 sys_dict_data* * @author ruoyi*/
public class SysDictData extends BaseEntity
{private static final long serialVersionUID = 1L;/** 字典编码 */@Excel(name = "字典编码", cellType = ColumnType.NUMERIC)private Long dictCode;/** 字典排序 */@Excel(name = "字典排序", cellType = ColumnType.NUMERIC)private Long dictSort;/** 字典标签 */@Excel(name = "字典标签")private String dictLabel;/** 字典键值 */@Excel(name = "字典键值")private String dictValue;/** 字典类型 */@Excel(name = "字典类型")private String dictType;/** 样式属性（其他样式扩展） */@Excel(name = "字典样式")private String cssClass;/** 表格字典样式 */private String listClass;/** 是否默认（Y是 N否） */@Excel(name = "是否默认", readConverterExp = "Y=是,N=否")private String isDefault;/** 状态（0正常 1停用） */@Excel(name = "状态", readConverterExp = "0=正常,1=停用")private String status;public Long getDictCode(){return dictCode;}public void setDictCode(Long dictCode){this.dictCode = dictCode;}public Long getDictSort(){return dictSort;}public void setDictSort(Long dictSort){this.dictSort = dictSort;}@NotBlank(message = "字典标签不能为空")@Size(min = 0, max = 100, message = "字典标签长度不能超过100个字符")public String getDictLabel(){return dictLabel;}public void setDictLabel(String dictLabel){this.dictLabel = dictLabel;}@NotBlank(message = "字典键值不能为空")@Size(min = 0, max = 100, message = "字典键值长度不能超过100个字符")public String getDictValue(){return dictValue;}public void setDictValue(String dictValue){this.dictValue = dictValue;}@NotBlank(message = "字典类型不能为空")@Size(min = 0, max = 100, message = "字典类型长度不能超过100个字符")public String getDictType(){return dictType;}public void setDictType(String dictType){this.dictType = dictType;}@Size(min = 0, max = 100, message = "样式属性长度不能超过100个字符")public String getCssClass(){return cssClass;}public void setCssClass(String cssClass){this.cssClass = cssClass;}public String getListClass(){return listClass;}public void setListClass(String listClass){this.listClass = listClass;}public boolean getDefault(){return UserConstants.YES.equals(this.isDefault) ? true : false;}public String getIsDefault(){return isDefault;}public void setIsDefault(String isDefault){this.isDefault = isDefault;}public String getStatus(){return status;}public void setStatus(String status){this.status = status;}@Overridepublic String toString() {return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE).append("dictCode", getDictCode()).append("dictSort", getDictSort()).append("dictLabel", getDictLabel()).append("dictValue", getDictValue()).append("dictType", getDictType()).append("cssClass", getCssClass()).append("listClass", getListClass()).append("isDefault", getIsDefault()).append("status", getStatus()).append("createBy", getCreateBy()).append("createTime", getCreateTime()).append("updateBy", getUpdateBy()).append("updateTime", getUpdateTime()).append("remark", getRemark()).toString();}
}

pojo - 字典类型表

/*** 字典类型表 sys_dict_type* * @author ruoyi*/
public class SysDictType extends BaseEntity
{private static final long serialVersionUID = 1L;/** 字典主键 */@Excel(name = "字典主键", cellType = ColumnType.NUMERIC)private Long dictId;/** 字典名称 */@Excel(name = "字典名称")private String dictName;/** 字典类型 */@Excel(name = "字典类型")private String dictType;/** 状态（0正常 1停用） */@Excel(name = "状态", readConverterExp = "0=正常,1=停用")private String status;public Long getDictId(){return dictId;}public void setDictId(Long dictId){this.dictId = dictId;}@NotBlank(message = "字典名称不能为空")@Size(min = 0, max = 100, message = "字典类型名称长度不能超过100个字符")public String getDictName(){return dictName;}public void setDictName(String dictName){this.dictName = dictName;}@NotBlank(message = "字典类型不能为空")@Size(min = 0, max = 100, message = "字典类型类型长度不能超过100个字符")public String getDictType(){return dictType;}public void setDictType(String dictType){this.dictType = dictType;}public String getStatus(){return status;}public void setStatus(String status){this.status = status;}@Overridepublic String toString() {return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE).append("dictId", getDictId()).append("dictName", getDictName()).append("dictType", getDictType()).append("status", getStatus()).append("createBy", getCreateBy()).append("createTime", getCreateTime()).append("updateBy", getUpdateBy()).append("updateTime", getUpdateTime()).append("remark", getRemark()).toString();}
}

DictService进行字典元素的数据处理逻辑

package com.ruoyi.framework.web.service;import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ruoyi.system.domain.SysDictData;
import com.ruoyi.system.service.ISysDictDataService;
import com.ruoyi.system.service.ISysDictTypeService;/*** RuoYi首创 html调用 thymeleaf 实现字典读取* * @author ruoyi*/
@Service("dict")    //声明id方便前端调用
public class DictService
{/*** 字典类型的service业务层*/@Autowiredprivate ISysDictTypeService dictTypeService;/*** 字典数据的service业务层*/@Autowiredprivate ISysDictDataService dictDataService;/*** 根据字典类型查询字典数据信息* * @param dictType 字典类型* @return 参数键值*/public List<SysDictData> getType(String dictType){return dictTypeService.selectDictDataByType(dictType);}/*** 根据字典类型和字典键值查询字典数据信息* * @param dictType 字典类型* @param dictValue 字典键值* @return 字典标签*/public String getLabel(String dictType, String dictValue){return dictDataService.selectDictLabel(dictType, dictValue);}
}

查询角色 /system/role/list

此url在role.html加载函数中体现

    $(function() {var options = {url: prefix + "/list",createUrl: prefix + "/add",updateUrl: prefix + "/edit/{id}",removeUrl: prefix + "/remove",exportUrl: prefix + "/export",sortName: "roleSort",modalName: "角色",columns: [{checkbox: true},{field: 'roleId',title: '角色编号'},{field: 'roleName',title: '角色名称',sortable: true},{field: 'roleKey',title: '权限字符',sortable: true},{field: 'roleSort',title: '显示顺序',sortable: true},{visible: editFlag == 'hidden' ? false : true,title: '角色状态',align: 'center',formatter: function (value, row, index) {return statusTools(row);}},{field: 'createTime',title: '创建时间',sortable: true},{title: '操作',align: 'center',formatter: function(value, row, index) {var actions = [];actions.push('<a class="btn btn-success btn-xs ' + editFlag + '" href="javascript:void(0)" onclick="$.operate.edit(\'' + row.roleId + '\')"><i class="fa fa-edit"></i>编辑</a> ');actions.push('<a class="btn btn-danger btn-xs ' + removeFlag + '" href="javascript:void(0)" onclick="$.operate.remove(\'' + row.roleId + '\')"><i class="fa fa-remove"></i>删除</a> ');var more = [];more.push("<a class='btn btn-default btn-xs " + editFlag + "' href='javascript:void(0)' onclick='authDataScope(" + row.roleId + ")'><i class='fa fa-check-square-o'></i>数据权限</a> ");more.push("<a class='btn btn-default btn-xs " + editFlag + "' href='javascript:void(0)' onclick='authUser(" + row.roleId + ")'><i class='fa fa-user'></i>分配用户</a>");actions.push('<a tabindex="0" class="btn btn-info btn-xs" role="button" data-container="body" data-placement="left" data-toggle="popover" data-html="true" data-trigger="hover" data-content="' + more.join('') + '"><i class="fa fa-chevron-circle-right"></i>更多操作</a>');return actions.join('');}}]};$.table.init(options);});

角色展示

 /*** 角色展示（查询所有角色）* @param role* @return*/@RequiresPermissions("system:role:list")@PostMapping("/list")@ResponseBodypublic TableDataInfo list(SysRole role){startPage();List<SysRole> list = roleService.selectRoleList(role);return getDataTable(list);}/*** 响应请求分页数据*/@SuppressWarnings({ "rawtypes", "unchecked" })protected TableDataInfo getDataTable(List<?> list){TableDataInfo rspData = new TableDataInfo();rspData.setCode(0);rspData.setRows(list);rspData.setTotal(new PageInfo(list).getTotal());return rspData;}

新增角色 /system/role/add

打开角色添加页面 GET请求

保存角色 POST请求

pojo - 角色表sys_role

/*** 角色表 sys_role* * @author ruoyi*/
public class SysRole extends BaseEntity
{private static final long serialVersionUID = 1L;/** 角色ID */@Excel(name = "角色序号", cellType = ColumnType.NUMERIC)private Long roleId;/** 角色名称 */@Excel(name = "角色名称")private String roleName;/** 角色权限 */@Excel(name = "角色权限")private String roleKey;/** 角色排序 */@Excel(name = "角色排序", cellType = ColumnType.NUMERIC)private String roleSort;/** 数据范围（1：所有数据权限；2：自定义数据权限；3：本部门数据权限；4：本部门及以下数据权限） */@Excel(name = "数据范围", readConverterExp = "1=所有数据权限,2=自定义数据权限,3=本部门数据权限,4=本部门及以下数据权限")private String dataScope;/** 角色状态（0正常 1停用） */@Excel(name = "角色状态", readConverterExp = "0=正常,1=停用")private String status;/** 删除标志（0代表存在 2代表删除） */private String delFlag;/** 用户是否存在此角色标识 默认不存在 */private boolean flag = false;/** 菜单组 */private Long[] menuIds;/** 部门组（数据权限） */private Long[] deptIds;public SysRole(){}public SysRole(Long roleId){this.roleId = roleId;}public Long getRoleId(){return roleId;}public void setRoleId(Long roleId){this.roleId = roleId;}public boolean isAdmin(){return isAdmin(this.roleId);}public static boolean isAdmin(Long roleId){return roleId != null && 1L == roleId;}public String getDataScope(){return dataScope;}public void setDataScope(String dataScope){this.dataScope = dataScope;}@NotBlank(message = "角色名称不能为空")@Size(min = 0, max = 30, message = "角色名称长度不能超过30个字符")public String getRoleName(){return roleName;}public void setRoleName(String roleName){this.roleName = roleName;}@NotBlank(message = "权限字符不能为空")@Size(min = 0, max = 100, message = "权限字符长度不能超过100个字符")public String getRoleKey(){return roleKey;}public void setRoleKey(String roleKey){this.roleKey = roleKey;}@NotBlank(message = "显示顺序不能为空")public String getRoleSort(){return roleSort;}public void setRoleSort(String roleSort){this.roleSort = roleSort;}public String getStatus(){return status;}public String getDelFlag(){return delFlag;}public void setDelFlag(String delFlag){this.delFlag = delFlag;}public void setStatus(String status){this.status = status;}public boolean isFlag(){return flag;}public void setFlag(boolean flag){this.flag = flag;}public Long[] getMenuIds(){return menuIds;}public void setMenuIds(Long[] menuIds){this.menuIds = menuIds;}public Long[] getDeptIds(){return deptIds;}public void setDeptIds(Long[] deptIds){this.deptIds = deptIds;}@Overridepublic String toString() {return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE).append("roleId", getRoleId()).append("roleName", getRoleName()).append("roleKey", getRoleKey()).append("roleSort", getRoleSort()).append("dataScope", getDataScope()).append("status", getStatus()).append("delFlag", getDelFlag()).append("createBy", getCreateBy()).append("createTime", getCreateTime()).append("updateBy", getUpdateBy()).append("updateTime", getUpdateTime()).append("remark", getRemark()).toString();}
}

pojo - 菜单权限表sys_menu

/*** 菜单权限表 sys_menu* * @author ruoyi*/
public class SysMenu extends BaseEntity
{private static final long serialVersionUID = 1L;/** 菜单ID */private Long menuId;/** 菜单名称 */private String menuName;/** 父菜单名称 */private String parentName;/** 父菜单ID */private Long parentId;/** 显示顺序 */private String orderNum;/** 菜单URL */private String url;/** 打开方式：menuItem页签 menuBlank新窗口 */private String target;/** 类型:0目录,1菜单,2按钮 */private String menuType;/** 菜单状态:0显示,1隐藏 */private String visible;/** 权限字符串 */private String perms;/** 菜单图标 */private String icon;/** 子菜单 */private List<SysMenu> children = new ArrayList<SysMenu>();public Long getMenuId(){return menuId;}public void setMenuId(Long menuId){this.menuId = menuId;}@NotBlank(message = "菜单名称不能为空")@Size(min = 0, max = 50, message = "菜单名称长度不能超过50个字符")public String getMenuName(){return menuName;}public void setMenuName(String menuName){this.menuName = menuName;}public String getParentName(){return parentName;}public void setParentName(String parentName){this.parentName = parentName;}public Long getParentId(){return parentId;}public void setParentId(Long parentId){this.parentId = parentId;}@NotBlank(message = "显示顺序不能为空")public String getOrderNum(){return orderNum;}public void setOrderNum(String orderNum){this.orderNum = orderNum;}@Size(min = 0, max = 200, message = "请求地址不能超过200个字符")public String getUrl(){return url;}public void setUrl(String url){this.url = url;}public String getTarget(){return target;}public void setTarget(String target){this.target = target;}@NotBlank(message = "菜单类型不能为空")public String getMenuType(){return menuType;}public void setMenuType(String menuType){this.menuType = menuType;}public String getVisible(){return visible;}public void setVisible(String visible){this.visible = visible;}@Size(min = 0, max = 100, message = "权限标识长度不能超过100个字符")public String getPerms(){return perms;}public void setPerms(String perms){this.perms = perms;}public String getIcon(){return icon;}public void setIcon(String icon){this.icon = icon;}public List<SysMenu> getChildren(){return children;}public void setChildren(List<SysMenu> children){this.children = children;}@Overridepublic String toString() {return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE).append("menuId", getMenuId()).append("menuName", getMenuName()).append("parentId", getParentId()).append("orderNum", getOrderNum()).append("url", getUrl()).append("target", getTarget()).append("menuType", getMenuType()).append("visible", getVisible()).append("perms", getPerms()).append("icon", getIcon()).append("createBy", getCreateBy()).append("createTime", getCreateTime()).append("updateBy", getUpdateBy()).append("updateTime", getUpdateTime()).append("remark", getRemark()).toString();}
}

pojo - 角色和菜单关联表

/*** 角色和菜单关联 sys_role_menu* * @author ruoyi*/
public class SysRoleMenu
{/** 角色ID */private Long roleId;/** 菜单ID */private Long menuId;public Long getRoleId(){return roleId;}public void setRoleId(Long roleId){this.roleId = roleId;}public Long getMenuId(){return menuId;}public void setMenuId(Long menuId){this.menuId = menuId;}@Overridepublic String toString() {return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE).append("roleId", getRoleId()).append("menuId", getMenuId()).toString();}
}

修改角色 /system/role/edit/{userId}

回显数据

/*** 修改角色*/
@GetMapping("/edit/{roleId}")
public String edit(@PathVariable("roleId") Long roleId, ModelMap mmap)
{// 获取相关用户信息mmap.put("role", roleService.selectRoleById(roleId));//页面跳转return prefix + "/edit";
}

保存修改 /system/role/edit

 /*** 修改保存角色*/@RequiresPermissions("system:role:edit")@Log(title = "角色管理", businessType = BusinessType.UPDATE)@PostMapping("/edit")@ResponseBodypublic AjaxResult editSave(@Validated SysRole role){// 校验角色是否允许操作roleService.checkRoleAllowed(role);// 数据校验if (UserConstants.ROLE_NAME_NOT_UNIQUE.equals(roleService.checkRoleNameUnique(role))){return error("修改角色'" + role.getRoleName() + "'失败，角色名称已存在");}else if (UserConstants.ROLE_KEY_NOT_UNIQUE.equals(roleService.checkRoleKeyUnique(role))){return error("修改角色'" + role.getRoleName() + "'失败，角色权限已存在");}// 设置更新者role.setUpdateBy(ShiroUtils.getLoginName());// 清理缓存权限ShiroUtils.clearCachedAuthorizationInfo();return toAjax(roleService.updateRole(role));}

删除角色 /system/role/remove

/*** 批量删除角色信息* * @param ids 需要删除的数据ID* @throws Exception*/@Overridepublic int deleteRoleByIds(String ids) throws BusinessException{// 将String转化为数组Long[] roleIds = Convert.toLongArray(ids);// 遍历所有角色idfor (Long roleId : roleIds){// 校验角色是否允许操作// 不能删除超级管理员角色！否则直接异常checkRoleAllowed(new SysRole(roleId));// 查询出指定角色SysRole role = selectRoleById(roleId);// 通过角色ID查询角色使用数量if (countUserRoleByRoleId(roleId) > 0){// 说明当前角色已被用户使用throw new BusinessException(String.format("%1$s已分配,不能删除", role.getRoleName()));}}// 校验成功（既不是超级管理员，也没有被使用）// 直接批量删除角色信息return roleMapper.deleteRoleByIds(roleIds);}

分配数据权限 /system/role/authDataScope/{roleId}

回显信息 GET请求

/*** 角色分配数据权限*/@GetMapping("/authDataScope/{roleId}")public String authDataScope(@PathVariable("roleId") Long roleId, ModelMap mmap){// 查询到指定id角色，返回给视图解析器回显mmap.put("role", roleService.selectRoleById(roleId));// 跳转页面return prefix + "/dataScope";}

切面 - 数据过滤处理

###　service层查询角色数据中有@DataScope的注解切面

/*** 根据条件分页查询角色数据* * @param role 角色信息* @return 角色数据集合信息*/@Override@DataScope(deptAlias = "d")public List<SysRole> selectRoleList(SysRole role){return roleMapper.selectRoleList(role);}

数据权限过滤注解@DataScope

/*** 数据权限过滤注解* * @author ruoyi*/
@Target(ElementType.METHOD)
@Retention(RetentionPolicy.RUNTIME)
@Documented
public @interface DataScope
{/*** 部门表的别名*/public String deptAlias() default "";/*** 用户表的别名*/public String userAlias() default "";
}

数据过滤处理切面类(有@annotation(com.ruoyi.common.annotation.DataScope)的方法都会被切入)

/*** 数据过滤处理* * @author ruoyi*/
@Aspect
@Component
public class DataScopeAspect
{/*** 全部数据权限*/public static final String DATA_SCOPE_ALL = "1";/*** 自定数据权限*/public static final String DATA_SCOPE_CUSTOM = "2";/*** 部门数据权限*/public static final String DATA_SCOPE_DEPT = "3";/*** 部门及以下数据权限*/public static final String DATA_SCOPE_DEPT_AND_CHILD = "4";/*** 仅本人数据权限*/public static final String DATA_SCOPE_SELF = "5";/*** 数据权限过滤关键字*/public static final String DATA_SCOPE = "dataScope";// 配置数据权限的切入点// 有@annotation(com.ruoyi.common.annotation.DataScope)的方法都会被切入@Pointcut("@annotation(com.ruoyi.common.annotation.DataScope)")public void dataScopePointCut(){// 这是一个空函数}/*** 切入点的前置方法* @param point* @throws Throwable*/@Before("dataScopePointCut()")public void doBefore(JoinPoint point) throws Throwable{/*** JoinPoint对象封装了SpringAop中切面方法的信息* 在切面方法中添加JoinPoint参数，* 就可以获取到封装了该方法信息的JoinPoint对象*///处理当前方法的数据权限handleDataScope(point);}protected void handleDataScope(final JoinPoint joinPoint){// 获得注解DataScope controllerDataScope = getAnnotationLog(joinPoint);if (controllerDataScope == null){// 如果没有得到注解，则直接返回return;}// 获取当前的用户SysUser currentUser = ShiroUtils.getSysUser();if (currentUser != null){// 如果是超级管理员，则不过滤数据if (!currentUser.isAdmin()){// 不是超级管理员，执行数据权限过滤器（针对当前方法和当前用户）// 后面两个参数是注解中设置的部门表和用户表的别名dataScopeFilter(joinPoint, currentUser, controllerDataScope.deptAlias(),controllerDataScope.userAlias());}}}/*** 数据范围过滤* 进行sql语句的拼接* * @param joinPoint 切点* @param user 用户* @param deptAlias 部门别名* @param userAlias 用户别名*/public static void dataScopeFilter(JoinPoint joinPoint, SysUser user, String deptAlias, String userAlias){// 字符串是不变的，他们的值在创建后不能更改StringBuilder sqlString = new StringBuilder();// 遍历当前用户的所有角色for (SysRole role : user.getRoles()){// 获取当前角色的数据权限处理范围（'1'-'5'）String dataScope = role.getDataScope();if (DATA_SCOPE_ALL.equals(dataScope)){// 全部数据权限// sql语句没有任何限制sqlString = new StringBuilder();break;}else if (DATA_SCOPE_CUSTOM.equals(dataScope)){// 自定数据权限// StringUtils.format表示格式化文本，其中{}表示占位符// 此方法将占位符 {} 按照顺序替换为参数sqlString.append(StringUtils.format(" OR {}.dept_id IN ( SELECT dept_id FROM sys_role_dept WHERE role_id = {} ) ", deptAlias,role.getRoleId()));}else if (DATA_SCOPE_DEPT.equals(dataScope)){// 部门数据权限sqlString.append(StringUtils.format(" OR {}.dept_id = {} ", deptAlias, user.getDeptId()));}else if (DATA_SCOPE_DEPT_AND_CHILD.equals(dataScope)){// 部门及以下数据权限sqlString.append(StringUtils.format(" OR {}.dept_id IN ( SELECT dept_id FROM sys_dept WHERE dept_id = {} or find_in_set( {} , ancestors ) )",deptAlias, user.getDeptId(), user.getDeptId()));}else if (DATA_SCOPE_SELF.equals(dataScope)){// 仅本人数据权限if (StringUtils.isNotBlank(userAlias)){sqlString.append(StringUtils.format(" OR {}.user_id = {} ", userAlias, user.getUserId()));}else{// 数据权限为仅本人且没有userAlias别名不查询任何数据sqlString.append(" OR 1=0 ");}}}// 判断上面生成的sql语句// sqlString是StringBuilder类型if (StringUtils.isNotBlank(sqlString.toString())){// 获得第一个参数// public List<SysRole> selectRoleList(SysRole role)BaseEntity baseEntity = (BaseEntity) joinPoint.getArgs()[0];// 获得请求参数，将数据权限及对应的sql语句注入到实体类// 请求参数params是一个map映射// 字符串从第5个字符开始，再拼接上前缀baseEntity.getParams().put(DATA_SCOPE, " AND (" + sqlString.substring(4) + ")");}}/*** 是否存在注解，如果存在就获取* 先要获得方法名，才能获得对应方法的注解*/private DataScope getAnnotationLog(JoinPoint joinPoint){// 获取签名(可以获取到目标方法名，所属类的Class等信息)Signature signature = joinPoint.getSignature();MethodSignature methodSignature = (MethodSignature) signature;// 根据签名反射获得方法Method method = methodSignature.getMethod();if (method != null){// 有方法，返回方法的注解return method.getAnnotation(DataScope.class);}return null;}
}

保存信息 POST请求 /system/role/authDataScope

/*** 保存角色分配数据权限*/@RequiresPermissions("system:role:edit")@Log(title = "角色管理", businessType = BusinessType.UPDATE)@PostMapping("/authDataScope")@ResponseBody   // 返回响应体public AjaxResult authDataScopeSave(SysRole role){// 校验当前角色是否允许操作，判断是不是超级管理员roleService.checkRoleAllowed(role);// 设置更新者role.setUpdateBy(ShiroUtils.getLoginName());/*** 修改权限：*  1. 修改角色信息*  2. 删除之前的角色与部门关联*  3. 重新添加角色与部门关联*/if (roleService.authDataScope(role) > 0){// 修改数据权限信息成功ShiroUtils.setSysUser(userService.selectUserById(ShiroUtils.getSysUser().getUserId()));// 返回成功的ajax信息，而不是要跳转到的页面return success();}// 修改失败，返回失败信息return error();}

分配用户 /system/role/authUser/{roleId}

/*** 分配用户*/@RequiresPermissions("system:role:edit")@GetMapping("/authUser/{roleId}")public String authUser(@PathVariable("roleId") Long roleId, ModelMap mmap){mmap.put("role", roleService.selectRoleById(roleId));// 返回显示分配用户页面return prefix + "/authUser";}

加载页面后跳转到请求 - 查询已分配用户角色列表 /system/role/authUser/allocatedList

/*** 查询已分配用户角色列表*/@RequiresPermissions("system:role:list")@PostMapping("/authUser/allocatedList")@ResponseBodypublic TableDataInfo allocatedList(SysUser user){// 分页数据展示，设置请求分页数据startPage();// 查询角色列表List<SysUser> list = userService.selectAllocatedList(user);// 返回查询到的角色列表，响应数据return getDataTable(list);}

service层

/*** 根据条件分页查询用户列表* * @param user 用户信息* @return 用户信息集合信息*/@Override@DataScope(deptAlias = "d", userAlias = "u")public List<SysUser> selectUserList(SysUser user){return userMapper.selectUserList(user);}/*** 根据条件分页查询已分配用户角色列表* 有横切方法* * @param user 用户信息* @return 用户信息集合信息*/@Override@DataScope(deptAlias = "d", userAlias = "u")public List<SysUser> selectAllocatedList(SysUser user){return userMapper.selectAllocatedList(user);}

dao层

	<select id="selectAllocatedList" parameterType="SysUser" resultMap="SysUserResult">select distinct u.user_id, u.dept_id, u.login_name, u.user_name, u.user_type, u.email, u.avatar, u.phonenumber, u.status, u.create_timefrom sys_user uleft join sys_dept d on u.dept_id = d.dept_idleft join sys_user_role ur on u.user_id = ur.user_idleft join sys_role r on r.role_id = ur.role_idwhere u.del_flag = '0' and r.role_id = #{roleId}<if test="loginName != null and loginName != ''">AND u.login_name like concat('%', #{loginName}, '%')</if><if test="phonenumber != null and phonenumber != ''">AND u.phonenumber like concat('%', #{phonenumber}, '%')</if><!-- 数据范围过滤 -->${params.dataScope}</select>

给角色添加用户

选择用户 /system/role/authUser/selectUser/{roleId}

	/*** 选择用户*/@GetMapping("/authUser/selectUser/{roleId}")public String selectUser(@PathVariable("roleId") Long roleId, ModelMap mmap){// 查询到当前用户id的角色，放入视图解析器中mmap.put("role", roleService.selectRoleById(roleId));// 定向到selectUser的HTML页面return prefix + "/selectUser";}

跳转到 /system/role/selectUser.html页面

查询未分配用户角色列表 /system/role/authUser/unallocatedList

/*** 查询未分配用户角色列表*/@RequiresPermissions("system:role:list")@PostMapping("/authUser/unallocatedList")@ResponseBodypublic TableDataInfo unallocatedList(SysUser user){startPage();List<SysUser> list = userService.selectUnallocatedList(user);return getDataTable(list);}

提交

取消授权 /system/role/authUser/cancel

/*** 取消授权*/@Log(title = "角色管理", businessType = BusinessType.GRANT)@PostMapping("/authUser/cancel")@ResponseBodypublic AjaxResult cancelAuthUser(SysUserRole userRole){return toAjax(roleService.deleteAuthUser(userRole));}

service层

 /*** 取消授权用户角色* * @param userRole 用户和角色关联信息* @return 结果*/@Overridepublic int deleteAuthUser(SysUserRole userRole){return userRoleMapper.deleteUserRoleInfo(userRole);}

dao层

<delete id="deleteUserRoleInfo" parameterType="SysUserRole">delete from sys_user_role where user_id=#{userId} and role_id=#{roleId}</delete><delete id="deleteUserRoleInfos">delete from sys_user_role where role_id=#{roleId} and user_id in<foreach collection="userIds" item="userId" open="(" separator="," close=")">#{userId}</foreach> </delete>

批量取消授权 /system/role/authUser/cancelAll

/*** 批量取消授权*/@Log(title = "角色管理", businessType = BusinessType.GRANT)@PostMapping("/authUser/cancelAll")@ResponseBodypublic AjaxResult cancelAuthUserAll(Long roleId, String userIds){return toAjax(roleService.deleteAuthUsers(roleId, userIds));}

service层

/*** 批量取消授权用户角色* * @param roleId 角色ID* @param userIds 需要删除的用户数据ID* @return 结果*/@Overridepublic int deleteAuthUsers(Long roleId, String userIds){return userRoleMapper.deleteUserRoleInfos(roleId, Convert.toLongArray(userIds));}

导出角色数据 /system/role/export

    /*** 导出角色数据* @param role* @return*/@Log(title = "角色管理", businessType = BusinessType.EXPORT)@RequiresPermissions("system:role:export")@PostMapping("/export")@ResponseBodypublic AjaxResult export(SysRole role){// 查询角色集合List<SysRole> list = roleService.selectRoleList(role);// 导出excelExcelUtil<SysRole> util = new ExcelUtil<SysRole>(SysRole.class);return util.exportExcel(list, "角色数据");}