//package com.mes.hollow.service.impl;
|
//
|
//import cn.hutool.core.lang.Assert;
|
//import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
//import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
|
//import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
//import com.github.yulichang.wrapper.MPJLambdaWrapper;
|
//import com.mes.bigstorage.entity.BigStorageCage;
|
//import com.mes.bigstorage.entity.BigStorageCageDetails;
|
//import com.mes.bigstorage.entity.BigStorageDTO;
|
//import com.mes.common.config.Const;
|
//import com.mes.glassinfo.entity.GlassInfo;
|
//import com.mes.hollow.entity.BigStorageCageHollow;
|
//import com.mes.hollow.entity.BigStorageCageHollowDetails;
|
//import com.mes.hollow.mapper.BigStorageCageHollowDetailsMapper;
|
//import com.mes.hollow.service.BigStorageCageHollowDetailsService;
|
//import org.springframework.stereotype.Service;
|
//
|
//import java.util.List;
|
//
|
///**
|
// * (BigStorageCageHollowDetails)表服务实现类
|
// *
|
// * @author makejava
|
// * @since 2024-11-21 09:23:12
|
// */
|
//@Service
|
//public class BigStorageCageHollowDetailsServiceImpl extends ServiceImpl<BigStorageCageHollowDetailsMapper, BigStorageCageHollowDetails> implements BigStorageCageHollowDetailsService {
|
//
|
// @Override
|
// public BigStorageDTO queryTargetSlotByHollow(GlassInfo glassInfo) {
|
// BigStorageDTO bigStorageDTO = null;
|
// MPJLambdaWrapper<BigStorageCageHollow> wrapper = new MPJLambdaWrapper<>(BigStorageCageHollow.class)
|
// .selectAll(BigStorageCageHollow.class)
|
// .leftJoin(BigStorageCageHollowDetails.class, BigStorageCageHollowDetails::getSlot, BigStorageCageHollow::getSlot)
|
// .eq(BigStorageCage::getEnableState, Const.SLOT_ON)
|
// .in(BigStorageCageDetails::getState, Const.GLASS_STATE_NEW,Const.GLASS_STATE_IN)
|
// .eq(BigStorageCageDetails::getEngineerId, glassInfo.getEngineerId())
|
// .eq(BigStorageCageDetails::getTemperingLayoutId, glassInfo.getTemperingLayoutId())
|
// .gt(BigStorageCage::getRemainWidth, Math.max(glassInfo.getWidth(), glassInfo.getHeight()))
|
// .last("limit 1");
|
// if (glassInfo.getTemperingLayoutId() == 0) {
|
// wrapper.eq(BigStorageCageDetails::getFlowCardId, glassInfo.getFlowCardId())
|
// .eq(BigStorageCageDetails::getLayer, glassInfo.getLayer());
|
//// wrapper.eq(BigStorageCageDetails::getWidth, glassInfo.getWidth()).eq(BigStorageCageDetails::getHeight, glassInfo.getHeight());
|
// } else {
|
// wrapper.eq(BigStorageCageDetails::getTemperingFeedSequence, glassInfo.getTemperingFeedSequence() - 1);
|
// }
|
// BigStorageCage bigStorageCage = bigStorageCageService.selectJoinOne(BigStorageCage.class, wrapper);
|
// if (null != bigStorageCage) {
|
// log.info("无钢化版图id或根据当前玻璃片序+1找到目标格子：{},玻璃id：{}", bigStorageCage.getSlot(), glassInfo.getGlassId());
|
// bigStorageDTO = new BigStorageDTO();
|
// bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
// bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
// bigStorageDTO.setDeviceId(bigStorageCage.getDeviceId());
|
// return bigStorageDTO;
|
// }
|
// bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
|
// .eq(BigStorageCage::getEnableState, Const.SLOT_ON)
|
// .eq(BigStorageCage::getRemainWidth, slotWidth)
|
//// .notInSql(BigStorageCage::getSlot, "select distinct slot from big_storage_cage_details where state = 0")
|
// .inSql(BigStorageCage::getDeviceId,
|
// "select distinct device_id from big_storage_cage_details where engineer_id = '" + glassInfo.getEngineerId() + "' and tempering_layout_id = " + glassInfo.getTemperingLayoutId())
|
// .last("limit 1"));
|
// if (null != bigStorageCage) {
|
// log.info("根据版图id找到笼子内的目标格子：{},玻璃id：{}", bigStorageCage.getSlot(), glassInfo.getGlassId());
|
// bigStorageDTO = new BigStorageDTO();
|
// bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
// bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
// bigStorageDTO.setDeviceId(bigStorageCage.getDeviceId());
|
// return bigStorageDTO;
|
// }
|
//
|
// //获取玻璃的厚度：重新选笼子需要按照笼子可放玻璃厚度进行选择 因为子查询排序对主sql无影响，所以先执行子查询获取顺序，然后一次去查询
|
// List<Integer> deviceUsedList = bigStorageCageService.queryFreeDeviceByUsed(glassInfo.getThickness());
|
// List<Integer> deviceUseds = bigStorageCageService.queryFreeDeviceByUsed(glassInfo.getThickness());
|
// List<BigStorageCageDetails> engineerCount1 = baseMapper.selectList(
|
// new LambdaQueryWrapper<BigStorageCageDetails>()
|
// .notIn(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT, Const.GLASS_STATE_DAMAGE, Const.GLASS_STATE_TAKE)
|
// .select(BigStorageCageDetails::getEngineerId)
|
// .groupBy(BigStorageCageDetails::getEngineerId)
|
// .between(BigStorageCageDetails::getDeviceId, 1, 5)
|
// );
|
// List<BigStorageCageDetails> engineerCount2 = baseMapper.selectList(
|
// new LambdaQueryWrapper<BigStorageCageDetails>()
|
// .notIn(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT, Const.GLASS_STATE_DAMAGE, Const.GLASS_STATE_TAKE)
|
// .select(BigStorageCageDetails::getEngineerId)
|
// .groupBy(BigStorageCageDetails::getEngineerId)
|
// .between(BigStorageCageDetails::getDeviceId, 6, 8)
|
// );
|
// if (engineerCount1.size() > engineerCount2.size()) {
|
// deviceUsedList.removeIf(device -> device < 6);
|
// } else {
|
// deviceUsedList.removeIf(device -> device > 5);
|
// }
|
// if (CollectionUtils.isEmpty(deviceUsedList)) {
|
// deviceUsedList = deviceUseds;
|
// }
|
// for (Integer item : deviceUsedList) {
|
// bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
|
// .eq(BigStorageCage::getRemainWidth, slotWidth)
|
// .eq(BigStorageCage::getEnableState, Const.SLOT_ON)
|
// .eq(BigStorageCage::getDeviceId, item)
|
// .last("limit 1"));
|
// if (null != bigStorageCage) {
|
// log.info("按照存笼玻璃格子数占用最少方式获取信息格子为：{},玻璃id：{}", bigStorageCage.getSlot(), glassInfo.getGlassId());
|
// bigStorageDTO = new BigStorageDTO();
|
// bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
// bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
// bigStorageDTO.setDeviceId(bigStorageCage.getDeviceId());
|
// return bigStorageDTO;
|
// }
|
// }
|
//
|
// //获取玻璃的厚度：重新选笼子需要按照笼子可放玻璃厚度进行选择
|
//// List<Integer> deviceNotUsedList = bigStorageCageService.queryFreeDeviceByNotUsed(glassInfo.getThickness());
|
//// for (Integer item : deviceNotUsedList) {
|
//// bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
|
//// .eq(BigStorageCage::getRemainWidth, slotWidth)
|
//// .eq(BigStorageCage::getEnableState, Const.SLOT_ON)
|
//// .eq(BigStorageCage::getDeviceId, item)
|
//// .last("limit 1"));
|
//// if (null != bigStorageCage) {
|
//// log.info("按照存笼玻璃格子数剩余最多得方式获取信息版图id:{},格子：{},玻璃id：{}", glassInfo.getTemperingLayoutId(), bigStorageCage.getSlot(), glassInfo.getGlassId());
|
//// bigStorageDTO = new BigStorageDTO();
|
//// bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
//// bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
//// bigStorageDTO.setDeviceId(bigStorageCage.getDeviceId());
|
//// return bigStorageDTO;
|
//// }
|
//// }
|
// Assert.isTrue(null != bigStorageCage, "没有空余的笼子存放玻璃");
|
// return bigStorageDTO;
|
// }
|
//}
|
//
|
