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);
    }

}