From 8d9a2d656e4ae007590c622e5f7c228adacdca49 Mon Sep 17 00:00:00 2001
From: rain <167982779@qq.com>
Date: Fri, 14 Jun 2024 10:11:36 +0800
Subject: [PATCH] 统一风格

---
 src/main/java/com/dji/sample/territory/service/impl/TbDkjbxxServiceImpl.java |   89 ++++++++++++++++++++++++++++++++------------
 1 files changed, 64 insertions(+), 25 deletions(-)

diff --git a/src/main/java/com/dji/sample/territory/service/impl/TbDkjbxxServiceImpl.java b/src/main/java/com/dji/sample/territory/service/impl/TbDkjbxxServiceImpl.java
index f3c4b40..135d1e5 100644
--- a/src/main/java/com/dji/sample/territory/service/impl/TbDkjbxxServiceImpl.java
+++ b/src/main/java/com/dji/sample/territory/service/impl/TbDkjbxxServiceImpl.java
@@ -8,16 +8,21 @@
 import com.dji.sample.patches.model.entity.LotInfo;
 import com.dji.sample.patches.utils.GeoToolsUtil;
 import com.dji.sample.patches.utils.MultipartFileTOFileUtil;
+import com.dji.sample.patches.utils.PointPO;
+import com.dji.sample.patches.utils.TimerUtil;
 import com.dji.sample.patches.xml.mode.XMLTemplateModel;
 import com.dji.sample.patches.xml.utils.CreateWaylineFileUtils;
 import com.dji.sample.territory.dao.ITbDkjbxxMapper;
 import com.dji.sample.territory.dao.ITbFjMapper;
 import com.dji.sample.territory.model.entity.TbDkjbxxEntity;
 import com.dji.sample.territory.model.entity.TbFjEntity;
+import com.dji.sample.territory.model.entity.param.UploadUrlParam;
+import com.dji.sample.territory.pojo.TerritoryConfigPojo;
 import com.dji.sample.territory.service.ITbDkjbxxService;
 import org.locationtech.jts.geom.Coordinate;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 import org.springframework.util.FileCopyUtils;
 import org.springframework.web.bind.annotation.PostMapping;
 import org.springframework.web.multipart.MultipartFile;
@@ -25,11 +30,16 @@
 import java.io.*;
 import java.net.HttpURLConnection;
 import java.net.URL;
+import java.net.URLConnection;
 import java.util.ArrayList;
 import java.util.List;
+import java.util.Objects;
+import java.util.UUID;
 
 import static com.dji.sample.patches.utils.MultipartFileTOFileUtil.convert;
 import static com.dji.sample.patches.utils.ZipUtil.zipFolder;
+import static com.dji.sample.territory.utils.CoordinateSystemUtil.*;
+
 
 /**
  * @PROJECT_NAME: drone
@@ -38,13 +48,16 @@
  * @DATE: 2024/4/10 11:19
  */
 @Service
