From c00fd90a440e17954791061f4f8ee604cf99ea5b Mon Sep 17 00:00:00 2001
From: ZhuDongming <773644075@qq.com>
Date: Tue, 06 Aug 2019 14:00:39 +0800
Subject: [PATCH] 新增根据mac查询sensor的sql
---
src/main/java/com/moral/service/HistoryService.java | 16 ++++++++++++++--
1 files changed, 14 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/moral/service/HistoryService.java b/src/main/java/com/moral/service/HistoryService.java
index 8c88967..822cbc2 100644
--- a/src/main/java/com/moral/service/HistoryService.java
+++ b/src/main/java/com/moral/service/HistoryService.java
@@ -1,14 +1,26 @@
package com.moral.service;
+import java.util.Date;
+import java.util.List;
import java.util.Map;
public interface HistoryService {
- Map<String, Object> getAllSensorAverageByDevice(Map<String, Object> parameters);
+ Map<String, Object> getAllSensorAverageByDevice(Map<String, Object> parameters) throws Exception;
Map<String, Object> getDeviceRankingBySensorAverage(Map<String, Object> parameters);
- Map<String, Object> getMonthAverageBySensor(Map<String, Object> parameters);
+ String queryValueByMacAndTime(String mac, Date time);
+
+ List<Map<String, Object>> getRegionRankingData(Map<String, Object> parameters);
+
+ List<Map<String, Object>> getSensorsDataByDevice(Map<String, Object> parameters);
+
+ List<Map<String, Object>> getSensorDataBySensorKey(Map<String, Object> parameters);
+
+ Map<String, Object> getActualDataByRegion(Map<String, Object> parameters);
+
+ Map<String, Object> getSensorUnitByDeviceMac(Map<String, Object> parameters);
}
--
Gitblit v1.8.0