package com.fengdu.gas.repository.mapper;

import com.fengdu.gas.repository.BasicMapper;import com.fengdu.gas.repository.po.DataUploadRecordHourPO;
import com.fengdu.gas.repository.po.DataUploadRecordPO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 数据上报记录-小时统计 mapper
 * @author zr
 */
public interface DataUploadRecordHourMapper extends BasicMapper<DataUploadRecordHourPO> {
    @Select("SELECT point_id,point_name,facility_id,facility_name,min_value,max_value,avg_value,upload_time  FROM data_upload_record_hour " +
            " WHERE is_delete=0 AND upload_time BETWEEN  #{startTime} AND #{endTime}")
    List<DataUploadRecordHourPO> getByTime(Long startTime, Long endTime);
}