From 2935442d9bdb795fecaa704d3bce2f6249b208d4 Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期三, 25 十二月 2024 16:12:48 +0800
Subject: [PATCH] Merge branch 'master' of http://bore.pub:10439/r/HangZhouMes

---
 hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java |   84 +++++++++++++++++++++++++++++++++++++-----
 1 files changed, 74 insertions(+), 10 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 3340ea3..2200bae 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,10 +2,12 @@
 
 import cn.hutool.core.lang.Assert;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
 import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
 import com.github.yulichang.base.MPJBaseServiceImpl;
 import com.github.yulichang.toolkit.JoinWrappers;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
+import com.mes.base.entity.BigStorageCageBaseInfo;
 import com.mes.bigstorage.entity.BigStorageCage;
 import com.mes.bigstorage.entity.BigStorageCageDetails;
 import com.mes.bigstorage.entity.BigStorageDTO;
@@ -19,6 +21,7 @@
 import com.mes.bigstoragetask.entity.UpdateBigStorageCageDTO;
 import com.mes.bigstoragetask.mapper.BigStorageCageFeedTaskMapper;
 import com.mes.bigstoragetask.mapper.BigStorageCageOutTaskMapper;
+import com.mes.bigstoragetask.service.BigStorageCageOutTaskService;
 import com.mes.common.config.Const;
 import com.mes.damage.entity.Damage;
 import com.mes.damage.service.DamageService;
@@ -36,10 +39,7 @@
 import org.springframework.stereotype.Service;
 
 import javax.annotation.Resource;
