From 8891898a6ae6229ede66c8005f2912c75ddc6d90 Mon Sep 17 00:00:00 2001
From: zhoushihao <zsh19950802@163.com>
Date: 星期三, 05 三月 2025 22:32:26 +0800
Subject: [PATCH] 1、fixbug:中空任务领取部分对数玻璃后继续领任务,任务显示异常bug解决 2、大理片笼/中空理片笼显示异常bug:进片任务计算目标格子后,预先将笼子插入一条记录,界面相同判断时显示存在歧义,修改数据返回逻辑:在没有目标格子前提下,如果笼内存在玻璃显示相同,有目标格子后笼内有数据不显示 3、中空理片笼进片任务优化:中空可能存在脏数据,原因人为操作或订单多补片造成中空关系订单数量与实际数据不匹配,实际数量大于订单数量,系统会重新生成一份关系造成关系进笼玻璃数据顺序存在重复而无法进笼。

---
 hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/job/OpcPlcStorageCageNewTask.java |  144 +++++++++++++++++++++++++++++++++++++----------
 1 files changed, 112 insertions(+), 32 deletions(-)

diff --git a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/job/OpcPlcStorageCageNewTask.java b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/job/OpcPlcStorageCageNewTask.java
index 4d69ac4..640cf2f 100644
--- a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/job/OpcPlcStorageCageNewTask.java
+++ b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/job/OpcPlcStorageCageNewTask.java
@@ -75,6 +75,11 @@
     @Autowired(required = false)
     MiloService miloService;
 
+    /**
+     * 鐩撮�氭牸瀛�
+     */
+    private static final Integer THROUGH_SLOT = 920;
+
     @Resource
     private RedisUtil redisUtil;
 
@@ -94,7 +99,10 @@
     private Integer temperingOutTargetPosition;
     @Value("${mes.artificialOutTargetPosition}")
     private Integer artificialOutTargetPosition;
-
+    @Value("${mes.slotMaxHeight}")
+    private Integer slotMaxHeight;
+    @Value("${mes.slotMaxthickness}")
+    private Integer slotMaxthickness;
 
     @Scheduled(fixedDelay = 1000)
     public void inBigStorageTask() throws Exception {
@@ -133,6 +141,11 @@
             return;
         }
         log.info("鑾峰彇浠诲姟鐨勭幓鐠僫d锛歿}", glassIdList);
+        ReadWriteEntity countEntity = miloService.readFromOpcUa("DLP1A.DLP1A.glassCount");
+        if (null == countEntity.getValue() || Integer.parseInt(countEntity.getValue() + "") != glassIdList.size()) {
+            log.info("褰撳墠澶ц溅杩涚墖鐜荤拑鏁伴噺{}涓巑es璇诲彇鍒扮殑鏁伴噺{}涓嶅尮閰嶏紝缁撴潫杩涚墖浠诲姟", countEntity.getValue(), glassIdList.size());
+            return;
+        }
         Map<String, Long> glassCountMap = glassIdList.stream().collect(Collectors.groupingBy(e -> e, Collectors.counting()));
         for (Map.Entry<String, Long> entry : glassCountMap.entrySet()) {
             if (entry.getValue() > 1) {
@@ -142,7 +155,7 @@
             }
         }
         List<BigStorageCageDetails> detailsList = bigStorageCageDetailsService.list(new LambdaQueryWrapper<BigStorageCageDetails>().in(BigStorageCageDetails::getGlassId, glassIdList)
-                .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN_ALL));
+                .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN_ALL_ZERO));
         if (CollectionUtil.isNotEmpty(detailsList)) {
             log.info("鐞嗙墖绗煎瓨鍦ㄧ浉鍚岀殑杩涚墖鐜荤拑{}锛岀粨鏉熸湰娆′换鍔�", detailsList);
             //todo:鍚憄lc鍙戦�佹姤璀�
@@ -155,23 +168,78 @@
             //todo:鍚憄lc鍙戦�佹姤璀�
             return;
         }
