From e66b0932eb782c6ec771ffaa9957e6d5d5361286 Mon Sep 17 00:00:00 2001 From: xufenglei <xufenglei> Date: Tue, 07 Aug 2018 12:49:06 +0800 Subject: [PATCH] 增加 年查询 --- src/main/java/com/moral/mapper/HistoryMapper.java | 22 ++++++++++++---------- 1 files changed, 12 insertions(+), 10 deletions(-) diff --git a/src/main/java/com/moral/mapper/HistoryMapper.java b/src/main/java/com/moral/mapper/HistoryMapper.java index 8fecdda..4b5a131 100644 --- a/src/main/java/com/moral/mapper/HistoryMapper.java +++ b/src/main/java/com/moral/mapper/HistoryMapper.java @@ -1,19 +1,21 @@ package com.moral.mapper; +import org.apache.ibatis.annotations.Param; + +import java.util.Date; import java.util.List; import java.util.Map; -import org.apache.ibatis.annotations.Mapper; - -@Mapper public interface HistoryMapper{ - - Map<String, Double> getDayAQIByDevice(Map<String, Object> parameters); - - Map<String, Object> getAllSensorAverageByDevice(Map<String, Object> parameters); - - List<Map<String, Object>> getSensorsAverageByDevice4Report(Map<String, Object> parameters); - + 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); + } \ No newline at end of file -- Gitblit v1.8.0