From c363540ce0469e6754329c1be5e56a63ec1d344f Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Mon, 27 Dec 2021 15:40:41 +0800 Subject: [PATCH] 行业贡献率 --- screen-api/src/main/java/com/moral/api/mapper/HistoryHourlyMapper.java | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/mapper/HistoryHourlyMapper.java b/screen-api/src/main/java/com/moral/api/mapper/HistoryHourlyMapper.java index 71102bf..17ca271 100644 --- a/screen-api/src/main/java/com/moral/api/mapper/HistoryHourlyMapper.java +++ b/screen-api/src/main/java/com/moral/api/mapper/HistoryHourlyMapper.java @@ -21,4 +21,7 @@ List<Map<String,Object>> selectDataByMacsAndTime(@Param("timeUnits") String timeUnits, @Param("list")List list, @Param("time")String time); + Double getSensorSumByMacs(@Param("sensorCode") String sensorCode, @Param("macs") List<String> macs, @Param("time") String time, @Param("timeUnits") String timeUnits); + + Double getSensorAvgByMacs(@Param("sensorCode") String sensorCode, @Param("macs") List<String> macs, @Param("time") String time, @Param("timeUnits") String timeUnits); } -- Gitblit v1.8.0