package com.moral.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.moral.entity.charts.DataCondition;
import com.moral.entity.charts.TimePeriod;

public interface HistoryMinutelyMapper {

    Map<String, Double> getSersionAvgByDevice(Map<String, Object> parameters);

    Map<String, Double> getAvgByDevice(Map<String, Object> parameters);

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

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

    /**
     * @param sensorKeys
     * @param timePeriod
     * @param dataCondition
     * @return {format_time:string,e1:double,e2...............}
     */
    List<Map<String, Object>> selectLineChartDateByCrieria(@Param("sensorKeys") List<String> sensorKeys, @Param("timePeriod") TimePeriod timePeriod, @Param("timeUnits") String timeUnits, @Param("dataCondition") DataCondition dataCondition);

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

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

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

    List<Map<String, Object>> getDevicesSensorsAvgDataToExcel(Map<String, Object> parameters);
}