From f1374915909bb5bddb8d3a7fad84b3955fd69778 Mon Sep 17 00:00:00 2001
From: ZhuDongming <773644075@qq.com>
Date: Mon, 19 Aug 2019 16:55:17 +0800
Subject: [PATCH] 合并sql
---
src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java | 118 ++++++++++++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 96 insertions(+), 22 deletions(-)
diff --git a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
index 472bba7..581029a 100644
--- a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
@@ -5,9 +5,8 @@
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;
@@ -43,7 +42,6 @@
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;
@@ -55,9 +53,6 @@
import com.moral.mapper.HistoryMinutelyMapper;
import com.moral.mapper.SensorMapper;
import com.moral.service.HistoryMinutelyService;
-import com.moral.service.SensorService;
-
-import lombok.val;
@Service
@SuppressWarnings({"unchecked", "unused", "rawtypes"})
@@ -542,21 +537,23 @@
*/
@Override
public List<Map<String, Object>> getSensorData(Map<String, Object> parameters) {
- String startTime=parameters.get("startTime").toString();
- DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
- LocalDateTime now = LocalDateTime.now();
- LocalDateTime datetime = LocalDateTime.parse(startTime, formatter);
- Boolean flag= datetime.isAfter(now.minusHours(1));
- List<Sensor> sensors=sensorMapper.getSensorsByMac(parameters);
- List<String> sensorKeys=new ArrayList<>();
- for(Sensor sensor:sensors){
+ 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){
+ List<Map<String, Object>> listMap = null;
+ if (flag) {
listMap = historyMapper.getSensorDataToday(parameters);
- }else{
+ } else {
listMap = historyMinutelyMapper.getSensorData(parameters);
}
List<Map<String, Object>> listMapNew = new ArrayList<>();
@@ -567,11 +564,7 @@
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())+sensor.getUnit());
- }else{
- new_map.put(sensor.getDescription(), map.get(key)+sensor.getUnit());
- }
+ new_map.put(sensor.getDescription(), new BigDecimal(map.get(key).toString()).stripTrailingZeros().toPlainString() + sensor.getUnit());
}
}
}
@@ -581,4 +574,85 @@
}
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.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("time"));
+ for (String key : map.keySet()) {
+ for (Sensor sensor : sensors) {
+ if (("min" + sensor.getSensorKey()).equals(key)) {
+ new_map.put(sensor.getDescription(), new BigDecimal(map.get(key).toString().replace("\"", "")).stripTrailingZeros().toPlainString());
+ }
+ }
+ }
+ 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.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("time"));
+ for (String key : map.keySet()) {
+ for (Sensor sensor : sensors) {
+ if (("max" + sensor.getSensorKey()).equals(key)) {
+ new_map.put(sensor.getDescription(), new BigDecimal(map.get(key).toString().replace("\"", "")).stripTrailingZeros().toPlainString());
+ }
+ }
+ }
+ listMapNew.add(new_map);
+ new_map = new LinkedHashMap<>();
+ }
+ }
+ return listMapNew;
+ }
+
}
--
Gitblit v1.8.0