| | |
| | | /** |
| | | * MES 盘点任务行 Mapper |
| | | * |
| | | * @author 芋道源码 |
| | | * @author 超级管理员 |
| | | */ |
| | | @Mapper |
| | | public interface MesWmStockTakingTaskLineMapper extends BaseMapperX<MesWmStockTakingTaskLineDO> { |
| | |
| | | .orderByAsc(MesWmStockTakingTaskLineDO::getId)); |
| | | } |
| | | |
| | | default MesWmStockTakingTaskLineDO selectByTaskIdAndItemIdAndAreaId(Long taskId, Long itemId, Long areaId) { |
| | | default MesWmStockTakingTaskLineDO selectByStockDimensions(Long taskId, Long itemId, Long warehouseId, |
| | | Long locationId, Long areaId, Long batchId) { |
| | | return selectOne(new LambdaQueryWrapperX<MesWmStockTakingTaskLineDO>() |
| | | .eq(MesWmStockTakingTaskLineDO::getTaskId, taskId) |
| | | .eq(MesWmStockTakingTaskLineDO::getItemId, itemId) |
| | | .eqIfPresent(MesWmStockTakingTaskLineDO::getAreaId, areaId)); |
| | | .eq(MesWmStockTakingTaskLineDO::getWarehouseId, warehouseId) |
| | | .eq(locationId != null, MesWmStockTakingTaskLineDO::getLocationId, locationId) |
| | | .isNull(locationId == null, MesWmStockTakingTaskLineDO::getLocationId) |
| | | .eq(areaId != null, MesWmStockTakingTaskLineDO::getAreaId, areaId) |
| | | .isNull(areaId == null, MesWmStockTakingTaskLineDO::getAreaId) |
| | | .eq(batchId != null, MesWmStockTakingTaskLineDO::getBatchId, batchId) |
| | | .isNull(batchId == null, MesWmStockTakingTaskLineDO::getBatchId)); |
| | | } |
| | | |
| | | } |