From 6977fb42d5067f6c938ef3de559a6ad19b542a0b Mon Sep 17 00:00:00 2001 From: 严智鑫 <test> Date: 星期五, 14 六月 2024 11:29:09 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/HangZhouMes --- hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java | 241 +++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 235 insertions(+), 6 deletions(-) diff --git a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java index 298761d..ebaec10 100644 --- a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java +++ b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java @@ -1,15 +1,31 @@ package com.mes.bigstorage.service.impl; -import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import cn.hutool.core.lang.Assert; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.github.yulichang.base.MPJBaseServiceImpl; +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.bigstorage.mapper.BigStorageCageDetailsMapper; -import com.mes.bigstorage.mapper.BigStorageCageMapper; import com.mes.bigstorage.service.BigStorageCageDetailsService; -import org.springframework.beans.factory.annotation.Autowired; +import com.mes.bigstorage.service.BigStorageCageService; +import com.mes.bigstoragetask.entity.BigStorageCageFeedTask; +import com.mes.bigstoragetask.entity.BigStorageCageOutTask; +import com.mes.bigstoragetask.mapper.BigStorageCageFeedTaskMapper; +import com.mes.bigstoragetask.mapper.BigStorageCageOutTaskMapper; +import com.mes.common.config.Const; +import com.mes.glassinfo.entity.GlassInfo; +import com.mes.glassinfo.mapper.GlassInfoMapper; +import com.mes.temperingglass.entity.TemperingGlassInfo; +import com.mes.temperingglass.mapper.TemperingGlassInfoMapper; +import org.springframework.beans.BeanUtils; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.util.List; +import java.util.Map; +import java.util.stream.Collectors; /** * <p> @@ -20,8 +36,221 @@ * @since 2024-03-27 */ @Service -public class BigStorageCageDetailsServiceImpl extends ServiceImpl<BigStorageCageDetailsMapper, BigStorageCageDetails> implements BigStorageCageDetailsService { - @Resource - private BigStorageCageMapper bigStorageCageMapper; +public class BigStorageCageDetailsServiceImpl extends MPJBaseServiceImpl<BigStorageCageDetailsMapper, BigStorageCageDetails> implements BigStorageCageDetailsService { + @Resource + private BigStorageCageOutTaskMapper bigStorageCageOutTaskMapper; + @Resource + private BigStorageCageFeedTaskMapper bigStorageCageFeedTaskMapper; + @Resource + private TemperingGlassInfoMapper temperingGlassInfoMapper; + @Resource + private BigStorageCageService bigStorageCageService; + @Resource + private GlassInfoMapper glassInfoMapper; + + /** + * 鏌ヨ杩�/鍑虹墖浠诲姟 + */ + @Override + public List<BigStorageCageDetails> selectTask(int taskType) { + if (taskType == 1) { + //杩涚墖浠诲姟鏁版嵁 + LambdaQueryWrapper<BigStorageCageDetails> feedWrapper = new LambdaQueryWrapper<>(); + feedWrapper.eq(BigStorageCageDetails::getState, 1) + .or() + .eq(BigStorageCageDetails::getState, 2); + List<BigStorageCageDetails> bigStorageCageDetailsList = baseMapper.selectList(feedWrapper); + List<BigStorageCageFeedTask> bigStorageCageFeedTaskList = bigStorageCageFeedTaskMapper.selectList(null); + + Map<String, BigStorageCageFeedTask> listMap = bigStorageCageFeedTaskList.stream() + .collect(Collectors.toMap(BigStorageCageFeedTask::getGlassId, task -> task)); + + for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList) { + BigStorageCageFeedTask bigStorageCageFeedTask = listMap.get(bigStorageCageDetails.getGlassId()); + bigStorageCageDetails.setBigStorageCageFeedTask(bigStorageCageFeedTask); + } + return bigStorageCageDetailsList; + } else { + //鍑虹墖浠诲姟鏁版嵁 + LambdaQueryWrapper<BigStorageCageDetails> outWrapper = new LambdaQueryWrapper<>(); + outWrapper.eq(BigStorageCageDetails::getState, 3) + .or() + .eq(BigStorageCageDetails::getState, 4); + List<BigStorageCageDetails> bigStorageCageDetailsList = baseMapper.selectList(outWrapper); + List<BigStorageCageOutTask> bigStorageCageOutTaskList = bigStorageCageOutTaskMapper.selectList(null); + + Map<String, BigStorageCageOutTask> listMap = bigStorageCageOutTaskList.stream() + .collect(Collectors.toMap(BigStorageCageOutTask::getGlassId, task -> task)); + for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList) { + BigStorageCageOutTask bigStorageCageOutTask = listMap.get(bigStorageCageDetails.getGlassId()); + bigStorageCageDetails.setBigStorageCageOutTask(bigStorageCageOutTask); + } + return bigStorageCageDetailsList; + } + + } + + /** + * 鍒ゆ柇褰撳墠鐜荤拑鏄惁鑳戒笂杞� + */ + @Override + public double selectGetBoard(String plcFeedReqLine) { + double carWidth = 5000; + LambdaQueryWrapper<BigStorageCageDetails> feedWrapper = new LambdaQueryWrapper<>(); + feedWrapper.eq(BigStorageCageDetails::getState, plcFeedReqLine); + List<BigStorageCageDetails> bigStorageCageDetailsList = baseMapper.selectList(feedWrapper); + + LambdaQueryWrapper<BigStorageCageFeedTask> bigStorageCageFeedTaskWrapper = new LambdaQueryWrapper<>(); + bigStorageCageFeedTaskWrapper + .eq(BigStorageCageFeedTask::getTaskState, plcFeedReqLine) + .eq(BigStorageCageFeedTask::getLine, plcFeedReqLine); + + List<BigStorageCageFeedTask> bigStorageCageFeedTaskList = bigStorageCageFeedTaskMapper.selectList(bigStorageCageFeedTaskWrapper); + Map<String, BigStorageCageFeedTask> listMap = bigStorageCageFeedTaskList.stream() + .collect(Collectors.toMap(BigStorageCageFeedTask::getGlassId, task -> task)); + for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList) { + BigStorageCageFeedTask bigStorageCageFeedTask = listMap.get(bigStorageCageDetails.getGlassId()); + bigStorageCageDetails.setBigStorageCageFeedTask(bigStorageCageFeedTask); + } + for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList + ) { + if (bigStorageCageDetails.getBigStorageCageFeedTask().getTaskState() == 0) { + carWidth -= Integer.parseInt(bigStorageCageDetails.getWidth().toString()) + bigStorageCageDetails.getGap(); + } + } + return carWidth; + + } + + + //鏍撻櫎鍑虹墖浠诲姟.鏇存柊鏍煎瓙瀹藉害 + @Override + public void deleteBigStorageCageDetails(BigStorageCageDetails bigStorageCageDetails) { + baseMapper.deleteById(bigStorageCageDetails.getId()); + bigStorageCageService.updateRemainWidth(bigStorageCageDetails.getSlot()); + } + + //鐞嗙墖绗艰鎯呯牬鎹� + @Override + public void damageBigStorageCageDetails(String glassId) { + LambdaQueryWrapper<TemperingGlassInfo> temperingGlassInfoWrapper = new LambdaQueryWrapper<>(); + temperingGlassInfoWrapper.eq(TemperingGlassInfo::getGlassId, glassId); + TemperingGlassInfo temperingGlassInfo = temperingGlassInfoMapper.selectOne(temperingGlassInfoWrapper); + + LambdaQueryWrapper<BigStorageCageDetails> bigStorageCageDetailsWrapper = new LambdaQueryWrapper<>(); + bigStorageCageDetailsWrapper.eq(BigStorageCageDetails::getGlassId, glassId); + BigStorageCageDetails bigStorageCageDetails = baseMapper.selectOne(bigStorageCageDetailsWrapper); + + if (temperingGlassInfo.getState() == -2) { + temperingGlassInfoMapper.deleteById(temperingGlassInfo); + } else { + temperingGlassInfo.setState(5); + temperingGlassInfoMapper.updateById(temperingGlassInfo); + } + baseMapper.deleteById(bigStorageCageDetails.getId()); + bigStorageCageService.updateRemainWidth(bigStorageCageDetails.getSlot()); + //todo:鎻掑叆鐮存崯鏁版嵁 + + } + + //鏌ヨ鐜荤拑淇℃伅 + @Override + public BigStorageCageDetails selectBigStorageCageDetails(String glassId) { + LambdaQueryWrapper<GlassInfo> glassInfoWrapper = new LambdaQueryWrapper<>(); + glassInfoWrapper.eq(GlassInfo::getGlassId, glassId); + GlassInfo glassInfo = glassInfoMapper.selectOne(glassInfoWrapper); + BigStorageCageDetails bigStorageCageDetails = new BigStorageCageDetails(); + BeanUtils.copyProperties(glassInfo, bigStorageCageDetails); + bigStorageCageDetails.setState(0); + bigStorageCageDetails.setGap(20); + return bigStorageCageDetails; + } + + //鐞嗙墖绗艰鎯呮坊鍔� + @Override + public void insertBigStorageCageDetails(BigStorageCageDetails bigStorageCageDetails) { + baseMapper.insert(bigStorageCageDetails); + bigStorageCageService.updateRemainWidth(bigStorageCageDetails.getSlot()); + } + + //鐞嗙墖绗艰鎯呭畬鎴� + @Override + public void finishBigStorageCageDetails(BigStorageCageDetails bigStorageCageDetails) { + if (bigStorageCageDetails.getState() == 1 || bigStorageCageDetails.getState() == 2) { + bigStorageCageDetails.setState(0); + baseMapper.updateById(bigStorageCageDetails); + bigStorageCageFeedTaskMapper.deleteById(bigStorageCageDetails.getBigStorageCageFeedTask().getId()); + } else { + baseMapper.deleteById(bigStorageCageDetails.getId()); + bigStorageCageOutTaskMapper.deleteById(bigStorageCageDetails.getBigStorageCageOutTask().getId()); + } + + } + + //鎵嬪姩鍑虹墖 + @Override + public void outBigStorageCageDetails(BigStorageCageDetails bigStorageCageDetails) { + LambdaQueryWrapper<TemperingGlassInfo> temperingGlassInfoWrapper = new LambdaQueryWrapper<>(); + temperingGlassInfoWrapper + .eq(TemperingGlassInfo::getGlassId, bigStorageCageDetails.getGlassId()); + TemperingGlassInfo temperingGlassInfo = temperingGlassInfoMapper.selectOne(temperingGlassInfoWrapper); + if (temperingGlassInfo.getGlassId() == null) { + LambdaQueryWrapper<GlassInfo> glassInfoWrapper = new LambdaQueryWrapper<>(); + glassInfoWrapper + .eq(GlassInfo::getGlassId, bigStorageCageDetails.getGlassId()); + GlassInfo glassInfo = glassInfoMapper.selectOne(glassInfoWrapper); + TemperingGlassInfo temperingGlassInfo1 = new TemperingGlassInfo(); + BeanUtils.copyProperties(glassInfo, temperingGlassInfo1); + + if (temperingGlassInfo.getTemperingLayoutId() != null) { + temperingGlassInfo1.setState(-1); + } else { + temperingGlassInfo1.setState(-2); + } + temperingGlassInfoMapper.insert(temperingGlassInfo1); + } + } + + @Override + public BigStorageDTO queryTargetSlotByTempering(GlassInfo glassInfo) { +// MPJLambdaWrapper<BigStorageDTO> wrapper = new MPJLambdaWrapper<>(BigStorageCage.class) +// .selectAll(BigStorageDTO.class) +// .leftJoin(BigStorageCageDetails.class, BigStorageCageDetails::getSlot, BigStorageCage::getSlot) +// .eq(BigStorageCageDetails::getTemperingLayoutId, glassInfo.getTemperingLayoutId()) +// .eq(BigStorageCageDetails::getTemperingFeedSequence, glassInfo.getTemperingFeedSequence() + 1) +// .last("limit 1"); + BigStorageDTO bigStorageDTO = null; + MPJLambdaWrapper<BigStorageCage> wrapper = new MPJLambdaWrapper<>(BigStorageCage.class) + .selectAsClass(BigStorageCage.class, BigStorageDTO.class) + .leftJoin(BigStorageCageDetails.class, BigStorageCageDetails::getSlot, BigStorageCage::getSlot) + .eq(BigStorageCageDetails::getTemperingLayoutId, glassInfo.getTemperingLayoutId()) + .eq(BigStorageCageDetails::getTemperingFeedSequence, glassInfo.getTemperingFeedSequence() + 1) + .last("limit 1"); + bigStorageDTO = bigStorageCageService.selectJoinOne(BigStorageDTO.class, wrapper); + if (null != bigStorageDTO) { + return bigStorageDTO; + } + BigStorageCage bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>() + .eq(BigStorageCage::getRemainWidth, Const.BIG_STORAGE_WIDTH) + .inSql(BigStorageCage::getDeviceId, + "select distinct device_id from big_storage_cage_details where tempering_layout_id = " + glassInfo.getTemperingLayoutId()) + .last("limit 1")); + if (null != bigStorageCage) { + bigStorageDTO = new BigStorageDTO(); + bigStorageDTO.setWidth(bigStorageCage.getRemainWidth()); + bigStorageDTO.setSlot(bigStorageCage.getSlot()); + return bigStorageDTO; + } + bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>() + .eq(BigStorageCage::getRemainWidth, Const.BIG_STORAGE_WIDTH) + .last("limit 1")); + Assert.isTrue(null != bigStorageCage, "娌℃湁绌轰綑鐨勭瀛愬瓨鏀剧幓鐠�"); + bigStorageDTO = new BigStorageDTO(); + bigStorageDTO.setWidth(bigStorageCage.getRemainWidth()); + bigStorageDTO.setSlot(bigStorageCage.getSlot()); + return bigStorageDTO; + + + } } -- Gitblit v1.8.0