From 9829070db9b84f43ae1e0e7a48806c8c90a1fbc8 Mon Sep 17 00:00:00 2001
From: kaiyu <404897439@qq.com>
Date: Fri, 16 Oct 2020 13:49:27 +0800
Subject: [PATCH] 建立五分钟数据表以及读取一分钟表数据计算平均值到五分钟表的接口
---
src/main/java/com/moral/task/HistoryFiveMinutelyTask.java | 134 ++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 134 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/moral/task/HistoryFiveMinutelyTask.java b/src/main/java/com/moral/task/HistoryFiveMinutelyTask.java
new file mode 100644
index 0000000..9f2196c
--- /dev/null
+++ b/src/main/java/com/moral/task/HistoryFiveMinutelyTask.java
@@ -0,0 +1,134 @@
+package com.moral.task;
+
+import com.alibaba.fastjson.JSON;
+import com.moral.service.HistoryFiveMinutelyService;
+import com.moral.service.SensorService;
+import com.moral.util.DateUtil;
+import com.xxl.job.core.biz.model.ReturnT;
+import com.xxl.job.core.handler.annotation.XxlJob;
+import org.springframework.stereotype.Component;
+import org.springframework.util.ObjectUtils;
+
+import javax.annotation.Resource;
+import java.text.SimpleDateFormat;
+import java.util.*;
+
+@Component
+public class HistoryFiveMinutelyTask {
+ @Resource
+ HistoryFiveMinutelyService historyFiveMinutelyService;
+
+ @Resource
+ SensorService sensorService;
+
+ @XxlJob("createHistoryFiveMinutelyTb")
+ public ReturnT createHistoryMinutelyTb(String param) {
+ SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+ Date date = new Date();
+ date = DateUtil.rollMon(date, 1);
+ String year = DateUtil.getYear(date);
+ String month = DateUtil.getMonth(date).length() == 1 ? "0".concat(DateUtil.getMonth(date)) : DateUtil.getMonth(date);
+ try {
+ historyFiveMinutelyService.createHistoryFiveMinutelyTable(year + month);
+ } catch (Exception e) {
+ return new ReturnT(500, "������������������������");
+ }
+ return new ReturnT(200, "������������������������");
+ }
+
+
+ /*������������������������������������������������
+ * ������������������������������������������������������������������
+ * EG: 10:15:30 ������10:10--10:15���������
+ * 10:20:30 ������10:15--10:20���������*/
+ @XxlJob("insertHistoryFiveMinutelyTb")
+ public ReturnT insertHistoryFiveMinutely(String param) {
+ /*������������������������������������������������������������������*/
+ Map<String, Object> params = getStartAndEndTime();
+ List<String> sensorKeys = sensorService.getSensorKeys();
+ params.put("sensorKeys", sensorKeys);
+ List<Map<String, Object>> fiveMinutesSensorDatas;
+ try {
+ fiveMinutesSensorDatas = historyFiveMinutelyService.getFiveMinutesSensorData(params);
+ } catch (Exception e) {
+ return new ReturnT(500, "���������������������������");
+ }
+
+ /*������������������������������*/
+ List<Map<String, Object>> insertDatas;
+ try {
+ insertDatas = new ArrayList<>();
+ for (Map<String, Object> data : fiveMinutesSensorDatas) {
+ String mac = (String) data.get("mac");
+ data.remove("mac");
+ Map<String, Object> keyAndValueMap = new LinkedHashMap<>();
+ Map<String, Object> insertDataMap = new LinkedHashMap<>();
+ data.forEach((key, value) -> {
+ key = key.substring(3);
+ List<Object> list = null;
+ if (ObjectUtils.isEmpty(keyAndValueMap.get(key))) {
+ list = new ArrayList<>();
+ } else {
+ list = (List<Object>) keyAndValueMap.get(key);
+ }
+ if (value instanceof Double) {
+ value = String.valueOf(value);
+ value = value.equals("0.0") ? 0 : Double.valueOf((String) value);
+ }
+ list.add(value);
+ keyAndValueMap.put(key, list);
+ });
+ String keyAndValueJson = JSON.toJSONString(keyAndValueMap);
+ insertDataMap.put("mac", mac);
+ insertDataMap.put("time", params.get("start"));
+ insertDataMap.put("json", keyAndValueJson);
+ insertDatas.add(insertDataMap);
+ }
+ } catch (Exception e) {
+ return new ReturnT(500, "������������������");
+ }
+
+ /*������������������������*/
+ historyFiveMinutelyService.insertHistoryFiveMinutely(insertDatas, (String) params.get("yearAndMonth"));
+ return new ReturnT(200, "������������������");
+ }
+
+ /**
+ * @Description: ������������������������������������������������������������������������������������
+ * @Param:
+ * @return:
+ * @Author: ������������
+ * @Date: 2020/10/15
+ */
+ private Map<String, Object> getStartAndEndTime() {
+ Map<String, Object> map = new HashMap<>();
+ SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+ Date date = new Date();
+ String minute = DateUtil.getMinute(date);
+ String year = "";
+ String month = "";
+ String yearAndMonth = "";
+ String startTime = "";
+ String endTime = "";
+ Integer endMinute = Integer.parseInt(String.valueOf(minute.charAt(minute.length() - 1)));
+ if (endMinute >= 5) {
+ StringBuilder time = new StringBuilder(sdf.format(date));
+ startTime = time.replace(15, 19, "0:00").toString();
+ endTime = time.replace(15, 19, "4:00").toString();
+ } else {
+ date = DateUtil.rollMinute(date, -5);
+ StringBuilder time = new StringBuilder(sdf.format(date));
+ startTime = time.replace(15, 19, "5:00").toString();
+ endTime = time.replace(15, 19, "9:00").toString();
+ }
+
+ year = DateUtil.getYear(date);
+ month = DateUtil.getMonth(date);
+ yearAndMonth = year + month;
+ map.put("start", startTime);
+ map.put("end", endTime);
+ map.put("yearAndMonth", yearAndMonth);
+ return map;
+ }
+
+}
--
Gitblit v1.8.0