package cn.iocoder.yudao.module.mes.dal.mysql.wm.stocktaking.task;
|
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
|
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
|
import cn.iocoder.yudao.module.mes.controller.admin.wm.stocktaking.task.vo.line.MesWmStockTakingTaskLinePageReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.stocktaking.task.MesWmStockTakingTaskLineDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.List;
|
|
/**
|
* MES 盘点任务行 Mapper
|
*
|
* @author 超级管理员
|
*/
|
@Mapper
|
public interface MesWmStockTakingTaskLineMapper extends BaseMapperX<MesWmStockTakingTaskLineDO> {
|
|
default List<MesWmStockTakingTaskLineDO> selectListByTaskId(Long taskId) {
|
return selectList(new LambdaQueryWrapperX<MesWmStockTakingTaskLineDO>()
|
.eq(MesWmStockTakingTaskLineDO::getTaskId, taskId)
|
.orderByAsc(MesWmStockTakingTaskLineDO::getId));
|
}
|
|
default void deleteByTaskId(Long taskId) {
|
delete(MesWmStockTakingTaskLineDO::getTaskId, taskId);
|
}
|
|
default PageResult<MesWmStockTakingTaskLineDO> selectPage(MesWmStockTakingTaskLinePageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<MesWmStockTakingTaskLineDO>()
|
.eqIfPresent(MesWmStockTakingTaskLineDO::getTaskId, reqVO.getTaskId())
|
.orderByAsc(MesWmStockTakingTaskLineDO::getId));
|
}
|
|
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)
|
.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));
|
}
|
|
}
|