From 1717a12c83db01e3b31ea9ed913e5bacaf9edbf3 Mon Sep 17 00:00:00 2001
From: hdy <1105738590@qq.com>
Date: 星期六, 29 三月 2025 14:24:06 +0800
Subject: [PATCH] 修改

---
 billion-main/src/main/java/com/billion/main/plcServer/sub/OPCUaSubscription.java |  158 ++++++++++++++++++++++++++++------------------------
 1 files changed, 84 insertions(+), 74 deletions(-)

diff --git a/billion-main/src/main/java/com/billion/main/plcServer/sub/OPCUaSubscription.java b/billion-main/src/main/java/com/billion/main/plcServer/sub/OPCUaSubscription.java
index 0594533..e92c791 100644
--- a/billion-main/src/main/java/com/billion/main/plcServer/sub/OPCUaSubscription.java
+++ b/billion-main/src/main/java/com/billion/main/plcServer/sub/OPCUaSubscription.java
@@ -25,6 +25,7 @@
 import com.kangaroohy.milo.runner.subscription.SubscriptionCallback;
 import com.kangaroohy.milo.service.MiloService;
 import lombok.extern.slf4j.Slf4j;
+import org.eclipse.milo.opcua.sdk.client.nodes.UaNode;
 import org.springframework.stereotype.Component;
 
 import java.text.SimpleDateFormat;
@@ -47,7 +48,6 @@
     public IDaCollectionParamConfService daCollectionParamConfService;
     public IDaMaterialCollectionService daMaterialCollectionService;
     public ISysCountService sysCountService;
-
     public IBsLineInfoService bsLineInfoService;
 
 
@@ -101,14 +101,14 @@
                 if (Constants.ZERO.equals(valueString)){
                     miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".RecordDataDone").value(0).build());
                 //璇锋眰杩涚珯
-                } else if (Constants.ONE.equals(valueString)){
+                }  if (Constants.ONE.equals(valueString)){
                     //1.1//棣栧伐绔�
                     if(Constants.ONLINE.contains(device)){
                         miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".RecordDataDone").value(11).build());
                     }
                     //1.2//闄ら宸ョ珯鎵�鏈夊伐绔�
                     else if(
-                            Constants.TEST.contains(device) ||
+//                            Constants.TEST.contains(device) ||
                             Constants.PLC1.contains(device) ||
                             Constants.PLC2.contains(device) ||
                             Constants.PLC3.contains(device) ||
@@ -132,42 +132,45 @@
                                     miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".SerialNumber").value(SerialNumber).build());
                                 }
                                 //9L鍙戝姩鏈烘秱鑳惰建杩逛笅鍙�
-                                else if(Constants.OP080.equals(device) && Constants.PLC_4.equals(thoroughfare)){
-                                    // 1. 鍒濆鍖栧伐鍗曞璞″苟鏌ヨ宸ュ崟淇℃伅
-                                    String workOrderNo = resultList.get(0).getWorkOrderNo();
-                                    OmProductionOrderInfo queryOrder = new OmProductionOrderInfo();
-                                    queryOrder.setWorkOrderNo(workOrderNo);
-                                    List<OmProductionOrderInfo> orderList = omProductionOrderInfoService.selectOmProductionOrderInfoList(queryOrder);
-                                    // 2. 鍒ゆ柇绫诲瀷鍒嗘敮閫昏緫
-                                    String engineName = orderList.get(0).getEngineName();
-                                    if (!"9L".equals(engineName)) {
-                                        // 闈�9L鐩存帴鍐�0
-                                        miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".GlueType").value(0).build());
-                                    } else {
-                                        // 3. 鏌ヨ浜х嚎閰嶇疆鐨勪袱鏉¢缃暟鎹�
-                                        BsLineInfo lineQuery = new BsLineInfo();
-                                        lineQuery.setLineCode(engineName);  // 鍋囪閫氳繃lineCode=9L鑾峰彇涓ゆ潯鏁版嵁
-                                        List<BsLineInfo> configuredLines = bsLineInfoService.selectBsLineInfoList(lineQuery);
-                                            // 绗竴鏉¢厤缃暟鎹殑鏍¢獙
-                                            BsLineInfo firstLine = configuredLines.get(0);
-                                            BsBomChildInfo checkFirst  = new BsBomChildInfo();
-                                            checkFirst.setMaterialCode(firstLine.getLineName());
-                                            checkFirst.setBomCode(workOrderNo);
-                                            List<BsBomChildInfo> firstCheckList = bsBomChildInfoService.selectBsBomChildInfoList(checkFirst);
-                                            if (firstCheckList.size() == 1) {
-                                                miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".GlueType").value(1).build());
-                                            } else {
-                                                // 绗簩鏉¢厤缃暟鎹殑鏍¢獙
-                                                BsLineInfo secondLine = configuredLines.get(1);
-                                                BsBomChildInfo checkSecond  = new BsBomChildInfo();
-                                                checkSecond.setMaterialCode(secondLine.getLineName());
-                                                checkSecond.setBomCode(workOrderNo);
-                                                List<BsBomChildInfo> secondCheckList = bsBomChildInfoService.selectBsBomChildInfoList(checkSecond);
-                                                if (secondCheckList.size() == 1) {
-                                                    miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".GlueType").value(2).build());
-                                                }
-                                            }
-                                    }
+                                 if(Constants.OP080.equals(device) ){
+                                     if(Constants.PLC_4.equals(thoroughfare)){
+                                         // 1. 鍒濆鍖栧伐鍗曞璞″苟鏌ヨ宸ュ崟淇℃伅
+                                         String workOrderNo = resultList.get(0).getWorkOrderNo();
+                                         OmProductionOrderInfo queryOrder = new OmProductionOrderInfo();
+                                         queryOrder.setWorkOrderNo(workOrderNo);
+                                         List<OmProductionOrderInfo> orderList = omProductionOrderInfoService.selectOmProductionOrderInfoList(queryOrder);
+                                         // 2. 鍒ゆ柇绫诲瀷鍒嗘敮閫昏緫
+                                         String engineName = orderList.get(0).getEngineName();
+                                         if (!"9L".equals(engineName)) {
+                                             // 闈�9L鐩存帴鍐�0
+                                             miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".GlueType").value(0).build());
+                                         } else {
+                                             // 3. 鏌ヨ浜х嚎閰嶇疆鐨勪袱鏉¢缃暟鎹�
+                                             BsLineInfo lineQuery = new BsLineInfo();
+                                             lineQuery.setLineCode(engineName);  // 鍋囪閫氳繃lineCode=9L鑾峰彇涓ゆ潯鏁版嵁
+                                             List<BsLineInfo> configuredLines = bsLineInfoService.selectBsLineInfoList(lineQuery);
+                                             // 绗竴鏉¢厤缃暟鎹殑鏍¢獙
+                                             BsLineInfo firstLine = configuredLines.get(0);
+                                             BsBomChildInfo checkFirst  = new BsBomChildInfo();
+                                             checkFirst.setMaterialCode(firstLine.getLineName());
+                                             checkFirst.setBomCode(workOrderNo);
+                                             List<BsBomChildInfo> firstCheckList = bsBomChildInfoService.selectBsBomChildInfoList(checkFirst);
+                                             if (firstCheckList.size() == 1) {
+                                                 miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".GlueType").value(1).build());
+                                             } else {
+                                                 // 绗簩鏉¢厤缃暟鎹殑鏍¢獙
+                                                 BsLineInfo secondLine = configuredLines.get(1);
+                                                 BsBomChildInfo checkSecond  = new BsBomChildInfo();
+                                                 checkSecond.setMaterialCode(secondLine.getLineName());
+                                                 checkSecond.setBomCode(workOrderNo);
+                                                 List<BsBomChildInfo> secondCheckList = bsBomChildInfoService.selectBsBomChildInfoList(checkSecond);
+                                                 if (secondCheckList.size() == 1) {
+                                                     miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".GlueType").value(2).build());
+                                                 }
+                                             }
+                                         }
+                                     }
+
                                 }
                                 String getWorkOrderNo = resultList.get(0).getWorkOrderNo();
                                 BsBomChildInfo bsbomChildInfo= new BsBomChildInfo();
@@ -183,7 +186,7 @@
                         }
                     }
                 //鍑虹珯淇濆瓨鏁版嵁
