| | |
| | | .eqIfPresent(MesWmMaterialStockDO::getLocationId, reqVO.getLocationId()) |
| | | .eqIfPresent(MesWmMaterialStockDO::getAreaId, reqVO.getAreaId()) |
| | | .eqIfPresent(MesWmMaterialStockDO::getVendorId, reqVO.getVendorId()) |
| | | .eqIfPresent(MesWmMaterialStockDO::getStockState, reqVO.getStockState()) |
| | | .eqIfPresent(MesWmMaterialStockDO::getFrozen, reqVO.getFrozen()); |
| | | wrapper.ne(MesWmMaterialStockDO::getQuantity, BigDecimal.ZERO) |
| | | .orderByAsc(MesWmMaterialStockDO::getReceiptTime); |
| | |
| | | .eqIfPresent(MesWmMaterialStockDO::getItemId, reqVO.getItemId()) |
| | | .eqIfPresent(MesWmMaterialStockDO::getBatchId, reqVO.getBatchId()) |
| | | .eqIfPresent(MesWmMaterialStockDO::getVendorId, reqVO.getVendorId()) |
| | | .eqIfPresent(MesWmMaterialStockDO::getStockState, reqVO.getStockState()) |
| | | .likeIfPresent(MesWmMaterialStockDO::getBatchCode, reqVO.getBatchCode()) |
| | | .geIfPresent(MesWmMaterialStockDO::getUpdateTime, reqVO.getStartTime()) |
| | | .leIfPresent(MesWmMaterialStockDO::getUpdateTime, reqVO.getEndTime()) |
| | |
| | | /** |
| | | * 按物料编号批量查询库存记录(用于物料需求库存校验) |
| | | */ |
| | | default List<MesWmMaterialStockDO> selectListByItemAndBatch(Long itemId, Long batchId) { |
| | | return selectList(new LambdaQueryWrapperX<MesWmMaterialStockDO>() |
| | | .eq(MesWmMaterialStockDO::getItemId, itemId) |
| | | .eqIfPresent(MesWmMaterialStockDO::getBatchId, batchId) |
| | | .gt(MesWmMaterialStockDO::getQuantity, BigDecimal.ZERO) |
| | | .orderByAsc(MesWmMaterialStockDO::getReceiptTime)); |
| | | } |
| | | |
| | | default List<MesWmMaterialStockDO> selectListByItemIds(Collection<Long> itemIds) { |
| | | if (itemIds == null || itemIds.isEmpty()) { |
| | | return java.util.Collections.emptyList(); |