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 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.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;
|
|
@Autowired
|
private IWaylineFileService service;
|
String head = POLYGON;
|
// String sourceDir = "src/main/resources/template/wpmz/"; // 源文件夹路径
|
String sourceDir = "/home/drone/server/template/wpmz/"; // 源文件夹路径
|
|
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;
|
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;
|
|
}
|
|
}
|
