From 02de694f6deabb1ab8d2fa37c923980a9e6c0538 Mon Sep 17 00:00:00 2001 From: 18756 <1875631620@qq.com> Date: 星期五, 30 八月 2024 14:54:48 +0800 Subject: [PATCH] 借阅文档排名优化8.30 --- src/main/java/com/product/file/service/DocumentService.java | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/product/file/service/DocumentService.java b/src/main/java/com/product/file/service/DocumentService.java index 5649627..a53d8b6 100644 --- a/src/main/java/com/product/file/service/DocumentService.java +++ b/src/main/java/com/product/file/service/DocumentService.java @@ -716,7 +716,7 @@ sb.append(" JOIN product_sys_staffs s "); sb.append(" on t.created_by=s.user_id"); sb.append(" group by t.file_name,t.uuid,s.show_name,t.created_utc_datetime,t.attachment_size"); - sb.append(" )b order by b.applyCount asc"); + sb.append(" )b order by b.applyCount DESC"); DataTableEntity dataTableEntity = baseDao.listTable(sb.toString(), param.toArray()); return dataTableEntity; } @@ -747,7 +747,7 @@ sb.append(" GROUP BY w.borrower,s.show_name"); sb.append(" )a )b"); sb.append(" on a.borrower=b.borrower "); - sb.append(" order by a.applayCount,b.applayFileCount asc"); + sb.append(" order by a.applayCount,b.applayFileCount DESC"); DataTableEntity dataTableEntity = baseDao.listTable(sb.toString(), param.toArray()); return dataTableEntity; } -- Gitblit v1.9.2