From 3aa2f5aa4c7963e7bcfbc0d710c286c826338df9 Mon Sep 17 00:00:00 2001 From: kaiyu <404897439@qq.com> Date: Wed, 02 Dec 2020 14:39:08 +0800 Subject: [PATCH] Merge branch 'master' of http://blit.7drlb.com:8888/r/screen_api_v2 --- src/main/java/com/moral/mapper/HistoryHourlyMapper.java | 43 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 43 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/moral/mapper/HistoryHourlyMapper.java b/src/main/java/com/moral/mapper/HistoryHourlyMapper.java index 2bdc6c9..651d743 100644 --- a/src/main/java/com/moral/mapper/HistoryHourlyMapper.java +++ b/src/main/java/com/moral/mapper/HistoryHourlyMapper.java @@ -1,5 +1,10 @@ package com.moral.mapper; +import org.apache.ibatis.annotations.Param; +import org.springframework.security.access.method.P; + +import java.lang.reflect.Array; +import java.util.List; import java.util.Map; public interface HistoryHourlyMapper { @@ -9,4 +14,42 @@ Map<String, Object> getPollutionSourceDataByHour(Map<String, Object> parameters); Map<String, Object> getPollutionSourceDataAll(Map<String, Object> parameters); + //������TVOC������ + String getTVOCByMac(@Param("mac") String mac, @Param("time") String time, @Param("sensor") String sensor); + //������������������ + String getPressureByMac(@Param("mac") String mac,@Param("time") String time); + //������������ + Map<String,Object> getDataByMac(@Param("mac") String mac,@Param("time") String time); + + List<Map<String,Object>> getBeamByMacs(Map<String,Object> params); + + List<Map<String, Object>> getDataByTimeSlot(@Param("mac") String mac, @Param("startTime") String startTime, @Param("endTime") String endTime); + + List<Map<String,Object>> getTVOCByMacs(Map<String,Object> params); + + List<Map> getDataByMacAndTime(@Param("mac") String mac, + @Param("sensor") String sensor, + @Param("startTime") String startTime, + @Param("endTime") String endTime); + List<Map> getDataByMacAndTime1(@Param("mac") String mac, + @Param("sensor") String sensor, + @Param("startTime") String startTime, + @Param("endTime") String endTime); + + List<Map<String,Object>> getDataAvbByMIdAndTime( @Param("mId")String mId, + @Param("startTime")String startTime, + @Param("endTime")String endTime); + + List<Map<String,Object>> getDataByMonitorPoints(@Param("mIds") String[] mIds, + @Param("startTime")String startTime, + @Param("endTime")String endTime); + + + Map<String,Object> getAvgDataByMId(@Param("mId")String mId, + @Param("startTime")String startTime, + @Param("endTime")String endTime); + + Map<String,Object> getAvgDataByMIds(@Param("mIds")String[] mIds, + @Param("startTime")String startTime, + @Param("endTime")String endTime); } -- Gitblit v1.8.0