blame | history | patch | commit | commitdiff | ignore whitespace
rain
2024-06-14 8d9a2d656e4ae007590c622e5f7c228adacdca49 
 src/main/java/com/dji/sample/territory/service/impl/TbFjServiceImpl.java


@@ -1,31 +1,49 @@


package com.dji.sample.territory.service.impl;




import com.alibaba.fastjson.JSON;


import com.alibaba.fastjson.JSONObject;


import com.baomidou.dynamic.datasource.annotation.DS;


import com.dji.sample.media.model.MediaFileEntity;


import com.dji.sample.media.util.ImgUtil;


import com.dji.sample.patches.config.pojo.PatchesConfigPojo;


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


import com.dji.sample.territory.dao.ITbFjMapper;


import com.dji.sample.territory.model.entity.TbFjEntity;


import com.dji.sample.territory.service.ITbFJService;


import com.dji.sample.territory.utils.Sm3Util;


import com.dji.sample.territory.utils.VideoZipUtil;


import com.dji.sample.territory.utils.WaterMarkUtil;


import com.dji.sample.territory.utils.*;


import com.dji.sample.territory.utils.jym.SM2SignVO;


import com.dji.sample.territory.utils.jym.SM2SignVerUtils;


import com.dji.sample.territory.utils.jym.Util;


import org.bouncycastle.crypto.params.ECPrivateKeyParameters;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;




import javax.imageio.ImageIO;


import javax.xml.crypto.Data;


import java.awt.image.BufferedImage;


import java.io.*;


import java.math.BigDecimal;


import java.math.RoundingMode;


import java.net.HttpURLConnection;


import java.net.URL;


import java.nio.charset.StandardCharsets;


import java.nio.file.Files;


import java.text.SimpleDateFormat;


import java.time.Instant;


import java.time.LocalDateTime;


import java.time.ZoneId;


import java.time.format.DateTimeFormatter;


import java.util.ArrayList;


import java.util.Date;


import java.util.List;


import java.util.UUID;




import static com.dji.sample.territory.utils.CoordinateSystemUtil.*;


import static com.dji.sample.territory.utils.SM2SignUtil.getSM2PrivateKey;


import static com.dji.sample.territory.utils.SM2SignUtil.signWithSM2;


import static com.dji.sample.territory.utils.SM3.addJym;


import static com.dji.sample.territory.utils.SM3.sm3;




@Service


@DS("sqlite-ret")


