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