From 3f667355c7013b459f3ab5ec0c1bc035d7e2d5aa Mon Sep 17 00:00:00 2001
From: cjl <909710561@qq.com>
Date: Wed, 31 Jan 2024 10:57:28 +0800
Subject: [PATCH] fix：sql查询时间调整
---
screen-job/src/main/java/com/moral/api/mapper/HistoryHourlyMapper.java | 24 +++++++++++++++++++++---
1 files changed, 21 insertions(+), 3 deletions(-)
diff --git a/screen-job/src/main/java/com/moral/api/mapper/HistoryHourlyMapper.java b/screen-job/src/main/java/com/moral/api/mapper/HistoryHourlyMapper.java
index f52b66c..59b1e87 100644
--- a/screen-job/src/main/java/com/moral/api/mapper/HistoryHourlyMapper.java
+++ b/screen-job/src/main/java/com/moral/api/mapper/HistoryHourlyMapper.java
@@ -1,9 +1,12 @@
package com.moral.api.mapper;
-import java.util.List;
+import org.apache.ibatis.annotations.Param;
-import com.moral.api.entity.HistoryHourly;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.moral.api.entity.HistoryHourly;
+
+import java.util.List;
+import java.util.Map;
/**
* <p>
@@ -15,6 +18,21 @@
*/
public interface HistoryHourlyMapper extends BaseMapper<HistoryHourly> {
- void insertHistoryHourly(List<HistoryHourly> list);
+ void createTable(String timeUnits);
+
+ void createTableComplete(String timeUnits);
+
+ void insertHistoryHourly(List<Map<String, Object>> list);
+
+ Integer selectCountByTime(Map<String, Object> params);
+
+ List<Map<String, Object>> selectDailyData(Map<String, Object> params);
+
+ void insertHistoryHourlyComplete(@Param("list") List<Map<String, Object>> list, @Param("timeUnits") String timeUnits);
+
+
+ void insertHistoryHourlyAvg(@Param("list") List<Map<String, Object>> list, @Param("timeUnits") String timeUnits);
}
+
+
--
Gitblit v1.8.0