package cn.iocoder.yudao.module.mes.dal.mysql.pro.alert;

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.pro.alert.vo.MesProOverConsumeAlertPageReqVO;
import cn.iocoder.yudao.module.mes.dal.dataobject.pro.alert.MesProOverConsumeAlertDO;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * MES 工单物料超耗报警记录 Mapper
 *
 * @author 超级管理员
 */
@Mapper
public interface MesProOverConsumeAlertMapper extends BaseMapperX<MesProOverConsumeAlertDO> {

    default PageResult<MesProOverConsumeAlertDO> selectPage(MesProOverConsumeAlertPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<MesProOverConsumeAlertDO>()
                .eqIfPresent(MesProOverConsumeAlertDO::getWorkOrderId, reqVO.getWorkOrderId())
                .eqIfPresent(MesProOverConsumeAlertDO::getItemId, reqVO.getItemId())
                .eqIfPresent(MesProOverConsumeAlertDO::getStatus, reqVO.getStatus())
                .betweenIfPresent(MesProOverConsumeAlertDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(MesProOverConsumeAlertDO::getId));
    }

    default List<MesProOverConsumeAlertDO> selectListByWorkOrderId(Long workOrderId) {
        return selectList(new LambdaQueryWrapperX<MesProOverConsumeAlertDO>()
                .eq(MesProOverConsumeAlertDO::getWorkOrderId, workOrderId)
                .orderByDesc(MesProOverConsumeAlertDO::getId));
    }

    default MesProOverConsumeAlertDO selectByWorkOrderIdAndItemId(Long workOrderId, Long itemId) {
        return selectOne(new LambdaQueryWrapperX<MesProOverConsumeAlertDO>()
                .eq(MesProOverConsumeAlertDO::getWorkOrderId, workOrderId)
                .eq(MesProOverConsumeAlertDO::getItemId, itemId)
                .last("LIMIT 1"));
    }

}