From af47b774448bfa3ece4741664ce4d24128c8f629 Mon Sep 17 00:00:00 2001 From: fei <791364011@qq.com> Date: 星期一, 01 九月 2025 14:29:50 +0800 Subject: [PATCH] 新增了代码 --- archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java b/archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java index 13d8b96..3a9a890 100644 --- a/archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java +++ b/archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java @@ -19,7 +19,7 @@ @Select({ "<script>", - "SELECT c.*,a.archive_records_id,b.user_id, if(a.user_id=#{userId}, TRUE, FALSE) as tst FROM archiverecordstouser a inner join sys_user b ON a.user_id = b.user_id right join archive_records c on c.record_id=a.archive_records_id ${ew.customSqlSegment} ", + "SELECT distinct c.*,a.archive_records_id,b.user_id, if(a.user_id=#{userId}, TRUE, FALSE) as tst FROM archiverecordstouser a inner join sys_user b ON a.user_id = b.user_id right join archive_records c on c.record_id=a.archive_records_id ${ew.customSqlSegment} ", "<if test= \"userId !=1 \">", "order by tst desc", "</if>", -- Gitblit v1.9.1