| | |
|---|
| | | .setSql("reserved_quantity = reserved_quantity + " + count); |
|---|
| | | if (checkFlag && count.compareTo(BigDecimal.ZERO) > 0) { |
|---|
| | | // 校验可用量充足：quantity - frozen_quantity - reserved_quantity >= count |
|---|
| | | updateWrapper.setSql("reserved_quantity = reserved_quantity + " + count + |
|---|
| | | " WHERE quantity - IFNULL(frozen_quantity, 0) - IFNULL(reserved_quantity, 0) >= " + count); |
|---|
| | | updateWrapper.apply("quantity - IFNULL(frozen_quantity, 0) - IFNULL(reserved_quantity, 0) >= {0}", count); |
|---|
| | | } |
|---|
| | | return update(null, updateWrapper); |
|---|
| | | } |
|---|
| | |
|---|
| | | return selectOne(wrapper); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 按组合键查询库存记录（忽略供应商维度） |
|---|
| | | * |
|---|
| | | * 用于移库场景：移库时将库存合并到目标库位已有库存，不区分供应商 |
|---|
| | | */ |
|---|
| | | default MesWmMaterialStockDO selectByCompositeKeyIgnoreVendor(Long itemId, Long warehouseId, Long locationId, |
|---|
| | | Long areaId, Long batchId) { |
|---|
| | | LambdaQueryWrapperX<MesWmMaterialStockDO> wrapper = new LambdaQueryWrapperX<MesWmMaterialStockDO>() |
|---|
| | | .eq(MesWmMaterialStockDO::getItemId, itemId) |
|---|
| | | .eq(MesWmMaterialStockDO::getWarehouseId, warehouseId) |
|---|
| | | .eq(MesWmMaterialStockDO::getLocationId, locationId) |
|---|
| | | .eq(MesWmMaterialStockDO::getAreaId, areaId); |
|---|
| | | // batchId=null 时精确匹配 is null |
|---|
| | | if (batchId != null) { |
|---|
| | | wrapper.eq(MesWmMaterialStockDO::getBatchId, batchId); |
|---|
| | | } else { |
|---|
| | | wrapper.isNull(MesWmMaterialStockDO::getBatchId); |
|---|
| | | } |
|---|
| | | wrapper.last("LIMIT 1"); |
|---|
| | | return selectOne(wrapper); |
|---|
| | | } |
|---|
| | | |
|---|
| | | default List<MesWmMaterialStockDO> selectList(MesWmMaterialStockListReqVO reqVO) { |
|---|
| | | return selectList(new LambdaQueryWrapperX<MesWmMaterialStockDO>() |
|---|
| | | .eqIfPresent(MesWmMaterialStockDO::getWarehouseId, reqVO.getWarehouseId()) |
|---|
