From 529d04102d54c3a2ed5da05ce4793af51472e454 Mon Sep 17 00:00:00 2001 From: zhoushihao <zsh19950802@163.com> Date: 星期一, 22 七月 2024 08:10:18 +0800 Subject: [PATCH] 1、大理片笼进任务问题解决,不同版图进同一笼子问题解决 2、通信字电气未收到问题解决:发送后读取plc数据,未写进去一直写 --- hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 54 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 96b7fbb..b3fb398 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 @@ -2,6 +2,7 @@ import cn.hutool.core.lang.Assert; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.github.yulichang.base.MPJBaseServiceImpl; import com.github.yulichang.wrapper.MPJLambdaWrapper; import com.mes.bigstorage.entity.BigStorageCage; @@ -202,9 +203,9 @@ temperingGlassInfoMapper.updateById(temperingGlassInfo); } if (status == 0) { - bigStorageCageDetails.setState(Const.GLASS_STATE_TAKE); - } else { bigStorageCageDetails.setState(Const.GLASS_STATE_DAMAGE); + } else { + bigStorageCageDetails.setState(Const.GLASS_STATE_TAKE); } baseMapper.updateById(bigStorageCageDetails); bigStorageCageService.updateRemainWidth(bigStorageCageDetails.getSlot()); @@ -228,10 +229,13 @@ BeanUtils.copyProperties(glassInfo, bigStorageCageDetails); bigStorageCageDetails.setState(1); bigStorageCageDetails.setGap(glassGap); + List<BigStorageCageDetails> bigStorageCageDetailsList = new ArrayList<>(); + bigStorageCageDetailsList.add(bigStorageCageDetails); + return bigStorageCageDetailsList; + } else { + return null; } - List<BigStorageCageDetails> bigStorageCageDetailsList = new ArrayList<>(); - bigStorageCageDetailsList.add(bigStorageCageDetails); - return bigStorageCageDetailsList; + } //鐞嗙墖绗艰鎯呮坊鍔� @@ -304,7 +308,7 @@ .eq(BigStorageCage::getRemainWidth, slotWidth) .eq(BigStorageCage::getEnableState, Const.SLOT_ON) .notInSql(BigStorageCage::getDeviceId, - "select distinct device_id from big_storage_cage_details where tempering_layout_id = " + glassInfo.getTemperingLayoutId()) + "select distinct device_id from big_storage_cage_details where state in (100,102,103)") .gt(BigStorageCage::getMaxThickness, glassInfo.getThickness()) .orderByAsc(BigStorageCage::getDeviceId) .last("limit 1")); @@ -344,4 +348,48 @@ public List<SlotSequenceDTO> queryGlassMaxAndMin(String engineerId, Integer temperingLayoutId) { return baseMapper.queryGlassMaxAndMin(engineerId, temperingLayoutId); } + + @Override + public boolean TemperingGlass(String temperingLayoutId, String engineerId) { + LambdaQueryWrapper<TemperingGlassInfo> temperingGlassInfoLambdaQueryWrapper = new LambdaQueryWrapper<>(); + temperingGlassInfoLambdaQueryWrapper + .eq(TemperingGlassInfo::getTemperingLayoutId, temperingLayoutId) + .eq(TemperingGlassInfo::getEngineerId, engineerId); + List<TemperingGlassInfo> temperingGlassInfoList = temperingGlassInfoMapper.selectList(temperingGlassInfoLambdaQueryWrapper); + if (temperingGlassInfoList.size() == 0) { + LambdaQueryWrapper<BigStorageCageDetails> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(BigStorageCageDetails::getTemperingLayoutId, temperingLayoutId) + .eq(BigStorageCageDetails::getEngineerId, engineerId) + .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN, Const.GLASS_STATE_ARTIFICIAL); + List<BigStorageCageDetails> bigStorageCageDetailsList = baseMapper.selectList(wrapper); + + for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList + ) { + TemperingGlassInfo temperingGlassInfo = new TemperingGlassInfo(); + LambdaQueryWrapper<GlassInfo> glassInfoLambdaQueryWrapper = new LambdaQueryWrapper<>(); + glassInfoLambdaQueryWrapper.eq(GlassInfo::getGlassId, bigStorageCageDetails.getGlassId()); + GlassInfo glassInfo = glassInfoMapper.selectOne(glassInfoLambdaQueryWrapper); + + BeanUtils.copyProperties(glassInfo, temperingGlassInfo); + temperingGlassInfo.setAngle((int) glassInfo.getAngle()); + temperingGlassInfo.setState(Const.TEMPERING_NEW); + temperingGlassInfo.setSlot(bigStorageCageDetails.getSlot()); + temperingGlassInfoMapper.insert(temperingGlassInfo); + } + return true; + } else { + return false; + } + + + } + + @Override + public List<Map<String, Object>> selectTemperingGlass() { + QueryWrapper<BigStorageCageDetails> wrapper = new QueryWrapper<>(); + wrapper.select("engineer_id,tempering_layout_id,count(*) as count") + .groupBy("engineer_id,tempering_layout_id"); + List<Map<String, Object>> TemperingGlass = baseMapper.selectMaps(wrapper); + return TemperingGlass; + } } -- Gitblit v1.8.0