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

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

/**
 * MES 委外检测/试验单 Mapper
 *
 * @author xiaoyi
 */
@Mapper
public interface MesQcOutsourceTestMapper extends BaseMapperX<MesQcOutsourceTestDO> {

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

    default PageResult<MesQcOutsourceTestDO> selectPage(MesQcOutsourceTestPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<MesQcOutsourceTestDO>()
                .likeIfPresent(MesQcOutsourceTestDO::getCode, reqVO.getCode())
                .likeIfPresent(MesQcOutsourceTestDO::getName, reqVO.getName())
                .eqIfPresent(MesQcOutsourceTestDO::getTestType, reqVO.getTestType())
                .eqIfPresent(MesQcOutsourceTestDO::getResult, reqVO.getResult())
                .eqIfPresent(MesQcOutsourceTestDO::getStatus, reqVO.getStatus())
                .betweenIfPresent(MesQcOutsourceTestDO::getTestDate, reqVO.getTestDate())
                .orderByDesc(MesQcOutsourceTestDO::getId));
    }

}