From da467ef402e3c5ddf87f1c0a1145aebd37bedd13 Mon Sep 17 00:00:00 2001
From: zhaowenyu <35589726@qq.com>
Date: Wed, 12 Nov 2025 20:02:22 +0800
Subject: [PATCH] 2025-11-12 zwy 更改取航线文件从ard_route_information表中取,增加模拟飞行功能.下发任务已成功.执行任务代码暂时注释;

---
 ard-sample/src/main/java/com/ard/sample/wayline/service/impl/WaylineJobServiceImpl.java |  115 +++++++++++++++++++++++++++++++++++++++++++--------------
 1 files changed, 87 insertions(+), 28 deletions(-)

diff --git a/ard-sample/src/main/java/com/ard/sample/wayline/service/impl/WaylineJobServiceImpl.java b/ard-sample/src/main/java/com/ard/sample/wayline/service/impl/WaylineJobServiceImpl.java
index fa62ebc..22581c7 100644
--- a/ard-sample/src/main/java/com/ard/sample/wayline/service/impl/WaylineJobServiceImpl.java
+++ b/ard-sample/src/main/java/com/ard/sample/wayline/service/impl/WaylineJobServiceImpl.java
@@ -1,5 +1,8 @@
 package com.ard.sample.wayline.service.impl;
 
+import com.ard.oss.service.impl.OssServiceContext;
+import com.ard.route.domain.route.ArdRouteInformation;
+import com.ard.route.service.IArdRouteInformationService;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
@@ -29,6 +32,7 @@
 import com.fasterxml.jackson.core.type.TypeReference;
 import com.fasterxml.jackson.databind.ObjectMapper;
 import lombok.extern.slf4j.Slf4j;
+import org.apache.commons.codec.digest.DigestUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.integration.annotation.ServiceActivator;
 import org.springframework.integration.mqtt.support.MqttHeaders;
@@ -37,6 +41,11 @@
 import org.springframework.transaction.annotation.Isolation;
 import org.springframework.transaction.annotation.Transactional;
 import org.springframework.util.CollectionUtils;
+
+import javax.annotation.Resource;
+import java.io.IOException;
+import java.io.InputStream;
+import java.net.MalformedURLException;
 import java.net.URL;
 import java.sql.SQLException;
 import java.time.Instant;
@@ -44,6 +53,8 @@
 import java.time.ZoneId;
 import java.util.*;
 import java.util.stream.Collectors;
