From 9a906b9d83ccd8a638a407eb16a44a44025225c0 Mon Sep 17 00:00:00 2001 From: bsw215583320 <baoshiwei121@163.com> Date: 星期四, 07 十一月 2024 09:03:11 +0800 Subject: [PATCH] 增加设备信息获取mqtt主题和订阅,租户上传设备实时数据时,若服务端无相关设备信息,可通过此接口获取 --- jeecg-module-dry/jeecg-module-dry-biz/src/main/java/org/jeecg/modules/dry/service/impl/DryRealTimeDataServiceImpl.java | 314 ++++++++++++++++++++++++++++++++++++++++++++------- 1 files changed, 268 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 ff8c0df..1c222f0 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 @@ -5,27 +5,47 @@ import com.alibaba.fastjson.TypeReference; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import lombok.extern.slf4j.Slf4j; +import org.apache.mina.core.service.IoAcceptor; +import org.apache.mina.core.service.IoHandler; +import org.apache.mina.core.session.IoSession; +import org.apache.shiro.SecurityUtils; +import org.eclipse.paho.client.mqttv3.MqttClient; +import org.eclipse.paho.client.mqttv3.MqttException; +import org.eclipse.paho.client.mqttv3.MqttMessage; +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.constant.MqttConstant; +import org.jeecg.common.system.util.JwtUtil; +import org.jeecg.common.system.vo.LoginUser; 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.DryEquipment; -import org.jeecg.modules.dry.entity.DryHerb; -import org.jeecg.modules.dry.entity.DryOrder; -import org.jeecg.modules.dry.entity.DryOrderTrend; +import org.jeecg.modules.dry.entity.*; +import org.jeecg.modules.dry.mqtt.MqttUtil; import org.jeecg.modules.dry.service.*; -import org.jeecg.modules.dry.vo.DryOrderTrendVo; -import org.jeecg.modules.dry.vo.DryOrderVo; -import org.jeecg.modules.dry.vo.RealTimeDataVo; +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; +import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; +import javax.security.auth.login.LoginContext; +import java.io.IOException; +import java.io.ObjectOutputStream; +import java.net.Socket; import java.text.DecimalFormat; import java.util.ArrayList; import java.util.List; import java.util.Map; +import java.util.Set; + @Slf4j @Service public class DryRealTimeDataServiceImpl implements IDryRealTimeDataService { @@ -38,16 +58,45 @@ private IDryHerbService herbService; @Autowired + private IDryHerbFormulaService dryHerbFormulaService; + + @Autowired private IDryEquipmentService equipmentService; @Autowired private RedisUtil redisUtil; + @Autowired + private IDryProdRecordService prodRecordService; + + + private String token; + + @Value(value = "${jeecg.mqtt.role}") + private String role; + + @Autowired + private MqttUtil mqttUtil; + + 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鍙栧嚭宸ュ崟缂撳瓨 @@ -61,10 +110,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()); @@ -88,14 +142,70 @@ 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()); + + DryOrderTrendVo trendVo = new DryOrderTrendVo(realTimeDataVo); // 2.2 淇濆瓨宸ュ崟鍚按鐜囧彉鍖� 鎴� 閲嶉噺鍙樺寲 + + if(realTimeDataVo.getReport_flag()) { + DryProdRecord prodRecord = new DryProdRecord(); + prodRecord.setReportHeadName(realTimeDataVo.getReport_head_name()); + prodRecord.setReportHeadBatch(realTimeDataVo.getReport_head_batch()); + prodRecord.setReportHeadNum(realTimeDataVo.getReport_head_num()); + prodRecord.setReportHeadMachine(realTimeDataVo.getReport_head_machine()); + prodRecord.setReportHeadAccepter(realTimeDataVo.getReport_head_accepter()); + prodRecord.setReportHeadDate(realTimeDataVo.getReport_head_date()); + prodRecord.setReportHeadLeader(realTimeDataVo.getReport_head_leader()); + prodRecord.setReportHeadTecher(realTimeDataVo.getReport_head_techer()); + + prodRecord.setReportCheckField(realTimeDataVo.getReport_check_field()?1:0); + prodRecord.setReportCheckFile(realTimeDataVo.getReport_check_file()?1:0); + prodRecord.setReportCheckTag(realTimeDataVo.getReport_check_tag()?1:0); + prodRecord.setReportCheckTool(realTimeDataVo.getReport_check_tool()?1:0); + prodRecord.setReportCheckMan(realTimeDataVo.getReport_check_man()); + prodRecord.setReportCheckStatus(realTimeDataVo.getReport_check_status()?1:0); + prodRecord.setReportCheckQa(realTimeDataVo.getReport_check_qa()); + prodRecord.setReportCheckRecord(realTimeDataVo.getReport_check_record()); + + prodRecord.setReportProductView(realTimeDataVo.getReport_product_view()?1:0); + prodRecord.setReportProductWind(realTimeDataVo.getReport_product_wind()?1:0); + prodRecord.setReportProductSun(realTimeDataVo.getReport_product_sun()?1:0); + prodRecord.setReportProductLowDry(realTimeDataVo.getReport_product_low_dry()?1:0); + prodRecord.setReportProductDry(realTimeDataVo.getReport_product_dry()?1:0); + prodRecord.setReportProductStart(realTimeDataVo.getReport_product_start()); + prodRecord.setReportProductEnd(realTimeDataVo.getReport_product_end()); + prodRecord.setReportProductTotal(realTimeDataVo.getReport_product_total()); + prodRecord.setReportProductCheck(realTimeDataVo.getReport_product_check()?1:0); + prodRecord.setReportProductMan1(realTimeDataVo.getReport_product_man1()); + prodRecord.setReportProductMan2(realTimeDataVo.getReport_product_man2()); + prodRecord.setReportProductWeight(realTimeDataVo.getReport_product_weight()); + prodRecord.setReportProductWaste(realTimeDataVo.getReport_product_waste()); + prodRecord.setReportProductUse(realTimeDataVo.getReport_product_use()); + prodRecord.setReportProductQa(realTimeDataVo.getReport_product_qa()); + + prodRecord.setReportCleanMachine(realTimeDataVo.getReport_clean_machine()?1:0); + prodRecord.setReportCleanWaste(realTimeDataVo.getReport_clean_waste()?1:0); + prodRecord.setReportCleanTool(realTimeDataVo.getReport_clean_tool()?1:0); + prodRecord.setReportCleanDoor(realTimeDataVo.getReport_clean_door()?1:0); + prodRecord.setReportCleanBox(realTimeDataVo.getReport_clean_box()?1:0); + prodRecord.setReportCleanRecord(realTimeDataVo.getReport_clean_record()?1:0); + prodRecord.setReportCleanDate(realTimeDataVo.getReport_clean_date()); + prodRecord.setReportCleanMan(realTimeDataVo.getReport_clean_man()); + prodRecord.setReportCleanConfirm(realTimeDataVo.getReport_clean_confirm()?1:0); + prodRecord.setReportCleanQa(realTimeDataVo.getReport_clean_qa()); + prodRecordService.save(prodRecord); + } saveOrderTrendVo(trendVo, orderVo); orderVo.setTrendVo(trendVo); 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(); } @@ -128,6 +238,7 @@ } // 3 鏁版嵁搴撴病鏈夊垯鏂板涓�鏉℃暟鎹� } else { + orderVo = saveNewOrder(realTimeDataVo); } return orderVo; @@ -138,17 +249,26 @@ * @param realTimeDataVo * @return */ - @NotNull private DryOrderVo saveNewOrder(RealTimeDataVo realTimeDataVo) { DryOrderVo orderVo; - // 鏌ヨ鑽潗 - DryHerb herb = queryHerbByIndexTenant(realTimeDataVo); + // 鏌ヨ璁惧 DryEquipment equ = queryEquipmentByCodeTenant(realTimeDataVo); + if (equ == null) { + log.error("鏈壘鍒拌澶囷細"+realTimeDataVo.getIndex() +","+realTimeDataVo.getName() +",鏈哄彴锛�" + realTimeDataVo.getMachineid()); + return null; + } + // 鏌ヨ鑽潗 + DryHerbFormula herbFormula = queryHerbByIndexTenant(realTimeDataVo); + if (herbFormula == null) { + log.error("鏈壘鍒拌嵂鏉愶細"+realTimeDataVo.getIndex() +","+realTimeDataVo.getName() +",鏈哄彴锛�" + realTimeDataVo.getMachineid()); + return null; + } // 鍒涘缓鏂板伐鍗� orderVo = new DryOrderVo(realTimeDataVo); - orderVo.setHerbId(herb.getId()); + + orderVo.setHerbId(herbFormula.getId()); orderVo.setEquId(equ.getId()); DryOrder dryOrder = BeanUtil.toBean(orderVo, DryOrder.class); boolean save = dryOrderService.save(dryOrder); @@ -167,8 +287,23 @@ queryWrapper.eq(DryEquipment::getCode, realTimeDataVo.getMachineid()); DryEquipment one = equipmentService.getOne(queryWrapper); if (one == null) { - one = new DryEquipment(realTimeDataVo); - equipmentService.save(one); + log.error(role+"淇濆瓨瀹炴椂鏁版嵁锛屾湭鎵惧埌璁惧锛�"+realTimeDataVo.getMachineid()); +// one = new DryEquipment(realTimeDataVo); +// equipmentService.save(one); + if (MqttConstant.ROLE_ADMIN.equals(role)) { + MqttMessage mqttMessage = new MqttMessage(); + mqttMessage.setQos(0); + JSONObject object = new JSONObject(); + object.put("code", realTimeDataVo.getMachineid()); + mqttMessage.setPayload(object.toJSONString().getBytes()); + try { + mqttUtil.getMqttClient().publish(String.format(MqttConstant.SERVICE_REQ_EQUIPMENT, TenantContext.getTenant()) ,mqttMessage); + }catch (MqttException e) { + e.printStackTrace(); + } + + } + return null; } return one; } @@ -178,14 +313,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; } @@ -197,7 +334,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()); @@ -224,42 +361,127 @@ 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 (v > 0 && dryOrderTrendVo.getTotalTime()>0) { + DecimalFormat df = new DecimalFormat("#.00"); + dList.add(Double.valueOf(df.format(v / dryOrderTrendVo.getTotalTime() * 60))); + } else { + dList.add(50d); + } + + } 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); + } - 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) { - DecimalFormat df = new DecimalFormat("#.00"); - dList.add(Double.valueOf(df.format(v / order.getDryTime() * 60))); - } else { - dList.add(50d); + @Override + public Result<?> sendSocketMsg(CommandMessageVo msgVo) { + + + DryEquipment dryEquipment = equipmentService.selectByTenantIdEquipmentId(msgVo.getTenantId() + "", msgVo.getMachineId()); + log.info("鑾峰彇璁惧锛�" + dryEquipment.toString()); + + // managedSessions.keySet().forEach(addr -> { + // ObjectOutputStream oos = null; + try { +// Socket socket = SocketServerConfig.clientMap.get(addr); + IoSession session = ServerHandler.clientSocket.get(dryEquipment.getIp()); + if (session == null) { + return Result.error("鏈幏鍙栧埌session,璇锋鏌ュ鎴风閰嶇疆鎴栬澶噄p閰嶇疆鏄惁姝e父"); } + SocketMsgVo smv = new SocketMsgVo(msgVo); + session.write(JSONObject.toJSONString(smv)); +// oos = new ObjectOutputStream(socket.getOutputStream()); +// String s = JSONObject.toJSONString(new SocketMsgVo(msgVo)); +// oos.writeUTF(s); +// oos.flush(); + + } catch (Exception e) { + throw new RuntimeException(e); + } finally { } - }); + // }); + return Result.OK(); } - if (orderVo != null) { - orderVo.setCompEqpNum(list); - orderVo.setCompEqpEffic(dList); + + + @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); } -}catch (Exception e) { - e.printStackTrace(); -} - return Result.ok(orderVo); + + @Override + public Result<?> statisticsDataHandle(StatisticsDataVo statsDataVo) { + return null; } } -- Gitblit v1.9.3