From 4fe66d4f3ac6888b10f9b0e5e0f2ab555c650d7d Mon Sep 17 00:00:00 2001 From: wujian <14790700720@163.com> Date: 星期一, 15 四月 2024 16:23:44 +0800 Subject: [PATCH] chenge plan --- jcdm-main/src/main/java/com/jcdm/main/plcserver/sub/OPCUaSubscription.java | 219 ++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 179 insertions(+), 40 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 f841abe..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,10 @@ 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; import com.jcdm.main.da.paramCollection.domain.DaParamCollection; @@ -8,28 +12,41 @@ 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; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Component; -import java.util.ArrayList; -import java.util.Date; -import java.util.List; +import javax.websocket.Session; +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; + + Map<String, Session> map = WebSocketUsers.getUsers(); public IDaPassingStationCollectionService daPassingStationCollectionService; - public IDaCollectionParamConfService collectionParamConfService; + public static IDaCollectionParamConfService collectionParamConfService; - public IDaParamCollectionService daParamCollectionService; + public static IDaParamCollectionService daParamCollectionService; public OPCUaSubscription(MiloService miloService, IDaPassingStationCollectionService daPassingStationCollectionService, @@ -37,8 +54,8 @@ IDaParamCollectionService daParamCollectionService) { OPCUaSubscription.miloService = miloService; this.daPassingStationCollectionService = daPassingStationCollectionService; - this.collectionParamConfService = collectionParamConfService; - this.daParamCollectionService = daParamCollectionService; + OPCUaSubscription.collectionParamConfService = collectionParamConfService; + OPCUaSubscription.daParamCollectionService = daParamCollectionService; } @@ -72,26 +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) +// inSaveDate(thoroughfare,device) //璁板綍鏁版嵁瀹屾垚 String RecordDataDoneAddress = thoroughfare + "." + device + ".RecordDataDone"; - miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(RecordDataDoneAddress).value(recordDataDoneValue).build()); - }else if("2".equals(tabVlaue)){ - //鍑虹珯淇濆瓨鏁版嵁 - recordDataDoneValue = outSaveDate(thoroughfare,device); - //璁板綍鏁版嵁瀹屾垚 - String RecordDataDoneAddress = thoroughfare + "." + device + ".RecordDataDone"; - miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(RecordDataDoneAddress).value(recordDataDoneValue).build()); - }else{ + 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"}; - - - + 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); + } } } } catch (Exception e) { @@ -109,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); @@ -167,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()); @@ -180,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