From 99cb5ef3a41cc3bdba2f8c6379fc1dd1e77c82a1 Mon Sep 17 00:00:00 2001
From: ZhuDongming <773644075@qq.com>
Date: Tue, 13 Aug 2019 11:06:31 +0800
Subject: [PATCH] 修改无人机sql
---
src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java | 18 +++++++++++++-----
1 files changed, 13 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
index e2e94d3..a7fba8d 100644
--- a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
@@ -41,6 +41,7 @@
import com.moral.common.util.ParameterUtils;
import com.moral.common.util.ReportTimeFormat;
import com.moral.common.util.ResourceUtil;
+import com.moral.common.util.StringUtils;
import com.moral.common.util.ValidateUtil;
import com.moral.entity.Sensor;
import com.moral.entity.charts.DataCondition;
@@ -535,22 +536,29 @@
*/
@Override
public List<Map<String, Object>> getSensorData(Map<String, Object> parameters) {
- parameters.put("sensorKeys", Arrays.asList("e1", "e2", "e3", "e4", "e6", "e7", "e9", "e10", "e11", "e15", "e16", "e17", "e27", "e28", "e76", "e77", "e78", "e79", "e80", "e81"));
- List<Sensor> sensors = sensorMapper.selectByExample(null);
- System.out.println(sensors);
+ List<Sensor> sensors=sensorMapper.getSensorsByMac(parameters);
+ List<String> sensorKeys=new ArrayList<>();
+ for(Sensor sensor:sensors){
+ sensorKeys.add(sensor.getSensorKey());
+ }
+ parameters.put("sensorKeys", sensorKeys);
List<Map<String, Object>> listMap = historyMinutelyMapper.getSensorData(parameters);
List<Map<String, Object>> listMapNew = new ArrayList<>();
Map<String, Object> new_map = new LinkedHashMap<>();
if (CollectionUtils.isNotEmpty(listMap)) {
for (Map<String, Object> map : listMap) {
+ new_map.put("������", map.get("uavDate"));
for (String key : map.keySet()) {
for (Sensor sensor : sensors) {
if (sensor.getSensorKey().equals(key)) {
- new_map.put(sensor.getDescription(), map.get(key));
+ if("e79".equals(key)||"e80".equals(key)||"e81".equals(key)){
+ new_map.put(sensor.getDescription(), StringUtils.scientificCountingConversion(map.get(key).toString())+sensor.getUnit());
+ }else{
+ new_map.put(sensor.getDescription(), map.get(key)+sensor.getUnit());
+ }
}
}
}
- new_map.put("������", map.get("uavDate"));
listMapNew.add(new_map);
new_map = new LinkedHashMap<>();
}
--
Gitblit v1.8.0