常熟中隆汽车设备转发，千灯设备数据转发

lizijie

2022-05-26 ed8c07e1870d8cd2151355ea34019a3f02087568

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

@@ -4,20 +4,39 @@
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>> getSensorDataOnce(Map<String,Object> parameters);

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

    List<Map<String, Object>> getSensorData(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);



    void createHistoryTable(@Param("yearMonthDay") String yearMonthDay);



    void dropHistoryTable(@Param("yearMonthDay") String yearMonthDay);



    History selectLastDataByMac(@Param("yearMonthDay") String yearMonthDay, @Param("mac") String mac);



}