From 6f6e5c91056f0d5ebde632f27443b76bffac1aef Mon Sep 17 00:00:00 2001 From: 2369059705@qq.com <2369059705@qq.com> Date: 星期六, 27 五月 2023 15:36:20 +0800 Subject: [PATCH] 解决了文档权限问题 --- src/main/java/com/product/file/config/CmnConst.java | 1 + src/main/java/com/product/file/service/DocumentService.java | 38 +++++++++++++++++++++++++++++++------- 2 files changed, 32 insertions(+), 7 deletions(-) diff --git a/src/main/java/com/product/file/config/CmnConst.java b/src/main/java/com/product/file/config/CmnConst.java index 0a8b795..134b40f 100644 --- a/src/main/java/com/product/file/config/CmnConst.java +++ b/src/main/java/com/product/file/config/CmnConst.java @@ -26,6 +26,7 @@ public static final String product_oa_DOCUMENT_LOG = "product_oa_document_log"; // 鏂囨。鎿嶄綔鏃ュ織琛� public static final String PRODUCT_SYS_PRINT_TEMPLATE_RECORD = "product_sys_print_template_reocrd";// 鎵撳嵃妯℃澘璁板綍琛� public static final String PRODUCT_SYS_STAFFS = "product_sys_staffs"; + public static final String TABLE_PRODUCT_SYS_ORG_LEVELS = "product_sys_org_levels";// 缁勭粐鏈烘瀯琛� public static final String ATTACHMENT_CAPACITY = "attachment_capacity"; public static final String RESULT = "result"; diff --git a/src/main/java/com/product/file/service/DocumentService.java b/src/main/java/com/product/file/service/DocumentService.java index 0ccf57f..526e10c 100644 --- a/src/main/java/com/product/file/service/DocumentService.java +++ b/src/main/java/com/product/file/service/DocumentService.java @@ -21,6 +21,8 @@ import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Component; +import java.util.ArrayList; +import java.util.Arrays; import java.util.List; import java.util.Map; @@ -222,8 +224,16 @@ baseDao.add(dataTableEntity); } - public boolean verifyOrgExist(String org, Integer user_id) { + public boolean verifyOrgExist(String org) { + Integer user_id = SpringMVCContextHolder.getCurrentUser().getUser_id(); + String code = SpringMVCContextHolder.getCurrentUser().getCurrentStaff().getString("tricode"); + //鑾峰彇鎵�鏈変笂绾х紪鐮� + String[] superior_code = new String[code.split("-").length - 1]; + for (int i = 0; i < code.split("-").length - 1; i++) { + superior_code[i] = code.substring(0, code.length() - ((i + 1) * 4)); + } String this_user = String.valueOf(user_id); + SpringMVCContextHolder.getCurrentUser().getLanguageCode(); String[][] orgArr = BaseUtil.decomposesMultipleTypeValues(org); String[] user = orgArr[3]; if (null != user) { @@ -235,14 +245,28 @@ } String[] level = orgArr[0]; String[] dept = orgArr[1]; - String[] post = orgArr[2]; + // List<String> list = Arrays.asList(a); --OK + // List<String> list = Arrays.asList("A","B","C"); --OK + // list.add("F"); --UnsupportedOperationException + // list.remove("A"); --UnsupportedOperationException + // list.set(1,"javaee");--OK (鍥犱负鏄妸鏁扮粍杞负闆嗗悎锛屽叾鏈川杩樻槸鏁扮粍锛屾暟缁勯暱搴﹀浐瀹氫笉鍙橈紝浣嗗唴瀹瑰彲浠ユ敼鍙�) + // 缁撹锛氳櫧鐒跺彲浠ユ妸鏁扮粍杞负闆嗗悎锛屼絾鏄泦鍚堥暱搴︿笉鑳芥敼鍙� + List list = new ArrayList(); + ; if (null != level) { - DataTableEntity org_level_uuid = baseDao.listTable(CmnConst.PRODUCT_SYS_STAFFS, BaseUtil.buildQuestionMarkFilter("org_level_uuid", level, true) + " and user_id=?", new String[]{this_user}); - if (org_level_uuid.getRows() > 0) return true; + list.addAll(Arrays.asList(level)); } if (null != dept) { - DataTableEntity dept_uuid = baseDao.listTable(CmnConst.PRODUCT_SYS_STAFFS, BaseUtil.buildQuestionMarkFilter("dept_uuid", dept, true) + " and user_id=?", new String[]{this_user}); - if (dept_uuid.getRows() > 0) return true; + list.addAll(Arrays.asList(dept)); + } + String[] level_dept = new String[list.size()]; + list.toArray(level_dept); + + + String[] post = orgArr[2]; + if (level_dept.length != 0) { + DataTableEntity org_level_uuid = baseDao.listTable(CmnConst.TABLE_PRODUCT_SYS_ORG_LEVELS, BaseUtil.buildQuestionMarkFilter("uuid", level_dept, true) + " and " + BaseUtil.buildQuestionMarkFilter("org_level_code", superior_code, true), new String[]{}); + if (org_level_uuid.getRows() > 0) return true; } if (null != post) { DataTableEntity post_uuid = baseDao.listTable(CmnConst.PRODUCT_SYS_STAFFS, BaseUtil.buildQuestionMarkFilter("job_post_uuid", post, true) + " and user_id=?", new String[]{this_user}); @@ -265,7 +289,7 @@ //String key = "%,140,%"; DataTableEntity dataTableEntity = new DataTableEntity(); FieldSetEntity org = baseDao.getFieldSetByFilter(CmnConst.product_oa_DIRECTORY_RIGHTS, "directory_uuid=?", new String[]{directory_uuid}, false); - if (verifyOrgExist(org.getString("storage_uuid"), user_id)) { + if (verifyOrgExist(org.getString("storage_uuid"))) { StringBuffer sql = new StringBuffer(); sql.append(" SELECT substring_index(substring_index(a.rigths,',',b.help_topic_id+1),',',-1) fun FROM product_oa_directory_rights a ") .append(" INNER join mysql.help_topic b on b.help_topic_id < (length(a.rigths) - length(replace(a.rigths,',',''))+1) ") -- Gitblit v1.9.2