2022.11.15

feiyu02

2022-11-15 23bd719cebe5feeff4e48fde925b0b39755eea93

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
package cn.flightfeather.supervision.domain.mapper
 
import cn.flightfeather.supervision.domain.entity.LedgerRecord
import cn.flightfeather.supervision.domain.util.MyMapper
import org.apache.ibatis.annotations.Delete
import org.apache.ibatis.annotations.Select
import tk.mybatis.mapper.common.Mapper
 
@org.apache.ibatis.annotations.Mapper
interface LedgerRecordMapper : MyMapper<LedgerRecord> {
 
    fun selectByUser(userId: String, year: Int, month: Byte, subTypeId: Int?, sceneType: String, startIndex: Int?, perPage: Int): MutableList<LedgerRecord>
 
    fun getLedgerImgs(userId: String, ledgerType: List<Int>):List<LedgerRecord>
 
    @Select("set @row_number:=0;")
    fun setRowNumber()
 
    @Select("set @median_group:='';")
    fun setGroup()
    /**
     * 获取每个激活状态的用户需要复制的每种台账的最新一条记录
     */
    fun getNeedCopyLedgers(): List<LedgerRecord>
}