From efc00a16186704c48196e013a3f24a075193a203 Mon Sep 17 00:00:00 2001 From: zm <2369059705qq.com> Date: 星期四, 29 八月 2024 16:15:37 +0800 Subject: [PATCH] 文档统计 --- src/main/java/com/product/file/service/DocumentService.java | 8 ++++++++ 1 files changed, 8 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/product/file/service/DocumentService.java b/src/main/java/com/product/file/service/DocumentService.java index 9863320..c76415f 100644 --- a/src/main/java/com/product/file/service/DocumentService.java +++ b/src/main/java/com/product/file/service/DocumentService.java @@ -809,4 +809,12 @@ } return permission; } + public DataTableEntity getFileItemize(FieldSetEntity fes) throws BaseException { + DataTableEntity dt = baseDao.listTable("SELECT b.classify_name,COUNT(1) number FROM product_oa_document a LEFT JOIN product_oa_document_classify_config b on a.business_classify_uuid=b.uuid\n" + + "where classify_name is not null GROUP BY b.classify_name ORDER BY COUNT(1)",new String[]{}); + for (int i = 0; i <dt.getRows() ; i++) { + dt.setFieldValue(i,"ranking",i+1); + } + return dt; + } } -- Gitblit v1.9.2