+        //鎸夌収鐜荤拑鍘氬害鍒嗙粍锛屽垽鏂墿浣欐牸瀛愭槸鍚﹀彲浠ュ瓨鏀�
+        Map<Double, Long> thickCountMap = glassInfoList.stream().collect(Collectors.groupingBy(GlassInfo::getThickness, Collectors.counting()));
+        for (Map.Entry<Double, Long> entry : thickCountMap.entrySet()) {
+            int count = bigStorageCageService.count(new LambdaQueryWrapper<BigStorageCage>()
+                    .eq(BigStorageCage::getEnableState, Const.SLOT_ON).eq(BigStorageCage::getRemainWidth, slotWidth)
+                    .le(BigStorageCage::getMinThickness, entry.getKey())
+                    .ge(BigStorageCage::getMaxThickness, entry.getKey()));
+            if (count < entry.getValue()) {
+                log.info("绗煎唴鏍煎瓙鍓╀綑鏁伴噺涓嶈冻锛岀粨鏉熸湰娆¤繘鐗�");
+                //todo:鍚憄lc鍙戦�佹姤璀�
+                return;
+            }
+        }
+        //todo:瓒呭ぇ灏哄
+        if (slotMaxHeight < Math.min(glassInfoList.get(0).getWidth(), glassInfoList.get(0).getHeight()) || glassInfoList.get(0).getThickness() > slotMaxthickness) {
+            int count = bigStorageCageDetailsService.count(new LambdaQueryWrapper<BigStorageCageDetails>()
+                    .eq(BigStorageCageDetails::getSlot, THROUGH_SLOT)
+                    .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN_ALL));
+            if (count > 0) {
+                log.info("鐩撮�氱墖鍙板瓨鍦ㄧ幓鐠冿紝缁撴潫鏈杩涚墖");
+                //todo:鍚憄lc鍙戦�佹姤璀�
+                return;
+            }
+        }
+
         //淇敼纾ㄨ竟瀵瑰垪琛ㄧ殑鐜荤拑鐘舵��
         edgGlassTaskInfoService.update(new LambdaUpdateWrapper<EdgGlassTaskInfo>()
                 .set(EdgGlassTaskInfo::getState, Const.EDG_GLASS_SUCCESS).in(EdgGlassTaskInfo::getGlassId, glassIdList));
+        //鎶ュ伐
+        for (String glass : glassIdList) {
+            damageService.autoSubmitReport(glass, inTaskList.get(0).getStartSlot(), "纾ㄨ竟", "杩涘ぇ鐞嗙墖绗�", 1);
+        }
+
         Map<String, List<GlassInfo>> glassListMap = glassInfoList.stream().collect(Collectors.groupingBy(GlassInfo::getGlassId));
         //璁$畻鐩爣鏍煎瓙
         List<BigStorageCageHistoryTask> historyTasks = new ArrayList<>();
