| | |
|---|
| | | |
|---|
| | | import cn.hutool.core.lang.Assert; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; |
|---|
| | | import com.github.yulichang.base.MPJBaseServiceImpl; |
|---|
| | | import com.github.yulichang.toolkit.JoinWrappers; |
|---|
| | |
|---|
| | | .eq(BigStorageCage::getEnableState, Const.SLOT_ON) |
|---|
| | | .eq(BigStorageCage::getRemainWidth, slotWidth).orderByAsc(BigStorageCage::getSlot) |
|---|
| | | .inSql(BigStorageCage::getDeviceId, |
|---|
| | | "select distinct device_id from big_storage_cage_details where engineer_id = '" + EngineerId + "'") |
|---|
| | | "select distinct device_id from big_storage_cage_details where engineer_id = '" + EngineerId + "' and device_id not in (5,6)") |
|---|
| | | .last("limit 1")); |
|---|
| | | if (null != bigStorageCage) { |
|---|
| | | log.info("根据版图id找到笼子内的目标格子：{},玻璃id：{}", bigStorageCage.getSlot(), glassId); |
|---|
| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<BigStorageRelationDTO> queryIsAllNeedDispatchVirtualSlot() { |
|---|
| | | return baseMapper.queryIsAllNeedDispatchVirtualSlot(); |
|---|
| | | public List<BigStorageRelationDTO> queryIsAllNeedDispatchVirtualSlot(List<Integer> deviceIdList) { |
|---|
| | | return baseMapper.queryIsAllNeedDispatchVirtualSlot(deviceIdList); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | |
|---|
| | | public void updateDeviceIdBySlot(List<Integer> slotList) { |
|---|
| | | baseMapper.updateDeviceIdBySlot(slotList); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<BigStorageCageDetails> queryEngineer() { |
|---|
| | | QueryWrapper<BigStorageCageDetails> wrapper = new QueryWrapper<>(); |
|---|
| | | wrapper.select("distinct engineer_id") |
|---|
| | | .eq("state", 100); |
|---|
| | | return this.list(wrapper); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<BigStorageCageDetails> queryNeedDispatch() { |
|---|
| | | return baseMapper.queryNeedDispatch(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public BigStorageSlotDTO queryNeedDispatchSlotBySequence() { |
|---|
| | | return baseMapper.queryNeedDispatchSlotBySequence(); |
|---|
| | | } |
|---|
| | | } |
|---|
