package com.billion.main.plcServer.sub;
|
|
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
|
import com.billion.main.bs.domain.BsBomChildInfo;
|
import com.billion.main.bs.domain.BsLineInfo;
|
import com.billion.main.bs.service.IBsBomChildInfoService;
|
import com.billion.main.bs.service.IBsLineInfoService;
|
import com.billion.main.constant.Constants;
|
import com.billion.main.da.domain.DaCollectionParamConf;
|
import com.billion.main.da.domain.DaMaterialCollection;
|
import com.billion.main.da.domain.DaParamCollection;
|
import com.billion.main.da.domain.DaStationCollection;
|
import com.billion.main.da.service.IDaCollectionParamConfService;
|
import com.billion.main.da.service.IDaMaterialCollectionService;
|
import com.billion.main.da.service.IDaParamCollectionService;
|
import com.billion.main.da.service.IDaStationCollectionService;
|
import com.billion.main.om.domain.OmOrderScheduling;
|
import com.billion.main.om.domain.OmProductionOrderInfo;
|
import com.billion.main.om.service.IOmOrderSchedulingService;
|
import com.billion.main.om.service.IOmProductionOrderInfoService;
|
import com.billion.main.plcServer.util.TimeUtil;
|
import com.billion.main.sys.domain.SysCount;
|
import com.billion.main.sys.service.ISysCountService;
|
import com.kangaroohy.milo.model.ReadWriteEntity;
|
import com.kangaroohy.milo.runner.subscription.SubscriptionCallback;
|
import com.kangaroohy.milo.service.MiloService;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.stereotype.Component;
|
|
import java.text.SimpleDateFormat;
|
import java.time.LocalDateTime;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Objects;
|
import java.util.concurrent.CompletableFuture;
|
@Slf4j
|
@Component
|
public class OPCUaSubscription implements SubscriptionCallback {
|
|
public static SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
public static MiloService miloService;
|
public IDaParamCollectionService daParamCollectionService;
|
public IDaStationCollectionService daStationCollectionService;
|
public IOmProductionOrderInfoService omProductionOrderInfoService;
|
public IOmOrderSchedulingService omOrderSchedulingService;
|
public IBsBomChildInfoService bsBomChildInfoService;
|
public IDaCollectionParamConfService daCollectionParamConfService;
|
public IDaMaterialCollectionService daMaterialCollectionService;
|
public ISysCountService sysCountService;
|
public IBsLineInfoService bsLineInfoService;
|
|
|
public OPCUaSubscription(MiloService miloService,
|
IDaParamCollectionService daParamCollectionService,
|
IDaStationCollectionService daStationCollectionService,
|
IOmProductionOrderInfoService omProductionOrderInfoService,
|
IOmOrderSchedulingService omOrderSchedulingService,
|
IBsBomChildInfoService bsBomChildInfoService,
|
IDaCollectionParamConfService daCollectionParamConfService,
|
IDaMaterialCollectionService daMaterialCollectionService,
|
ISysCountService sysCountService,
|
IBsLineInfoService bsLineInfoService
|
) {
|
OPCUaSubscription.miloService = miloService;
|
this.daParamCollectionService = daParamCollectionService;
|
this.daStationCollectionService = daStationCollectionService;
|
this.omProductionOrderInfoService = omProductionOrderInfoService;
|
this.omOrderSchedulingService = omOrderSchedulingService;
|
this.bsBomChildInfoService = bsBomChildInfoService;
|
this.daCollectionParamConfService = daCollectionParamConfService;
|
this.daMaterialCollectionService = daMaterialCollectionService;
|
this.sysCountService = sysCountService;
|
this.bsLineInfoService = bsLineInfoService;
|
}
|
|
@Override
|
public void onSubscribe(String identifier, Object value) {
|
log.info("地址："+identifier+"值："+value);
|
try {
|
if(null != value ) {
|
String[] nodes = identifier.split("[.]");
|
String thoroughfare = nodes[0];//通道
|
String device = nodes[1];//设备
|
String tab = nodes[2];//标记
|
String valueString = value.toString();//地址值
|
CompletableFuture<Void> cp1 = CompletableFuture.runAsync(() -> {
|
onSubscribe(thoroughfare,device,tab,valueString);
|
plackWorkOrder(thoroughfare,device,tab,valueString);
|
});
|
}
|
} catch (Exception e) {
|
log.error(e.getMessage());
|
}
|
}
|
|
public void onSubscribe(String thoroughfare,String device,String tab,String valueString) {
|
try {
|
if (Constants.RecordData.equals(tab)){
|
//工站交互初始化
|
if (Constants.ZERO.equals(valueString)){
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".RecordDataDone").value(0).build());
|
//请求进站
|
} else 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.PLC1.contains(device) ||
|
Constants.PLC2.contains(device) ||
|
Constants.PLC3.contains(device) ||
|
Constants.PLC4.contains(device) ||
|
Constants.OFFLINE.contains(device)
|
){
|
//校验SFCCode是否存在
|
Object SFCCode = miloService.readFromOpcUa(thoroughfare + "." + device + ".SFCCode").getValue();
|
if (SFCCode == null ) {
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".RecordDataDone").value(13).build());
|
log.info( "进站失败：地址SFCCode为空");
|
} else {
|
OmOrderScheduling omOrderScheduling = new OmOrderScheduling();
|
omOrderScheduling.setSfcCode(SFCCode.toString());
|
List<OmOrderScheduling> resultList = omOrderSchedulingService.selectOmOrderSchedulingList(omOrderScheduling);
|
if(resultList != null){
|
if(Constants.OP010.equals(device)||Constants.OP310.equals(device)){
|
String EngineType =resultList.get(0).getProductCode();
|
String SerialNumber = SFCCode.toString().substring(EngineType.length());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".EngineType").value(EngineType).build());
|
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());
|
}
|
}
|
}
|
}
|
String getWorkOrderNo = resultList.get(0).getWorkOrderNo();
|
BsBomChildInfo bsbomChildInfo= new BsBomChildInfo();
|
bsbomChildInfo.setLocationCode(device);
|
bsbomChildInfo.setBomCode(getWorkOrderNo);
|
//下发配方
|
formula(thoroughfare, device, bsbomChildInfo);
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".RecordDataDone").value(11).build());
|
}else {
|
log.info( "进站失败：未检索到SFCCode:{}对应工单" ,SFCCode);
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".RecordDataDone").value(13).build());
|
}
|
}
|
}
|
//出站保存数据
|
} else if (Constants.TWO.equals(valueString)) {
|
OmProductionOrderInfo omProductionOrderInfo = new OmProductionOrderInfo();
|
OmOrderScheduling omOrderScheduling = new OmOrderScheduling();
|
Object SFCCode = miloService.readFromOpcUa(thoroughfare + "." + device + ".SFCCode").getValue();
|
//上线工位
|
if(Constants.ONLINE.contains(device)){
|
Object workOrderNumber = miloService.readFromOpcUa(thoroughfare + "." + device + ".WorkOrderNumber").getValue();
|
Object nowQty = miloService.readFromOpcUa(thoroughfare + "." + device + ".PalletID").getValue().toString();
|
Object EngineType = miloService.readFromOpcUa(thoroughfare + "." + device + ".EngineType").getValue().toString();
|
omOrderScheduling.setWorkOrderNo(workOrderNumber.toString());
|
omOrderScheduling.setNowQty(nowQty.toString());
|
omOrderScheduling.setSfcCode(SFCCode.toString());
|
omOrderScheduling.setProductCode(EngineType.toString());
|
omOrderScheduling.setStatus("1");
|
Date Time = new Date();
|
ReadWriteEntity TimeRead = miloService.readFromOpcUa(thoroughfare + "." + device + ".StartTime");
|
Time = format.parse(TimeUtil.test(TimeUtil.stringProcessing(TimeRead.getValue().toString())));
|
omOrderScheduling.setOnlineTime(Time);
|
//托盘绑定SFCCode和工单和产线
|
if(Constants.OP005.equals(device)){
|
omProductionOrderInfoService.updateBodyStatus1();
|
omOrderScheduling.setRemarks("Body");
|
sysCountService.updateSerialNumber();
|
OmProductionOrderInfo getBodyOrder2 = omProductionOrderInfoService.getBodyOrder();
|
if (Objects.equals(nowQty, getBodyOrder2.getPlanQty().toString())){
|
omProductionOrderInfoService.updateBodyStatus2();
|
}
|
}
|
if(Constants.C005.equals(device)){
|
omProductionOrderInfoService.updateHeadStatus1();
|
omOrderScheduling.setRemarks("Head");
|
sysCountService.updateHeadNumber();
|
OmProductionOrderInfo getHeadOrder2 = omProductionOrderInfoService.getHeadOrder();
|
if (Objects.equals(nowQty, getHeadOrder2.getPlanQty().toString())){
|
omProductionOrderInfoService.updateHeadStatus2();
|
}
|
}
|
omOrderSchedulingService.insertOmOrderScheduling(omOrderScheduling);
|
}else if(Constants.OFFLINE.contains(device)){
|
Date Time = new Date();
|
ReadWriteEntity TimeRead = miloService.readFromOpcUa(thoroughfare + "." + device + ".StopTime");
|
Time = format.parse(TimeUtil.test(TimeUtil.stringProcessing(TimeRead.getValue().toString())));
|
omOrderScheduling.setOfflineTime(Time);
|
if(Constants.C060.equals(device)){
|
omOrderScheduling.setRemarks("Head");
|
omOrderScheduling.setSfcCode(SFCCode.toString());
|
List<OmOrderScheduling> omOrderSchedulingList = omOrderSchedulingService.selectOmOrderSchedulingList(omOrderScheduling);
|
String nowQty = omOrderSchedulingList.get(0).getNowQty();
|
Object WorkOrderNumber = omOrderSchedulingList.get(0).getWorkOrderNo();
|
omProductionOrderInfo.setWorkOrderNo(WorkOrderNumber.toString());
|
List<OmProductionOrderInfo> omProductionOrderInfoList = omProductionOrderInfoService.selectOmProductionOrderInfoList(omProductionOrderInfo);
|
Object headQty = omProductionOrderInfoList.get(0).getHeadQty();
|
if (Objects.equals(nowQty, headQty.toString())){
|
UpdateWrapper<OmProductionOrderInfo> updateWrapper = new UpdateWrapper<>();
|
updateWrapper.eq("work_order_no", omProductionOrderInfoList.get(0).getWorkOrderNo());
|
updateWrapper.set("head_status", "2");
|
omProductionOrderInfoService.update(new OmProductionOrderInfo(),updateWrapper);
|
}
|
} else if (Constants.OP310.equals(device)) {
|
omOrderScheduling.setRemarks("Body");
|
omOrderScheduling.setSfcCode(SFCCode.toString());
|
List<OmOrderScheduling> omOrderSchedulingList = omOrderSchedulingService.selectOmOrderSchedulingList(omOrderScheduling);
|
String nowQty = omOrderSchedulingList.get(0).getNowQty();
|
Object WorkOrderNumber = omOrderSchedulingList.get(0).getWorkOrderNo();
|
omProductionOrderInfo.setWorkOrderNo(WorkOrderNumber.toString());
|
List<OmProductionOrderInfo> omProductionOrderInfoList = omProductionOrderInfoService.selectOmProductionOrderInfoList(omProductionOrderInfo);
|
Object bodyQty = omProductionOrderInfoList.get(0).getBodyQty();
|
if (Objects.equals(nowQty, bodyQty.toString())){
|
UpdateWrapper<OmProductionOrderInfo> updateWrapper = new UpdateWrapper<>();
|
updateWrapper.eq("work_order_no", omProductionOrderInfoList.get(0).getWorkOrderNo());
|
updateWrapper.set("body_status", "2");
|
omProductionOrderInfoService.update(new OmProductionOrderInfo(),updateWrapper);
|
}
|
}
|
} else if (Constants.P010.equals(device)) {
|
Object workOrderNumber = miloService.readFromOpcUa(thoroughfare + "." + device + ".WorkOrderNumber").getValue();
|
Object nowQty = miloService.readFromOpcUa(thoroughfare + "." + device + ".PalletID").getValue();
|
omOrderScheduling.setWorkOrderNo(workOrderNumber.toString());
|
omOrderScheduling.setNowQty(nowQty.toString());
|
omOrderScheduling.setSfcCode(SFCCode.toString());
|
omOrderScheduling.setRemarks("Pre");
|
omOrderSchedulingService.insertOmOrderScheduling(omOrderScheduling);
|
List<OmOrderScheduling> omOrderSchedulingList = omOrderSchedulingService.selectOmOrderSchedulingList(omOrderScheduling);
|
Object WorkOrderNumber = omOrderSchedulingList.get(0).getWorkOrderNo();
|
omProductionOrderInfo.setWorkOrderNo(WorkOrderNumber.toString());
|
List<OmProductionOrderInfo> omProductionOrderInfoList = omProductionOrderInfoService.selectOmProductionOrderInfoList(omProductionOrderInfo);
|
Object preQty = omProductionOrderInfoList.get(0).getPreQty();
|
if (nowQty == preQty.toString()){
|
UpdateWrapper<OmProductionOrderInfo> updateWrapper = new UpdateWrapper<>();
|
updateWrapper.eq("work_order_no", omProductionOrderInfoList.get(0).getWorkOrderNo());
|
updateWrapper.set("pre_status", "2");
|
omProductionOrderInfoService.update(new OmProductionOrderInfo(),updateWrapper);
|
}
|
sysCountService.updatePreNumber();
|
omProductionOrderInfoService.updatePreStatus1();
|
OmProductionOrderInfo getPreOrder2 = omProductionOrderInfoService.getPreOrder();
|
if (Objects.equals(nowQty, getPreOrder2.getPlanQty().toString())){
|
omProductionOrderInfoService.updatePreStatus2();
|
}
|
}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;
|
// 创建采集对象
|
DaMaterialCollection materialCollection = new DaMaterialCollection();
|
materialCollection.setSfcCode(SFCCode.toString());
|
materialCollection.setLocationCode(device);
|
// 设置参数名称（活塞1到活塞6）
|
int pistonNumber = i - 34; // 35→1, 36→2...40→6
|
materialCollection.setParamName("活塞" + pistonNumber);
|
// 通过OPC UA读取参数值
|
ReadWriteEntity dataRead = miloService.readFromOpcUa(nodeId);
|
if (dataRead != null && dataRead.getValue() != null) {
|
materialCollection.setParamValue(dataRead.getValue().toString());
|
} else {
|
materialCollection.setParamValue("N/A"); // 处理空值情况
|
}
|
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" ;
|
// 创建采集对象
|
DaMaterialCollection materialCollection = new DaMaterialCollection();
|
materialCollection.setSfcCode(SFCCode.toString());
|
materialCollection.setLocationCode(device);
|
materialCollection.setParamName("缸盖码");
|
// 通过OPC UA读取参数值
|
ReadWriteEntity dataRead = miloService.readFromOpcUa(nodeId);
|
if (dataRead != null && dataRead.getValue() != null) {
|
materialCollection.setParamValue(dataRead.getValue().toString());
|
} else {
|
materialCollection.setParamValue("N/A"); // 处理空值情况
|
}
|
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();
|
daStationCollection.setLocationCode(device);
|
daStationCollection.setSfcCode(SFCCode.toString());
|
Object StationStatus = miloService.readFromOpcUa(thoroughfare + "." + device + ".StationStatus").getValue();
|
Date startTime = new Date();
|
ReadWriteEntity startTimeRead = miloService.readFromOpcUa(thoroughfare + "." + device + ".StartTime");//进站时间
|
startTime = format.parse(TimeUtil.test(TimeUtil.stringProcessing(startTimeRead.getValue().toString())));
|
daStationCollection.setInboundTime( startTime);
|
Date stopTime = new Date();
|
ReadWriteEntity stopTimeRead = miloService.readFromOpcUa(thoroughfare + "." + device + ".StopTime");//进站时间
|
stopTime = format.parse(TimeUtil.test(TimeUtil.stringProcessing(stopTimeRead.getValue().toString())));
|
daStationCollection.setOutboundTime( stopTime);
|
daStationCollection.setStatus(StationStatus.toString());
|
daStationCollectionService.insertDaStationCollection(daStationCollection);
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".RecordDataDone").value(21).build());
|
//查询descriptive字段等于1的采集项保存到扫码保存到da_material_collection表里
|
DaCollectionParamConf daCollectionParamConf1 = new DaCollectionParamConf();
|
daCollectionParamConf1.setProcessesCode(device);
|
daCollectionParamConf1.setDescriptive("1");
|
List<DaCollectionParamConf> daCollectionParamConfList1 = daCollectionParamConfService.selectDaCollectionParamConfList(daCollectionParamConf1);
|
for (DaCollectionParamConf conf : daCollectionParamConfList1) {
|
String gatherAddress = conf.getGatherAddress();
|
String valueObj = null;
|
ReadWriteEntity entity = miloService.readFromOpcUa(gatherAddress);
|
if (entity != null) {
|
Object value = entity.getValue();
|
if (value != null) {
|
valueObj = value.toString(); // 最终赋值
|
if (!Objects.equals(valueObj, " ")) {
|
DaMaterialCollection materialCollection = new DaMaterialCollection();
|
materialCollection.setSfcCode(SFCCode.toString());
|
materialCollection.setLocationCode(device);
|
materialCollection.setParamName(conf.getParameterSetName());
|
materialCollection.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())));
|
materialCollection.setCollectTime(Time);
|
daMaterialCollectionService.insertDaMaterialCollection(materialCollection);
|
}
|
else {
|
log.info("采集项为空: {}", gatherAddress);
|
}
|
}
|
}
|
}
|
// 查询descriptive字段等于2的采集项保存到扫码保存到da_param_collection表里
|
DaCollectionParamConf daCollectionParamConf2 = new DaCollectionParamConf();
|
daCollectionParamConf2.setProcessesCode(device);
|
daCollectionParamConf2.setDescriptive("2");
|
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);
|
}
|
else {
|
log.info("采集项为空: {}", gatherAddress);
|
}
|
}
|
}
|
}
|
}
|
catch (Exception e) {
|
log.error(e.getMessage());
|
}
|
}
|
|
|
|
|
//首工站下发工单,并生成SN码
|
private static final String[] MONTH = {"A","B","C","D","E","F","G","H","I","J","K","L"};
|
public void plackWorkOrder(String thoroughfare, String device, String tab, String valueString) {
|
try {
|
if (Constants.WorkOrderRequest.equals(tab)) {
|
if (Constants.ZERO.equals(valueString)) {
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".WorkOrderRequestDone").value(0).build());
|
}else if (Constants.ONE.equals(valueString)){
|
if (Constants.OP005.equals(device)){
|
// 查询数据库获取符合条件的订单信息
|
OmProductionOrderInfo getBodyOrder = omProductionOrderInfoService.getBodyOrder();
|
if (getBodyOrder != null) {
|
//判断当前下发数量是否满足计划数量
|
//更新工单状态
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".WorkOrderNumber").value(getBodyOrder.getWorkOrderNo()).build());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".EngineType").value(getBodyOrder.getEngineType()).build());
|
//生成sn码
|
SysCount serialNumber = sysCountService.getSerialNumber();
|
String A3 = String.valueOf(LocalDateTime.now().getYear()).substring(2);
|
//判断是否跨年
|
if(A3.equals(String.valueOf(serialNumber.getYear()))){
|
String A1 = getBodyOrder.getEngineType();//获取产品型号
|
String A2 = "3";//固定产线
|
String A4 = MONTH[LocalDateTime.now().getMonthValue() - 1];// 获取当前月份（1-12）
|
String A5 = String.format("%05d", serialNumber.getSerialNumber());
|
String SFCCode = A1 + A2 + A3+ A4 + A5;
|
String SerialNumber = A2 + A3+ A4 + A5;
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".SerialNumber").value(SerialNumber).build());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".SFCCode").value(SFCCode).build());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".MESSFCCode").value(SFCCode).build());
|
log.info("SFCCode：{}下发成功",SFCCode);
|
}else{
|
sysCountService.clean();
|
sysCountService.updateYear();
|
String A1 = getBodyOrder.getEngineType();//获取产品型号
|
String A2 = "3";
|
String newA3 = String.valueOf(LocalDateTime.now().getYear()).substring(2);
|
String A4 = MONTH[LocalDateTime.now().getMonthValue() - 1];// 获取当前月份（1-12）
|
String A5 = String.format("%05d", sysCountService.getSerialNumber().getSerialNumber());
|
String SFCCode = A1 + A2 + newA3+ A4 + A5;
|
String SerialNumber = A2 + newA3+ A4 + A5;
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".SerialNumber").value(SerialNumber).build());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".SFCCode").value(SFCCode).build());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".MESSFCCode").value(SFCCode).build());
|
log.info("SFCCode：{}下发成功",SFCCode);
|
}
|
// 更新 WorkOrderRequestDone 地址块
|
BsBomChildInfo bsbomChildInfo= new BsBomChildInfo();
|
bsbomChildInfo.setLocationCode(device);
|
bsbomChildInfo.setBomCode(getBodyOrder.getWorkOrderNo());
|
//发下工艺配方
|
formula(thoroughfare, device, bsbomChildInfo);
|
// omProductionOrderInfoService.updateBodyStatus1();
|
//判断缸体工单完成
|
// OmProductionOrderInfo getBodyOrder2 = omProductionOrderInfoService.getBodyOrder();
|
// if (Objects.equals(getBodyOrder2.getBodyQty(), getBodyOrder2.getPlanQty())){
|
// omProductionOrderInfoService.updateBodyStatus2();
|
// }
|
String PalletID = String.valueOf(getBodyOrder.getBodyQty() + 1);
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".PalletID").value(PalletID).build());
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".WorkOrderRequestDone").value(11).build());
|
log.info("工位{}请求工单成功",device);
|
}
|
else{
|
log.info("请求工单失败：未检索到工单");
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".WorkOrderRequestDone").value(12).build());
|
}
|
} else if (Constants.C005.equals(device)) {
|
// 查询数据库获取符合条件的订单信息
|
OmProductionOrderInfo getHeadOrder = omProductionOrderInfoService.getHeadOrder();
|
if (getHeadOrder != null) {
|
//判断当前下发数量是否满足计划数量
|
//更新工单状态
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".WorkOrderNumber").value(getHeadOrder.getWorkOrderNo()).build());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".EngineType").value(getHeadOrder.getEngineType()).build());
|
//生成sn码
|
SysCount headNumber = sysCountService.getHeadNumber();
|
String A3 = String.valueOf(LocalDateTime.now().getYear()).substring(2);
|
//判断是否跨年
|
if(A3.equals(String.valueOf(headNumber.getYear()))){
|
String A1 = getHeadOrder.getEngineType();//获取产品型号
|
String A2 = "3";//固定产线
|
String A4 = MONTH[LocalDateTime.now().getMonthValue() - 1];// 获取当前月份（1-12）
|
String A5 = String.format("%05d", headNumber.getHeadNumber());
|
String SFCCode = A1 + A2 + A3+ A4 + A5;
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".SFCCode").value(SFCCode).build());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".MESSFCCode").value(SFCCode).build());
|
log.info("SFCCode：{}下发成功",SFCCode);
|
}else{
|
sysCountService.clean();
|
sysCountService.updateYear();
|
String A1 = getHeadOrder.getEngineType();//获取产品型号
|
String A2 = "3";
|
String newA3 = String.valueOf(LocalDateTime.now().getYear()).substring(2);
|
String A4 = MONTH[LocalDateTime.now().getMonthValue() - 1];// 获取当前月份（1-12）
|
String A5 = String.format("%05d", sysCountService.getHeadNumber().getHeadNumber());
|
String SFCCode = A1 + A2 + newA3+ A4 + A5;
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".SFCCode").value(SFCCode).build());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".MESSFCCode").value(SFCCode).build());
|
log.info("SFCCode：{}下发成功",SFCCode);
|
}
|
// 更新 WorkOrderRequestDone 地址块
|
BsBomChildInfo bsbomChildInfo= new BsBomChildInfo();
|
bsbomChildInfo.setLocationCode(device);
|
bsbomChildInfo.setBomCode(getHeadOrder.getWorkOrderNo());
|
//发下工艺配方
|
formula(thoroughfare, device, bsbomChildInfo);
|
// omProductionOrderInfoService.updateHeadStatus1();
|
//判断缸体工单完成
|
// OmProductionOrderInfo getHeadOrder2 = omProductionOrderInfoService.getHeadOrder();
|
// if (Objects.equals(getHeadOrder2.getHeadQty(), getHeadOrder2.getPlanQty())){
|
// omProductionOrderInfoService.updateHeadStatus2();
|
// }
|
String PalletID = String.valueOf(getHeadOrder.getHeadQty() + 1);
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".PalletID").value(PalletID).build());
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".WorkOrderRequestDone").value(11).build());
|
log.info("工位{}请求工单成功",device);
|
}
|
else{
|
log.info("请求工单失败：未检索到对应工单");
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".WorkOrderRequestDone").value(12).build());
|
}
|
} else if (Constants.P010.equals(device)) {
|
// 查询数据库获取符合条件的订单信息
|
OmProductionOrderInfo getPreOrder = omProductionOrderInfoService.getPreOrder();
|
if (getPreOrder != null) {
|
//判断当前下发数量是否满足计划数量
|
//更新工单状态
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".WorkOrderNumber").value(getPreOrder.getWorkOrderNo()).build());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".EngineType").value(getPreOrder.getEngineType()).build());
|
//生成sn码
|
SysCount preNumber = sysCountService.getPreNumber();
|
String A3 = String.valueOf(LocalDateTime.now().getYear()).substring(2);
|
if(A3.equals(String.valueOf(preNumber.getYear()))){
|
String A1 = getPreOrder.getEngineType();//获取产品型号
|
String A2 = "3";
|
String A4 = MONTH[LocalDateTime.now().getMonthValue() - 1];// 获取当前月份（1-12）
|
String A5 = String.format("%05d", preNumber.getPreNumber());
|
String SFCCode = A1 + A2 + A3+ A4 + A5;
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".SFCCode").value(SFCCode).build());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".MESSFCCode").value(SFCCode).build());
|
log.info("SFCCode：{}下发成功",SFCCode);
|
}else{
|
sysCountService.clean();
|
sysCountService.updateYear();
|
String A1 = getPreOrder.getEngineType();//获取产品型号
|
String A2 = "3";
|
String newA3 = String.valueOf(LocalDateTime.now().getYear()).substring(2);
|
String A4 = MONTH[LocalDateTime.now().getMonthValue() - 1];// 获取当前月份（1-12）
|
String A5 = String.format("%05d", sysCountService.getPreNumber().getPreNumber());
|
String SFCCode = A1 + A2 + newA3+ A4 + A5;
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".SFCCode").value(SFCCode).build());
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".MESSFCCode").value(SFCCode).build());
|
log.info("SFCCode：{}下发成功",SFCCode);
|
}
|
// 更新 WorkOrderRequestDone 地址块
|
BsBomChildInfo bsbomChildInfo= new BsBomChildInfo();
|
bsbomChildInfo.setLocationCode(device);
|
bsbomChildInfo.setBomCode(getPreOrder.getWorkOrderNo());
|
//发下工艺配方
|
formula(thoroughfare, device, bsbomChildInfo);
|
// omProductionOrderInfoService.updatePreStatus1();
|
//判断缸体工单完成
|
// OmProductionOrderInfo getPreOrder2 = omProductionOrderInfoService.getPreOrder();
|
// if (Objects.equals(getPreOrder2.getPreQty(), getPreOrder2.getPlanQty())){
|
// omProductionOrderInfoService.updatePreStatus2();
|
// }
|
String PalletID = String.valueOf(getPreOrder.getPreQty() + 1);
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".PalletID").value(PalletID).build());
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".WorkOrderRequestDone").value(11).build());
|
log.info("工位{}请求工单成功",device);
|
}
|
else{
|
log.info("请求工单失败：未检索到对应工单");
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".WorkOrderRequestDone").value(12).build());
|
}
|
}
|
}
|
}
|
} catch (Exception e) {
|
log.error(e.getMessage());
|
}
|
}
|
|
//发下工艺配方方法
|
private void formula(String thoroughfare, String device, BsBomChildInfo bsbomChildInfo) throws Exception {
|
List<BsBomChildInfo> bomChildList = bsBomChildInfoService.selectBsBomChildInfoList(bsbomChildInfo);
|
for (int i = 1; i <= bomChildList.size(); i++) {
|
// 生成 MaterialCode 节点
|
miloService.writeToOpcUa(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".Material"+ i +"Code").value(bomChildList.get(i-1).getMaterialCode()).build());
|
// 生成 MaterialNumber 节点
|
miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(thoroughfare + "." + device + ".Material"+ i +"Number").value(Integer.parseInt(bomChildList.get(i-1).getCostQty())).build());
|
}
|
}
|
|
}
|
//
|
