| | |
|---|
| | | |
|---|
| | | @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>", |
|---|
