From 4a50bd93dfcdedb85f117d25f89e67291eb65cf7 Mon Sep 17 00:00:00 2001
From: cjl <276999030@qq.com>
Date: Sat, 14 Oct 2023 10:55:51 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/cjl' into dev

---
 screen-manage/src/main/java/com/moral/api/service/impl/HistorySecondCruiserServiceImpl.java |  156 ++++++++++++++++++++++++++++++++++++++++++++++------
 1 files changed, 138 insertions(+), 18 deletions(-)

diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/HistorySecondCruiserServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/HistorySecondCruiserServiceImpl.java
index 0b2e9af..92da268 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/HistorySecondCruiserServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/HistorySecondCruiserServiceImpl.java
@@ -3,15 +3,18 @@
 import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.moral.api.entity.HistorySecondCruiser;
+import com.moral.api.entity.ManageCoordinateDetail;
 import com.moral.api.entity.Sensor;
 import com.moral.api.entity.SpecialDevice;
 import com.moral.api.mapper.HistorySecondCruiserMapper;
+import com.moral.api.mapper.ManageCoordinateDetailMapper;
 import com.moral.api.mapper.SpecialDeviceMapper;
 import com.moral.api.pojo.dto.cruiser.CruiserDTO;
 import com.moral.api.service.DeviceService;
 import com.moral.api.service.HistorySecondCruiserService;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.moral.api.service.SpecialDeviceService;
+import com.moral.api.util.RoadUtils;
 import com.moral.constant.Constants;
 import com.moral.constant.RedisConstants;
 import com.moral.util.DateUtils;
@@ -24,9 +27,14 @@
 import org.springframework.util.ObjectUtils;
 
 import java.sql.Wrapper;
+import java.util.ArrayList;
 import java.util.Date;
+import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
+import java.util.concurrent.TimeUnit;
+import java.util.regex.Matcher;
+import java.util.regex.Pattern;
 import java.util.stream.Collectors;
 
 /**
@@ -48,6 +56,8 @@
     private SpecialDeviceService specialDeviceService;
     @Autowired
     private SpecialDeviceMapper specialDeviceMapper;
+    @Autowired
+    private ManageCoordinateDetailMapper manageCoordinateDetailMapper;
 
     @Autowired
     private RedisTemplate redisTemplate;
@@ -97,6 +107,7 @@
     @Override
     public List<SpecialDevice> selectCruisers() {
         QueryWrapper<SpecialDevice> wrapper = new QueryWrapper<>();
+        wrapper.select("name","mac");
         wrapper.eq("is_delete",Constants.NOT_DELETE);
         List<SpecialDevice> specialDevices = specialDeviceMapper.selectList(wrapper);
         return specialDevices;
@@ -108,26 +119,135 @@
      * @return
      */
     @Override
