| | |
| | | .eqIfPresent(MesWmMaterialStockDO::getVendorId, reqVO.getVendorId()) |
| | | .eqIfPresent(MesWmMaterialStockDO::getStockState, reqVO.getStockState()) |
| | | .eqIfPresent(MesWmMaterialStockDO::getFrozen, reqVO.getFrozen()); |
| | | wrapper.ne(MesWmMaterialStockDO::getQuantity, BigDecimal.ZERO) |
| | | .orderByAsc(MesWmMaterialStockDO::getReceiptTime); |
| | | if (!Boolean.TRUE.equals(reqVO.getIncludeZero())) { |
| | | wrapper.ne(MesWmMaterialStockDO::getQuantity, BigDecimal.ZERO); |
| | | } |
| | | wrapper.orderByAsc(MesWmMaterialStockDO::getReceiptTime); |
| | | // 虚拟仓过滤(Service 层已将 virtualFilter 解析为 virtualWarehouseId) |
| | | if (virtualWarehouseId != null) { |
| | | if (MesWmMaterialStockPageReqVO.VIRTUAL_FILTER_ONLY.equals(reqVO.getVirtualFilter())) { |
| | |
| | | LambdaQueryWrapperX<MesWmMaterialStockDO> wrapper = new LambdaQueryWrapperX<MesWmMaterialStockDO>() |
| | | .eq(MesWmMaterialStockDO::getItemId, itemId) |
| | | .eq(MesWmMaterialStockDO::getWarehouseId, warehouseId) |
| | | .eq(MesWmMaterialStockDO::getLocationId, locationId) |
| | | .eq(MesWmMaterialStockDO::getAreaId, areaId) |
| | | .eqIfPresent(MesWmMaterialStockDO::getLocationId, locationId) |
| | | .eqIfPresent(MesWmMaterialStockDO::getAreaId, areaId) |
| | | .eq(MesWmMaterialStockDO::getStockState, MesWmStockStateEnum.QUALIFIED.getState()); |
| | | // batchId=null 时精确匹配 is null |
| | | if (batchId != null) { |
| | |
| | | LambdaQueryWrapperX<MesWmMaterialStockDO> wrapper = new LambdaQueryWrapperX<MesWmMaterialStockDO>() |
| | | .eq(MesWmMaterialStockDO::getItemId, itemId) |
| | | .eq(MesWmMaterialStockDO::getWarehouseId, warehouseId) |
| | | .eq(MesWmMaterialStockDO::getLocationId, locationId) |
| | | .eq(MesWmMaterialStockDO::getAreaId, areaId) |
| | | .eqIfPresent(MesWmMaterialStockDO::getLocationId, locationId) |
| | | .eqIfPresent(MesWmMaterialStockDO::getAreaId, areaId) |
| | | .eq(MesWmMaterialStockDO::getStockState, MesWmStockStateEnum.QUALIFIED.getState()); |
| | | // batchId=null 时精确匹配 is null |
| | | if (batchId != null) { |