From e2a02c09b9d087a49ae5dd9f70856967390237de Mon Sep 17 00:00:00 2001 From: bsw215583320 <baoshiwei121@163.com> Date: 星期五, 01 十一月 2024 16:54:23 +0800 Subject: [PATCH] 兼容机台自建配方,实时数据通过mqtt转发 --- jeecg-module-dry/jeecg-module-dry-biz/src/main/java/org/jeecg/modules/dry/service/impl/DryRealTimeDataServiceImpl.java | 181 +++++++++++++++++++++++++++++++++----------- 1 files changed, 135 insertions(+), 46 deletions(-) diff --git a/jeecg-module-dry/jeecg-module-dry-biz/src/main/java/org/jeecg/modules/dry/service/impl/DryRealTimeDataServiceImpl.java b/jeecg-module-dry/jeecg-module-dry-biz/src/main/java/org/jeecg/modules/dry/service/impl/DryRealTimeDataServiceImpl.java index a28e5cd..5c6d723 100644 --- a/jeecg-module-dry/jeecg-module-dry-biz/src/main/java/org/jeecg/modules/dry/service/impl/DryRealTimeDataServiceImpl.java +++ b/jeecg-module-dry/jeecg-module-dry-biz/src/main/java/org/jeecg/modules/dry/service/impl/DryRealTimeDataServiceImpl.java @@ -8,14 +8,20 @@ import org.apache.mina.core.service.IoAcceptor; import org.apache.mina.core.service.IoHandler; import org.apache.mina.core.session.IoSession; +import org.jeecg.common.api.CommonAPI; import org.jeecg.common.api.vo.Result; import org.jeecg.common.config.TenantContext; +import org.jeecg.common.config.mqtoken.UserTokenContext; +import org.jeecg.common.constant.CommonConstant; +import org.jeecg.common.system.util.JwtUtil; import org.jeecg.common.util.RedisUtil; +import org.jeecg.common.util.SpringContextUtils; import org.jeecg.modules.dry.common.CacheConstants; import org.jeecg.modules.dry.entity.*; import org.jeecg.modules.dry.service.*; import org.jeecg.modules.dry.socket.ServerHandler; import org.jeecg.modules.dry.socket.SocketServerConfig; +import org.jeecg.modules.dry.util.DryUtil; import org.jeecg.modules.dry.vo.*; import org.jetbrains.annotations.NotNull; import org.springframework.beans.factory.annotation.Autowired; @@ -43,6 +49,9 @@ private IDryHerbService herbService; @Autowired + private IDryHerbFormulaService dryHerbFormulaService; + + @Autowired private IDryEquipmentService equipmentService; @Autowired @@ -51,14 +60,30 @@ @Autowired private IDryProdRecordService prodRecordService; - @Autowired - private IoAcceptor ioAcceptor; + + private String token; + + + + public String getTemporaryToken() { + if (token == null) { + RedisUtil redisUtil = SpringContextUtils.getBean(RedisUtil.class); + // 妯℃嫙鐧诲綍鐢熸垚Token + token = JwtUtil.sign("admin", "b668043e3ea4bc2d"); + // 璁剧疆Token缂撳瓨鏈夋晥鏃堕棿涓� 5 鍒嗛挓 + redisUtil.set(CommonConstant.PREFIX_USER_TOKEN + token, token); + redisUtil.expire(CommonConstant.PREFIX_USER_TOKEN + token, 5 * 60 * 1000); + } + + return token; + } @Override @Transactional public Result<?> realTimeDataHandle(RealTimeDataVo realTimeDataVo) { TenantContext.setTenant(realTimeDataVo.getTenantid()+""); - log.info("瀹炴椂鏁版嵁锛�"+realTimeDataVo.toString()); + // log.info("瀹炴椂鏁版嵁锛�"+realTimeDataVo.toString()); + // 1 鏌ヨ鎴栧垱寤哄伐鍗� // 1.1 浠巖edis鍙栧嚭宸ュ崟缂撳瓨 @@ -72,10 +97,15 @@ // 鏍规嵁绉熸埛id鍜屽伐鍗曞彿鏌ヨ鏁版嵁搴撴槸鍚︽湁璁板綍锛屾湁鍒欒繑鍥烇紝娌℃湁鍒欐柊澧炰竴鏉″啀杩斿洖 orderVo = getOrSaveDryOrderVoDB(realTimeDataVo); } + if (orderVo == null) { + log.error("宸ュ崟涓嶅瓨鍦紝宸ュ崟鍙凤細"+realTimeDataVo.getWorkorder()+",璁惧锛�" + realTimeDataVo.getMachineid() +",鑽潗锛�" + realTimeDataVo.getName()); + return Result.error("宸ュ崟涓嶅瓨鍦�"); + } // 2 鏇存柊宸ュ崟瀹炴椂鏁版嵁 // 2.1 灏嗗伐鍗曚腑鐨勬暟鎹浛鎹负鏈�鏂版暟鎹� realTimeDataVo.setOrderId(orderVo.getId()); + orderVo.setInitial(realTimeDataVo.getMoisture1()); orderVo.setDryTime(realTimeDataVo.getTime3()); orderVo.setDelay(realTimeDataVo.getDelay()); @@ -99,12 +129,12 @@ orderVo.setState_windbox(realTimeDataVo.getState_windbox()); orderVo.setState_valve(realTimeDataVo.getState_valve()); orderVo.setOrderStatus(realTimeDataVo.getWorkorder_status()); + orderVo.setEqp_status(realTimeDataVo.getEqp_status()); +// orderVo.setEqp_state(realTimeDataVo.getEqp_state()); + orderVo.setWarning(realTimeDataVo.getEqp_warning()); + orderVo.setFault(realTimeDataVo.getEqp_fault()); + orderVo.setLevel(realTimeDataVo.getLevel()); - String fault = realTimeDataVo.getFault(); -// String[] split = fault.split(","); -// for (String s : split) { -// -// } DryOrderTrendVo trendVo = new DryOrderTrendVo(realTimeDataVo); // 2.2 淇濆瓨宸ュ崟鍚按鐜囧彉鍖� 鎴� 閲嶉噺鍙樺寲 @@ -162,7 +192,7 @@ orderVo.getBellowsTemp().put(realTimeDataVo.getTime3(), realTimeDataVo.getTemp2()); // 2.3 鏇存柊鍒皉edis缂撳瓨 redisUtil.hset(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode(), - realTimeDataVo.getTenantid()+"_"+realTimeDataVo.getMachineid(),orderVo, 600000); + realTimeDataVo.getTenantid()+"_"+realTimeDataVo.getMachineid(),orderVo, 60*60); return Result.ok(); } @@ -195,6 +225,7 @@ } // 3 鏁版嵁搴撴病鏈夊垯鏂板涓�鏉℃暟鎹� } else { + orderVo = saveNewOrder(realTimeDataVo); } return orderVo; @@ -205,17 +236,20 @@ * @param realTimeDataVo * @return */ - @NotNull private DryOrderVo saveNewOrder(RealTimeDataVo realTimeDataVo) { DryOrderVo orderVo; // 鏌ヨ鑽潗 - DryHerb herb = queryHerbByIndexTenant(realTimeDataVo); + DryHerbFormula herbFormula = queryHerbByIndexTenant(realTimeDataVo); // 鏌ヨ璁惧 DryEquipment equ = queryEquipmentByCodeTenant(realTimeDataVo); // 鍒涘缓鏂板伐鍗� orderVo = new DryOrderVo(realTimeDataVo); - orderVo.setHerbId(herb.getId()); + if (herbFormula == null) { + log.error("鏈壘鍒拌嵂鏉愶細"+realTimeDataVo.getIndex() +","+realTimeDataVo.getName() +",鏈哄彴锛�" + realTimeDataVo.getMachineid()); + return null; + } + orderVo.setHerbId(herbFormula.getId()); orderVo.setEquId(equ.getId()); DryOrder dryOrder = BeanUtil.toBean(orderVo, DryOrder.class); boolean save = dryOrderService.save(dryOrder); @@ -245,14 +279,16 @@ * @param realTimeDataVo * @return */ - private DryHerb queryHerbByIndexTenant(RealTimeDataVo realTimeDataVo) { - LambdaQueryWrapper<DryHerb> queryWrapper = new LambdaQueryWrapper<>(); - queryWrapper.eq(DryHerb::getTenantId, realTimeDataVo.getTenantid()); - queryWrapper.eq(DryHerb::getCode, realTimeDataVo.getIndex()); - DryHerb one = herbService.getOne(queryWrapper); + private DryHerbFormula queryHerbByIndexTenant(RealTimeDataVo realTimeDataVo) { + LambdaQueryWrapper<DryHerbFormula> queryWrapper = new LambdaQueryWrapper<>(); + queryWrapper.eq(DryHerbFormula::getTenantId, realTimeDataVo.getTenantid()); + queryWrapper.eq(DryHerbFormula::getName, realTimeDataVo.getName()); + DryHerbFormula one = dryHerbFormulaService.getOne(queryWrapper); if (one == null) { - one = new DryHerb(realTimeDataVo); - herbService.save(one); + one = new DryHerbFormula(realTimeDataVo); + DryEquipment dryEquipment = equipmentService.selectByTenantIdEquipmentId(realTimeDataVo.getTenantid() + "", realTimeDataVo.getMachineid()); + one.setEqpType(dryEquipment.getType()); + dryHerbFormulaService.save(one); } return one; } @@ -264,7 +300,7 @@ */ private void saveOrderTrendVo(DryOrderTrendVo trendVo, DryOrderVo orderVo) { //鍒ゆ柇 瀹炴椂鍚按鐜� 鎴� 瀹炴椂閲嶉噺鏈夋病鏈夊彉鍖栵紝鏈夊彉鍖栧垯鏇存柊 - if(orderVo.getTrendVo() == null + if(orderVo.getTrendVo() == null && trendVo != null && trendVo.getWeight() > 0 || trendVo.getWeight() < orderVo.getTrendVo().getWeight() ) { DryOrder byId = dryOrderService.getById(orderVo.getId()); @@ -291,42 +327,57 @@ public Result<?> queryMachineRealTImeData(RealTimeDataVo realTimeDataVo) { TenantContext.setTenant(realTimeDataVo.getTenantid()+""); - + // 鏌ヨ鎵�鏈夋満鍙�,鏌ヨ璇彞缁勮 LambdaQueryWrapper<DryEquipment> queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.eq(DryEquipment::getTenantId, realTimeDataVo.getTenantid()); queryWrapper.eq(DryEquipment::getEnable, "Y"); - + queryWrapper.orderByAsc(DryEquipment::getCode); + // 鏌ヨ鎵�鏈夋満鍙� List<DryEquipment> dryEquipments = equipmentService.list(queryWrapper); + // 鏈哄彴鍒楄〃锛岀敤浜庢晥鐜囧姣� List<String> list = new ArrayList<>(); - + // 鏁堢巼鍒楄〃锛岀敤浜庢晥鐜囧姣� List<Double> dList = new ArrayList<>(); + // 鏌ヨ褰撳墠鏈哄彴宸ュ崟 DryOrderVo orderVo = (DryOrderVo) redisUtil.hget(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode(), realTimeDataVo.getTenantid() + "_" + realTimeDataVo.getMachineid()); - try { + try { + // 濡傛灉鏈夊彲鐢ㄦ満鍙� + if (dryEquipments != null && dryEquipments.size() > 0) { + // 鏌ヨ鍏跺畠鏈哄彴宸ュ崟 + dryEquipments.stream().forEach(item -> { + // 鑾峰彇宸ュ崟 + DryOrderVo order = (DryOrderVo) redisUtil.hget(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode(), realTimeDataVo.getTenantid() + "_" + item.getCode()); + list.add(item.getName().substring(0, item.getName().indexOf('#')+1)); + if (order != null) { + // 璁$畻骞茬嚗鏁堢巼锛岀敤浜庡姣� + DryOrderTrendVo dryOrderTrendVo = order.getDetailList().get(order.getDetailList().size() - 1); + double v = order.getOriginWeight() - dryOrderTrendVo.getWeight(); - - if (dryEquipments != null && dryEquipments.size() > 0) { - dryEquipments.stream().forEach(item -> { - DryOrderVo order = (DryOrderVo) redisUtil.hget(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode(), realTimeDataVo.getTenantid() + "_" + item.getCode()); - if (order != null) { - double v = order.getOriginWeight() - order.getYield(); - list.add(item.getName().substring(0, item.getName().indexOf('#')+1)); - if (v > 0 && order.getDryTime()>0) { - DecimalFormat df = new DecimalFormat("#.00"); - dList.add(Double.valueOf(df.format(v / order.getDryTime() * 60))); - } else { - dList.add(50d); - } - + if (v > 0 && dryOrderTrendVo.getTotalTime()>0) { + DecimalFormat df = new DecimalFormat("#.00"); + dList.add(Double.valueOf(df.format(v / dryOrderTrendVo.getTotalTime() * 60))); + } else { + dList.add(50d); } - }); - } - if (orderVo != null) { - orderVo.setCompEqpNum(list); - orderVo.setCompEqpEffic(dList); - } - }catch (Exception e) { - e.printStackTrace(); + + } else { + // 濡傛灉娌℃湁鐢熶骇锛屾晥鐜囩疆0 + dList.add(0d); + } + + }); } + + if (orderVo != null) { + // 灏嗘晥鐜囧姣旀暟鎹斁鍏ュ綋鍓嶆満鍙板疄鏃舵暟鎹腑杩斿洖 + orderVo.setCompEqpNum(list); + orderVo.setCompEqpEffic(dList); + // 鏌ヨ杩戝崄娆℃晥鐜囧拰鑳借兘鑰楀钩鍧� + dryOrderService.queryRecentOrderAvg(orderVo); + } + }catch (Exception e) { + e.printStackTrace(); + } return Result.ok(orderVo); } @@ -361,4 +412,42 @@ // }); return Result.OK(); } + + + @Override + public Result<?> queryWorkshopStatistics(RealTimeDataVo realTimeDataVo) { + LambdaQueryWrapper<DryEquipment> queryWrapper = new LambdaQueryWrapper<>(); + queryWrapper.eq(DryEquipment::getTenantId, realTimeDataVo.getTenantid()); + queryWrapper.eq(DryEquipment::getEnable, "Y"); + List<DryEquipment> dryEquipments = equipmentService.list(queryWrapper); + DryOrderVo orderVo = new DryOrderVo(); + if (dryEquipments != null && dryEquipments.size() > 0) { + dryEquipments.stream().forEach(item -> { + DryOrderVo order = (DryOrderVo) redisUtil.hget(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode(), realTimeDataVo.getTenantid() + "_" + item.getCode()); + if (order != null) { + orderVo.setEnvHum(order.getEnvHum()); + orderVo.setEnvTemp(order.getEnvTemp()); + double watt = order.getWatt() - order.getDetailList().get(0).getWatt(); + orderVo.setWatt(orderVo.getWatt()==null? watt : orderVo.getWatt() + watt); + double steam = order.getSteam() - order.getDetailList().get(0).getSteam(); + orderVo.setSteam(orderVo.getSteam()==null? steam : orderVo.getSteam() + steam); + orderVo.setOriginWeight(orderVo.getOriginWeight()==null? order.getOriginWeight(): orderVo.getOriginWeight() + order.getOriginWeight()); + + double yield = order.getOriginWeight()*(1-(order.getInitial()/100))/(1-(order.getTarget()/100)); + orderVo.setYield(orderVo.getYield()==null? yield: orderVo.getYield() + yield); + double sub = order.getOriginWeight() - order.getYield(); + orderVo.setReduce(orderVo.getReduce()==null? sub: orderVo.getReduce() + sub); + + + } + }); + } + //redisUtil.get(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode() + return Result.OK(orderVo); + } + + @Override + public Result<?> statisticsDataHandle(StatisticsDataVo statsDataVo) { + return null; + } } -- Gitblit v1.9.3