From 2a781bbf1d42191c3b8225a9973bf3d0ecccd66b Mon Sep 17 00:00:00 2001
From: kaiyu <404897439@qq.com>
Date: Mon, 27 Sep 2021 14:33:36 +0800
Subject: [PATCH] screen-aqi 增加获取监测站数据显示接口
---
screen-api/src/main/java/com/moral/api/service/impl/HistoryDailyServiceImpl.java | 36 ++++++++++++++++++++++++++++++++++++
1 files changed, 36 insertions(+), 0 deletions(-)
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/HistoryDailyServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/HistoryDailyServiceImpl.java
index 5c1316e..4895d63 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/HistoryDailyServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/HistoryDailyServiceImpl.java
@@ -1,5 +1,6 @@
package com.moral.api.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.moral.api.entity.HistoryDaily;
import com.moral.api.mapper.HistoryDailyMapper;
import com.moral.api.service.HistoryDailyService;
@@ -11,7 +12,9 @@
import org.springframework.stereotype.Service;
import org.springframework.util.ObjectUtils;
+import java.util.Date;
import java.util.HashMap;
+import java.util.List;
import java.util.Map;
/**
@@ -41,4 +44,37 @@
result.put("avg", data.get(params.get("sensorCode")));
return result;
}
+
+ @Override
+ public HistoryDaily getHistoryDailyByMacAndDate(String mac, Date date) {
+ QueryWrapper<HistoryDaily> wrapper = new QueryWrapper<>();
+ wrapper.eq("mac",mac);
+ wrapper.eq("time",date);
+ List<HistoryDaily> historyDailies = historyDailyMapper.selectList(wrapper);
+ return historyDailies.get(0);
+ }
+
+ @Override
+ public Map<String, HistoryDaily> getHistoryDailyByMacsAndDate(List<String> mac, Date date) {
+ QueryWrapper<HistoryDaily> wrapper = new QueryWrapper<>();
+ wrapper.in("mac",mac);
+ wrapper.eq("time",date);
+ List<HistoryDaily> historyDailies = historyDailyMapper.selectList(wrapper);
+ Map<String,HistoryDaily> map = new HashMap<>();
+ for (HistoryDaily historyDaily : historyDailies) {
+ map.put(historyDaily.getMac(),historyDaily);
+ }
+ return map;
+ }
+
+ @Override
+ public List<HistoryDaily> getHistoryDailyByMacAndTimeSlot(String mac, Date startDate, Date endDate) {
+ QueryWrapper<HistoryDaily> wrapper = new QueryWrapper<>();
+ wrapper.in("mac",mac);
+ wrapper.between("time",startDate,endDate);
+ List<HistoryDaily> historyDailies = historyDailyMapper.selectList(wrapper);
+ return historyDailies;
+ }
+
+
}
--
Gitblit v1.8.0