导出数据接口update

于紫祥_1901

2020-11-20 b3a7d3d28ee5934a4f3fdb89b50c681667440c68

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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
package com.moral.mapper;
 
import org.apache.ibatis.annotations.Param;
import org.springframework.security.access.method.P;
 
import java.lang.reflect.Array;
import java.util.List;
import java.util.Map;
 
public interface HistoryHourlyMapper {
 
    Map<String, Object> getPollutionSourceData(Map<String, Object> parameters);
 
    Map<String, Object> getPollutionSourceDataByHour(Map<String, Object> parameters);
 
    Map<String, Object> getPollutionSourceDataAll(Map<String, Object> parameters);
    //获取TVOC浓度
    String getTVOCByMac(@Param("mac") String mac, @Param("time") String time, @Param("sensor") String sensor);
    //获取压强大小
    String getPressureByMac(@Param("mac") String mac,@Param("time") String time);
    //获取风向
    Map<String,Object> getDataByMac(@Param("mac") String mac,@Param("time") String time);
 
    List<Map<String,Object>> getBeamByMacs(Map<String,Object> params);
 
    List<Map<String, Object>> getDataByTimeSlot(@Param("mac") String mac, @Param("startTime") String startTime, @Param("endTime") String endTime);
 
    List<Map<String,Object>> getTVOCByMacs(Map<String,Object> params);
 
    List<Map> getDataByMacAndTime(@Param("mac") String mac,
                                  @Param("sensor") String sensor,
                                  @Param("startTime") String startTime,
                                  @Param("endTime") String endTime);
    List<Map> getDataByMacAndTime1(@Param("mac") String mac,
                                  @Param("sensor") String sensor,
                                  @Param("startTime") String startTime,
                                  @Param("endTime") String endTime);
 
    List<Map<String,Object>> getDataAvbByMIdAndTime( @Param("mId")String mId,
                                                     @Param("startTime")String startTime,
                                                     @Param("endTime")String endTime);
 
    List<Map<String,Object>> getDataByMonitorPoints(@Param("mIds") String[] mIds,
                                                    @Param("startTime")String startTime,
                                                    @Param("endTime")String endTime);
 
 
    Map<String,Object> getAvgDataByMId(@Param("mId")String mId,
                                              @Param("startTime")String startTime,
                                              @Param("endTime")String endTime);
 
    Map<String,Object> getAvgDataByMIds(@Param("mIds")String[] mIds,
                                       @Param("startTime")String startTime,
                                       @Param("endTime")String endTime);
}