From 1af4bd87ce7cb6beef5dd3f448bc09d9fda7abff Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Wed, 26 Jul 2023 14:40:22 +0800
Subject: [PATCH] chore:测试提交

---
 screen-api/src/main/java/com/moral/api/service/impl/HistoryDailyServiceImpl.java  |    6 ++
 screen-api/src/main/java/com/moral/api/mapper/HistorySecondCruiserMapper.java     |    3 +
 screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java |   47 +++++++++++++++--------
 screen-api/src/main/resources/mapper/HistorySecondCruiserMapper.xml               |   10 +++++
 4 files changed, 48 insertions(+), 18 deletions(-)

diff --git a/screen-api/src/main/java/com/moral/api/mapper/HistorySecondCruiserMapper.java b/screen-api/src/main/java/com/moral/api/mapper/HistorySecondCruiserMapper.java
index bbb87da..ac90e66 100644
--- a/screen-api/src/main/java/com/moral/api/mapper/HistorySecondCruiserMapper.java
+++ b/screen-api/src/main/java/com/moral/api/mapper/HistorySecondCruiserMapper.java
@@ -28,4 +28,7 @@
 
     List<Double> getDust(String start,String end,String mac);
 
+
+    List<Map<String,Object>> getAllCruiserData(Map<String,Object> params);
+
 }
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/HistoryDailyServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/HistoryDailyServiceImpl.java
index 060cb1c..b1d5996 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/HistoryDailyServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/HistoryDailyServiceImpl.java
@@ -7,6 +7,7 @@
 import org.springframework.stereotype.Service;
 import org.springframework.util.ObjectUtils;
 
+import java.math.BigDecimal;
 import java.text.ParseException;
 import java.text.SimpleDateFormat;
 import java.util.ArrayList;
@@ -70,7 +71,10 @@
             result.put("avg", Constants.NULL_VALUE);
             return result;
         }
-        result.put("avg", data.get(params.get("sensorCode")));
+        double aDouble = Double.parseDouble(data.get(params.get("sensorCode")).toString());
+        double v = new BigDecimal(aDouble).setScale(1, BigDecimal.ROUND_HALF_UP).doubleValue();
+//        result.put("avg", data.get(params.get("sensorCode")));
+        result.put("avg", ""+v);
         return result;
     }
 
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java
index 65d397d..73e3552 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java
@@ -211,7 +211,10 @@
         String time2 = params.get("time2").toString();
         String rsTime = getTime(time1, time2);
         list.add(rsTime);
-        List<Map<String, Object>> maps = specialDeviceService.carTrajectory(params,false);
+//        List<Map<String, Object>> maps = specialDeviceService.carTrajectory(params,false);
+//        List<Map<String, Object>> maps = HistorySecondCruiserMapper.getCruiserData(params);
+        List<Map<String, Object>> maps = HistorySecondCruiserMapper.getAllCruiserData(params);
+
         if (ObjectUtils.isEmpty(maps)){
             return null;
         }
@@ -223,7 +226,8 @@
             map.put("time1",time3);
             map.put("time2",time4);
             map.put("mac",mac);
-            List<Map<String, Object>> maps1 = specialDeviceService.carTrajectory(map,false);
+//            List<Map<String, Object>> maps1 = specialDeviceService.carTrajectory(map,false);
+            List<Map<String, Object>> maps1 = HistorySecondCruiserMapper.getAllCruiserData(params);
             if (ObjectUtils.isEmpty(maps1)){
                 return null;
             }
@@ -239,7 +243,8 @@
             map.put("time1",time5);
             map.put("time2",time6);
             map.put("mac",mac);
-            List<Map<String, Object>> maps1 = specialDeviceService.carTrajectory(map,false);
+//            List<Map<String, Object>> maps1 = specialDeviceService.carTrajectory(map,false);
+            List<Map<String, Object>> maps1 = HistorySecondCruiserMapper.getAllCruiserData(params);
             if (ObjectUtils.isEmpty(maps1)){
                 return null;
             }
@@ -459,20 +464,28 @@
 
 
         for (Map<String, Object> map : maps) {
-//            String flylon = map.get("flylon").toString();
-//            String flylat = map.get("flylat").toString();
-//            String s = flylon + "-" + flylat;
-//            if (Double.parseDouble(map.get("a34004").toString())>200){
-//
-//            }
-            pm25List.add(Double.parseDouble(map.get("a34004").toString()));
-            pm10List.add(Double.parseDouble(map.get("a34002").toString()));
-            COList.add(Double.parseDouble(map.get("a21005").toString()));
-            SO2List.add(Double.parseDouble(map.get("a21026").toString()));
-            NO2List.add(Double.parseDouble(map.get("a21004").toString()));
-            O3List.add(Double.parseDouble(map.get("a05024").toString()));
-            VOCList.add(Double.parseDouble(map.get("a99054").toString()));
-
+            Map value = JSON.parseObject(map.get("value").toString(), Map.class);
+            if (!ObjectUtils.isEmpty(value.get("a34004"))){
+                pm25List.add(Double.parseDouble(value.get("a34004").toString()));
+            }
+            if (!ObjectUtils.isEmpty(value.get("a34002"))){
+                pm10List.add(Double.parseDouble(value.get("a34002").toString()));
+            }
+            if (!ObjectUtils.isEmpty(value.get("a21005"))){
+                COList.add(Double.parseDouble(value.get("a21005").toString()));
+            }
+            if (!ObjectUtils.isEmpty(value.get("a21026"))){
+                SO2List.add(Double.parseDouble(value.get("a21026").toString()));
+            }
+            if (!ObjectUtils.isEmpty(value.get("a21004"))){
+                NO2List.add(Double.parseDouble(value.get("a21004").toString()));
+            }
+            if (!ObjectUtils.isEmpty(value.get("a05024"))){
+                O3List.add(Double.parseDouble(value.get("a05024").toString()));
+            }
+            if (!ObjectUtils.isEmpty(value.get("a99054"))){
+                VOCList.add(Double.parseDouble(value.get("a99054").toString()));
+            }
         }
 
         //���������������
diff --git a/screen-api/src/main/resources/mapper/HistorySecondCruiserMapper.xml b/screen-api/src/main/resources/mapper/HistorySecondCruiserMapper.xml
index 2f52e18..441d95e 100644
--- a/screen-api/src/main/resources/mapper/HistorySecondCruiserMapper.xml
+++ b/screen-api/src/main/resources/mapper/HistorySecondCruiserMapper.xml
@@ -57,4 +57,14 @@
           AND `time` <![CDATA[>=]]> #{start}
           AND `time` <![CDATA[<=]]> #{end}
     </select>
+
+
+    <select id="getAllCruiserData" resultType="java.util.Map">
+        SELECT
+        `value`
+        FROM `history_second_cruiser`
+        WHERE mac = #{mac}
+        AND `time` <![CDATA[>=]]> #{time1}
+        AND `time` <![CDATA[<=]]> #{time2}
+    </select>
 </mapper>
\ No newline at end of file

--
Gitblit v1.8.0