修改平均风向SQL语句

kaiyu

2020-11-02 a8a98fd6f24d5c7bf001055898e397f2f2deffa4

 src/main/java/com/moral/mapper/HistoryMapper.java

@@ -4,22 +4,33 @@
import java.util.Map;



import com.moral.entity.History;

import org.apache.ibatis.annotations.Param;



public interface HistoryMapper {

    int insert(History record);



    int insertSelective(History record);



   Map<String, Object> getAvgData(Map<String,Object> parameters);

	
   Map<String, Object> getMaxAndMinData(Map<String,Object> parameters);

    Map<String, Object> getAvgData(Map<String, Object> parameters);



    List<Map<String, Object>> getSensorData(Map<String,Object> parameters);

    Map<String, Object> getMaxAndMinData(Map<String, Object> parameters);



    List<Map<String, Object>> getSensorDataByMac(Map<String,Object> parameters);

    List<Map<String, Object>> getSensorData(Map<String, Object> parameters);



    List<Map<String, Object>> getSensorDataOnce(Map<String,Object> parameters);

	
   Map<String, Object> getMinData(Map<String,Object> parameters);

    List<Map<String, Object>> getSensorDataByMac(Map<String, Object> parameters);



    List<Map<String, Object>> getSensorDataByMacOnce(Map<String, Object> parameters);



    List<Map<String, Object>> getSensorDataOnce(Map<String, Object> parameters);



    Map<String, Object> getMinData(Map<String, Object> parameters);



    List<History> selectByMacAndTime(Map<String, Object> parameters);



    int insertHistorySpecialTable(Map<String, Object> parameters);



    int deleteHistoryData(String oldTime);



    void deletePartition(@Param("p") String p);



}