package cn.iocoder.yudao.module.mes.dal.mysql.dv.meteringcheck;
|
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
|
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
|
import cn.iocoder.yudao.module.mes.controller.admin.dv.meteringcheck.vo.MesDvMeteringCheckPageReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.dv.meteringcheck.MesDvMeteringCheckDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
/**
|
* MES 计量检测记录 Mapper
|
*
|
* @author 超级管理员
|
*/
|
@Mapper
|
public interface MesDvMeteringCheckMapper extends BaseMapperX<MesDvMeteringCheckDO> {
|
|
default PageResult<MesDvMeteringCheckDO> selectPage(MesDvMeteringCheckPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<MesDvMeteringCheckDO>()
|
.eqIfPresent(MesDvMeteringCheckDO::getMeteringId, reqVO.getMeteringId())
|
.likeIfPresent(MesDvMeteringCheckDO::getCheckCode, reqVO.getCheckCode())
|
.eqIfPresent(MesDvMeteringCheckDO::getCheckResult, reqVO.getCheckResult())
|
.betweenIfPresent(MesDvMeteringCheckDO::getCheckDate, reqVO.getCheckDate())
|
.orderByDesc(MesDvMeteringCheckDO::getId));
|
}
|
|
default MesDvMeteringCheckDO selectByCheckCode(String checkCode) {
|
return selectOne(MesDvMeteringCheckDO::getCheckCode, checkCode);
|
}
|
|
default MesDvMeteringCheckDO selectLatestByMeteringId(Long meteringId) {
|
return selectOne(new LambdaQueryWrapperX<MesDvMeteringCheckDO>()
|
.eq(MesDvMeteringCheckDO::getMeteringId, meteringId)
|
.orderByDesc(MesDvMeteringCheckDO::getCheckDate)
|
.orderByDesc(MesDvMeteringCheckDO::getId)
|
.last("LIMIT 1"));
|
}
|
|
default Long selectCountByMeteringId(Long meteringId) {
|
return selectCount(MesDvMeteringCheckDO::getMeteringId, meteringId);
|
}
|
|
}
|
