From 1b50a30228774b94afd8d02a4a4576b6ea4f2efc Mon Sep 17 00:00:00 2001
From: 2369059705@qq.com <2369059705@qq.com>
Date: 星期四, 18 五月 2023 16:11:44 +0800
Subject: [PATCH] 解决了文档移动权限问题
---
src/main/java/com/product/file/service/DocumentService.java | 13 ++++++-------
1 files changed, 6 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/product/file/service/DocumentService.java b/src/main/java/com/product/file/service/DocumentService.java
index dbd2c83..2de5ac5 100644
--- a/src/main/java/com/product/file/service/DocumentService.java
+++ b/src/main/java/com/product/file/service/DocumentService.java
@@ -422,13 +422,12 @@
//1涓哄叕鍙告枃浠跺す
if(directory_type == 1) {
StringBuffer sql = new StringBuffer();
- sql.append(" SELECT * FROM product_oa_directory_rights a ")
- .append(" LEFT JOIN product_sys_organizational_structure_storage b on a.storage_uuid = b.uuid ")
- .append(" WHERE a.directory_uuid = ? ")
- .append(" AND rigths like '%3%' AND concat(',',staff_ids,',') like ? ");//3涓烘柊澧�
- String staffId = SpringMVCContextHolder.getCurrentUser().getCurrentStaff().getString("staff_id");
- staffId = "%," + staffId + ",%";
- DataTableEntity dataTableEntity = baseDao.listTable(sql.toString(), new String[]{directory_uuid, staffId});
+ sql.append(" SELECT * FROM product_oa_directory_rights ")
+ .append(" WHERE directory_uuid = ? ")
+ .append(" AND rigths like '%3%' AND concat(',',storage_uuid,',') like ? ");//3涓烘柊澧�
+ String user_id = String.valueOf(SpringMVCContextHolder.getCurrentUser().getUser_id());
+ user_id = "%," + user_id + ",%";
+ DataTableEntity dataTableEntity = baseDao.listTable(sql.toString(), new String[]{directory_uuid, user_id});
row = dataTableEntity.getRows();
}
//1涓轰釜浜烘枃浠跺す
--
Gitblit v1.9.2