From ebaaac167a229dd2d9115478e17bc46b7f7afb5f Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Wed, 22 Dec 2021 17:09:39 +0800 Subject: [PATCH] 设备最大值,最小值,平均值小时统计任务 --- screen-job/src/main/java/com/moral/api/mapper/HistoryHourlyMapper.java | 22 +++++++++++++++++++--- 1 files changed, 19 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 9b3c8d7..3ac14a0 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,10 +1,12 @@ package com.moral.api.mapper; +import org.apache.ibatis.annotations.Param; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.moral.api.entity.HistoryHourly; + import java.util.List; import java.util.Map; - -import com.moral.api.entity.HistoryHourly; -import com.baomidou.mybatisplus.core.mapper.BaseMapper; /** * <p> @@ -16,4 +18,18 @@ */ public interface HistoryHourlyMapper extends BaseMapper<HistoryHourly> { + 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); + } + + -- Gitblit v1.8.0