package com.mes.bigstorage.mapper;
|
|
import com.github.yulichang.base.MPJBaseMapper;
|
import com.mes.base.entity.vo.BigStorageVO;
|
import com.mes.bigstorage.entity.BigStorageCageDetails;
|
import com.mes.bigstorage.entity.dto.*;
|
import com.mes.bigstorage.entity.vo.BigStorageQueryVO;
|
import com.mes.bigstoragetask.entity.UpdateBigStorageCageDTO;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
|
|
/**
|
* <p>
|
* Mapper 接口
|
* </p>
|
*
|
* @author zhoush
|
* @since 2024-03-27
|
*/
|
public interface BigStorageCageDetailsMapper extends MPJBaseMapper<BigStorageCageDetails> {
|
|
/**
|
* 获取钢化版图已经到齐的工程号及版图id
|
*
|
* @return
|
*/
|
List<TemperingLayoutDTO> temperingIsAll();
|
|
/**
|
* 获取每个钢化版图占用的格子数量
|
*
|
* @return
|
*/
|
List<TemperingLayoutDTO> queryTemperingOccupySlot(@Param(value = "count") int count);
|
|
|
List<SlotSequenceDTO> queryGlassMaxAndMin(@Param(value = "engineerId") String engineerId, @Param(value = "temperingLayoutId") Integer temperingLayoutId);
|
|
/**
|
* 按照玻璃id和目标格子更新笼内玻璃信息
|
*
|
* @param glassList
|
* @param state
|
*/
|
void updateBySlot(@Param(value = "list") List<UpdateBigStorageCageDTO> glassList, @Param(value = "state") int state);
|
|
List<TemperingGlassCountDTO> selectTemperingGlassCount(int isTempering);
|
|
List<BigStorageRelationDTO> queryIsAllNeedDispatchVirtualSlot();
|
|
List<BigStorageSequenceDTO> queryNeedDispatchSlot(BigStorageRelationDTO bigStorageRelationDTO);
|
|
List<GlassInfoLackDTO> queryLackGlassInfo(BigStorageQueryVO bigStorageQueryVO);
|
|
void updateDeviceIdBySlot(@Param("list") List<Integer> slotList);
|
|
List<BigStorageVO> querybigStorageCageDetail();
|
}
|
