| | |
| | | import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.time.LocalDateTime; |
| | | import java.util.Collection; |
| | | import java.util.List; |
| | | import java.util.Objects; |
| | | |
| | |
| | | .eq(ErpPurchaseOrderDO::getSourceId, sourceId)); |
| | | } |
| | | |
| | | /** |
| | | * 按供应商与下单时间范围查询采购订单(供应商往来) |
| | | */ |
| | | default List<ErpPurchaseOrderDO> selectListBySupplierIdAndOrderTimeBetween(Long supplierId, |
| | | LocalDateTime beginTime, |
| | | LocalDateTime endTime, |
| | | Collection<Integer> statuses) { |
| | | return selectList(new LambdaQueryWrapperX<ErpPurchaseOrderDO>() |
| | | .eq(ErpPurchaseOrderDO::getSupplierId, supplierId) |
| | | .geIfPresent(ErpPurchaseOrderDO::getOrderTime, beginTime) |
| | | .leIfPresent(ErpPurchaseOrderDO::getOrderTime, endTime) |
| | | .inIfPresent(ErpPurchaseOrderDO::getStatus, statuses) |
| | | .orderByAsc(ErpPurchaseOrderDO::getOrderTime) |
| | | .orderByAsc(ErpPurchaseOrderDO::getId)); |
| | | } |
| | | |
| | | } |