From a708bc2345e42cc9c04233664056a8eebb5a3b1b Mon Sep 17 00:00:00 2001 From: zm <2369059705qq.com> Date: 星期二, 08 十月 2024 11:17:08 +0800 Subject: [PATCH] 个人文档 --- src/main/java/com/product/file/service/DocumentDirectoryService.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/product/file/service/DocumentDirectoryService.java b/src/main/java/com/product/file/service/DocumentDirectoryService.java index 392f2ff..bc2de3b 100644 --- a/src/main/java/com/product/file/service/DocumentDirectoryService.java +++ b/src/main/java/com/product/file/service/DocumentDirectoryService.java @@ -451,7 +451,7 @@ sql.setLength(0); sql.append(" SELECT\n"); sql.append(" ( SELECT count(*) FROM product_oa_document_collection WHERE document_collector = ? ) collection_count,\n"); - sql.append(" ( SELECT count(distinct sub_uuid ) FROM product_oa_document_borrow_sub WHERE borrow_uuid IN ( SELECT uuid FROM product_oa_document_borrow WHERE borrower = ? ) ) borrow_count\n"); + sql.append(" ( SELECT count(distinct sub_uuid ) FROM product_oa_document_borrow_sub WHERE borrow_uuid IN ( SELECT uuid FROM product_oa_document_borrow WHERE borrower = ? and flow_flag=2) ) borrow_count\n"); sql.append(" FROM\n"); sql.append("DUAL\n"); FieldSetEntity fieldSetBySQL = baseDao.getFieldSetBySQL(sql.toString(), new Object[]{user.getUser_id(), user.getUser_id()}, false); -- Gitblit v1.9.2