-        for (BigStorageCageTask task : inTaskList) {
-            GlassInfo info = glassListMap.get(task.getGlassId()).get(0);
-            BigStorageDTO bigStorageDTO = bigStorageGlassInfoService.queryBigStorageTargetSlot(info.getEngineerId(), info.getTemperingLayoutId(), info.getTemperingFeedSequence());
-            //鑾峰彇鐩爣鏍煎瓙淇℃伅
+        //瓒呭ぇ灏哄涓庢甯稿昂瀵哥幓鐠冭绠楁柟寮忎笉涓�鏍�
+        if (slotMaxHeight > Math.min(glassInfoList.get(0).getWidth(), glassInfoList.get(0).getHeight())) {
+            for (BigStorageCageTask task : inTaskList) {
+                GlassInfo info = glassListMap.get(task.getGlassId()).get(0);
+                BigStorageDTO bigStorageDTO = bigStorageGlassInfoService.queryBigStorageTargetSlot(info.getEngineerId(), info.getTemperingLayoutId(), info.getTemperingFeedSequence());
+                //鑾峰彇鐩爣鏍煎瓙淇℃伅
 //            BigStorageDTO bigStorageDTO = bigStorageCageDetailsService.queryTargetSlotByTempering(info);
 //            涓存椂鏇存柊鏍煎瓙鐨勫墿浣欏昂瀵革細闃叉鐩搁偦鐜荤拑杩涘悓涓�鏍煎瓙閫犳垚鍓╀綑灏哄涓嶈冻锛岀幓鐠冭秺鐣岀殑鎯呭喌锛屼换鍔″畬鎴愬悗鍐嶆鏇存柊澶х悊鐗囩琛ㄥ墿浣欏搴︼紙鎸夌収绗煎唴鐜荤拑鏁伴噺鏇存柊澶х悊鐗囩鍓╀綑灏哄锛�
-            bigStorageCageService.update(new LambdaUpdateWrapper<BigStorageCage>()
-                    .set(BigStorageCage::getRemainWidth, bigStorageDTO.getWidth() - Math.max(info.getWidth(), info.getHeight()) - glassGap)
-                    .eq(BigStorageCage::getSlot, bigStorageDTO.getSlot()));
-            task.setTargetSlot(bigStorageDTO.getSlot());
-            task.setGlassId(info.getGlassId());
+                bigStorageCageService.update(new LambdaUpdateWrapper<BigStorageCage>()
+                        .set(BigStorageCage::getRemainWidth, bigStorageDTO.getWidth() - Math.max(info.getWidth(), info.getHeight()) - glassGap)
+                        .eq(BigStorageCage::getSlot, bigStorageDTO.getSlot()));
+                task.setTargetSlot(bigStorageDTO.getSlot());
+                task.setGlassId(info.getGlassId());
+                bigStorageCageTaskService.updateTaskMessage("big_storage_cage_in_one_task", task);
+                //瀛樻斁鍘嗗彶浠诲姟
+                BigStorageCageHistoryTask historyTask = new BigStorageCageHistoryTask();
+                BeanUtils.copyProperties(task, historyTask);
+                historyTask.setTaskType(Const.BIG_STORAGE_BEFORE_IN);
+                historyTask.setGlassCount(glassInfoList.size());
+                historyTask.setTaskState(Const.ENGINEERING_NEW);
+                historyTasks.add(historyTask);
+                BigStorageCageDetails cageDetails = new BigStorageCageDetails();
+                BeanUtils.copyProperties(info, cageDetails);
+                cageDetails.setSlot(bigStorageDTO.getSlot());
+                cageDetails.setState(Const.GLASS_STATE_NEW);
+                cageDetails.setDeviceId(bigStorageDTO.getDeviceId());
+                cageDetails.setSequence(bigStorageDTO.getSlotSequence());
+                cageDetails.setAngle((int) info.getAngle());
+                cageDetails.setGap(glassGap);
+                cageDetails.setFilmsId(info.getFilmsid());
+                cageDetails.setId(null);
+                bigStorageCageDetailsService.save(cageDetails);
+            }
+        } else {
+            BigStorageCageTask task = inTaskList.get(0);
+            task.setTargetSlot(THROUGH_SLOT);
             bigStorageCageTaskService.updateTaskMessage("big_storage_cage_in_one_task", task);
             //瀛樻斁鍘嗗彶浠诲姟
             BigStorageCageHistoryTask historyTask = new BigStorageCageHistoryTask();
@@ -180,13 +248,16 @@
             historyTask.setGlassCount(glassInfoList.size());
             historyTask.setTaskState(Const.ENGINEERING_NEW);
             historyTasks.add(historyTask);
+            GlassInfo info = glassInfoList.get(0);
             BigStorageCageDetails cageDetails = new BigStorageCageDetails();
             BeanUtils.copyProperties(info, cageDetails);
-            cageDetails.setSlot(bigStorageDTO.getSlot());
+            cageDetails.setSlot(THROUGH_SLOT);
             cageDetails.setState(Const.GLASS_STATE_NEW);
-            cageDetails.setDeviceId(bigStorageDTO.getDeviceId());
-            cageDetails.setSequence(bigStorageDTO.getSlotSequence());
+            cageDetails.setDeviceId(0);
+            cageDetails.setSequence(0);
             cageDetails.setGap(glassGap);
+            cageDetails.setAngle((int) info.getAngle());
+            cageDetails.setFilmsId(info.getFilmsid());
             cageDetails.setId(null);
             bigStorageCageDetailsService.save(cageDetails);
         }
@@ -224,22 +295,24 @@
         //鏄惁鏈夋鍦ㄩ挗鍖栫殑鐜荤拑:閽㈠寲灏忕墖琛ㄥ叧鑱斿巻鍙蹭换鍔¤〃锛岀瓫閫夋湭鍑虹鐨勭幓鐠冧俊鎭�
 //            鑾峰彇褰撳墠閽㈠寲浠诲姟鏈畬鎴愬嚭鐗囩殑鐜荤拑淇℃伅
         List<TemperingGlassInfo> unFinishTemperingGlassInfoList = temperingGlassInfoService.list(new LambdaQueryWrapper<TemperingGlassInfo>()
-                .eq(TemperingGlassInfo::getState, Const.TEMPERING_NEW).orderByAsc(TemperingGlassInfo::getTemperingFeedSequence));
+                .eq(TemperingGlassInfo::getState, Const.TEMPERING_NEW).orderByAsc(TemperingGlassInfo::getTemperingLayoutId).orderByAsc(TemperingGlassInfo::getTemperingFeedSequence));
         if (CollectionUtil.isNotEmpty(unFinishTemperingGlassInfoList)) {
-//            List<String> glassIdList = unFinishTemperingGlassInfoList.stream().map(TemperingGlassInfo::getGlassId).collect(Collectors.toList());
-//            List<BigStorageCageHistoryTask> historyTaskList = bigStorageCageHistoryTaskService.list(new LambdaQueryWrapper<BigStorageCageHistoryTask>()
-//                    .eq(BigStorageCageHistoryTask::getTaskType, Const.BIG_STORAGE_BEFORE_OUT)
-//                    .in(BigStorageCageHistoryTask::getGlassId, glassIdList));
-//            List<TemperingGlassInfo> temperingGlassList = unFinishTemperingGlassInfoList;
-//            if (CollectionUtil.isNotEmpty(historyTaskList)) {
-//                List<String> taskGlassList = historyTaskList.stream().map(BigStorageCageHistoryTask::getGlassId).collect(Collectors.toList());
-//                temperingGlassList = unFinishTemperingGlassInfoList.stream().filter(e -> !taskGlassList.contains(e.getGlassId())).collect(Collectors.toList());
-//            }
-//            if (CollectionUtil.isNotEmpty(unFinishTemperingGlassInfoList)) {
             log.info("鏈夋鍦ㄥ嚭鐗囩殑閽㈠寲浠诲姟");
             computeOutGlassInfoByVirtualSlot(unFinishTemperingGlassInfoList, "big_storage_cage_out_one_task", temperingOutTargetPosition, Const.GLASS_STATE_OUT_ING, Const.BIG_STORAGE_BEFORE_OUT);
             Date endDate = new Date();
             log.info("澶х悊鐗囩鍑虹墖浠诲姟缁撴潫鏃堕棿锛歿}锛屽叡鑰楁椂锛歿}ms,缁撴潫鎵爜浠诲姟", endDate, endDate.getTime() - startDate.getTime());
+            return;
+        }
+
+        BigStorageCageDetails details = bigStorageCageDetailsService.getOne(new LambdaQueryWrapper<BigStorageCageDetails>()
+                .eq(BigStorageCageDetails::getSlot, THROUGH_SLOT)
+                .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN_ALL).last("limit 1"));
+        if (details != null) {
+            TemperingGlassInfo temperingGlassInfo = new TemperingGlassInfo();
+            BeanUtils.copyProperties(details, temperingGlassInfo);
+            temperingGlassInfo.setState(-1);
+            temperingGlassInfoService.save(temperingGlassInfo);
+            computeOutGlassInfoByVirtualSlot(Arrays.asList(temperingGlassInfo), "big_storage_cage_out_one_task", temperingOutTargetPosition, Const.GLASS_STATE_OUT_ING, Const.BIG_STORAGE_BEFORE_OUT);
             return;
         }
 
