From 3649b739991d079ee1669f02c60b3ee01c2877e1 Mon Sep 17 00:00:00 2001 From: lizijie <lzjiiie@163.com> Date: Mon, 02 Sep 2019 17:14:51 +0800 Subject: [PATCH] 空气质量对比 --- src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java | 128 ++++++++++-------------------------------- 1 files changed, 32 insertions(+), 96 deletions(-) diff --git a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java index 581029a..ba6fc1a 100644 --- a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java +++ b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java @@ -7,6 +7,8 @@ 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; @@ -536,14 +538,13 @@ * @return */ @Override - public List<Map<String, Object>> getSensorData(Map<String, Object> parameters) { + public List<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(); - } + DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); + LocalDateTime startTimeLocalDateTime = LocalDateTime.parse(startTime, dateTimeFormatter); + LocalDate today = LocalDate.now(); + LocalDate startTimeLocalDate=startTimeLocalDateTime.toLocalDate(); + Boolean flag=today.isEqual(startTimeLocalDate); List<Sensor> sensors = sensorMapper.getSensorsByMac(parameters); List<String> sensorKeys = new ArrayList<>(); for (Sensor sensor : sensors) { @@ -556,103 +557,38 @@ } else { listMap = historyMinutelyMapper.getSensorData(parameters); } - List<Map<String, Object>> listMapNew = new ArrayList<>(); - Map<String, Object> new_map = new LinkedHashMap<>(); + List<List<Map<String, Object>>> listMaps = new ArrayList<>(); + List<Map<String, Object>> listMapAvg = new ArrayList<>(); + List<Map<String, Object>> listMapMin = new ArrayList<>(); + List<Map<String, Object>> listMapMax = new ArrayList<>(); if (CollectionUtils.isNotEmpty(listMap)) { for (Map<String, Object> map : listMap) { - new_map.put("������", map.get("time")); - for (String key : map.keySet()) { + Map<String, Object> mapAvg = new LinkedHashMap<>(); + Map<String, Object> mapMin = new LinkedHashMap<>(); + Map<String, Object> mapMax = new LinkedHashMap<>(); + mapAvg.put("time", map.get("time")); + mapMin.put("time", map.get("time")); + mapMax.put("time", map.get("time")); + for (Entry<String,Object> entry : map.entrySet()) { for (Sensor sensor : sensors) { - if (sensor.getSensorKey().equals(key)) { - new_map.put(sensor.getDescription(), new BigDecimal(map.get(key).toString()).stripTrailingZeros().toPlainString() + sensor.getUnit()); + if (sensor.getSensorKey().equals(entry.getKey())) { + mapAvg.put(entry.getKey(), new BigDecimal(entry.getValue().toString()).stripTrailingZeros().toPlainString() + sensor.getUnit()); + } else if (("min" + sensor.getSensorKey()).equals(entry.getKey())) { + mapMin.put(entry.getKey().substring(3), new BigDecimal(entry.getValue().toString().replace("\"", "")).stripTrailingZeros().toPlainString()); + } else if (("max" + sensor.getSensorKey()).equals(entry.getKey())) { + mapMax.put(entry.getKey().substring(3), new BigDecimal(entry.getValue().toString().replace("\"", "")).stripTrailingZeros().toPlainString()); } } } - listMapNew.add(new_map); - new_map = new LinkedHashMap<>(); + listMapAvg.add(mapAvg); + listMapMin.add(mapMin); + listMapMax.add(mapMax); } + listMaps.add(listMapAvg); + listMaps.add(listMapMin); + listMaps.add(listMapMax); } - 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; + return listMaps; } } -- Gitblit v1.8.0