From 3aa63f15b853e9103a906102c46d26784be7655e Mon Sep 17 00:00:00 2001
From: ZhuDongming <773644075@qq.com>
Date: Thu, 15 Aug 2019 17:23:45 +0800
Subject: [PATCH] 添加无人机历史查询最大值和最小值的sql语句
---
src/main/java/com/moral/mapper/HistoryMinutelyMapper.java | 24 +++++++++++++++++++++---
1 files changed, 21 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/moral/mapper/HistoryMinutelyMapper.java b/src/main/java/com/moral/mapper/HistoryMinutelyMapper.java
index cfc8941..8c8bb48 100644
--- a/src/main/java/com/moral/mapper/HistoryMinutelyMapper.java
+++ b/src/main/java/com/moral/mapper/HistoryMinutelyMapper.java
@@ -1,12 +1,30 @@
package com.moral.mapper;
+import com.moral.entity.charts.DataCondition;
+import com.moral.entity.charts.TimePeriod;
+
+import org.apache.ibatis.annotations.Param;
+
import java.util.List;
import java.util.Map;
-public interface HistoryMinutelyMapper{
+public interface HistoryMinutelyMapper {
- Map<String, Double> getSersionAvgByDevice(Map<String, Object> parameters);
+ Map<String, Double> getSersionAvgByDevice(Map<String, Object> parameters);
- List<Map<String, Object>> getMonitorPointOrDeviceAvgData(Map<String, Object> parameters);
+ List<Map<String, Object>> getMonitorPointOrDeviceAvgData(Map<String, Object> parameters);
+ /**
+ * @param sensorKeys
+ * @param timePeriod
+ * @param dataCondition
+ * @return {format_time:string,e1:double,e2...............}
+ */
+ List<Map<String, Object>> selectLineChartDateByCrieria(@Param("sensorKeys") List<String> sensorKeys, @Param("timePeriod") TimePeriod timePeriod, @Param("dataCondition") DataCondition dataCondition);
+
+ List<Map<String, Object>> getSensorData(Map<String, Object> parameters);
+
+ List<Map<String, Object>> getSensorDataMin(Map<String, Object> parameters);
+
+ List<Map<String, Object>> getSensorDataMax(Map<String, Object> parameters);
}
\ No newline at end of file
--
Gitblit v1.8.0