@@ -252,9 +325,9 @@
                 for (TemperingLayoutDTO item : temperingLayoutDTOList) {
 //                    if (item.getEngineerId().equals(redisUtil.getCacheObject("temperingengineerId"))) {
                     List<TemperingGlassInfo> temperingGlassInfos = glassInfoService.selectJoinList(TemperingGlassInfo.class, JoinWrappers.lambda(GlassInfo.class)
-                            .selectAll(GlassInfo.class)
-                            .select("-1 as state")
-                            .selectAs(BigStorageCageDetails::getSlot, TemperingGlassInfo::getSlot)
+                            .select("-1 as state,t.filmsid as films_id,t.glass_id,t.flow_card_id,t.glass_type,t.width,t.height" +
+                                    ",t.thickness,t.ishorizontal,t.tempering_layout_id,t.tempering_feed_sequence,t.x_coordinate,t.y_coordinate," +
+                                    "t.angle,t1.slot,t.engineer_id")
                             .innerJoin(BigStorageCageDetails.class, BigStorageCageDetails::getGlassId, GlassInfo::getGlassId)
                             .eq(BigStorageCageDetails::getState, Const.GLASS_STATE_IN)
                             .eq(GlassInfo::getTemperingLayoutId, item.getTemperingLayoutId())
@@ -466,6 +539,10 @@
                     bigStorageCageDetailsService.updateBySlot(storageCageDTOList, Const.GLASS_STATE_OUT);
                 } else {
                     bigStorageCageDetailsService.updateBySlot(storageCageDTOList, Const.GLASS_STATE_IN);
+                    //鎸夌収鏍煎瓙淇℃伅鏇存柊瀵瑰簲鐨勮澶噄d
+                    List<Integer> slotList = storageCageDTOList.stream().map(UpdateBigStorageCageDTO::getTargetSlot).distinct().collect(Collectors.toList());
+                    bigStorageCageDetailsService.updateDeviceIdBySlot(slotList);
+
                 }
                 log.info("4銆佸ぇ鐞嗙墖绗艰繘鐗囩姸鎬佸凡瀹屾垚宸插畬鎴愮殑鐜荤拑淇℃伅id:{}", v);
                 updateSlotRemainBySlots(outSuccessGlassSlot);
@@ -518,7 +595,7 @@
             Damage damage = new Damage();
             damage.setGlassId(item.getGlassId());
             damage.setLine(item.getStartSlot());
-            damage.setWorkingProcedure("纾ㄨ竟");
+            damage.setWorkingProcedure("澶х悊鐗囩");
             damage.setRemark("杩涚鍓嶅崸杞珛");
             damage.setStatus(1);
             damage.setType(item.getTaskState());
@@ -615,9 +692,12 @@
      */
     private <T extends BigStorageCageBaseInfo> Boolean computeOutGlassInfoByVirtualSlot(List<T> list, String tableName, int targetSlot, int state, int taskType) {
         //浠诲姟鏁版嵁:鑾峰彇杞﹀瓙瀛樻斁鐜荤拑鏈�澶ф暟閲�,鐜荤拑闂撮殧
-        List<String> glassIdList = bigStorageGlassRelationInfoService.queryNeedOutGlassId(
-                list.get(0).getEngineerId(), list.get(0).getTemperingLayoutId(), list.get(0).getTemperingFeedSequence());
-        List<T> outGlassList = list.stream().filter(e -> glassIdList.contains(e.getGlassId())).collect(Collectors.toList());
+        List<T> outGlassList = list;
+        if (!THROUGH_SLOT.equals(list.get(0).getSlot())) {
+            List<String> glassIdList = bigStorageGlassRelationInfoService.queryNeedOutGlassId(
+                    list.get(0).getEngineerId(), list.get(0).getTemperingLayoutId(), list.get(0).getTemperingFeedSequence());
+            outGlassList = list.stream().filter(e -> glassIdList.contains(e.getGlassId())).collect(Collectors.toList());
+        }
         Assert.isFalse(CollectionUtil.isEmpty(outGlassList), "鏈幏鍙栧嚭鐗囨暟鎹紝缁撴潫鍑虹墖浠诲姟");
         log.info("鑾峰彇鍑虹墖浠诲姟鏁版嵁{}鏉★紝鎵ц淇濆瓨", outGlassList.size());
         List<BigStorageCageTask> bigStorageCageTaskList = outGlassList.stream()

--
Gitblit v1.8.0