From 63b2548414682dd0127f0bffe3313ea465046957 Mon Sep 17 00:00:00 2001
From: 懒羊羊 <15939171744@163.com>
Date: 星期一, 15 四月 2024 14:06:43 +0800
Subject: [PATCH] -

---
 jcdm-main/src/main/java/com/jcdm/main/plcserver/sub/OPCUaSubscription.java |  223 +++++++++++++++++++++++++++++++++++++++++--------------
 1 files changed, 167 insertions(+), 56 deletions(-)

diff --git a/jcdm-main/src/main/java/com/jcdm/main/plcserver/sub/OPCUaSubscription.java b/jcdm-main/src/main/java/com/jcdm/main/plcserver/sub/OPCUaSubscription.java
index b3f749a..411e780 100644
--- a/jcdm-main/src/main/java/com/jcdm/main/plcserver/sub/OPCUaSubscription.java
+++ b/jcdm-main/src/main/java/com/jcdm/main/plcserver/sub/OPCUaSubscription.java
@@ -1,6 +1,9 @@
 package com.jcdm.main.plcserver.sub;
 
 
+import cn.hutool.core.date.DateUtil;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.jcdm.framework.websocket.WebSocketUsers;
 import com.jcdm.main.da.collectionParamConf.domain.DaCollectionParamConf;
 import com.jcdm.main.da.collectionParamConf.service.IDaCollectionParamConfService;
@@ -9,6 +12,7 @@
 import com.jcdm.main.da.passingStationCollection.domain.DaPassingStationCollection;
 import com.jcdm.main.da.passingStationCollection.service.IDaPassingStationCollectionService;
 import com.jcdm.main.plcserver.conf.OPCElement;
+import com.jcdm.main.plcserver.util.TimeUtil;
 import com.kangaroohy.milo.model.ReadWriteEntity;
 import com.kangaroohy.milo.runner.subscription.SubscriptionCallback;
 import com.kangaroohy.milo.service.MiloService;
@@ -16,15 +20,23 @@
 import org.springframework.stereotype.Component;
 
 import javax.websocket.Session;
-import java.util.ArrayList;
-import java.util.Date;
-import java.util.List;
-import java.util.Map;
+import java.text.SimpleDateFormat;
+import java.util.*;
 import java.util.stream.Collectors;
 
 
 @Component
 public class OPCUaSubscription implements SubscriptionCallback {
+
+    //鑷姩宸ヤ綅
+    public List<String> automaticList = Arrays.asList("OP300","OP280", "OP320", "OP340", "OP350", "OP360","OP370", "OP390", "OP470", "OP530", "OP540");
+
+    //閲囬泦妯$粍宸ヤ綅
+    public List<String> moduleCodeList = Arrays.asList("OP300","OP310", "OP320", "OP340", "OP350", "OP330");
+
+    //绌虹殑
+    public List<String> nullList = Arrays.asList("OP250","OP260");
+
 
     public static MiloService miloService;
 
@@ -32,9 +44,9 @@
 
     public IDaPassingStationCollectionService daPassingStationCollectionService;
 
-    public IDaCollectionParamConfService collectionParamConfService;
+    public static IDaCollectionParamConfService collectionParamConfService;
 
-    public IDaParamCollectionService daParamCollectionService;
+    public static IDaParamCollectionService daParamCollectionService;
 
     public OPCUaSubscription(MiloService miloService,
                              IDaPassingStationCollectionService daPassingStationCollectionService,
@@ -42,8 +54,8 @@
                              IDaParamCollectionService daParamCollectionService) {
         OPCUaSubscription.miloService = miloService;
         this.daPassingStationCollectionService = daPassingStationCollectionService;
-        this.collectionParamConfService = collectionParamConfService;
-        this.daParamCollectionService = daParamCollectionService;
+        OPCUaSubscription.collectionParamConfService = collectionParamConfService;
+        OPCUaSubscription.daParamCollectionService = daParamCollectionService;
 
     }
 
@@ -77,49 +89,59 @@
 
                     if("1".equals(tabVlaue)){
                         recordDataDoneValue = "11";
+                        //鏍¢獙鍏ョ珯鏄惁鍙互宸ヤ綔
 
+                        //plc缁欐垜浠竴涓猵ack鐮侊紝鎷縫ack鐮佹牎楠屽嚭鍨嬪彿
+                        if(moduleCodeList.stream().anyMatch(s -> s.equals(device))){
+                            //璇绘ā缁勭爜
+                            String moduleCode = miloService.readFromOpcUa(thoroughfare + "." + device + ".ModuleCode").getValue().toString();
+                            String productTye = thoroughfare + "." + device + ".ProductType";
+                            miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(productTye).value(Integer.valueOf(moduleCode.substring(7,8))).build());
+                        }
                         //杩涚珯淇濆瓨鏁版嵁
 //                        inSaveDate(thoroughfare,device)
                         //璁板綍鏁版嵁瀹屾垚
                         String RecordDataDoneAddress = thoroughfare + "." + device + ".RecordDataDone";
-                        miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(RecordDataDoneAddress).value(recordDataDoneValue).build());
 
