package cn.iocoder.yudao.module.mes.dal.mysql.qc.ncr; import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; import cn.iocoder.yudao.framework.common.pojo.PageParam; import cn.iocoder.yudao.framework.common.pojo.PageResult; import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.mes.dal.dataobject.qc.ncr.MesQcPurchaseReturnDO; import org.apache.ibatis.annotations.Mapper; @Mapper public interface MesQcPurchaseReturnMapper extends BaseMapperX { default MesQcPurchaseReturnDO selectByNcrId(Long ncrId) { return selectOne(new LambdaQueryWrapperX() .eq(MesQcPurchaseReturnDO::getNcrId, ncrId)); } default MesQcPurchaseReturnDO selectByIdForUpdate(Long id) { return selectOne(new LambdaQueryWrapperX() .eq(MesQcPurchaseReturnDO::getId, id).last("FOR UPDATE")); } default MesQcPurchaseReturnDO selectConfirmedByIqcId(Long iqcId) { return selectOne(new LambdaQueryWrapperX() .eq(MesQcPurchaseReturnDO::getIqcId, iqcId) .eq(MesQcPurchaseReturnDO::getStatus, 1).last("LIMIT 1")); } default MesQcPurchaseReturnDO selectByIqcId(Long iqcId) { return selectOne(new LambdaQueryWrapperX() .eq(MesQcPurchaseReturnDO::getIqcId, iqcId)); } default PageResult selectPage(PageParam page, Integer status) { return selectPage(page, new LambdaQueryWrapperX() .eqIfPresent(MesQcPurchaseReturnDO::getStatus, status) .orderByDesc(MesQcPurchaseReturnDO::getId)); } }