-                } else if (Constants.TWO.equals(valueString)) {
+                } if (Constants.TWO.equals(valueString)) {
                     OmProductionOrderInfo omProductionOrderInfo = new OmProductionOrderInfo();
                     OmOrderScheduling omOrderScheduling = new OmOrderScheduling();
                     Object SFCCode = miloService.readFromOpcUa(thoroughfare + "." + device + ".SFCCode").getValue();
@@ -282,12 +285,13 @@
                         if (Objects.equals(nowQty, getPreOrder2.getPlanQty().toString())){
                             omProductionOrderInfoService.updatePreStatus2();
                         }
-                    }else if (Constants.OP020.equals(device)){
+                    }
+                    else if (Constants.OP020.equals(device)){
                         final SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                         // 閬嶅巻 MaterialCode35 鍒� MaterialCode40 鍏�6缁勬暟鎹�
                         for (int i = 35; i <= 40; i++) {  // 淇敼寰幆鑼冨洿
                                 // 鏋勫缓OPC UA鑺傜偣鍦板潃锛堜緥濡傦細PLC1.OP020.MaterialCode35锛�
-                                String nodeId = "PLC1." + device + ".MaterialCode" + i;
+                                String nodeId = "PLC2." + device + ".MaterialCode" + i;
                                 // 鍒涘缓閲囬泦瀵硅薄
                                 DaMaterialCollection materialCollection = new DaMaterialCollection();
                                 materialCollection.setSfcCode(SFCCode.toString());
@@ -297,22 +301,22 @@
                                 materialCollection.setParamName("娲诲" + pistonNumber);
                                 // 閫氳繃OPC UA璇诲彇鍙傛暟鍊�
                                 ReadWriteEntity dataRead = miloService.readFromOpcUa(nodeId);
-                                if (dataRead != null && dataRead.getValue() != null) {
+                                if (dataRead != null && dataRead.getValue() != null && !Objects.equals(dataRead.getValue(), "                                                  ")) {
                                     materialCollection.setParamValue(dataRead.getValue().toString());
+                                    Date collectTime = new Date();
+                                    ReadWriteEntity collectTimeRead = miloService.readFromOpcUa(thoroughfare + "." + device + ".StopTime");//杩涚珯鏃堕棿
+                                    collectTime = format.parse(TimeUtil.test(TimeUtil.stringProcessing(collectTimeRead.getValue().toString())));
+                                    materialCollection.setCollectTime( collectTime);
+                                    // 鎻掑叆鏁版嵁搴�
+                                    daMaterialCollectionService.plusSave(materialCollection);
                                 } else {
-                                    materialCollection.setParamValue("N/A");  // 澶勭悊绌哄�兼儏鍐�
+                                    log.info("娲诲鍙蜂负绌�: {}",materialCollection.getParamName() );
                                 }
-                                Date collectTime = new Date();
-                                ReadWriteEntity collectTimeRead = miloService.readFromOpcUa(thoroughfare + "." + device + ".StopTime");//杩涚珯鏃堕棿
-                                collectTime = format.parse(TimeUtil.test(TimeUtil.stringProcessing(collectTimeRead.getValue().toString())));
-                                materialCollection.setCollectTime( collectTime);
-                                // 鎻掑叆鏁版嵁搴�
-                                daMaterialCollectionService.insertDaMaterialCollection(materialCollection);
                         }
                     }else if (Constants.OP130.equals(device)){
                         final SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                         // 閬嶅巻 MaterialCode35 鍒� MaterialCode40 鍏�6缁勬暟鎹�
-                            String nodeId = "PLC1." + device + ".MaterialCode35" ;
+                            String nodeId = "PLC3." + device + ".MaterialCode35" ;
                             // 鍒涘缓閲囬泦瀵硅薄
                             DaMaterialCollection materialCollection = new DaMaterialCollection();
                             materialCollection.setSfcCode(SFCCode.toString());
@@ -320,17 +324,17 @@
                             materialCollection.setParamName("缂哥洊鐮�");
                             // 閫氳繃OPC UA璇诲彇鍙傛暟鍊�
                             ReadWriteEntity dataRead = miloService.readFromOpcUa(nodeId);
-                            if (dataRead != null && dataRead.getValue() != null) {
+                            if (dataRead != null && dataRead.getValue() != null && !Objects.equals(dataRead.getValue(), "                                                  ")) {
                                 materialCollection.setParamValue(dataRead.getValue().toString());
+                                Date collectTime = new Date();
+                                ReadWriteEntity collectTimeRead = miloService.readFromOpcUa(thoroughfare + "." + device + ".StopTime");//杩涚珯鏃堕棿
+                                collectTime = format.parse(TimeUtil.test(TimeUtil.stringProcessing(collectTimeRead.getValue().toString())));
+                                materialCollection.setCollectTime( collectTime);
+                                // 鎻掑叆鏁版嵁搴�
+                                daMaterialCollectionService.plusSave(materialCollection);
                             } else {
-                                materialCollection.setParamValue("N/A");  // 澶勭悊绌哄�兼儏鍐�
+                                log.info("缂哥洊鐮佷负绌�: {}",materialCollection.getParamName() );
                             }
-                            Date collectTime = new Date();
-                            ReadWriteEntity collectTimeRead = miloService.readFromOpcUa(thoroughfare + "." + device + ".StopTime");//杩涚珯鏃堕棿
-                            collectTime = format.parse(TimeUtil.test(TimeUtil.stringProcessing(collectTimeRead.getValue().toString())));
-                            materialCollection.setCollectTime( collectTime);
-                            // 鎻掑叆鏁版嵁搴�
-                            daMaterialCollectionService.insertDaMaterialCollection(materialCollection);
                     }
                     //鍑虹珯淇濆瓨
                     DaStationCollection daStationCollection = new DaStationCollection();
@@ -363,6 +367,7 @@
                                 valueObj = value.toString();  // 鏈�缁堣祴鍊�
                                 if (!Objects.equals(valueObj, "                                                  ")) {
                                     DaMaterialCollection materialCollection = new DaMaterialCollection();
+
                                     materialCollection.setSfcCode(SFCCode.toString());
                                     materialCollection.setLocationCode(device);
                                     materialCollection.setParamName(conf.getParameterSetName());
@@ -386,22 +391,27 @@
                     List<DaCollectionParamConf> daCollectionParamConfList2 = daCollectionParamConfService.selectDaCollectionParamConfList(daCollectionParamConf2);
                     for (DaCollectionParamConf conf : daCollectionParamConfList2) {
                         String gatherAddress = conf.getGatherAddress();
-                        String valueObj = miloService.readFromOpcUa(gatherAddress).getValue().toString(); // 鑾峰彇鍘熷鍊煎璞♀��:ml-citation{ref="4" data="citationList"}
-                        if (!Objects.equals(valueObj, "0.0") && !Objects.equals(valueObj, "0")) {
-                            DaParamCollection paramCollection = new DaParamCollection();
-                            paramCollection.setSfcCode(SFCCode.toString());
-                            paramCollection.setLocationCode(device);
-                            paramCollection.setParamName(conf.getParameterSetName());
-                            paramCollection.setParamValue(miloService.readFromOpcUa(gatherAddress).getValue().toString());
-                            Date Time = new Date();
-                            ReadWriteEntity TimeRead = miloService.readFromOpcUa(thoroughfare + "." + device + ".StopTime");
-                            Time = format.parse(TimeUtil.test(TimeUtil.stringProcessing(TimeRead.getValue().toString())));
-                            paramCollection.setCollectTime(Time);
-                            daParamCollectionService.insertDaParamCollection(paramCollection);
+                        try{
+                            Object valueObj = miloService.readFromOpcUa(gatherAddress).getValue(); // 鑾峰彇鍘熷鍊煎璞♀��:ml-citation{ref="4" data="citationList"}
+                            if (!Objects.equals(valueObj, "0.0") && !Objects.equals(valueObj, "0") && valueObj != null  ) {
+                                DaParamCollection paramCollection = new DaParamCollection();
+                                paramCollection.setSfcCode(SFCCode.toString());
+                                paramCollection.setLocationCode(device);
+                                paramCollection.setParamName(conf.getParameterSetName());
+                                paramCollection.setParamValue(miloService.readFromOpcUa(gatherAddress).getValue().toString());
+                                Date Time = new Date();
+                                ReadWriteEntity TimeRead = miloService.readFromOpcUa(thoroughfare + "." + device + ".StopTime");
+                                Time = format.parse(TimeUtil.test(TimeUtil.stringProcessing(TimeRead.getValue().toString())));
+                                paramCollection.setCollectTime(Time);
+                                daParamCollectionService.insertDaParamCollection(paramCollection);
+                            }
+                            else {
+                                log.info("閲囬泦椤逛负绌�: {}", gatherAddress);
+                            }
+                        }catch (Exception e){
+                            log.error(e.getMessage());
                         }
-                        else {
-                            log.info("閲囬泦椤逛负绌�: {}", gatherAddress);
-                        }
+
                     }
                 }
             }

--
Gitblit v1.9.3