-                        //缁欏墠绔彂宸ヤ欢鍒颁綅淇″彿
+                        miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(RecordDataDoneAddress).value(11).build());
 
+                        if(automaticList.stream().noneMatch(s -> s.equals(device))){
+                            //缁欏墠绔彂宸ヤ欢鍒颁綅淇″彿
+                            WebSocketUsers.sendMessageToUserByText(map.get(device), "IN");
+                        }
                         //璇锋眰宸ュ崟
 
-
-
-
                     }else if("2".equals(tabVlaue)){
+                        if(automaticList.stream().anyMatch(s -> s.equals(device))){
+                            //鑷姩宸ヤ綅
+                            //鍑虹珯淇濆瓨鏁版嵁
+                            recordDataDoneValue = outSaveDate(thoroughfare,device);
+                            //璁板綍鏁版嵁瀹屾垚
+                            String RecordDataDoneAddress = thoroughfare + "." + device + ".RecordDataDone";
+                            miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(RecordDataDoneAddress).value(Integer.valueOf(RecordDataDoneAddress)).build());
+                        }else {
+                            //鎵嬪姩宸ヤ綅
+                            WebSocketUsers.sendMessageToUserByText(map.get(device), "END");
+                        }
+                    }else {
+                        System.out.println("^");
+                    }
+                }
+                //淇濆瓨鎷х揣鏁版嵁
+                else if (("AngleResult").equals(tab)) {
+                    if("1".equals(tabVlaue)||"2".equals(tabVlaue)){
+                        List<String> list = new ArrayList<>();
+                        String[] suffixes = {"Torque", "Angle", "TorqueResult", "AngleResult"};
 
-                        //鍑虹珯淇濆瓨鏁版嵁
-                        recordDataDoneValue = outSaveDate(thoroughfare,device);
-                        //璁板綍鏁版嵁瀹屾垚
-                        String RecordDataDoneAddress = thoroughfare + "." + device + ".RecordDataDone";
-                        miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(RecordDataDoneAddress).value(recordDataDoneValue).build());
-                    }else if("3".equals(tabVlaue)){
-                        String Torque = thoroughfare + "." + device + ".Torque";
-                        String Angle = thoroughfare + "." + device + ".Angle";
-                        String Result = thoroughfare + "." + device + ".Result";
-                        String Result1 = thoroughfare + "." + device + ".Result1";
-                        List<String> list = new ArrayList();
-                        list.add(Torque);
-                        list.add(Angle);
-                        list.add(Result);
-                        list.add(Result1);
+                        for (String suffix : suffixes) {
+                            String string = thoroughfare + "." + device + "." + suffix;
+                            list.add(string);
+                        }
                         List<ReadWriteEntity> list1 = miloService.readFromOpcUa(list);
                         List<Object> collect = list1.stream().map(ReadWriteEntity::getValue).collect(Collectors.toList());
                         String joinedString = String.join(",", collect.toString());
                         WebSocketUsers.sendMessageToUserByText(map.get(device), joinedString);
-                    }else {
-                        System.out.println("^");
-
                     }
-
-
-
-
                 }
             }
         } catch (Exception e) {
@@ -137,50 +159,104 @@
         return SNCode;
     }
 
