新增图斑解析航线文件

rain

2024-04-07 8310296e65e5b013829b206c630180a00ca34045

新增图斑解析航线文件

 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);
    }


}
    @GetMapping("/getFile")
    public ResponseEntity<Resource> download(String waylineName) throws UnsupportedEncodingException {
        return shpToDataSourceServiceImpl.backWayline(waylineName);
    }
}


 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;
}

 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);
        }
    }
}





 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());
        }
    }
}