| | |
| | | package com.moral.api.service; |
| | | |
| | | import com.moral.api.entity.HistoryHourly; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | * @author moral |
| | | * @since 2021-06-28 |
| | | */ |
| | | public interface HistoryHourlyService extends IService<HistoryHourly> { |
| | | public interface HistoryHourlyService { |
| | | |
| | | //小时表创建 |
| | | void createTable(String timeUnits); |
| | | |
| | | //完整小时表创建 |
| | | void createTableComplete(String timeUnits); |
| | | |
| | | //缺失小时数据补充 |
| | | void insertHistoryHourly(); |
| | | |
| | | //从分钟表统计天数据 |
| | | List<Map<String, Object>> selectDailyData(Map<String, Object> params); |
| | | |
| | | /** |
| | | * @Description: 根据mac和时间获取小时值 |
| | | * @Param: [mac, startDate, endDate] |
| | | * @return: java.util.List<com.moral.api.entity.HistoryHourly> |
| | | * @Author: 陈凯裕 |
| | | * @Date: 2021/9/28 |
| | | */ |
| | | List<HistoryHourly> getValueByMacAndTime(String mac, Date startDate, Date endDate); |
| | | |
| | | //设备小时数据,最大值,最小值,均值统计入表 |
| | | void insertHistoryHourlyComplete(); |
| | | |
| | | |
| | | void dateToChangShu(String time); |
| | | |
| | | |
| | | } |