From dacae5af651baa6ae102c8dd4350a7b8b7d86fe6 Mon Sep 17 00:00:00 2001
From: lizijie <lzjiiie@163.com>
Date: Thu, 28 Apr 2022 16:16:40 +0800
Subject: [PATCH] 通过时间和mac集合查询数据接口,修改蜂窝图小时数据接口

---
 screen-api/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java |   11 +++++++++++
 1 files changed, 11 insertions(+), 0 deletions(-)

diff --git a/screen-api/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java
index 63879e6..deeb591 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java
@@ -779,6 +779,17 @@
     }
 
     @Override
+    public List<HistoryHourly> getHourlyDataByMacs(List<String> macs, String time) {
+        QueryWrapper<HistoryHourly> queryWrapper = new QueryWrapper<>();
+        queryWrapper.select("mac","time", "value")
+                .likeRight("time", time)
+                .in("mac", macs);
+        Date date = DateUtils.getDate(time, DateUtils.yyyy_MM_dd_EN);
+        List<String> tableNames = MybatisPLUSUtils.getTableNamesByWrapper(date, date, SeparateTableType.MONTH);
+        return multiTableQuery(queryWrapper, tableNames);
+    }
+
+    @Override
     public Double calculatedValue(List<HistoryHourly> list, String sensorCode, String type, Double lower, Double upper) {
         Supplier<Stream<HistoryHourly>> supplier = list::stream;
         DoubleStream doubleStream = supplier.get()

--
Gitblit v1.8.0