| | |
|---|
| | | if (StringUtils.isNotNull(currentUser) && !currentUser.isAdmin())
|
|---|
| | | {
|
|---|
| | | String permission = StringUtils.defaultIfEmpty(controllerDataScope.permission(), PermissionContextHolder.getContext());
|
|---|
| | | dataScopeFilter(joinPoint, currentUser, controllerDataScope.deptAlias(), controllerDataScope.userAlias(), permission);
|
|---|
| | | dataScopeFilter(joinPoint, currentUser, controllerDataScope.deptAlias(), controllerDataScope.userAlias(), controllerDataScope.tenantIdFelid(), permission);
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | |
|---|
| | | * @param user 用户
|
|---|
| | | * @param deptAlias 部门别名
|
|---|
| | | * @param userAlias 用户别名
|
|---|
| | | * @param tenantIdFelid 租户id字段名
|
|---|
| | | * @param permission 权限字符
|
|---|
| | | */
|
|---|
| | | public static void dataScopeFilter(JoinPoint joinPoint, SysUser user, String deptAlias, String userAlias, String permission)
|
|---|
| | | public static void dataScopeFilter(JoinPoint joinPoint, SysUser user, String deptAlias, String userAlias,String tenantIdFelid, String permission)
|
|---|
| | | {
|
|---|
| | | StringBuilder sqlString = new StringBuilder();
|
|---|
| | | List<String> conditions = new ArrayList<String>();
|
|---|
| | |
|---|
| | | conditions.add(dataScope);
|
|---|
| | | break;
|
|---|
| | | }
|
|---|
| | | else if (DATA_SCOPE_CUSTOM.equals(dataScope))
|
|---|
| | | {
|
|---|
| | | if (scopeCustomIds.size() > 1)
|
|---|
| | | {
|
|---|
| | | // 多个自定数据权限使用in查询，避免多次拼接。
|
|---|
| | | sqlString.append(StringUtils.format(" OR {}.dept_id IN ( SELECT dept_id FROM sys_role_dept WHERE role_id in ({}) ) ", deptAlias, String.join(",", scopeCustomIds)));
|
|---|
| | | }
|
|---|
| | | else
|
|---|
| | | {
|
|---|
| | | 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_CUSTOM.equals(dataScope))
|
|---|
| | | // {
|
|---|
| | | // if (scopeCustomIds.size() > 1)
|
|---|
| | | // {
|
|---|
| | | // // 多个自定数据权限使用in查询，避免多次拼接。
|
|---|
| | | // sqlString.append(StringUtils.format(" OR {}.dept_id IN ( SELECT dept_id FROM sys_role_dept WHERE role_id in ({}) ) ", deptAlias, String.join(",", scopeCustomIds)));
|
|---|
| | | // }
|
|---|
| | | // else
|
|---|
| | | // {
|
|---|
| | | // 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_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 if(StringUtils.isNotBlank(tenantIdFelid)){
|
|---|
| | | sqlString.append(StringUtils.format(" OR {}.tenant_id = {} ", tenantIdFelid, user.getTenantId()));
|
|---|
| | | }
|
|---|
| | | else
|
|---|
| | | {
|
|---|
