From 1d25854b8dfdebe7b4d5153e932c0e74ed5f7453 Mon Sep 17 00:00:00 2001 From: ZhuDongming <773644075@qq.com> Date: Thu, 15 Aug 2019 17:21:51 +0800 Subject: [PATCH] 添加查询最大值和最小值的service接口 --- src/main/java/com/moral/mapper/HistoryMapper.java | 18 ++++++++++++++++++ 1 files changed, 18 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/moral/mapper/HistoryMapper.java b/src/main/java/com/moral/mapper/HistoryMapper.java index 68db071..2779dec 100644 --- a/src/main/java/com/moral/mapper/HistoryMapper.java +++ b/src/main/java/com/moral/mapper/HistoryMapper.java @@ -10,4 +10,22 @@ String selectValueByMacAndTime(@Param("mac")String mac, @Param("time")Date time); List<Map<String, Object>> getAreaAllDataByAccount(Map<String, Object> parameters); + List<Map<String, Object>> getRegionRankingData(Map<String, Object> parameters); + + List<String> selectNextLevelRegion(Map<String, Object> parameters); + + List<Map<String, Object>> getDischargeByRegion(Map<String, Object> parameters); + + List<Map<String, Object>> getValueByMacAndSize(Map<String, Object> parameters); + + Map<String, Object> getActualDataByRegion(Map<String, Object> parameters); + + Map<String, Object> getAVGValueByMacAndTimeslot(@Param("mac")String mac, @Param("starttime")String starttime, @Param("endtime")String endtime); + + List<Map<String, Object>> getSensorDataToday(Map<String, Object> parameters); + + List<Map<String, Object>> getSensorDataTodayMin(Map<String, Object> parameters); + + List<Map<String, Object>> getSensorDataTodayMax(Map<String, Object> parameters); + } \ No newline at end of file -- Gitblit v1.8.0