个人文档查询数量bug

许鹏程

2024-09-02 f0eaa3605bb2d87d94b0e8240d347c171a67123d

个人文档查询数量bug

 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);