| | |
| | | package com.moral.api.mapper; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.moral.api.entity.HistoryHourly; |
| | | import com.moral.api.pojo.dto.Wind.WindData; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | |
| | | * @author moral |
| | | * @since 2021-07-14 |
| | | */ |
| | | public interface HistoryHourlyMapper{ |
| | | public interface HistoryHourlyMapper extends BaseMapper<HistoryHourly> { |
| | | |
| | | String selectHourlyData(Map<String,Object> params); |
| | | |
| | | List<Map<String,Object>> selectHourlyListData(Map<String,Object> params); |
| | | |
| | | List<Map<String,Object>> selectDataByMacsAndTime(@Param("timeUnits") String timeUnits, @Param("list")List list, @Param("time")String time); |
| | | |
| | | |
| | | String queryLastHourlyMac(String mac,String time,String timeUnits); |
| | | |
| | | |
| | | List<WindData> getArea(Map<String, Object> params); |
| | | |
| | | // //获取TVOC浓度 |
| | | // String getTVOCByMac(@Param("mac") String mac, @Param("time") String time, @Param("sensor") String sensor,@Param("yearAndMonth") String yearAndMonth); |
| | | // |
| | | // //获取压强大小 |
| | | // String getPressureByMac(@Param("mac") String mac,@Param("time") String time,@Param("yearAndMonth") String yearAndMonth); |
| | | // |
| | | // |
| | | // Map<String,Object> getDataByMac(@Param("mac") String mac,@Param("time") String time,@Param("yearAndMonth") String yearAndMonth); |
| | | } |