于紫祥_1901
2020-12-24 f28149d8183a62f87fa9c8df9ae589070d83f612
src/main/java/com/moral/mapper/HistoryHourlyMapper.java
@@ -1,7 +1,10 @@
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 {
@@ -17,4 +20,36 @@
    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);
}