云
5 天以前 9265065bea5a40bcaced67857cb3ba22324ce06c
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/stocktaking/task/MesWmStockTakingTaskLineMapper.java
@@ -12,7 +12,7 @@
/**
 * MES 盘点任务行 Mapper
 *
 * @author 芋道源码
 * @author 超级管理员
 */
@Mapper
public interface MesWmStockTakingTaskLineMapper extends BaseMapperX<MesWmStockTakingTaskLineDO> {
@@ -33,11 +33,18 @@
                .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));
    }
}