From 9902b8ccf2d4a7a297189a39c5843f52a83c7315 Mon Sep 17 00:00:00 2001
From: ZhuDongming <773644075@qq.com>
Date: Thu, 15 Aug 2019 17:22:33 +0800
Subject: [PATCH] 添加无人机查询最大值和最小值的service实现
---
src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java | 115 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 113 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
index a7fba8d..256baa1 100644
--- a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
@@ -3,9 +3,14 @@
import static com.moral.common.bean.Constants.NULL_VALUE;
import static org.springframework.util.ObjectUtils.isEmpty;
+import java.io.FileNotFoundException;
+import java.io.IOException;
import java.math.BigDecimal;
import java.text.ParseException;
+import java.text.SimpleDateFormat;
import java.time.LocalDate;
+import java.time.LocalDateTime;
+import java.time.format.DateTimeFormatter;
import java.time.temporal.TemporalAdjusters;
import java.util.ArrayList;
import java.util.Arrays;
@@ -36,6 +41,7 @@
import org.springframework.util.ObjectUtils;
import com.alibaba.fastjson.JSON;
+import com.alibaba.fastjson.JSONObject;
import com.alibaba.fastjson.TypeReference;
import com.moral.common.util.CalculateUtils;
import com.moral.common.util.ParameterUtils;
@@ -49,6 +55,7 @@
import com.moral.entity.charts.TimePeriod;
import com.moral.mapper.AlarmDailyMapper;
import com.moral.mapper.DeviceMapper;
+import com.moral.mapper.HistoryMapper;
import com.moral.mapper.HistoryMinutelyMapper;
import com.moral.mapper.SensorMapper;
import com.moral.service.HistoryMinutelyService;
@@ -62,6 +69,9 @@
@Resource
private HistoryMinutelyMapper historyMinutelyMapper;
+
+ @Resource
+ private HistoryMapper historyMapper;
@Resource
private DeviceMapper deviceMapper;
@@ -536,18 +546,30 @@
*/
@Override
public List<Map<String, Object>> getSensorData(Map<String, Object> parameters) {
+ String startTime=parameters.get("startTime").toString();
+ Boolean flag=null;
+ try {
+ flag = DateUtils.isSameDay(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(startTime), new Date());
+ }catch (ParseException e) {
+ e.printStackTrace();
+ }
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>> listMap=null;
+ if(flag){
+ listMap = historyMapper.getSensorDataToday(parameters);
+ }else{
+ 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"));
+ new_map.put("������", map.get("time"));
for (String key : map.keySet()) {
for (Sensor sensor : sensors) {
if (sensor.getSensorKey().equals(key)) {
@@ -565,4 +587,93 @@
}
return listMapNew;
}
+
+ @Override
+ public List<Map<String, Object>> getSensorDataMin(Map<String, Object> parameters) {
+ String startTime=parameters.get("startTime").toString();
+ Boolean flag=null;
+ try {
+ flag = DateUtils.isSameDay(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(startTime), new Date());
+ }catch (ParseException e) {
+ e.printStackTrace();
+ }
+ 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=null;
+ if(flag){
+ listMap = historyMapper.getSensorDataTodayMin(parameters);
+ }else{
+ listMap = historyMinutelyMapper.getSensorDataMin(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("time"));
+ for (String key : map.keySet()) {
+ for (Sensor sensor : sensors) {
+ if (sensor.getSensorKey().equals(key)) {
+ if("e79".equals(key)||"e80".equals(key)||"e81".equals(key)){
+ new_map.put(sensor.getDescription(), StringUtils.scientificCountingConversion(map.get(key).toString().replace("\"", "")));
+ }else{
+ new_map.put(sensor.getDescription(), map.get(key).toString().replace("\"", ""));
+ }
+ }
+ }
+ }
+ listMapNew.add(new_map);
+ new_map = new LinkedHashMap<>();
+ }
+ }
+ return listMapNew;
+ }
+
+ @Override
+ public List<Map<String, Object>> getSensorDataMax(Map<String, Object> parameters) {
+ String startTime=parameters.get("startTime").toString();
+ Boolean flag=null;
+ try {
+ flag = DateUtils.isSameDay(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(startTime), new Date());
+ }catch (ParseException e) {
+ e.printStackTrace();
+ }
+ 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=null;
+ if(flag){
+ listMap = historyMapper.getSensorDataTodayMax(parameters);
+ }else{
+ listMap = historyMinutelyMapper.getSensorDataMax(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("time"));
+ for (String key : map.keySet()) {
+ for (Sensor sensor : sensors) {
+ if (sensor.getSensorKey().equals(key)) {
+ if("e79".equals(key)||"e80".equals(key)||"e81".equals(key)){
+ new_map.put(sensor.getDescription(), StringUtils.scientificCountingConversion(map.get(key).toString().replace("\"", "")));
+ }else{
+ new_map.put(sensor.getDescription(), map.get(key).toString().replace("\"", ""));
+ }
+ }
+ }
+ }
+ listMapNew.add(new_map);
+ new_map = new LinkedHashMap<>();
+ }
+ }
+ return listMapNew;
+ }
+
}
--
Gitblit v1.8.0