package cn.iocoder.yudao.module.mes.dal.mysql.qc.ncr;

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.qc.ncr.vo.MesQcNcrPageReqVO;
import cn.iocoder.yudao.module.mes.dal.dataobject.qc.ncr.MesQcNcrDO;
import org.apache.ibatis.annotations.Mapper;

/**
 * MES 不合格品处理单（NCR） Mapper
 *
 * @author 超级管理员
 */
@Mapper
public interface MesQcNcrMapper extends BaseMapperX<MesQcNcrDO> {

    default PageResult<MesQcNcrDO> selectPage(MesQcNcrPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<MesQcNcrDO>()
                .likeIfPresent(MesQcNcrDO::getCode, reqVO.getCode())
                .eqIfPresent(MesQcNcrDO::getQcType, reqVO.getQcType())
                .eqIfPresent(MesQcNcrDO::getItemId, reqVO.getItemId())
                .eqIfPresent(MesQcNcrDO::getDefectLevel, reqVO.getDefectLevel())
                .eqIfPresent(MesQcNcrDO::getDisposition, reqVO.getDisposition())
                .eqIfPresent(MesQcNcrDO::getStatus, reqVO.getStatus())
                .eqIfPresent(MesQcNcrDO::getResponsibleDeptId, reqVO.getResponsibleDeptId())
                .betweenIfPresent(MesQcNcrDO::getReviewDate, reqVO.getReviewDate())
                .betweenIfPresent(MesQcNcrDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(MesQcNcrDO::getId));
    }

    default MesQcNcrDO selectByCode(String code) {
        return selectOne(MesQcNcrDO::getCode, code);
    }

}