1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
| package com.moral.api.mapper;
|
| import com.baomidou.mybatisplus.core.mapper.BaseMapper;
| import com.moral.api.entity.HistoryHourly;
| import org.apache.ibatis.annotations.Param;
|
| import java.util.List;
| import java.util.Map;
|
| /**
| * <p>
| * 已校准小时表 Mapper 接口
| * </p>
| *
| * @author moral
| * @since 2021-07-14
| */
| public interface HistoryHourlyMapper extends BaseMapper<HistoryHourly> {
|
| String selectHourlyData(Map<String,Object> params);
|
| List<Map<String,Object>> selectDataByMacsAndTime(@Param("timeUnits") String timeUnits, @Param("list")List list, @Param("time")String time);
|
| Double getSensorSumByMacs(@Param("sensorCode") String sensorCode, @Param("macs") List<String> macs, @Param("time") String time, @Param("timeUnits") String timeUnits);
|
| Double getSensorAvgByMacs(@Param("sensorCode") String sensorCode, @Param("macs") List<String> macs, @Param("time") String time, @Param("timeUnits") String timeUnits);
| }
|
|
