From adde1ed1a99622c80a95dea83e294711d295c55c Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Tue, 08 Sep 2020 14:46:43 +0800 Subject: [PATCH] 微型站5分钟与半小时数据 --- src/main/java/com/moral/mapper/HistoryMinutelyMapper.java | 49 +++++++++++++++++++++++++++++++++++++------------ 1 files changed, 37 insertions(+), 12 deletions(-) diff --git a/src/main/java/com/moral/mapper/HistoryMinutelyMapper.java b/src/main/java/com/moral/mapper/HistoryMinutelyMapper.java index cfc8941..516b9ec 100644 --- a/src/main/java/com/moral/mapper/HistoryMinutelyMapper.java +++ b/src/main/java/com/moral/mapper/HistoryMinutelyMapper.java @@ -1,12 +1,37 @@ -package com.moral.mapper; - -import java.util.List; -import java.util.Map; - -public interface HistoryMinutelyMapper{ - - Map<String, Double> getSersionAvgByDevice(Map<String, Object> parameters); - - List<Map<String, Object>> getMonitorPointOrDeviceAvgData(Map<String, Object> parameters); - -} \ No newline at end of file +package com.moral.mapper; + +import java.util.List; +import java.util.Map; + +import org.apache.ibatis.annotations.Param; + +import com.moral.entity.charts.DataCondition; +import com.moral.entity.charts.TimePeriod; + +public interface HistoryMinutelyMapper { + + Map<String, Double> getSersionAvgByDevice(Map<String, Object> parameters); + + Map<String, Double> getAvgByDevice(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("timeUnits") String timeUnits, @Param("dataCondition") DataCondition dataCondition); + + List<Map<String, Object>> getSensorData(Map<String, Object> parameters); + + List<Map<String, Object>> getSensorData2020(Map<String, Object> parameters); + + List<Map<String, Object>> getDevicesAvgDataToExcel(Map<String, Object> parameters); + + List<Map<String, Object>> getDevicesSensorsAvgDataToExcel(Map<String, Object> parameters); + + Map<String,Object> get5MiutesOrHalfHourByDay(Map<String, Object> parameters); + +} -- Gitblit v1.8.0