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