+
+import static com.ard.route.util.ToolUtils.kmzPath;
 
 /**
  * @author sean
@@ -58,8 +69,14 @@
     @Autowired
     private IWaylineJobMapper mapper;
 
+//    @Autowired
+//    private IWaylineFileService waylineFileService;
+
     @Autowired
-    private IWaylineFileService waylineFileService;
+    private IArdRouteInformationService _ardRouteInformationService;
+
+    @Resource
+    private OssServiceContext _ossService;
 
     @Autowired
     private IDeviceService deviceService;
@@ -170,13 +187,29 @@
         }
 
         // get wayline file
-        Optional<WaylineFileDTO> waylineFile = waylineFileService.getWaylineByWaylineId(waylineJob.getFileId());
-        if (waylineFile.isEmpty()) {
+//        Optional<WaylineFileDTO> waylineFile = waylineFileService.getWaylineByWaylineId(waylineJob.getFileId());
+//        if (waylineFile.isEmpty()) {
+//            return ResponseResult.error("机场任务航线不存在!");
+//        }
+        // 换航线表
+        ArdRouteInformation ardRouteOpt = _ardRouteInformationService.selectArdRouteInformationById(waylineJob.getFileId());
+        if (ardRouteOpt == null) {
             return ResponseResult.error("机场任务航线不存在!");
         }
 
         // get file url
-        URL url = waylineFileService.getObjectUrl(waylineFile.get().getWaylineId());
+//        URL url = waylineFileService.getObjectUrl(waylineFile.get().getWaylineId());
+        URL url= null;
+        String minioUrl = ardRouteOpt.getMinioUpPath();
+        String md5 = "";
+        try (InputStream inputStream = _ossService.getObject(kmzPath,minioUrl))
+        {
+            md5 = DigestUtils.md5Hex(inputStream);
+            url = new URL(ardRouteOpt.getUpPath());
+        }
+        catch (Exception e) {
+            return ResponseResult.error("机场任务航线文件地址错误!" + e.getMessage());
+        }
 
         WaylineTaskCreateDTO flightTask = WaylineTaskCreateDTO.builder()
                 .flightId(waylineJob.getJobId())
@@ -187,7 +220,13 @@
                 .outOfControlAction(waylineJob.getOutOfControlAction())
                 .file(WaylineTaskFileDTO.builder()
                         .url(url.toString())
-                        .fingerprint(waylineFile.get().getSign())
+//                        .fingerprint(waylineFile.get().getSign())
+                        .fingerprint(md5)
+                        .build())
+                .simulateMission(WaylineSimulateMissionDTO.builder()
+                        .isEnable(param.getSimulateMission().getIsEnable())
+                        .latitude(param.getSimulateMission().getLatitude())
+                        .longitude(param.getSimulateMission().getLongitude())
                         .build())
                 .build();
 
@@ -213,21 +252,22 @@
             return ResponseResult.error("Prepare task ====> Error code: " + serviceReply.getResult());
         }
 
+        // 飞行命令先注释掉
         // Issue an immediate task execution command.
-        if (WaylineTaskTypeEnum.IMMEDIATE.getVal() == waylineJob.getTaskType()) {
-            if (!executeFlightTask(waylineJob.getJobId())) {
-                return ResponseResult.error("Failed to execute job.");
-            }
-        }
-
-        if (WaylineTaskTypeEnum.TIMED.getVal() == waylineJob.getTaskType()) {
-            boolean isAdd = RedisOpsUtils.zAdd(RedisConst.WAYLINE_JOB_TIMED_EXECUTE,
-                     waylineJob.getDockSn() + RedisConst.DELIMITER + waylineJob.getJobId(),
-                    waylineJob.getBeginTime().atZone(ZoneId.systemDefault()).toInstant().toEpochMilli());
-            if (!isAdd) {
-                return ResponseResult.error("Failed to create scheduled job.");
-            }
-        }
+//        if (WaylineTaskTypeEnum.IMMEDIATE.getVal() == waylineJob.getTaskType()) {
+//            if (!executeFlightTask(waylineJob.getJobId())) {
+//                return ResponseResult.error("Failed to execute job.");
+//            }
+//        }
+//
+//        if (WaylineTaskTypeEnum.TIMED.getVal() == waylineJob.getTaskType()) {
+//            boolean isAdd = RedisOpsUtils.zAdd(RedisConst.WAYLINE_JOB_TIMED_EXECUTE,
+//                     waylineJob.getDockSn() + RedisConst.DELIMITER + waylineJob.getJobId(),
+//                    waylineJob.getBeginTime().atZone(ZoneId.systemDefault()).toInstant().toEpochMilli());
+//            if (!isAdd) {
+//                return ResponseResult.error("Failed to create scheduled job.");
+//            }
+//        }
 
         return ResponseResult.success();
     }
@@ -461,8 +501,16 @@
         WaylineJobDTO waylineJob = waylineJobOpt.get();
 
         // get wayline file
-        Optional<WaylineFileDTO> waylineFile = waylineFileService.getWaylineByWaylineId(waylineJob.getFileId());
-        if (waylineFile.isEmpty()) {
+//        Optional<WaylineFileDTO> waylineFile = waylineFileService.getWaylineByWaylineId(waylineJob.getFileId());
+//        if (waylineFile.isEmpty()) {
+//            builder.data(RequestsReply.error(CommonErrorEnum.ILLEGAL_ARGUMENT));
+//            messageSender.publish(topic, builder.build());
+//            return;
+//        }
+        // 修改航线文件名称,从ard_route_information航线表中取;
+        // 换航线表
+        ArdRouteInformation ardRouteOpt = _ardRouteInformationService.selectArdRouteInformationById(waylineJob.getFileId());
+        if (ardRouteOpt == null) {
             builder.data(RequestsReply.error(CommonErrorEnum.ILLEGAL_ARGUMENT));
             messageSender.publish(topic, builder.build());
             return;
@@ -470,16 +518,25 @@
 
         // get file url
         URL url = null;
-        try {
-            url = waylineFileService.getObjectUrl(waylineFile.get().getWaylineId());
+        String minioUrl = ardRouteOpt.getMinioUpPath();
+        String md5 = "";
+        try (InputStream inputStream = _ossService.getObject(kmzPath,minioUrl))
+        {
+            md5 = DigestUtils.md5Hex(inputStream);
+            url = new URL(ardRouteOpt.getUpPath());
+//        }
+//        try {
+//            url = waylineFileService.getObjectUrl(waylineFile.get().getWaylineId());
+//            url = new URL(ardRouteOpt.getUpPath());
             builder.data(RequestsReply.success(WaylineTaskCreateDTO.builder()
                     .file(WaylineTaskFileDTO.builder()
                             .url(url.toString())
-                            .fingerprint(waylineFile.get().getSign())
+//                            .fingerprint(waylineFile.get().getSign())
+                            .fingerprint(md5)
                             .build())
                     .build()));
 
-        } catch (SQLException | NullPointerException e) {
+        } catch (NullPointerException | IOException e) {
             e.printStackTrace();
             builder.data(RequestsReply.error(CommonErrorEnum.ILLEGAL_ARGUMENT));
             messageSender.publish(topic, builder.build());
@@ -572,13 +629,15 @@
         if (entity == null) {
             return null;
         }
-
+        // 修改航线文件名称,从ard_route_information航线表中取;
         WaylineJobDTO.WaylineJobDTOBuilder builder = WaylineJobDTO.builder()
                 .jobId(entity.getJobId())
                 .jobName(entity.getName())
                 .fileId(entity.getFileId())
-                .fileName(waylineFileService.getWaylineByWaylineId(entity.getFileId())
-                        .orElse(WaylineFileDTO.builder().build()).getName())
+//                .fileName(waylineFileService.getWaylineByWaylineId(entity.getFileId())
+//                        .orElse(WaylineFileDTO.builder().build()).getName())
+                .fileName(_ardRouteInformationService.selectArdRouteInformationById(entity.getFileId())
+                        .getFileName())
                 .dockSn(entity.getDockSn())
                 .dockName(deviceService.getDeviceBySn(entity.getDockSn())
                         .orElse(DeviceDTO.builder().build()).getNickname())

--
Gitblit v1.9.3