From 436b955086030caec4513022c1f5127470ad2b14 Mon Sep 17 00:00:00 2001
From: fei <791364011@qq.com>
Date: 星期日, 28 十二月 2025 20:54:21 +0800
Subject: [PATCH] 修改了对应代码
---
archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java | 13 +++++++++++++
1 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java b/archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java
index a0eb72a..36eb677 100644
--- a/archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java
+++ b/archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java
@@ -16,6 +16,16 @@
@Mapper
public interface ArchiveRecordsMapper extends BaseMapper<ArchiveRecords> {
+ @Select({
+ "<script>",
+ "select * from (SELECT distinct c.*,a.archive_records_id, if(a.user_id=#{userId}, TRUE, FALSE) as tst,b.user_id FROM archiverecordstouser a inner join sys_user b ON a.user_id = b.user_id inner join archive_records c on c.id=a.archive_records_id ${ew.customSqlSegment} ) as tmp\n" +
+ "where tst=true",
+ "<if test= \"userId !=1 \">",
+ "order by tst desc",
+ "</if>",
+ "</script>"
+ })
+ Page<ArchiveRecords> selectJoinCommonUserPage(Page<ArchiveRecords> page, @Param("userId") Long userId, @Param("ew") LambdaQueryWrapper<ArchiveRecords> queryWrapper);
@Select({
@@ -52,4 +62,7 @@
@Select("select ROW_NUMBER() OVER (ORDER BY record_id) AS num, filing_number, concat_ws(\" \", inquiry_number,record_id) as inqrid, case_title, public_attribute, (select count(*) as cnt from document_materials where record_id=ar.id) as cnt, remarks from archive_records as ar \n" +
"${ew.customSqlSegment}")
public List<ArchiveRecordSmall> selectByIds(@Param("ew") LambdaQueryWrapper<ArchiveRecords> queryWrapper);
+
+ @Select("SELECT COALESCE(SUM(IF(url IS NULL AND file_style != '鏂囧瓧鏉愭枡', 1, 0)), 0) = 0 AS result from document_materials where `record_id` = #{recordId}")
+ boolean whether(@Param("recordId") Long recordId);
}
--
Gitblit v1.9.1