monitor平均值导出数据

于紫祥_1901

2020-11-16 298f89f02b65783ba5cb79cf57f4fd097868ee5b

 src/main/java/com/moral/mapper/HistoryMapper.java

@@ -8,6 +8,7 @@


public interface HistoryMapper{

   String selectValueByMacAndTime(@Param("mac")String mac, @Param("time")Date time);

   String getValueByMacAndTime(@Param("mac")String mac, @Param("time")String time,@Param("time1")String time1);

   List<Map<String, Object>> getAreaAllDataByAccount(Map<String, Object> parameters);



   List<Map<String, Object>> getRegionRankingData(Map<String, Object> parameters);

@@ -42,4 +43,6 @@
   String getJsonData(@Param("mac") String mac,

                  @Param("time") String time,

                  @Param("table") String table);



   Map<String,Object> getDailyAvgData(@Param("mId")String mId,@Param("time")String time);

}