1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| 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);
| }
|
|