-import java.util.ArrayList;
-import java.util.Iterator;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
 import java.util.stream.Collectors;
 
 /**
@@ -78,6 +78,10 @@
     private DamageService damageService;
     @Resource
     private RedisUtil redisUtil;
+    @Resource
+    private BigStorageCageOutTaskService bigStorageCageOutTaskService;
+    @Resource
+    private BigStorageCageDetailsService bigStorageCageDetailsService;
 
     @Value("${mes.minCount}")
     private int minCount;
@@ -121,7 +125,8 @@
         outWrapper.in(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT_ING, Const.GLASS_STATE_SCHEDULE_ING);
         List<BigStorageCageDetails> bigStorageCageDetailsList = baseMapper.selectList(outWrapper);
         LambdaQueryWrapper<BigStorageCageOutTask> outTaskWrapper = new LambdaQueryWrapper<>();
-        outTaskWrapper.lt(BigStorageCageOutTask::getTaskState, Const.BIG_STORAGE_OUT_SUCCESS);
+        outTaskWrapper.lt(BigStorageCageOutTask::getTaskState, Const.BIG_STORAGE_OUT_SUCCESS)
+                .orderByAsc(BigStorageCageOutTask::getId);
         List<BigStorageCageOutTask> bigStorageCageOutTaskList = bigStorageCageOutTaskMapper.selectList(outTaskWrapper);
 
         Map<String, BigStorageCageOutTask> listMap = bigStorageCageOutTaskList.stream()
@@ -272,9 +277,9 @@
                 new LambdaQueryWrapper<GlassInfo>()
                         .eq(GlassInfo::getEngineerId, glassInfo.getEngineerId())
                         .eq(GlassInfo::getTemperingLayoutId, glassInfo.getTemperingLayoutId())
-                        .eq(GlassInfo::getSlot, glassInfo.getSlot())
+                        .eq(GlassInfo::getTargetSlot, glassInfo.getTargetSlot())
         );
-        List<String> glassIds = glassInfoList.stream().map(String::valueOf).collect(Collectors.toList());
+        List<String> glassIds = glassInfoList.stream().map(GlassInfo::getGlassId).collect(Collectors.toList());
         BigStorageDTO bigStorageDTO = null;
         MPJLambdaWrapper<BigStorageCage> wrapper = new MPJLambdaWrapper<>(BigStorageCage.class)
                 .selectAll(BigStorageCage.class)
@@ -284,6 +289,7 @@
                 .eq(BigStorageCageDetails::getEngineerId, glassInfo.getEngineerId())
                 .eq(BigStorageCageDetails::getTemperingLayoutId, glassInfo.getTemperingLayoutId())
                 .gt(BigStorageCage::getRemainWidth, Math.max(glassInfo.getWidth(), glassInfo.getHeight()))
+                .lt(BigStorageCage::getSlotHeight, Math.min(glassInfo.getWidth(), glassInfo.getHeight()))
                 .in(BigStorageCageDetails::getGlassId, glassIds)
                 .last("limit 1");
         if (glassInfo.getTemperingLayoutId() == 0) {
@@ -305,9 +311,10 @@
         bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
                 .eq(BigStorageCage::getEnableState, Const.SLOT_ON)
                 .eq(BigStorageCage::getRemainWidth, slotWidth)
+                .lt(BigStorageCage::getSlotHeight, Math.min(glassInfo.getWidth(), glassInfo.getHeight()))
 //                .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())
+                        "select distinct device_id from big_storage_cage_details where state!=101 and engineer_id = '" + glassInfo.getEngineerId() + "' and tempering_layout_id = " + glassInfo.getTemperingLayoutId())
                 .last("limit 1"));
         if (null != bigStorageCage) {
             log.info("鏍规嵁鐗堝浘id鎵惧埌绗煎瓙鍐呯殑鐩爣鏍煎瓙锛歿},鐜荤拑id锛歿}", bigStorageCage.getSlot(), glassInfo.getGlassId());
@@ -319,8 +326,8 @@
         }
 
         //鑾峰彇鐜荤拑鐨勫帤搴︼細閲嶆柊閫夌瀛愰渶瑕佹寜鐓х瀛愬彲鏀剧幓鐠冨帤搴﹁繘琛岄�夋嫨 鍥犱负瀛愭煡璇㈡帓搴忓涓籹ql鏃犲奖鍝嶏紝鎵�浠ュ厛鎵ц瀛愭煡璇㈣幏鍙栭『搴忥紝鐒跺悗涓�娆″幓鏌ヨ
-        List<Integer> deviceUsedList = bigStorageCageService.queryFreeDeviceByUsed(glassInfo.getThickness());
-        List<Integer> deviceUseds = bigStorageCageService.queryFreeDeviceByUsed(glassInfo.getThickness());
+        List<Integer> deviceUsedList = bigStorageCageService.queryFreeDeviceByUsed(glassInfo.getThickness(),Math.min(glassInfo.getWidth(),glassInfo.getHeight()));
+        List<Integer> deviceUseds = bigStorageCageService.queryFreeDeviceByUsed(glassInfo.getThickness(),Math.min(glassInfo.getWidth(),glassInfo.getHeight()));
         List<BigStorageCageDetails> engineerCount1 = baseMapper.selectList(
                 new LambdaQueryWrapper<BigStorageCageDetails>()
                         .notIn(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT, Const.GLASS_STATE_DAMAGE, Const.GLASS_STATE_TAKE)
@@ -362,6 +369,7 @@
         if (CollectionUtils.isEmpty(deviceUsedList)) {
             deviceUsedList = deviceUseds;
         }
+
         for (Integer item : deviceUsedList) {
             bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
                     .eq(BigStorageCage::getRemainWidth, slotWidth)
@@ -467,4 +475,60 @@
     public void appointEngineerId(String engineerId) {
         redisUtil.setCacheObject("temperingengineerId", engineerId);
     }
+
+    @Override
+    public long scheduleTime() {
+        //鎵ц鍐呴儴璋冨害浠诲姟
+        List<TemperingLayoutDTO> temperingOccupySlotList = bigStorageCageDetailsService.queryTemperingOccupySlot();
+        List<BigStorageCageOutTask> bigStorageCageOutTasks = new ArrayList<>();
+        if (CollectionUtils.isNotEmpty(temperingOccupySlotList)) {
+            for (TemperingLayoutDTO temperingOccupySlot : temperingOccupySlotList) {
+                List<GlassInfo> glassInfos = glassInfoService.list(
+                        new LambdaQueryWrapper<GlassInfo>()
+                                .eq(GlassInfo::getEngineerId, temperingOccupySlot.getEngineerId())
+                                .eq(GlassInfo::getTemperingLayoutId, temperingOccupySlot.getTemperingLayoutId())
+                                .notInSql(GlassInfo::getGlassId, "select glass_id from damage where type=8 and engineer_id='"
+                                        + temperingOccupySlot.getEngineerId() + "' and tempering_layout_id = '" + temperingOccupySlot.getTemperingLayoutId() + "'")
+                                .orderBy(Boolean.TRUE, sequenceOrder, GlassInfo::getTemperingFeedSequence)
+                );
+                Map<Integer, List<GlassInfo>> listMap = glassInfos.stream().collect(Collectors.groupingBy(item -> item.getTargetSlot()));
+                for (Map.Entry<Integer, List<GlassInfo>> entry : listMap.entrySet()) {
+                    List<GlassInfo> valueList = entry.getValue();
+                    List<String> glassIds = valueList.stream().map(GlassInfo::getGlassId).collect(Collectors.toList());
+                    List<BigStorageCageDetails> bigStorageCageDetailsList = bigStorageCageDetailsService.list(
+                            new LambdaQueryWrapper<BigStorageCageDetails>()
+                                    .in(BigStorageCageDetails::getGlassId, glassIds)
+                                    .eq(BigStorageCageDetails::getState, Const.GLASS_STATE_IN)
+                                    .orderBy(Boolean.TRUE, sequenceOrder, BigStorageCageDetails::getTemperingFeedSequence)
+                    );
+                    //褰撲竴鏍肩幓鐠冮兘鍒伴綈鏃�
+                    if (bigStorageCageDetailsList.size() == valueList.size()) {
+                        long distinctSlotCount = bigStorageCageDetailsList.stream()
+                                .map(BigStorageCageDetails::getSlot)
+                                .distinct()
+                                .count();
+                        //褰撶幓鐠冧笉鍦ㄥ悓涓�鏍兼椂
+                        if (distinctSlotCount > 1) {
+                            BigStorageCageDetails maxSequenceDetail = bigStorageCageDetailsList.stream()
+                                    .max(Comparator.comparingInt(BigStorageCageDetails::getTemperingFeedSequence))
+                                    .orElse(null);  // 濡傛灉娌℃湁鍏冪礌锛岃繑鍥� null
+                            int maxSlot = maxSequenceDetail.getSlot();
+                            int serialNumber = 1;
+                            for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList
+                            ) {
+                                if (bigStorageCageDetails.getSlot() != maxSlot) {
+                                    bigStorageCageOutTasks.add(new BigStorageCageOutTask(bigStorageCageDetails.getGlassId(), bigStorageCageDetails.getSlot(), maxSlot,
+                                            bigStorageCageDetails.getWidth() * 10, bigStorageCageDetails.getHeight() * 10, 1, serialNumber++, Const.BIG_STORAGE_OUT_NEW, new Date()));
+                                }
+                            }
+                        }
+                    }
+                }
+            }
+        }
+        long startSlotCount = bigStorageCageOutTasks.stream().map(BigStorageCageOutTask::getStartSlot).distinct().count();
+        long endSlotCount = bigStorageCageOutTasks.stream().map(BigStorageCageOutTask::getEndSlot).distinct().count();
+        long time = (startSlotCount * 20 + endSlotCount * 20) / 60;
+        return time;
+    }
 }

--
Gitblit v1.8.0