From 5245fffadd41c6e83b24c6706e6feb54a6a0ca7b Mon Sep 17 00:00:00 2001
From: rain <167982779@qq.com>
Date: Wed, 10 Apr 2024 15:27:38 +0800
Subject: [PATCH] 修改图斑模块的接口信息，修复航线bug
---
src/main/java/com/dji/sample/patches/service/impl/ShpToDataSourceServiceImpl.java | 70 ++++++++++++++++++++++++++++------
1 files changed, 57 insertions(+), 13 deletions(-)
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 eda379b..563642f 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,48 +1,92 @@
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.PatchesEntity;
+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 com.dji.sample.territory.model.entity.TbDkjbxxEntity;
+import com.dji.sample.wayline.service.IWaylineFileService;
+import org.locationtech.jts.geom.Coordinate;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;
+import javax.sql.DataSource;
import java.io.File;
-import java.io.IOException;
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.ResultSet;
+import java.sql.Statement;
+import java.util.ArrayList;
import java.util.List;
import java.util.UUID;
-
+import static com.dji.sample.patches.utils.FormatConversionUtil.getCentros;
+import static com.dji.sample.patches.utils.MultipartFileTOFileUtil.convert;
+import static com.dji.sample.patches.utils.ZipUtil.*;
import static org.locationtech.jts.io.WKTConstants.POLYGON;
@Service
public class ShpToDataSourceServiceImpl implements ShpToDataSourceService {
+
@Autowired
private ShpToDataSourceMapper mapper;
- private int createTime = 0;
- private int updateTime = 0;
+ @Autowired
+ private IWaylineFileService service;
String head = POLYGON;
- String json;
+// String sourceDir = "src/main/resources/template/wpmz/"; // 源文件夹路径
+ String sourceDir = "/home/drone/server/template/wpmz/"; // 源文件夹路径
- public void insertGeo(MultipartFile file) throws IOException {
- PatchesEntity patches = new PatchesEntity();
+ MultipartFile multipartFile;
+
+ String json;
+ public MultipartFile insertGeo(MultipartFile file, String workspaceId,String waylineName, double airportLat, double airportLon) throws Exception {
+ List<LotInfo> list = new ArrayList<>();
MultipartFileTOFileUtil multipartFileTOFileUtil = new MultipartFileTOFileUtil();
File file1 = multipartFileTOFileUtil.multipartFile2File(file);
List<String> s = ShapeFileUtil.shpToGeoJson(file1);
String[] arr1 = FormatConversionUtil.formatConversion(s);
for (int i = 0; i < arr1.length; i++) {
+ LotInfo lotInfo = new LotInfo();
String temp = arr1[i].trim();
temp = FormatConversionUtil.modifySpacesAndCommas(temp);
json = head + temp;
- patches.setBsm(UUID.randomUUID().toString());
- patches.setCreateTime(createTime);
- patches.setUpdateTime(updateTime);
- patches.setDkfw(json);
- mapper.insert(patches);
+ String uuid = UUID.randomUUID().toString();
+ String bsm = uuid.replaceAll("-", "");
+ lotInfo.setBsm(bsm);
+ lotInfo.setWorkspaceId(workspaceId);
+ lotInfo.setDkfw(json);
+ lotInfo.setDkbh("dkbh" + i);
+ list.add(lotInfo);
+ String strs=getCentros(list);
+ String end =strs.replaceAll("\\(","").replaceAll(", NaN\\)","");
+ String[] points=end.split(",");
+ lotInfo.setXzb(Double.valueOf(points[0]));
+ lotInfo.setYzb(Double.valueOf(points[1]));
+ mapper.insert(lotInfo);
}
+ Coordinate[] coordinates = GeoToolsUtil.getRoutePointOrder(list, airportLat, airportLon);
+ XMLTemplateModel xmlModel = XMLTemplateModel.init(coordinates, list);
+ CreateWaylineFileUtils.createWaylineFile(xmlModel);
+ // 压缩文件夹中的内容
+// String destKMZFile = "src/main/resources/template/kmz/"+waylineName+".kmz"; // 输出的KMZ文件路径
+ String destKMZFile = "/home/drone/server/template/kmz/"+waylineName+".kmz"; // 输出的KMZ文件路径
+ zipFolder(sourceDir, destKMZFile);
+// multipartFile = convert(new File("src/main/resources/template/kmz/"+waylineName+".kmz"));
+ multipartFile = convert(new File("/home/drone/server/template/kmz/"+waylineName+".kmz"));
+ return multipartFile;
+
}
}
+
+
+
--
Gitblit v1.9.3