package cn.iocoder.yudao.module.erp.dal.mysql.purchase;
|
|
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.erp.controller.admin.purchase.vo.demand.ErpPurchaseDemandPageReqVO;
|
import cn.iocoder.yudao.module.erp.dal.dataobject.purchase.ErpPurchaseDemandDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.Collection;
|
import java.util.List;
|
|
/**
|
* ERP 申请采购单 Mapper
|
*/
|
@Mapper
|
public interface ErpPurchaseDemandMapper extends BaseMapperX<ErpPurchaseDemandDO> {
|
|
default PageResult<ErpPurchaseDemandDO> selectPage(ErpPurchaseDemandPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<ErpPurchaseDemandDO>()
|
.likeIfPresent(ErpPurchaseDemandDO::getNo, reqVO.getNo())
|
.eqIfPresent(ErpPurchaseDemandDO::getSupplierId, reqVO.getSupplierId())
|
.eqIfPresent(ErpPurchaseDemandDO::getPurchaseCategory, reqVO.getPurchaseCategory())
|
.eqIfPresent(ErpPurchaseDemandDO::getSourceType, reqVO.getSourceType())
|
.eqIfPresent(ErpPurchaseDemandDO::getStatus, reqVO.getStatus())
|
.likeIfPresent(ErpPurchaseDemandDO::getWorkOrderNo, reqVO.getWorkOrderNo())
|
.betweenIfPresent(ErpPurchaseDemandDO::getDemandTime, reqVO.getDemandTime())
|
.orderByDesc(ErpPurchaseDemandDO::getId));
|
}
|
|
default ErpPurchaseDemandDO selectByNo(String no) {
|
return selectOne(ErpPurchaseDemandDO::getNo, no);
|
}
|
|
default List<ErpPurchaseDemandDO> selectListByIds(Collection<Long> ids) {
|
return selectList(ErpPurchaseDemandDO::getId, ids);
|
}
|
|
}
|