无人机java后台代码
blame | history | patch | commit | commitdiff | ignore whitespace
rain
2024-04-18 3dae83e56bbdef77404be7b47d19136bb8251c8c 
 src/main/java/com/dji/sample/patches/service/impl/ShpToDataSourceServiceImpl.java


@@ -1,7 +1,6 @@


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.config.pojo.PatchesConfigPojo;


import com.dji.sample.patches.dao.ShpToDataSourceMapper;


import com.dji.sample.patches.model.entity.LotInfo;


import com.dji.sample.patches.service.ShpToDataSourceService;


@@ -15,19 +14,16 @@


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.beans.factory.annotation.Value;


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;


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.*;


@@ -41,17 +37,17 @@




    @Autowired


    private IWaylineFileService service;


    String head = POLYGON;


//    String sourceDir = "src/main/resources/template/wpmz/"; // 源文件夹路径


    String sourceDir = "/home/drone/server/template/wpmz/"; // 源文件夹路径




    MultipartFile multipartFile;


    private String head = POLYGON;


    private MultipartFile multipartFile;




    String json;


    public MultipartFile insertGeo(MultipartFile file, String workspaceId,String waylineName, double airportLat, double airportLon) throws Exception {




    @Autowired


    private PatchesConfigPojo patchesConfigPojo;


    @Transactional


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


        File file1 = MultipartFileTOFileUtil.multipartFile2File(file, patchesConfigPojo.getUnzip());


        List<String> s = ShapeFileUtil.shpToGeoJson(file1);


        String[] arr1 = FormatConversionUtil.formatConversion(s);


        for (int i = 0; i < arr1.length; i++) {


@@ -66,27 +62,61 @@


            lotInfo.setDkfw(json);


            lotInfo.setDkbh("dkbh" + i);


            list.add(lotInfo);


            String strs=getCentros(list);


            String end =strs.replaceAll("\\(","").replaceAll(", NaN\\)","");


            String[] points=end.split(",");


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


        CreateWaylineFileUtils.createWaylineFile(xmlModel,patchesConfigPojo.getTemplate(),patchesConfigPojo.getTargetTemplate(),patchesConfigPojo.getWaylines(),patchesConfigPojo.getTargetWaylines());


        // 压缩文件夹中的内容


//        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"));


        String destKMZFile = patchesConfigPojo.getDestKMZFile() + waylineName + ".kmz"; // 输出的KMZ文件路径


        zipFolder(patchesConfigPojo.getSourceDir(), destKMZFile);


        multipartFile = convert(new File(destKMZFile));


        MultipartFileTOFileUtil.deleteFile(file1);


        return multipartFile;




    }




    @Transactional


    public void savaInMysql(List<TbDkjbxxEntity> list,String workspaceId){


        for (int i = 0; i <list.size() ; i++) {


            LotInfo lotInfo = new LotInfo();


            lotInfo.setWorkspaceId(workspaceId);


            lotInfo=dbConvertToEntity(list.get(i),workspaceId);


            mapper.insert(lotInfo);


        }


    }


    /**


     * 将SQlite数据库中DKJBXX对象转换为LotInfo对象。


     * @param file 需要转换的DKJBXX对象。


     * @return 返回一个构建好的LotInfo对象，包含从数据库实体中转换来的信息。


     */


    private LotInfo dbConvertToEntity(TbDkjbxxEntity file,String workspaceId) {


        LotInfo.LotInfoBuilder builder = LotInfo.builder();


        if (file != null) {


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


                    .workspaceId(workspaceId)


                    .build();


        }


        return builder.build();


    }


}