-
     /**
      * 鍑虹珯淇濆瓨鏁版嵁
      */
     public String outSaveDate(String thoroughfare,String device) {
+        String snCode = "";
         String result = "";
+        String read = thoroughfare + "." + device + ".";
+
         try {
-            //璇诲彇SNCode
-            String SNCodeAddress = thoroughfare + "." + device + ".SNCode";
-            Object SNCodeObject = miloService.readFromOpcUa(SNCodeAddress).getValue();
-            if(null == SNCodeObject || "".equals(SNCodeObject)){
-               result = "22";
+            if(nullList.stream().noneMatch(s -> s.equals(device))){
+                if(moduleCodeList.stream().anyMatch(s -> s.equals(device))){
+                    read = read + "ModuleCode";
+                }else {
+                    read = read + "PACKCode";
+                }
+            }
+            snCode = miloService.readFromOpcUa(read).getValue().toString();
+
+            if(null == snCode || "".equals(snCode)){
+                result = "22";
             }else{
-                String SNCode = SNCodeObject.toString();
                 //1銆佹洿鏂板伐鍗曚俊鎭�
                 //updateOrderInfo();
                 //2銆佷繚瀛樿繃绔欓噰闆嗘暟鎹�
-                saveStationInfo(SNCode,thoroughfare,device);
+                String workOrderNo = miloService.readFromOpcUa(thoroughfare + "." + device + "." + "WorkOrderNumber").getValue().toString();
+                String productCode = miloService.readFromOpcUa(thoroughfare + "." + device + "." + "ProductType").getValue().toString();
+
+
+                saveStationInfo(snCode,thoroughfare,device,workOrderNo,productCode);
                 //3銆佷繚瀛樺弬鏁伴噰闆嗘暟鎹�
-                SaveParamData(SNCode,thoroughfare,device);
+                SaveParamData(snCode,thoroughfare,device,workOrderNo,productCode);
 
                 result = "21";
 
             }
 
         }catch (Exception e) {
-
+            System.out.println(e.getMessage());
         }
         return result;
     }
 
+
+//    /**
+//     * 鍑虹珯淇濆瓨鏁版嵁
+//     */
+//    public String outSaveDate(String thoroughfare,String device) {
+//        String result = "";
+//        try {
+//            //璇诲彇SNCode
+//            String PACKCode = thoroughfare + "." + device + ".PACKCode";
+//            Object PACKCodeObject = miloService.readFromOpcUa(PACKCode).getValue();
+//            if(null == PACKCodeObject || "".equals(PACKCodeObject)){
+//               result = "22";
+//            }else{
+//                String PACKCodeParam = PACKCodeObject.toString();
+//                //1銆佹洿鏂板伐鍗曚俊鎭�
+//                //updateOrderInfo();
+//                //2銆佷繚瀛樿繃绔欓噰闆嗘暟鎹�
+//                saveStationInfo(PACKCodeParam,thoroughfare,device);
+//                //3銆佷繚瀛樺弬鏁伴噰闆嗘暟鎹�
+//                SaveParamData(PACKCodeParam,thoroughfare,device,"","");
+//
+//                result = "21";
+//
+//            }
+//
+//        }catch (Exception e) {
+//
+//        }
+//        return result;
+//    }
+
     /**
      * 淇濆瓨杩囩珯閲囬泦
      */
-    public void saveStationInfo(String SNCode,String thoroughfare,String device){
+    public void saveStationInfo(String packCode,String thoroughfare,String device,String workOrderNo,String productCode) throws Exception {
+        SimpleDateFormat sdf = new SimpleDateFormat("EEE MMM dd HH:mm:ss zzz yyyy", Locale.US);
+        sdf.setTimeZone(TimeZone.getTimeZone("GMT+8")); // CST閫氬父琛ㄧず涓浗鏍囧噯鏃堕棿锛屽嵆涓滃叓鍖�
+        String prefix = thoroughfare+"."+device+".";
+        String startTime = miloService.readFromOpcUa(prefix + "StartTime").getValue().toString();
+        String stopTime = miloService.readFromOpcUa(prefix + "StopTime").getValue().toString();
+        String stationStatus = miloService.readFromOpcUa(prefix + "StationStatus").getValue().toString();
+
         DaPassingStationCollection daPassingStationCollection = new DaPassingStationCollection();
-        daPassingStationCollection.setSfcCode(SNCode);
-        //daPassingStationCollection.setInboundTime();//鍏ョ珯鏃堕棿
-        daPassingStationCollection.setOutboundTime(new Date());//鍑虹珯鏃堕棿
-        //daPassingStationCollection.setOutRsSign();//鍑虹珯鏄惁鍚堟牸
+        daPassingStationCollection.setSfcCode(packCode);
+        daPassingStationCollection.setWorkOrderNo(workOrderNo);
+        daPassingStationCollection.setProductCode(productCode);
+        daPassingStationCollection.setLocationCode(device);
+        String strt = TimeUtil.stringProcessing(startTime);
+        String end = TimeUtil.stringProcessing(stopTime);
+        daPassingStationCollection.setInboundTime(sdf.parse(strt));//鍏ョ珯鏃堕棿
+        daPassingStationCollection.setOutboundTime(sdf.parse(end));//鍑虹珯鏃堕棿
+        daPassingStationCollection.setOutRsSign(stationStatus);//鍑虹珯鏄惁鍚堟牸
         daPassingStationCollectionService.insertDaPassingStationCollection(daPassingStationCollection);
     }
 
-    public void SaveParamData(String SNCode,String thoroughfare,String device) throws Exception {
+    public static void SaveParamData(String packCode,String thoroughfare,String device,String workOrderNo,String productType) throws Exception {
         List<DaCollectionParamConf> list;
         DaCollectionParamConf daCollectionParamConf = new DaCollectionParamConf();
         daCollectionParamConf.setGatherAddress(thoroughfare+ "." + device);
@@ -195,12 +271,18 @@
             List<ReadWriteEntity> readWriteEntityList = miloService.readFromOpcUa(nodeIdList);
             List<DaParamCollection> daParamCollectionlist = new ArrayList<>();
             for(int i=0;i<nodeIdList.size();i++){
-                DaParamCollection ParamCollection = new DaParamCollection();
                 if(!readWriteEntityList.get(i).getValue().toString().equals("0.0")){
-                    ParamCollection.setParamCode(readWriteEntityList.get(i).getIdentifier().toString().split("[.]")[2]);
+                    String tt = readWriteEntityList.get(i).getValue().toString();
+                    DaParamCollection ParamCollection = new DaParamCollection();
+                    ParamCollection.setParamCode(list.get(i).getCollectParameterId());
                     ParamCollection.setLocationCode(device);
-                    ParamCollection.setParamValue(readWriteEntityList.get(i).getValue().toString());
-                    ParamCollection.setSfcCode(SNCode);
+                    if(tt.contains("Time")){
+                        String str = TimeUtil.getTimestamp(TimeUtil.stringProcessing(tt));
+                        ParamCollection.setParamValue(str);
+                    }else {
+                        ParamCollection.setParamValue(readWriteEntityList.get(i).getValue().toString());
+                    }
+                    ParamCollection.setSfcCode(packCode);
                     ParamCollection.setParamName(list.get(i).getCollectParameterName());
                     ParamCollection.setParamUpper(list.get(i).getParamUpper());
                     ParamCollection.setParamLower(list.get(i).getParamLower());
@@ -208,11 +290,40 @@
                     //ParamCollection.setState("鍚堟牸");
                     ParamCollection.setType(list.get(i).getCollectParameterType());
                     ParamCollection.setCollectionTime(new Date());
+                    ParamCollection.setWorkOrderNo(workOrderNo);
+                    ParamCollection.setProductCode(productType);
                     daParamCollectionlist.add(ParamCollection);
+//                    daParamCollectionService.insertDaParamCollection(ParamCollection);
                 }
             }
-            //daParamCollectionService.saveBeachDaParamCollection(daParamCollectionlist);
+            daParamCollectionService.saveBeachDaParamCollection(daParamCollectionlist);
         }
+        addBaseData(workOrderNo,productType,device,packCode);
 
     }
+
+    public static void addBaseData(String workOrderNo,String productCode,String locationCode,String packCode){
+        Map<String, String> map = new HashMap<>();
+        map.put("GC", "鍗楁禂宸ュ巶");
+        map.put("CXBH", "Pack绾�");
+        map.put("SBBH", "璁惧001");
+        map.put("YGBH", "鍛樺伐001");
+        List<DaParamCollection> confList = new ArrayList<>();
+        map.forEach((key, value) -> {
+            List<DaCollectionParamConf> daCollectionParamConfs = collectionParamConfService.list(new LambdaQueryWrapper<DaCollectionParamConf>()
+                    .eq(DaCollectionParamConf::getProcessesCode,locationCode)
+                    .like(DaCollectionParamConf::getCollectParameterId,key));
+            DaParamCollection saveData = new DaParamCollection();
+            saveData.setWorkOrderNo(workOrderNo);
+            saveData.setProductCode(productCode);
+            saveData.setLocationCode(locationCode);
+            saveData.setSfcCode(packCode);
+            saveData.setParamCode(daCollectionParamConfs.get(0).getCollectParameterId());
+            saveData.setParamName(daCollectionParamConfs.get(0).getCollectParameterName());
+            saveData.setCollectionTime(new Date());
+            saveData.setParamValue(value);
+            confList.add(saveData);
+        });
+        daParamCollectionService.insertBatch(confList);
+    }
 }

--
Gitblit v1.9.3