From ccf9dfb83b9846974c569161502b784c668ee307 Mon Sep 17 00:00:00 2001 From: ZQN <364596817@qq.com> Date: 星期二, 18 六月 2024 16:48:07 +0800 Subject: [PATCH] 企业字段添加,执法评价添加 --- project-framework/src/main/java/com/project/framework/aspectj/DataScopeAspect.java | 32 ++++++++++++++++++++++---------- 1 files changed, 22 insertions(+), 10 deletions(-) diff --git a/project-framework/src/main/java/com/project/framework/aspectj/DataScopeAspect.java b/project-framework/src/main/java/com/project/framework/aspectj/DataScopeAspect.java index f890106..b533252 100644 --- a/project-framework/src/main/java/com/project/framework/aspectj/DataScopeAspect.java +++ b/project-framework/src/main/java/com/project/framework/aspectj/DataScopeAspect.java @@ -1,11 +1,5 @@ package com.project.framework.aspectj; -import java.util.ArrayList; -import java.util.List; -import org.aspectj.lang.JoinPoint; -import org.aspectj.lang.annotation.Aspect; -import org.aspectj.lang.annotation.Before; -import org.springframework.stereotype.Component; import com.project.common.annotation.DataScope; import com.project.common.core.domain.BaseEntity; import com.project.common.core.domain.entity.SysRole; @@ -15,6 +9,13 @@ import com.project.common.utils.SecurityUtils; import com.project.common.utils.StringUtils; import com.project.framework.security.context.PermissionContextHolder; +import org.aspectj.lang.JoinPoint; +import org.aspectj.lang.annotation.Aspect; +import org.aspectj.lang.annotation.Before; +import org.springframework.stereotype.Component; + +import java.util.ArrayList; +import java.util.List; /** * 鏁版嵁杩囨护澶勭悊 @@ -49,6 +50,11 @@ * 浠呮湰浜烘暟鎹潈闄� */ public static final String DATA_SCOPE_SELF = "5"; + + /** + * 鏈満鏋勬暟鎹潈闄� + */ + public static final String DATA_SCOPE_ORG = "6"; /** * 鏁版嵁鏉冮檺杩囨护鍏抽敭瀛� @@ -113,7 +119,7 @@ else if (DATA_SCOPE_CUSTOM.equals(dataScope)) { sqlString.append(StringUtils.format( - " OR {}.dept_id IN ( SELECT dept_id FROM sys_role_dept WHERE role_id = {} ) ", deptAlias, + " OR {} IN ( SELECT dept_id FROM sys_role_dept WHERE role_id = {} ) ", deptAlias, role.getRoleId())); } else if (DATA_SCOPE_DEPT.equals(dataScope)) @@ -123,19 +129,25 @@ 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 ) )", + " OR {} IN ( SELECT dept_id FROM sys_dept WHERE dept_id = {} or find_in_set( {} , ancestors ) )", deptAlias, user.getDeptId(), user.getDeptId())); + } + else if (DATA_SCOPE_ORG.equals(dataScope)) + { + sqlString.append(StringUtils.format( + " OR {} IN ( SELECT dept_id FROM sys_dept WHERE dept_id = {} or find_in_set( {} , ancestors ) )", + deptAlias, user.getRecommendUser(), user.getRecommendUser())); } else if (DATA_SCOPE_SELF.equals(dataScope)) { if (StringUtils.isNotBlank(userAlias)) { - sqlString.append(StringUtils.format(" OR {}.user_id = {} ", userAlias, user.getUserId())); + sqlString.append(StringUtils.format(" OR {} = {} ", userAlias, user.getUserId())); } else { // 鏁版嵁鏉冮檺涓轰粎鏈汉涓旀病鏈塽serAlias鍒悕涓嶆煡璇换浣曟暟鎹� - sqlString.append(StringUtils.format(" OR {}.dept_id = 0 ", deptAlias)); + sqlString.append(StringUtils.format(" OR {}= = 0 ", deptAlias)); } } conditions.add(dataScope); -- Gitblit v1.9.1