From f0eaa3605bb2d87d94b0e8240d347c171a67123d Mon Sep 17 00:00:00 2001
From: 许鹏程 <1821349743@qq.com>
Date: 星期一, 02 九月 2024 11:38:09 +0800
Subject: [PATCH] 个人文档查询数量bug
---
src/main/java/com/product/file/service/DocumentDirectoryService.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/product/file/service/DocumentDirectoryService.java b/src/main/java/com/product/file/service/DocumentDirectoryService.java
index c005b8c..1783b09 100644
--- a/src/main/java/com/product/file/service/DocumentDirectoryService.java
+++ b/src/main/java/com/product/file/service/DocumentDirectoryService.java
@@ -83,7 +83,7 @@
sql.append("where tricode like ? ");
baseDao.executeUpdate(sql.toString(), new Object[]{originTricode, originTricode, originTricode, tricode, originTricode, originTricode,
originTricode, originTricode, originTricode, tricode, originTricode, originTricode, originTricode + "-%"});
- }else {
+ } else {
tricode = fseOrigin.getString(CmnConst.TRICODE);
}
}
@@ -200,7 +200,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( sub_uuid ) FROM product_oa_document_borrow_sub WHERE borrow_uuid IN ( SELECT uuid FROM product_oa_document_borrow WHERE borrower = ? ) GROUP BY sub_uuid ) borrow_count\n");
+ sql.append(" ( SELECT count( 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