@@ -58,6 +76,13 @@


        return count;


    }




    public void insertOneData(MediaFileEntity mediaFile, LotInfo lotInfo) throws Exception {


        TbFjEntity tbFj = dbConvertToEntity(mediaFile, lotInfo);


        if (tbFj.getFjysgd() == 3000) {


            tbFjMapper.insert(tbFj);


        }


    }




    @Override


    public void deleteData() {


        tbFjMapper.delete(null);


@@ -79,66 +104,80 @@


        Double absoluteAltitude = jsonObject.getDouble("absoluteAltitude");


        Double relativeAltitude = jsonObject.getDouble("relativeAltitude");


        Double gimbalYawDegree = jsonObject.getDouble("gimbalYawDegree");


        Long sj = jsonObject.getLong("createdTime");


        JSONObject shootPosition = jsonObject.getJSONObject("shootPosition");


        Double lat = shootPosition.getDouble("lat");


        Double lng = shootPosition.getDouble("lng");


        double[] coordinates = extractCoordinates(pointWGStoCGCS(lng, lat));


        double x = Double.parseDouble(((formatCoordinate(coordinates[1]))));


        double y = Double.parseDouble(((formatCoordinate(coordinates[0]))));


//        double[] coordinates = extractCoordinates(pointWGStoCGCS(lng, lat));


//        double x = Double.parseDouble(((formatCoordinate(coordinates[1]))));


//        double y = Double.parseDouble(((formatCoordinate(coordinates[0]))));


        //本地数据库没有的数据在FJ表非空用0


        int psjd = 0;


        String fjhxz = "0";


        double psjd = WaterMarkUtil.convertAngle(gimbalYawDegree);


        int pshgj = 0;


        String psry = "0";


        String psry = "中图智绘无人机";


        String zsdm = "23C8CCC61E3042FBA6A658F319337B1A";


        String dklx = "0";


        String xzqdm = "0";


        int fjlx = 1;


        Long pssj = mediaFile.getCreateTime();


        String pstz = "Y";


        String pssj = convertTimestampToDateTime(sj);


        String bsm = UUID.randomUUID().toString();


        String fjmc = mediaFile.getFileName();


        String key = mediaFile.getObjectKey();


        String head = "http://dev.jxpskj.com:9000/cloud-bucket";


        String url = head + key;


        File file = downloadFile(url);


        JSONObject jsons = (JSONObject) (ImgUtil.getInfo(file));


        String str = jsons.toJSONString();


        String newstr = str.replace("+", "");


        JSONObject json = JSON.parseObject(newstr);


        double pitch = json.getDouble("GimbalPitchDegree");


        String focal = json.getString("FocalLength");


        String numberPart = focal.replaceAll("[^\\d]", "");


        int psjj = Integer.parseInt(numberPart);


        json.getString("GimbalYawDegree");


        BufferedImage image = ImageIO.read(file);


        int width = image.getWidth();


        int height = image.getHeight();


        String fjhxz = null;


        //对应图片和视频文件进行不同处理


        boolean endsWith = key.endsWith(".mp4");


        if (!endsWith) {


            file1 = WaterMarkUtil.addWatermark(file, patchesConfigPojo.getUnzip(), pssj, lat, lng,gimbalYawDegree);


            file1 = WaterMarkUtil.addWatermark(file, sj, lat, lng, gimbalYawDegree);


            byte[] bytesArray = Files.readAllBytes(file1.toPath());


            fjhxz= sm3(bytesArray);


            FJ = fileToByteArray(file1);


        } else {


            file1 = VideoZipUtil.compressVideo(file, 800000, 128000, 1280, 720);


            FJ = fileToByteArray(file1);


        }


        String sm3 = Sm3Util.calculateSM3Hash(fjhxz+","+pssj+","+lng+","+lat+","+gimbalYawDegree+","+psjd+","+pshgj+","+psry+","+zsdm);




        byte[] hash = sm3.getBytes(); // 注意：使用SM3或其他哈希算法来计算数据的哈希值


        // 加载私钥


        ECPrivateKeyParameters sm2PrivateKey = getSM2PrivateKey();


        // 使用SM2私钥对哈希值进行签名


        String signatureHex = signWithSM2(hash, sm2PrivateKey);


        StringBuffer buffer=SM3.addStringBuffer(fjhxz,pssj,truncateToSevenDecimalPlaces(lng),truncateToSevenDecimalPlaces(lat),(int)pitch,(int)psjd,pshgj,psry,zsdm);


        String jyms= SM3.addJym(buffer);


        TbFjEntity.TbFjEntityBuilder builder = TbFjEntity.builder();


        if (lotInfo != null) {


            builder.bsm(bsm)


                    .dkbsm(lotInfo.getDkbh())


                    .xzqdm(xzqdm)


                    .dkbsm(lotInfo.getBsm())


                    .xzqdm(lotInfo.getXzqdm())


                    .dklx(dklx)


                    .xdgd(relativeAltitude)


                    .jdgd(absoluteAltitude)


                    .Latitude(x)


                    .longitude(y)


                    .xdgd(truncateToTwoDecimalPlaces(relativeAltitude))


                    .jdgd(truncateToTwoDecimalPlaces(absoluteAltitude))


                    .Latitude(truncateToSevenDecimalPlaces(lat))


                    .longitude(truncateToSevenDecimalPlaces(lng))


                    .fj(FJ)


                    .psjj(psjj)


                    .fjmc(fjmc)


                    .fjlx(fjlx)


                    .psfyj(gimbalYawDegree)


                    .pssj(String.valueOf(pssj))


                    .psjd(psjd)


                    .psfyj(pitch)


                    .pssj(pssj)


                    .psjd((int) psjd)


                    .fjhxz(fjhxz)


                    .pshgj(pshgj)


                    .zsdm(zsdm)


                    .psry(psry)


                    .jym(signatureHex)


                    .jym(jyms)


                    .url(url)


                    .pstz(pstz)


                    .fjyskd(width)


                    .fjysgd(height)


                    .build();


        }


//        else {


@@ -153,7 +192,7 @@


     * @param fileUrl


     * @return


     */


    public File downloadFile(String fileUrl) {


    public static File downloadFile(String fileUrl) {


        File downloadedFile = null;


        try {


            URL url = new URL(fileUrl);


@@ -189,4 +228,33 @@


        fis.close();


        return data;


    }


}




    public static String convertTimestampToDateTime(long timestamp) {


        // 将时间戳转换为 Instant 对象


        Instant instant = Instant.ofEpochMilli(timestamp);




        // 将 Instant 对象转换为 LocalDateTime 对象


        LocalDateTime dateTime = LocalDateTime.ofInstant(instant, ZoneId.systemDefault());




        // 格式化日期时间


        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");


        return dateTime.format(formatter);


    }




    public static Double truncateToTwoDecimalPlaces(Double value) {


        if (value == null) {


            return null;  // 处理null值情况


        }


        BigDecimal bd = new BigDecimal(value).setScale(2, RoundingMode.DOWN);


        return bd.doubleValue();


    }




    public static Double truncateToSevenDecimalPlaces(Double value) {


        if (value == null) {


            return null;  // 处理null值情况


        }


        BigDecimal bd = new BigDecimal(value).setScale(7, RoundingMode.DOWN);


        return bd.doubleValue();




    }


}