-    public List<CruiserDTO> getCruiserInFo(Map<String, Object> params) {
+    public Map<String,Object> getCruiserInFo(Map<String, Object> params) {
+        HashMap<String, Object> map = new HashMap<>();
+        String mac = params.get("mac").toString();
+        String time1 = params.get("time1").toString();
         params.put("dateFormat", "%Y-%m-%d %H:%i:%s");
-        List<CruiserDTO> data = historySecondCruiserMapper.getCruiserInfo(params);
-        List<CruiserDTO> rsCruiser = data.stream().distinct().collect(Collectors.toList());
-        rsCruiser.removeIf(o->{
-            if (ObjectUtils.isEmpty(o.getFlyLon()) || ObjectUtils.isEmpty(o.getFlyLat())) {
-                return true;
-            }
-            double lon = o.getFlyLon();
-            double lat = o.getFlyLat();
-            if (lon < 70 || lon > 150 || lat < 20 || lat > 60) {
-                return true;
-            }
-            return false;
-        });
-        if(CollectionUtils.isEmpty(data)){
-            return null;
+        ArrayList<Object> list = new ArrayList<>();
+        List<CruiserDTO> data = (List<CruiserDTO>) redisTemplate.opsForHash().get(RedisConstants.DATE_COORDINATE, mac + time1);
+//        List<CruiserDTO> data = (List<CruiserDTO>) redisTemplate.opsForValue().get(mac + time1);
+        if (ObjectUtils.isEmpty(data)){
+            data = historySecondCruiserMapper.getCruiserInfo(params);
+            data = data.stream().distinct().collect(Collectors.toList());
+            data.removeIf(o->{
+                if (ObjectUtils.isEmpty(o.getFlyLon()) || ObjectUtils.isEmpty(o.getFlyLat())) {
+                    return true;
+                }
+                double lon = o.getFlyLon();
+                double lat = o.getFlyLat();
+                double[] doubles = RoadUtils.transformWGS84ToBD09(lon, lat);
+                Matcher matcher = Pattern.compile("\\d*\\.\\d{8}").matcher(""+doubles[0]);
+                matcher.find();
+                String s = matcher.group();
+                Matcher matcher1 = Pattern.compile("\\d*\\.\\d{8}").matcher(""+doubles[1]);
+                matcher1.find();
+                String s1 = matcher1.group();
+                o.setFlyLon(Double.parseDouble(s));
+                o.setFlyLat(Double.parseDouble(s1));
+                o.setData(lon+"_"+lat);
+//            o.setFlyLon(doubles[0]);
+//            o.setFlyLat(doubles[1]);
+                if (lon < 70 || lon > 150 || lat < 20 || lat > 60) {
+                    return true;
+                }
+                return false;
+            });
+
+            redisTemplate.opsForHash().put(RedisConstants.DATE_COORDINATE,mac+time1,data);
+            //������������������
+            redisTemplate.opsForHash().getOperations().expire(RedisConstants.DATE_COORDINATE,600, TimeUnit.SECONDS);
+
         }
+
+//        redisTemplate.opsForValue().set(mac+time1,rsCruiser,600, TimeUnit.SECONDS);
+
+        map.put("rsData",data);
+        map.put("data",list);
         log.info(data.size()+"");
-        log.info(rsCruiser.size()+"");
-        return rsCruiser;
+        log.info(data.size()+"");
+        return map;
     }
+
+    @Override
+    public Map<String, Object> getCruiserCompare(Map<String, Object> params) {
+        HashMap<String,Object> rsMap = new HashMap<>();
+        String mac = params.get("mac").toString();
+        String time1 = params.get("time1").toString();
+        ArrayList<ManageCoordinateDetail> rsList1 = new ArrayList<>();
+        params.put("dateFormat", "%Y-%m-%d %H:%i:%s");
+        List<ManageCoordinateDetail> manageCoordinateDetails = manageCoordinateDetailMapper.selectList(null);
+        List<CruiserDTO> cruiserInfo = (List<CruiserDTO>) redisTemplate.opsForHash().get(RedisConstants.DATE_COORDINATE, mac + time1);
+
+        if (ObjectUtils.isEmpty(cruiserInfo)){
+            cruiserInfo = historySecondCruiserMapper.getCruiserInfo(params);
+            cruiserInfo = cruiserInfo.stream().distinct().collect(Collectors.toList());
+            cruiserInfo.removeIf(o->{
+                if (ObjectUtils.isEmpty(o.getFlyLon()) || ObjectUtils.isEmpty(o.getFlyLat())) {
+                    return true;
+                }
+                double lon = o.getFlyLon();
+                double lat = o.getFlyLat();
+                double[] doubles = RoadUtils.transformWGS84ToBD09(lon, lat);
+                Matcher matcher = Pattern.compile("\\d*\\.\\d{8}").matcher(""+doubles[0]);
+                matcher.find();
+                String s = matcher.group();
+                Matcher matcher1 = Pattern.compile("\\d*\\.\\d{8}").matcher(""+doubles[1]);
+                matcher1.find();
+                String s1 = matcher1.group();
+                o.setFlyLon(Double.parseDouble(s));
+                o.setFlyLat(Double.parseDouble(s1));
+                o.setData(lon+"_"+lat);
+//            o.setFlyLon(doubles[0]);
+//            o.setFlyLat(doubles[1]);
+                if (lon < 70 || lon > 150 || lat < 20 || lat > 60) {
+                    return true;
+                }
+                return false;
+            });
+
+            redisTemplate.opsForHash().put(RedisConstants.DATE_COORDINATE,mac+time1,cruiserInfo);
+            //������������������
+            redisTemplate.opsForHash().getOperations().expire(RedisConstants.DATE_COORDINATE,6000, TimeUnit.SECONDS);
+
+        }
+//        List<CruiserDTO> cruiserInfo = historySecondCruiserMapper.getCruiserInfo(params);
+        log.info(""+cruiserInfo.size());
+        if (ObjectUtils.isEmpty(manageCoordinateDetails)){
+            rsMap.put("rsData",cruiserInfo);
+            rsMap.put("data",rsList1);
+            return rsMap;
+        }
+        for (int i=cruiserInfo.size()-1;i>0;i--) {
+            CruiserDTO cruiserDTO = cruiserInfo.get(i);
+            String data = cruiserDTO.getData();
+            String[] rs = data.split("_");
+            String flyLon = rs[0];
+            String flyLat = rs[1];
+//            double lonDouble = Double.parseDouble(flyLon);
+//            double latDouble = Double.parseDouble(flyLat);
+            for (ManageCoordinateDetail manageCoordinateDetail : manageCoordinateDetails) {
+                String latitude = manageCoordinateDetail.getLatitude().toString();
+                String longitude = manageCoordinateDetail.getLongitude().toString();
+//                double lonDouble1 = Double.parseDouble(longitude);
+//                double latDouble1 = Double.parseDouble(latitude);
+//                if (latDouble1==latDouble && lonDouble==lonDouble1){
+                    if (flyLon.equals(longitude) && flyLat.equals(latitude)){
+                    manageCoordinateDetail.setCode(data);
+                    manageCoordinateDetail.setLongitude(cruiserDTO.getFlyLon());
+                    manageCoordinateDetail.setLatitude(cruiserDTO.getFlyLat());
+                    rsList1.add(manageCoordinateDetail);
+                    cruiserInfo.remove(i);
+                    break;
+                }
+            }
+
+        }
+        rsMap.put("rsData",cruiserInfo);
+        rsMap.put("data",rsList1);
+        rsMap.put("message","���"+cruiserInfo.size()+"������������������"+"���������"+(cruiserInfo.size()+rsList1.size())+"���");
+        return rsMap;
+    }
+
+
 }

--
Gitblit v1.8.0