From c5c27e7fdbee0d23264558f6abba46f3bdbbe881 Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Mon, 31 Jul 2023 15:47:16 +0800 Subject: [PATCH] chore:解决经纬度丢失问题 --- screen-api/src/main/java/com/moral/api/controller/UAVController.java | 272 +++++++++++++++++++++++++++++++++-------------------- 1 files changed, 169 insertions(+), 103 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/controller/UAVController.java b/screen-api/src/main/java/com/moral/api/controller/UAVController.java index e501a09..1e969e9 100644 --- a/screen-api/src/main/java/com/moral/api/controller/UAVController.java +++ b/screen-api/src/main/java/com/moral/api/controller/UAVController.java @@ -8,6 +8,7 @@ import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; import com.moral.api.entity.HistorySecondUav; import com.moral.api.mapper.HistorySecondUavMapper; +import com.moral.api.pojo.dto.uav.UAVGetBD; import com.moral.api.pojo.dto.uav.UAVGteForDTO; import com.moral.api.pojo.dto.uav.UAVQueryTimeSlotDTO; import com.moral.api.pojo.dto.uav.UAVResultDTO; @@ -77,7 +78,7 @@ @PostMapping("test") public ResultMessage test(@RequestBody Map<String, Object> params){ //������������������������ - if (!params.containsKey("mac") || !params.containsKey("batch") || !params.containsKey("height")|| !params.containsKey("uvasize")) { + if (!params.containsKey("mac") || !params.containsKey("batch") || !params.containsKey("height1")|| !params.containsKey("uvasize")|| !params.containsKey("height2")) { return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg()); } String uvasize = params.get("uvasize").toString(); @@ -86,41 +87,44 @@ ArrayList<Double> flyLatList = new ArrayList<>(); //������ ArrayList<Double> flyLonList = new ArrayList<>(); -// String mac ="p5dnd7a0243591"; -// String time1 ="2023-07-19 14:14:08"; -// String time2 ="2023-07-19 14:35:29"; -// -//// List<UAVResultDTO> uavResultDTOS = historySecondUavMapper.reList(map); -// QueryWrapper<HistorySecondUav> queryWrapper = new QueryWrapper<>(); -// queryWrapper.select("value"); -// queryWrapper.eq("mac",mac); -// queryWrapper.between("time",time1,time2); -// List<HistorySecondUav> historySecondUavs = historySecondUavMapper.selectList(queryWrapper); + List<HistorySecondUav> historySecondUavs = historySecondUavMapper.reList(params); + ArrayList<UAVGetBD> rsBDList = new ArrayList<>(); + for (HistorySecondUav historySecondUav : historySecondUavs) { + UAVGetBD uavGetBD = new UAVGetBD(); + String value = historySecondUav.getValue(); + JSONObject jsonObject = JSONObject.parseObject(value); + + String flylon = jsonObject.get("flylon").toString(); + String flylat = jsonObject.get("flylat").toString(); + //WGS84 ��� ������������ + double[] doubles = transformWGS84ToBD09(Double.parseDouble(flylon), Double.parseDouble(flylat)); + uavGetBD.setFlyLon(doubles[0]); + uavGetBD.setFlyLat(doubles[1]); + uavGetBD.setTime(DateUtils.dateToDateString(historySecondUav.getTime())); + uavGetBD.setValue(value); + rsBDList.add(uavGetBD); +// flyLatList.add(Double.parseDouble(flylat)); +// flyLonList.add(Double.parseDouble(flylon)); + flyLatList.add(doubles[1]); + flyLonList.add(doubles[0]); + } if (ObjectUtils.isEmpty(historySecondUavs)){ return new ResultMessage(ResponseCodeEnum.TARGET_IS_NULL,"null"); } - - for (HistorySecondUav historySecondUav : historySecondUavs) { - String value = historySecondUav.getValue(); - Map map1 = JSON.parseObject(value, Map.class); - flyLatList.add(Double.parseDouble(map1.get("flylat").toString())); - flyLonList.add(Double.parseDouble(map1.get("flylon").toString())); - - } + //������������������������������ Double maxLat = Collections.max(flyLatList); Double maxLon = Collections.max(flyLonList); Double minLat = Collections.min(flyLatList); Double minLon = Collections.min(flyLonList); - //������������������ - String leftTop = minLat +";"+ maxLon; +// String leftTop = minLat +";"+ maxLon; //������ - String rightTop = maxLat +";"+ maxLon; +// String rightTop = maxLat +";"+ maxLon; //������ - String leftBottom = minLat +";" + minLon; +// String leftBottom = minLat +";" + minLon; //������ - String rightBottom = maxLat +";" + minLon; +// String rightBottom = maxLat +";" + minLon; //��������������������� double distance1 = getDistance(maxLon, minLat, maxLon, maxLat); //��������������������� @@ -128,13 +132,13 @@ ArrayList<UAVGteForDTO> list = new ArrayList<>(); //������������ - String [] lefts =new String[]{maxLon.toString(),minLat.toString()}; +// String [] lefts =new String[]{maxLon.toString(),minLat.toString()}; //������2 - String[] youshang = calLocationByDistanceAndLocationAndDirection(90, minLon, maxLat, 50); + String[] youshang = calLocationByDistanceAndLocationAndDirection(90, minLon, maxLat, size); //������2 - String[] youxia = calLocationByDistanceAndLocationAndDirection(180, Double.parseDouble(youshang[0]), Double.parseDouble(youshang[1]), 50); + String[] youxia = calLocationByDistanceAndLocationAndDirection(180, Double.parseDouble(youshang[0]), Double.parseDouble(youshang[1]), size); //������2 - String[] zuoxia = calLocationByDistanceAndLocationAndDirection(180, minLon, maxLat, 50); + String[] zuoxia = calLocationByDistanceAndLocationAndDirection(180, minLon, maxLat, size); for (int i = 0; i <distance2 ; i+=size) { UAVGteForDTO dto1 = new UAVGteForDTO(); @@ -162,39 +166,8 @@ } } } - ArrayList<Integer> list2 = new ArrayList<>(); - ArrayList<UAVResultDTO> uavResultDTOS1 = new ArrayList<>(); - for (UAVGteForDTO uavGteForDTO : list) { - ArrayList<String> list1 = new ArrayList<>(); - ArrayList<String[]> doubleArrayList = new ArrayList<>(); - doubleArrayList.add(uavGteForDTO.getLeftTop()); - doubleArrayList.add(uavGteForDTO.getLeftBottom()); - doubleArrayList.add(uavGteForDTO.getRightTop()); - doubleArrayList.add(uavGteForDTO.getRightBottom()); - UAVResultDTO result = getResults(doubleArrayList); - for (int i = 0; i < historySecondUavs.size(); i++) { - HistorySecondUav historySecondUav = historySecondUavs.get(i); - String value = historySecondUav.getValue(); - Map map1 = JSON.parseObject(value, Map.class); - String flylat = map1.get("flylat").toString(); - String flylon = map1.get("flylon").toString(); - //��������������������������� - boolean flag = isInPolygon(flylon,flylat,doubleArrayList); - if (flag){ - list2.add(list2.size()+1); - list1.add(historySecondUav.getValue()); - historySecondUavs.remove(i); - } - } - uavResultDTOS1.add(result); - } - if (!ObjectUtils.isEmpty(uavResultDTOS1)){ - return new ResultMessage(ResponseCodeEnum.SUCCESS.getCode(), ResponseCodeEnum.SUCCESS.getMsg(),uavResultDTOS1); - - } - - HashMap<String,List<String>> rsMap = new HashMap<>(); + List<String> stringList = new ArrayList<>(); for (UAVGteForDTO uavGteForDTO : list) { ArrayList<String> list1 = new ArrayList<>(); ArrayList<String[]> doubleArrayList = new ArrayList<>(); @@ -202,40 +175,45 @@ doubleArrayList.add(uavGteForDTO.getLeftBottom()); doubleArrayList.add(uavGteForDTO.getRightTop()); doubleArrayList.add(uavGteForDTO.getRightBottom()); + String[] leftTops = uavGteForDTO.getLeftTop(); + String[] rightBottoms = uavGteForDTO.getRightBottom(); + Double x1 = Double.parseDouble(leftTops[0]); + Double x2 = Double.parseDouble(rightBottoms[0]); + Double y1 = Double.parseDouble(leftTops[1]); + Double y2 = Double.parseDouble(rightBottoms[1]); //������������������ - for (int i = 0; i < historySecondUavs.size(); i++) { - HistorySecondUav historySecondUav = historySecondUavs.get(i); - String value = historySecondUav.getValue(); - Map map1 = JSON.parseObject(value, Map.class); - String flylat = map1.get("flylat").toString(); - String flylon = map1.get("flylon").toString(); - //��������������������������� - boolean flag = isInPolygon(flylon,flylat,doubleArrayList); - if (flag){ - list1.add(historySecondUav.getValue()); - historySecondUavs.remove(i); - } - } - //��������������������� - String result = getResult(doubleArrayList); - rsMap.put(result,list1); - } -// for (HistorySecondUav historySecondUav : historySecondUavs) { +// for (int i = 0; i < historySecondUavs.size(); i++) { +// HistorySecondUav historySecondUav = historySecondUavs.get(i); // String value = historySecondUav.getValue(); // Map map1 = JSON.parseObject(value, Map.class); // String flylat = map1.get("flylat").toString(); // String flylon = map1.get("flylon").toString(); // //��������������������������� -// boolean flag = isInPolygon(flylon,flylat,doubleArrayList); +// boolean flag = isInPolygon(flylon,flylat,x1,x2,y1,y2); // if (flag){ -// historySecondUavs.remove(historySecondUav); -// list1.add(historySecondUav.getValue()); +// String time = DateUtils.dateToDateString(historySecondUav.getTime()); +// //historySecondUavs.remove(i); +// if(!stringList.contains(time)){ +// list1.add(historySecondUav.getValue()); +// stringList.add(time); +// } // } // } -// //��������������������� -// String result = getResult(doubleArrayList); -// rsMap.put(result,list1); -// } + for (UAVGetBD uavGetBD : rsBDList) { + boolean flag = isInPolygon(uavGetBD.getFlyLon().toString(),uavGetBD.getFlyLat().toString(),x1,x2,y1,y2); + if (flag){ + String time = uavGetBD.getTime(); + //historySecondUavs.remove(i); + if(!stringList.contains(time)){ + list1.add(uavGetBD.getValue()); + stringList.add(time); + } + } + } + //��������������������� + String result = getResult(doubleArrayList); + rsMap.put(result,list1); + } //��������������������������������������� ArrayList<UAVResultDTO> uavResultDTOS = new ArrayList<>(); @@ -353,16 +331,6 @@ O3Double = O3ArrayList.stream().mapToDouble(Double::doubleValue).average().getAsDouble(); } -// dto.setCoAvg(CODouble); -// dto.setNO2Avg(NODouble); -// dto.setO3Avg(O3Double); -// dto.setTVOCAvg(TVODouble); -// dto.setPM10Avg(PM10Double); -// dto.setPM25Avg(PM25Double); -// dto.setSO2Avg(SODouble); -// dto.setWDAvg(WDDouble); -// dto.setSHAvg(SHDouble); -// dto.setQYAvg(QYDouble); dto.setA21005(CODouble); dto.setA21004(NODouble); dto.setA05024(O3Double); @@ -489,7 +457,7 @@ //��������������� public static String getResult(ArrayList<String[]> doubleArrayList){ -// UAVResultDTO uavResultDTO = new UAVResultDTO(); + int total = doubleArrayList.size(); double X = 0, Y = 0, Z = 0; for (int i = 0; i < total; i++) { @@ -510,14 +478,17 @@ double Lon = Math.atan2(Y, X); double Hyp = Math.sqrt(X * X + Y * Y); double Lat = Math.atan2(Z, Hyp); - + DecimalFormat decimalFormat = new DecimalFormat("#.00000000"); double rsLon = Lon * 180 / Math.PI; double rsLat = Lat * 180 / Math.PI; -// uavResultDTO.setFlyLon(rsLon); -// uavResultDTO.setFlyLat(rsLat); - return rsLon+"_"+rsLat; -// return uavResultDTO; +// double[] doubles = transformWGS84ToGCJ02(rsLon, rsLat); +// String s = transformGCJ02ToBD09(doubles[0], doubles[1]); + + + return decimalFormat.format(rsLon)+"_"+decimalFormat.format(rsLat); +// return rsLon+"_"+rsLat; +// return s; } @@ -661,9 +632,7 @@ double p_x =Double.parseDouble(X); double p_y =Double.parseDouble(Y); Point2D.Double point = new Point2D.Double(p_x, p_y); - List<Point2D.Double> pointList= new ArrayList<Point2D.Double>(); - for (String[] strings : doubleArrayList) { double polygonPoint_x=Double.parseDouble(strings[0]); double polygonPoint_y=Double.parseDouble(strings[1]); @@ -674,4 +643,101 @@ } + public boolean isInPolygon(String X,String Y,double x1,double x2,double y1,double y2){ + boolean result = false; + double x =Double.parseDouble(X); + double y =Double.parseDouble(Y); + if(x >= Math.min(x1, x2) && x <= Math.max(x1, x2) ){ + if(y >= Math.min(y1, y2) && y <= Math.max(y1, y2)){ + result = true; + } + } + return result; + + } + + private static final double x_PI = 3.14159265358979324 * 3000.0 / 180.0; + private static final double PI = 3.1415926535897932384626; + private static final double a = 6378245.0; + private static final double ee = 0.00669342162296594323; + /** + * WGS84 ������ ��� GCJ02 + * + * @param lng ������ + * @param lat ������ + * @return GCJ02 ���������[���������������] + */ + public static double[] transformWGS84ToGCJ02(double lng, double lat) { + if (outOfChina(lng, lat)) { + return new double[]{lng, lat}; + } else { + double dLat = transformLat(lng - 105.0, lat - 35.0); + double dLng = transformLng(lng - 105.0, lat - 35.0); + double redLat = lat / 180.0 * PI; + double magic = Math.sin(redLat); + magic = 1 - ee * magic * magic; + double sqrtMagic = Math.sqrt(magic); + dLat = (dLat * 180.0) / ((a * (1 - ee)) / (magic * sqrtMagic) * PI); + dLng = (dLng * 180.0) / (a / sqrtMagic * Math.cos(redLat) * PI); + double mgLat = lat + dLat; + double mgLng = lng + dLng; + return new double[]{mgLng, mgLat}; + } + } + + private static double transformLat(double lng, double lat) { + double ret = -100.0 + 2.0 * lng + 3.0 * lat + 0.2 * lat * lat + 0.1 * lng * lat + 0.2 * Math.sqrt(Math.abs(lng)); + ret += (20.0 * Math.sin(6.0 * lng * PI) + 20.0 * Math.sin(2.0 * lng * PI)) * 2.0 / 3.0; + ret += (20.0 * Math.sin(lat * PI) + 40.0 * Math.sin(lat / 3.0 * PI)) * 2.0 / 3.0; + ret += (160.0 * Math.sin(lat / 12.0 * PI) + 320 * Math.sin(lat * PI / 30.0)) * 2.0 / 3.0; + return ret; + } + + private static double transformLng(double lng, double lat) { + double ret = 300.0 + lng + 2.0 * lat + 0.1 * lng * lng + 0.1 * lng * lat + 0.1 * Math.sqrt(Math.abs(lng)); + ret += (20.0 * Math.sin(6.0 * lng * PI) + 20.0 * Math.sin(2.0 * lng * PI)) * 2.0 / 3.0; + ret += (20.0 * Math.sin(lng * PI) + 40.0 * Math.sin(lng / 3.0 * PI)) * 2.0 / 3.0; + ret += (150.0 * Math.sin(lng / 12.0 * PI) + 300.0 * Math.sin(lng / 30.0 * PI)) * 2.0 / 3.0; + return ret; + } + /** + * ������������������������������ + * + * @param lng ������ + * @param lat ������ + * @return ��������������������� + */ + public static boolean outOfChina(double lng, double lat) { + return (lng < 72.004 || lng > 137.8347) || (lat < 0.8293 || lat > 55.8271); + } + + /** + * GCJ02 ��������������� + * + * @param lng GCJ02 ������ + * @param lat GCJ02 ������ + * @return ���������������[���������������] + */ + public static double[] transformGCJ02ToBD09(double lng, double lat) { + double z = Math.sqrt(lng * lng + lat * lat) + 0.00002 * Math.sin(lat * x_PI); + double theta = Math.atan2(lat, lng) + 0.000003 * Math.cos(lng * x_PI); + double bd_lng = z * Math.cos(theta) + 0.0065; + double bd_lat = z * Math.sin(theta) + 0.006; + return new double[]{bd_lng, bd_lat}; + } + + + /** + * WGS84 ��� ������������BD09 + * + * @param lng ������ + * @param lat ������ + * @return BD09 ���������[���������������] + */ + public static double[] transformWGS84ToBD09(double lng, double lat) { + double[] lngLat = transformWGS84ToGCJ02(lng, lat); + + return transformGCJ02ToBD09(lngLat[0], lngLat[1]); + } + } -- Gitblit v1.8.0