| | |
|---|
| | | |
|---|
| | | @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({ |
|---|
