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({
|
"<script>",
|
"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} ",
|
"<if test= \"userId !=1 \">",
|
"order by a.user_id desc",
|
"</if>",
|
"</script>"
|
})
|
Page<ArchiveRecords> selectJoinUserPage(Page<ArchiveRecords> page, @Param("userId") Long userId, @Param("ew") LambdaQueryWrapper<ArchiveRecords> queryWrapper);
|
|
@Select("select max(id) from archive_records")
|
Long findMaxId();
|
|
}
|
