package cn.flightfeather.supervision.domain.ds2.mapper
|
|
import cn.flightfeather.supervision.domain.ds2.entity.LedgerRecord
|
import cn.flightfeather.supervision.domain.util.MyMapper
|
import org.apache.ibatis.annotations.Select
|
|
@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("select count(*) from ea_t_ledgerrecord as a left join ea_t_ledgersubtype as b on a.LS_SubTypeId = b.LS_SubTypeId " +
|
"where a.LR_SubmitID = #{param1} and a.LR_Year = #{param2} and a.LR_Month = #{param3} and b.L_NeedUpdate = true")
|
fun getNeedUpdateCount(userId: String?, year: Int, month: Byte): Int
|
}
|
