package cn.stylefeng.guns.plcserver.server.OP050.impl; import cn.stylefeng.guns.modular.bs.collectionParamConf.model.params.CollectionParamConfParam; import cn.stylefeng.guns.modular.bs.collectionParamConf.model.result.CollectionParamConfResult; import cn.stylefeng.guns.modular.bs.collectionParamConf.service.CollectionParamConfService; import cn.stylefeng.guns.modular.cm.paramCollection.model.params.ParamCollectionParam; import cn.stylefeng.guns.modular.cm.paramCollection.service.ParamCollectionService; import cn.stylefeng.guns.modular.cm.passingStationCollection.model.params.PassingStationCollectionParam; import cn.stylefeng.guns.modular.cm.passingStationCollection.model.result.PassingStationCollectionResult; import cn.stylefeng.guns.modular.cm.passingStationCollection.service.PassingStationCollectionService; import cn.stylefeng.guns.modular.dq.materialTraceability.model.params.MaterialTraceabilityParam; import cn.stylefeng.guns.modular.dq.materialTraceability.service.MaterialTraceabilityService; import cn.stylefeng.guns.modular.gm.greaseManage.model.params.GreaseManageParam; import cn.stylefeng.guns.modular.gm.greaseManage.model.result.GreaseManageResult; import cn.stylefeng.guns.modular.gm.greaseManage.service.GreaseManageService; import cn.stylefeng.guns.modular.om.productionOrderBatchInfo.model.params.ProductionOrderBatchInfoParam; import cn.stylefeng.guns.modular.om.productionOrderBatchInfo.model.result.ProductionOrderBatchInfoResult; import cn.stylefeng.guns.modular.om.productionOrderBatchInfo.service.ProductionOrderBatchInfoService; import cn.stylefeng.guns.modular.om.productionOrderRecords.model.params.ProductionOrderRecordsParam; import cn.stylefeng.guns.modular.om.productionOrderRecords.model.result.ProductionOrderRecordsResult; import cn.stylefeng.guns.modular.om.productionOrderRecords.service.ProductionOrderRecordsService; import cn.stylefeng.guns.plcserver.opc.GlobalVariable; import cn.stylefeng.guns.plcserver.opc.OPCComm; import cn.stylefeng.guns.plcserver.opc.unit.OPCUnit; import cn.stylefeng.guns.plcserver.server.OP050.OP050ServerInterface; import cn.stylefeng.guns.plcserver.tool.DateTool; import cn.stylefeng.guns.plcserver.tool.LogUtil; import org.apache.log4j.Logger; import org.openscada.opc.lib.da.Group; import org.openscada.opc.lib.da.Item; import java.text.SimpleDateFormat; import java.time.LocalDate; import java.time.format.DateTimeFormatter; import java.time.temporal.ChronoUnit; import java.util.Date; import java.util.List; public class OP050ServerInterfaceImpl implements OP050ServerInterface { private static Logger logger; LogUtil logUtil = new LogUtil(); static { logger = Logger.getLogger(OP050ServerInterfaceImpl.class); } private OPCComm opc = OPCComm.getInstance(); private static Date IN_TIME = null; private static String S_ORDER_CODE = "";//工单编号 private static String S_PRODUCT_CODE = "";//产品编号 private static String S_PRODUCT_TYPE= "";//产品类型 private static String S_PRODUCT_CODE_OLD = "";//产品编号 private static String S_SFC_CODE = "";//总成编码 private static String S_RIGHT_CODE = "";//右壳体编码 private static String PRODUCTION_LINE = "OP";//产线号 private static String LOCATION_CODE = "OP050";//工位号 private static String GROUP_NAME = "OP050_P";//组名 private static List list = null; private static Group group = null; private int count = 0; /** * 设置心跳标志位,保存到全局变量 */ public void setHeartbeat(String value) { if ("false".equals(value)) { OPCUnit.write(opc.getOP050_F_HEART_BEAT(), "true"); GlobalVariable.OP050_F_HEART_BEAT = true; count = 0; } else { count++; } // 循环读取频率是:500ms一次,如果超过6次,也就是3s认定超时 if (count > GlobalVariable.HEART_MAX_COUNT) { GlobalVariable.OP050_F_HEART_BEAT = false; } } @Override public synchronized void monitor() { String ecpStr = "";//异常记录标记 try{ /* String isHeartBeat = OPCUnit.read(opc.getOP050_F_HEART_BEAT()); setHeartbeat(isHeartBeat);*/ if(GlobalVariable.OP050_F_HEART_BEAT) { //PC读工单 String isPLCStart = OPCUnit.read(opc.getOP050_J_PLC_START());//PLC开始 if(isPLCStart.equals("true")){ String isFinish = OPCUnit.read(opc.getOP050_J_PC_WRITE_ORDER());//PC下发工单完成 if(isFinish.equals("false")){ handleOrder(); } } //PC完成 String isPLCFinish = OPCUnit.read(opc.getOP050_J_PLC_FINISH());//PLC完成 if(isPLCFinish.equals("true")){ String isFinish = OPCUnit.read(opc.getOP050_J_PC_FINISH());//PC操作完成 if(isFinish.equals("false")){ logger.info("handleFinsh开始时间:"+new Date()); handleFinsh(); logger.info("handleFinsh完成时间:"+new Date()); logger.info("handleInfo开始时间:"+new Date()); handleInfo(); logger.info("handleInfo完成时间:"+new Date()); logger.info("handleMaterial开始时间:"+new Date()); handleMaterial(); logger.info("handleMaterial完成时间:"+new Date()); } } handleOilState(); }else{ logger.info("OP050工位与PLC断开,请检查PLC或网络是否异常!"); } }catch (Exception e) { ecpStr ="出现异常:" + logUtil.getTrace(e); }finally { if(!"".equals(ecpStr)){ logger.info(ecpStr+"\r\n"); } } } public void handleOilState(){ GreaseManageParam param = new GreaseManageParam(); GreaseManageService greaseManageService = opc.greaseManageService; param.setLocationCode(LOCATION_CODE); List list = greaseManageService.findListBySpec(param); if(list.size()>0) { String duaDate = list.get(0).getDuaDate(); SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd"); String currentDate = format.format(new Date()); long daysBetween = getRemainder(currentDate,duaDate); if(daysBetween>0){ OPCUnit.write(opc.getOP050_OIL_STATE(), "false"); //写油脂状态 }else{ OPCUnit.write(opc.getOP050_OIL_STATE(), "true"); //写油脂状态 } //logger.info("到期日期:"+duaDate+"当前日期:"+currentDate+"剩余天数::"+daysBetween); } } public static long getRemainder(String currentDate,String tableDate){ DateTimeFormatter dateFormatter = DateTimeFormatter.ofPattern("yyyyMMdd"); LocalDate localDate1 = LocalDate.parse(currentDate, dateFormatter); LocalDate localDate2 = LocalDate.parse(tableDate, dateFormatter); long days = ChronoUnit.DAYS.between(localDate1, localDate2); return days; } //PC读工单 public void handleOrder() { IN_TIME = DateTool.getLocalTimeForDate(); S_ORDER_CODE = OPCUnit.read(opc.getOP050_S_ORDER_CODE());//工单编号 S_PRODUCT_TYPE = OPCUnit.read(opc.getOP050_S_PRODUCT_CODE());//产品编号 S_PRODUCT_CODE = GlobalVariable.PRODUCT_CODE_MAP.get(S_PRODUCT_TYPE); S_SFC_CODE = OPCUnit.read(opc.getOP050_S_SFC_CODE());//总成编码 OPCUnit.write(opc.getOP050_J_PC_WRITE_ORDER(), "true"); //PC读工单完成 logger.info("OP050工位,handleOrder PC处理完成!"); } public void handleMaterial() { //查询批次上料信息 ProductionOrderBatchInfoParam productionOrderBatchInfoParam = new ProductionOrderBatchInfoParam(); productionOrderBatchInfoParam.setWorkOrderNo(S_ORDER_CODE); productionOrderBatchInfoParam.setLocationCode(LOCATION_CODE); ProductionOrderBatchInfoService productionOrderBatchInfoService = opc.productionOrderBatchInfoService; List list1 = productionOrderBatchInfoService.findListBySpec(productionOrderBatchInfoParam); for(int i=0;i0){ //新增物料追溯 MaterialTraceabilityParam materialTraceabilityParam = new MaterialTraceabilityParam(); materialTraceabilityParam.setWorkOrderNo(S_ORDER_CODE); materialTraceabilityParam.setProductCode(S_PRODUCT_CODE); materialTraceabilityParam.setProductNo(S_SFC_CODE); materialTraceabilityParam.setLineCode(PRODUCTION_LINE); materialTraceabilityParam.setLocationCode(LOCATION_CODE); materialTraceabilityParam.setAssemblyQty(1); materialTraceabilityParam.setAssemblyTime(DateTool.getLocalTimeForDate()); materialTraceabilityParam.setMaterialCode(productionOrderBatchInfoResult.getMaterialCode());//物料编码 materialTraceabilityParam.setMaterialBatchNo(productionOrderBatchInfoResult.getBatch());//物料批次 MaterialTraceabilityService materialTraceabilityService = opc.materialTraceabilityService; materialTraceabilityService.add(materialTraceabilityParam); //更新剩余数量 productionOrderBatchInfoParam.setId(productionOrderBatchInfoResult.getId()); productionOrderBatchInfoParam.setResidueQuantity(remainingQuantity-1);//剩余数量 productionOrderBatchInfoService.update(productionOrderBatchInfoParam); } } } //PC读参数信息 public void handleInfo() throws Exception { logger.info("OP050工位,handleInfo START!"); if(null == list /*|| !S_PRODUCT_CODE_OLD.equals(S_PRODUCT_CODE)*/){ if(group != null){ opc.getServer().removeGroup(group,true); } group = opc.getServer().addGroup(GROUP_NAME); CollectionParamConfParam collectionParamConfParam = new CollectionParamConfParam(); //collectionParamConfParam.setProductCode(S_PRODUCT_CODE); collectionParamConfParam.setLocationCode(LOCATION_CODE); CollectionParamConfService collectionParamConfService = opc.collectionParamConfService; list = collectionParamConfService.findListBySpec(collectionParamConfParam); for(int i=0;i0) { ParamCollectionService paramCollectionService = opc.paramCollectionService; for (int i = 0; i < list.size(); i++) { CollectionParamConfResult result = (CollectionParamConfResult) list.get(i); Item item = result.getItem(); String value = OPCUnit.read(item);//读参数值 ParamCollectionParam paramCollectionParam = new ParamCollectionParam(); paramCollectionParam.setParamCode(result.getParamCode()); paramCollectionParam.setParamName(result.getParamName()); paramCollectionParam.setWorkOrderNo(S_ORDER_CODE); paramCollectionParam.setSfcCode(S_SFC_CODE); paramCollectionParam.setProductCode(S_PRODUCT_CODE); paramCollectionParam.setProductionLine(result.getProductionLine()); paramCollectionParam.setLocationCode(result.getLocationCode()); paramCollectionParam.setParamValue(value); paramCollectionParam.setParamLower(result.getParamLower()); paramCollectionParam.setParamUpper(result.getParamUpper()); paramCollectionParam.setParamStandard(result.getParamCentral()); paramCollectionParam.setCollectionTime(DateTool.getLocalTimeForDate()); paramCollectionParam.setUnit(result.getUnit()); paramCollectionService.add(paramCollectionParam); } } logger.info("OP050工位,handleInfo END!"); } //PC完成 public void handleFinsh() { if("".equals(S_ORDER_CODE)){ IN_TIME = DateTool.getLocalTimeForDate(); S_ORDER_CODE = OPCUnit.read(opc.getOP050_S_ORDER_CODE());//工单编号 S_PRODUCT_TYPE = OPCUnit.read(opc.getOP050_S_PRODUCT_CODE());//产品编号 S_PRODUCT_CODE = GlobalVariable.PRODUCT_CODE_MAP.get(S_PRODUCT_TYPE); S_SFC_CODE = OPCUnit.read(opc.getOP050_S_SFC_CODE());//总成编码 } //处理过站信息 String S_PRODUCT_STATE_CODE = OPCUnit.read(opc.getOP050_S_PRODUCT_STATE_CODE()); PassingStationCollectionParam param = new PassingStationCollectionParam(); param.setWorkOrderNo(S_ORDER_CODE); param.setProductCode(S_PRODUCT_CODE); param.setSfcCode(S_SFC_CODE); param.setProductionLine(PRODUCTION_LINE); param.setLocationCode(LOCATION_CODE); param.setInboundTime(IN_TIME); param.setOutboundTime(DateTool.getLocalTimeForDate()); param.setOutRsSign(S_PRODUCT_STATE_CODE);//出站是否合格 PassingStationCollectionService passingStationCollectionService = opc.passingStationCollectionService; passingStationCollectionService.add(param); String copSfcCode = OPCUnit.read(opc.getOP050_S_SFC_CODE_COP());//COP分总成 String bopSfcCode = OPCUnit.read(opc.getOP050_S_SFC_CODE_BOP());//BOP分总成 //根据分总成编码,将EOP物料数据绑定关系修改为总成编码 MaterialTraceabilityService materialTraceabilityService = opc.materialTraceabilityService; materialTraceabilityService.updateSFC(S_SFC_CODE,copSfcCode); materialTraceabilityService.updateSFC(S_SFC_CODE,bopSfcCode); //根据分总成编码,将EOP过站数据绑定关系修改为总成编码 passingStationCollectionService.updateSFC(S_SFC_CODE,copSfcCode); passingStationCollectionService.updateSFC(S_SFC_CODE,bopSfcCode); //根据分总成编码,将EOP采集数据绑定关系修改为总成编码 ParamCollectionService paramCollectionService = opc.paramCollectionService; paramCollectionService.updateSFC(S_SFC_CODE,copSfcCode); paramCollectionService.updateSFC(S_SFC_CODE,bopSfcCode); logger.info("S_SFC_CODE:"+S_SFC_CODE); logger.info("copSfcCode:"+copSfcCode); logger.info("bopSfcCode:"+bopSfcCode); //查询COP和BOP是否合格 PassingStationCollectionParam passingStationCollectionParam = new PassingStationCollectionParam(); passingStationCollectionParam.setSfcCode(S_SFC_CODE); List passingStationCollectionResultList = opc.passingStationCollectionService.findListBySpec(passingStationCollectionParam); String isProductState = "true"; for(int i=0;i list = productionOrderRecordsService.findListBySpec(productionOrderRecordsParam); if(list.size()>0){ ProductionOrderRecordsResult productionOrderRecordsResult = list.get(0); productionOrderRecordsParam.setId(productionOrderRecordsResult.getId()); productionOrderRecordsParam.setWhetherPass("false"); productionOrderRecordsService.update(productionOrderRecordsParam); } } OPCUnit.write(opc.getOP050_J_PC_FINISH(), "true"); //PC完成 logger.info("OP050工位,handleFinsh PC处理完成!"); } }