From 4581db487ca237dca8eb31415135e800b9982929 Mon Sep 17 00:00:00 2001 From: feige <791364011@qq.com> Date: 星期一, 04 八月 2025 21:44:05 +0800 Subject: [PATCH] 增加了相关代码 --- archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java | 12 ++++++++++++ 1 files changed, 12 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 03e96eb..429c7be 100644 --- a/archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java +++ b/archiveManager/src/main/java/com/ruoyi/mapper/ArchiveRecordsMapper.java @@ -1,9 +1,21 @@ package com.ruoyi.mapper; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ruoyi.domain.ArchiveRecords; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; @Mapper public interface ArchiveRecordsMapper extends BaseMapper<ArchiveRecords> { + + + @Select("SELECT c.*,a.archive_records_id,b.user_id 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} ") + Page<ArchiveRecords> selectJoinUserPage(Page<ArchiveRecords> page, @Param("ew") LambdaQueryWrapper<ArchiveRecords> queryWrapper); + + @Select("select max(id) from archive_records") + Long findMaxId(); + } -- Gitblit v1.9.1