-@DS("sqlite")
+@DS("sqlite-resource")
 public class TbDkjbxxServiceImpl extends ServiceImpl<ITbDkjbxxMapper, TbDkjbxxEntity> implements ITbDkjbxxService {
-    private static final String RESOURCE_FILE_PATH = "DB/resource_db.db";
     @Autowired
-    private ITbDkjbxxMapper mapper;
+    private ITbDkjbxxMapper iTbDkjbxxMapper;
+    @Autowired
+    private TbFjServiceImpl tbFjService;
     @Autowired
     private PatchesConfigPojo patchesConfigPojo;
+    @Autowired
+    private TerritoryConfigPojo territoryConfigPojo;
 
     /**
      * 上传DB文件并覆盖之前DB文件,自动读取数据到本地数据库
@@ -52,15 +65,19 @@
      * @param file
      * @return
      */
-    public ResponseResult<String> uploadFile(MultipartFile file) {
+    public ResponseResult uploadFile(MultipartFile file) {
         if (file.isEmpty()) {
-            return ResponseResult.error("所上传的文件为空");
+            throw new IllegalArgumentException("上传文件为空");
+        }
+        boolean fileName = Objects.requireNonNull(file.getOriginalFilename()).endsWith("db");
+        if (!fileName) {
+            throw new IllegalArgumentException("检查文件是否为db文件");
         }
         try {
             // 获取上传的文件输入流
             InputStream inputStream = file.getInputStream();
             // 创建输出流,将文件内容写入资源文件
-            OutputStream outputStream = new FileOutputStream(RESOURCE_FILE_PATH);
+            OutputStream outputStream = new FileOutputStream(territoryConfigPojo.getResource());
             byte[] buffer = new byte[1024];
             int bytesRead;
             while ((bytesRead = inputStream.read(buffer)) != -1) {
@@ -71,7 +88,7 @@
             return ResponseResult.success("文件上传成功");
         } catch (IOException e) {
             e.printStackTrace();
-            return ResponseResult.error(e.getMessage()); // 将异常信息包含在响应中返回给客户端
+            return ResponseResult.error(e.getMessage());
         }
     }
 
@@ -86,10 +103,11 @@
      * @return MultipartFile 对象,包含压缩后的航迹文件。
      * @throws IOException 如果文件操作失败,则抛出IOException。
      */
+    @Transactional
     public MultipartFile listFile(String workspaceId, String waylineName, double airportLat, double airportLon) throws IOException {
-        List<TbDkjbxxEntity> list = mapper.selectList(null);
+        List<TbDkjbxxEntity> list = iTbDkjbxxMapper.selectList(null);
         List<LotInfo> info = dbConvertToEntity(list);
-        Coordinate[] coordinates = GeoToolsUtil.getRoutePointOrder(info, airportLat, airportLon);
+        List<PointPO> coordinates = GeoToolsUtil.getRoutePointOrder(info, airportLat, airportLon);
         // 创建XML模板模型
         XMLTemplateModel xmlModel = XMLTemplateModel.init(coordinates, info);
         CreateWaylineFileUtils.createWaylineFile(xmlModel, patchesConfigPojo.getTemplate(), patchesConfigPojo.getTargetTemplate(), patchesConfigPojo.getWaylines(), patchesConfigPojo.getTargetWaylines());
@@ -97,8 +115,39 @@
         String destKMZFile = patchesConfigPojo.getDestKMZFile() + waylineName + ".kmz"; // 输出的KMZ文件路径
         zipFolder(patchesConfigPojo.getSourceDir(), destKMZFile);
         // 将压缩文件转换为MultipartFile对象
-        MultipartFile multipartFile = convert(new File(destKMZFile));
-        return multipartFile;
+        return convert(new File(destKMZFile));
+    }
+
+    @Override
+    public ResponseResult uploadUrl(String url,String taskName) {
+        if (url.isEmpty()) {
+            throw new IllegalArgumentException("上传文件为空");
+        }
+        String saveFilePath = territoryConfigPojo.getResource(); // 要保存文件的本地路径
+
+        try {
+            downloadFile(url, saveFilePath);
+            System.out.println("文件下载完成");
+        } catch (IOException e) {
+            System.out.println("下载文件时发生错误:" + e.getMessage());
+        }
+        TimerUtil util=new TimerUtil();
+        util.dbSave(territoryConfigPojo.getResource(),territoryConfigPojo.getResourcesave(),taskName);
+        return ResponseResult.success();
+    }
+    public static void downloadFile(String fileUrl, String saveFilePath) throws IOException {
+        // 创建URL对象
+        URL url = new URL(fileUrl);
+
+        // 打开连接
+        try (BufferedInputStream in = new BufferedInputStream(url.openStream());
+             FileOutputStream fileOutputStream = new FileOutputStream(saveFilePath)) {
+            byte[] dataBuffer = new byte[1024];
+            int bytesRead;
+            while ((bytesRead = in.read(dataBuffer, 0, 1024)) != -1) {
+                fileOutputStream.write(dataBuffer, 0, bytesRead);
+            }
+        }
     }
 
     /**
@@ -114,20 +163,10 @@
             LotInfo.LotInfoBuilder builder = LotInfo.builder();
             if (file != null) {
                 // 从TbDkjbxxEntity实体中提取信息,构建LotInfo对象
-                builder.bsm(file.getBsm())
-                        .bz(file.getBz())
-                        .dkmj(file.getDkmj())
-                        .dkmc(file.getDkmc())
-                        .dkbh(file.getDkbh())
-                        .xmc(file.getXmc())
-                        .xzb(file.getXzb())
-                        .sfbhzdk(file.getSfbhzdk())
-                        .sjlx(file.getSjlx())
-                        .dkfw(file.getDkfw())
-                        .xzqdm(file.getXzqdm())
-                        .yzb(file.getYzb())
-                        .kzxx(file.getKzxx())
-                        .dklx(file.getDklx())
+                builder.bsm(file.getFId())
+                        .dkbh(file.getFTbbh())
+                        .dkfw(file.getFShape())
+                        .xzqdm(file.getFXzqdm())
                         .build();
                 // 将构建好的LotInfo对象添加到infos列表中
                 infos.add(builder.build());

--
Gitblit v1.9.3