From 8310296e65e5b013829b206c630180a00ca34045 Mon Sep 17 00:00:00 2001
From: rain <167982779@qq.com>
Date: Sun, 07 Apr 2024 14:52:32 +0800
Subject: [PATCH] 新增图斑解析航线文件
---
src/main/java/com/dji/sample/patches/service/ShpToDataSourceService.java | 9 +
src/main/java/com/dji/sample/patches/utils/ZipUtil.java | 137 ++++++++++++++++++++++++++
src/main/java/com/dji/sample/patches/controller/ShpToDataSourceController.java | 30 +++++-
src/main/java/com/dji/sample/patches/service/impl/ShpToDataSourceServiceImpl.java | 67 ++++++++++++
4 files changed, 230 insertions(+), 13 deletions(-)
diff --git a/src/main/java/com/dji/sample/patches/controller/ShpToDataSourceController.java b/src/main/java/com/dji/sample/patches/controller/ShpToDataSourceController.java
index 3ee3772..acd4d65 100644
--- a/src/main/java/com/dji/sample/patches/controller/ShpToDataSourceController.java
+++ b/src/main/java/com/dji/sample/patches/controller/ShpToDataSourceController.java
@@ -1,26 +1,46 @@
package com.dji.sample.patches.controller;
+import cn.hutool.core.io.FileUtil;
import com.dji.sample.common.model.ResponseResult;
import com.dji.sample.patches.model.entity.LotInfo;
import com.dji.sample.patches.service.impl.ShpToDataSourceServiceImpl;
+import com.dji.sample.patches.utils.ZipUtil;
+import org.apache.tomcat.util.http.fileupload.UploadContext;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.core.io.FileSystemResource;
+import org.springframework.core.io.Resource;
+import org.springframework.http.HttpHeaders;
+import org.springframework.http.MediaType;
+import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
-import java.io.IOException;
+import javax.servlet.ServletOutputStream;
+import javax.servlet.http.HttpServletResponse;
+import java.io.*;
import java.util.List;
+
+import static org.springframework.http.MediaType.parseMediaType;
@RestController
@RequestMapping("${url.patches.prefix}${url.patches.version}")
public class ShpToDataSourceController {
@Autowired
private ShpToDataSourceServiceImpl shpToDataSourceServiceImpl;
+
@PostMapping("/getGeo")
- public ResponseResult<List<LotInfo>> getGeo (@RequestParam("file") MultipartFile file,@RequestParam String workspaceId) throws IOException {
- List<LotInfo> list=shpToDataSourceServiceImpl.insertGeo(file,workspaceId);
- return ResponseResult.success(list);
+ public ResponseResult<List<LotInfo>> getGeo(@RequestParam("file") MultipartFile file,
+ @RequestParam String waylineName,
+ @RequestParam String workspaceId) throws IOException {
+ List<LotInfo> list = shpToDataSourceServiceImpl.insertGeo(file, workspaceId,waylineName);
+ return ResponseResult.success(list);
}
-}
\ No newline at end of file
+ @GetMapping("/getFile")
+ public ResponseEntity<Resource> download(String waylineName) throws UnsupportedEncodingException {
+ return shpToDataSourceServiceImpl.backWayline(waylineName);
+ }
+}
+
diff --git a/src/main/java/com/dji/sample/patches/service/ShpToDataSourceService.java b/src/main/java/com/dji/sample/patches/service/ShpToDataSourceService.java
index e1dd12e..fbd4f8b 100644
--- a/src/main/java/com/dji/sample/patches/service/ShpToDataSourceService.java
+++ b/src/main/java/com/dji/sample/patches/service/ShpToDataSourceService.java
@@ -1,10 +1,17 @@
package com.dji.sample.patches.service;
import com.dji.sample.patches.model.entity.LotInfo;
+import org.springframework.core.io.Resource;
+import org.springframework.http.ResponseEntity;
import org.springframework.web.multipart.MultipartFile;
+
+import java.io.File;
+import java.io.FileNotFoundException;
import java.io.IOException;
+import java.io.UnsupportedEncodingException;
import java.util.List;
public interface ShpToDataSourceService {
- List<LotInfo> insertGeo(MultipartFile file ,String itemId) throws IOException;
+ List<LotInfo> insertGeo(MultipartFile file ,String workspaceId,String waylineName) throws IOException;
+ ResponseEntity<Resource> backWayline(String waylineName) throws FileNotFoundException, UnsupportedEncodingException;
}
diff --git a/src/main/java/com/dji/sample/patches/service/impl/ShpToDataSourceServiceImpl.java b/src/main/java/com/dji/sample/patches/service/impl/ShpToDataSourceServiceImpl.java
index 30cccc9..892c234 100644
--- a/src/main/java/com/dji/sample/patches/service/impl/ShpToDataSourceServiceImpl.java
+++ b/src/main/java/com/dji/sample/patches/service/impl/ShpToDataSourceServiceImpl.java
@@ -1,21 +1,38 @@
package com.dji.sample.patches.service.impl;
+import com.dji.sample.common.error.CommonErrorEnum;
+import com.dji.sample.component.mqtt.model.RequestsReply;
import com.dji.sample.patches.dao.ShpToDataSourceMapper;
import com.dji.sample.patches.model.entity.LotInfo;
import com.dji.sample.patches.service.ShpToDataSourceService;
import com.dji.sample.patches.utils.FormatConversionUtil;
+import com.dji.sample.patches.utils.GeoToolsUtil;
import com.dji.sample.patches.utils.MultipartFileTOFileUtil;
import com.dji.sample.patches.utils.ShapeFileUtil;
+import com.dji.sample.patches.xml.mode.XMLTemplateModel;
+import com.dji.sample.patches.xml.utils.CreateWaylineFileUtils;
+import org.locationtech.jts.geom.Coordinate;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.core.io.FileSystemResource;
+import org.springframework.core.io.Resource;
+import org.springframework.http.HttpHeaders;
+import org.springframework.http.HttpStatus;
+import org.springframework.http.MediaType;
+import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;
import java.io.File;
import java.io.IOException;
+import java.io.UnsupportedEncodingException;
+import java.net.URLEncoder;
+import java.nio.charset.StandardCharsets;
import java.util.ArrayList;
import java.util.List;
import java.util.UUID;
+import static com.dji.sample.common.error.CommonErrorEnum.ILLEGAL_ARGUMENT;
+import static com.dji.sample.patches.utils.ZipUtil.compressToKMZ;
import static org.locationtech.jts.io.WKTConstants.POLYGON;
@Service
@@ -23,9 +40,16 @@
@Autowired
private ShpToDataSourceMapper mapper;
String head = POLYGON;
+ double airportLat = 28.624514734; // 机场纬度
+ double airportLon = 115.856725497; // 机场经度
+
+ String kmlFilePath = "src/main/resources/template/wpmz/template.kml"; // KML文件路径
+ String wpmlFilePath = "src/main/resources/template/wpmz/waylines.wpml"; // WPML文件路径
+ String end = ".kmz";
String json;
- public List<LotInfo> insertGeo(MultipartFile file ,String workspaceId) throws IOException {
- List<LotInfo> list=new ArrayList<>();
+
+ public List<LotInfo> insertGeo(MultipartFile file, String workspaceId, String waylineName) throws IOException {
+ List<LotInfo> list = new ArrayList<>();
MultipartFileTOFileUtil multipartFileTOFileUtil = new MultipartFileTOFileUtil();
File file1 = multipartFileTOFileUtil.multipartFile2File(file);
List<String> s = ShapeFileUtil.shpToGeoJson(file1);
@@ -40,12 +64,49 @@
lotInfo.setBsm(bsm);
lotInfo.setWorkspaceId(workspaceId);
lotInfo.setDkfw(json);
- lotInfo.setDkbh("dkbh"+i);
+ lotInfo.setDkbh("dkbh" + i);
mapper.insert(lotInfo);
list.add(lotInfo);
System.out.println(lotInfo);
}
+ Coordinate[] coordinates = GeoToolsUtil.getRoutePointOrder(list, airportLat, airportLon);
+ XMLTemplateModel xmlModel = XMLTemplateModel.init(coordinates, list);
+ CreateWaylineFileUtils.createWaylineFile(xmlModel);
+ String destinationKMZFilePath = "src/main/resources/template/kmz/" + waylineName + ".kmz";
+ try {
+ compressToKMZ(kmlFilePath, wpmlFilePath, destinationKMZFilePath);
+ System.out.println("Files compressed to KMZ successfully.");
+ } catch (IOException e) {
+ e.printStackTrace();
+ System.out.println("Error compressing files to KMZ: " + e.getMessage());
+ }
return list;
}
+ public ResponseEntity<Resource> backWayline(String fileName) {
+ String name = fileName + end;
+ try {
+ File kmzFile = new File("src/main/resources/template/kmz/" + name);
+ boolean kzm=(kmzFile.exists());
+ System.out.println(kzm);
+ System.out.println(kmzFile);
+ if (!kzm) {
+ System.out.println(kzm);
+ // 如果文件不存在，返回404 Not Found响应
+ return ResponseEntity.status(HttpStatus.NOT_FOUND).body(null);
+ }
+ HttpHeaders headers = new HttpHeaders();
+ headers.add(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=\"" + name + "\"");
+ headers.add(HttpHeaders.CONTENT_TYPE, MediaType.APPLICATION_OCTET_STREAM_VALUE);
+ return ResponseEntity.ok().headers(headers).contentLength(kmzFile.length()).
+ contentType(MediaType.APPLICATION_OCTET_STREAM).body(new FileSystemResource(kmzFile));
+ } catch (Exception e) {
+ e.printStackTrace();
+ return ResponseEntity.status(HttpStatus.INTERNAL_SERVER_ERROR).body(null);
+ }
+ }
}
+
+
+
+
diff --git a/src/main/java/com/dji/sample/patches/utils/ZipUtil.java b/src/main/java/com/dji/sample/patches/utils/ZipUtil.java
index 07107c5..cb593bc 100644
--- a/src/main/java/com/dji/sample/patches/utils/ZipUtil.java
+++ b/src/main/java/com/dji/sample/patches/utils/ZipUtil.java
@@ -1,16 +1,18 @@
package com.dji.sample.patches.utils;
+import com.amazonaws.util.IOUtils;
import org.springframework.context.annotation.Configuration;
-import java.io.File;
-import java.io.FileOutputStream;
-import java.io.IOException;
-import java.io.InputStream;
+
+import javax.servlet.ServletOutputStream;
+import javax.servlet.http.HttpServletResponse;
+import java.io.*;
import java.nio.charset.Charset;
import java.util.ArrayList;
import java.util.Enumeration;
import java.util.List;
import java.util.zip.ZipEntry;
import java.util.zip.ZipFile;
+import java.util.zip.ZipOutputStream;
/**
* @author soulmate丶
@@ -124,5 +126,132 @@
// 空文件的删除
file.delete();
}
+ // 定义一个公共的静态方法zipFolder，用于压缩文件夹
+ // 参数sourceFolderPath是源文件夹的路径，zipFilePath是压缩后的zip文件路径
+ public static boolean zipFolder(String sourceFolderPath, String zipFilePath) {
+ // 创建一个File对象，表示源文件夹
+ File sourceFile = new File(sourceFolderPath);
+ try (
+ // 创建一个FileOutputStream对象，用于向指定的zip文件路径写入数据
+ FileOutputStream fos = new FileOutputStream(zipFilePath);
+ // 创建一个ZipOutputStream对象，用于将压缩数据写入到FileOutputStream中
+ ZipOutputStream zos = new ZipOutputStream(fos)
+ ) {
+ // 调用zipFile方法，开始压缩文件
+ zipFile(sourceFile, sourceFile.getName(), zos);
+ return true;
+ } catch (IOException e) {
+ // 如果在压缩过程中出现异常，打印异常堆栈信息
+ e.printStackTrace();
+ }
+ return false;
+ }
+
+ // 定义一个私有的静态方法zipFile，用于递归地压缩文件和文件夹
+ // 参数fileToZip是需要被压缩的文件或文件夹，fileName是其在zip中的名称，zos是ZipOutputStream对象
+ private static void zipFile(File fileToZip, String fileName, ZipOutputStream zos) throws IOException {
+ // 如果fileToZip是一个隐藏文件，则不进行压缩，直接返回
+ if (fileToZip.isHidden()) {
+ return;
+ }
+ // 如果fileToZip是一个目录（文件夹）
+ if (fileToZip.isDirectory()) {
+ // 如果fileName以"/"结尾，说明已经是一个目录路径，直接创建一个ZipEntry并关闭它
+ if (fileName.endsWith("/")) {
+ zos.putNextEntry(new ZipEntry(fileName));
+ zos.closeEntry();
+ } else {
+ // 否则，需要在fileName后加上"/"，表示这是一个目录路径，然后创建一个ZipEntry并关闭它
+ zos.putNextEntry(new ZipEntry(fileName + "/"));
+ zos.closeEntry();
+ }
+ // 获取fileToZip目录下的所有文件和子目录
+ File[] children = fileToZip.listFiles();
+ for (File childFile : children) {
+ // 递归调用zipFile方法，压缩子文件和子目录
+ zipFile(childFile, fileName + "/" + childFile.getName(), zos);
+ }
+ return;
+ }
+ // 如果fileToZip不是一个目录，那么它就是一个文件，需要被压缩
+ // 创建一个FileInputStream对象，用于读取fileToZip的内容
+ FileInputStream fis = new FileInputStream(fileToZip);
+ // 创建一个ZipEntry对象，表示fileToZip在zip文件中的条目
+ ZipEntry zipEntry = new ZipEntry(fileName);
+ // 在ZipOutputStream中开始一个新的zip条目（即将写入一个文件的内容）
+ zos.putNextEntry(zipEntry);
+ // 创建一个byte数组，作为缓冲区，用于从fileToZip读取数据并写入到zos中
+ byte[] bytes = new byte[1024];
+ int length;
+ // 使用循环从fis中读取数据，并写入到zos中，直到没有数据可读（返回-1）为止
+ while ((length = fis.read(bytes)) >= 0) {
+ zos.write(bytes, 0, length);
+ }
+ // 关闭FileInputStream对象，释放资源
+ fis.close();
+ }
+ public static void compressAndRename(String sourceFilePath, String destinationZipFilePath, String newFileName) throws IOException {
+ FileOutputStream fos = new FileOutputStream(destinationZipFilePath);
+ ZipOutputStream zos = new ZipOutputStream(fos);
+
+ File file = new File(sourceFilePath);
+ FileInputStream fis = new FileInputStream(file);
+
+ ZipEntry zipEntry = new ZipEntry(newFileName);
+ zos.putNextEntry(zipEntry);
+
+ byte[] bytes = new byte[1024];
+ int length;
+ while ((length = fis.read(bytes)) >= 0) {
+ zos.write(bytes, 0, length);
+ }
+
+ zos.closeEntry();
+ fis.close();
+ zos.close();
+ }
+
+ public static void compressToKMZ(String kmlFilePath, String wpmlFilePath, String destinationKMZFilePath) throws IOException {
+ FileOutputStream fos = new FileOutputStream(destinationKMZFilePath);
+ ZipOutputStream zos = new ZipOutputStream(fos);
+
+ byte[] buffer = new byte[1024];
+
+ // 添加KML文件
+ addFileToKMZ(zos, kmlFilePath, "doc.kml", buffer);
+
+ // 添加WPML文件
+ addFileToKMZ(zos, wpmlFilePath, "data.wpml", buffer);
+
+ zos.close();
+ }
+
+ private static void addFileToKMZ(ZipOutputStream zos, String filePath, String entryName, byte[] buffer) throws IOException {
+ File file = new File(filePath);
+ FileInputStream fis = new FileInputStream(file);
+ ZipEntry zipEntry = new ZipEntry(entryName);
+ zos.putNextEntry(zipEntry);
+
+ int length;
+ while ((length = fis.read(buffer)) > 0) {
+ zos.write(buffer, 0, length);
+ }
+
+ fis.close();
+ zos.closeEntry();
+ }
+ public static void main(String[] args) throws IOException {
+ String kmzFileName="航线001";
+ String kmlFilePath = "src/main/resources/template/wpmz/template.kml"; // KML文件路径
+ String wpmlFilePath = "src/main/resources/template/wpmz/waylines.wpml"; // WPML文件路径
+ String destinationKMZFilePath = "src/main/resources/template/zip/" + kmzFileName + ".kmz";
+ try {
+ compressToKMZ(kmlFilePath, wpmlFilePath, destinationKMZFilePath);
+ System.out.println("Files compressed to KMZ successfully.");
+ } catch (IOException e) {
+ e.printStackTrace();
+ System.out.println("Error compressing files to KMZ: " + e.getMessage());
+ }
+ }
}
--
Gitblit v1.9.3