1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
| package com.fengdu.gas.repository.mapper;
|
| import com.fengdu.gas.repository.BasicMapper;import com.fengdu.gas.repository.po.DataUploadRecordDayPO;
| import com.fengdu.gas.repository.po.DataUploadRecordHourPO;
| import org.apache.ibatis.annotations.Select;
|
| import java.util.List;
|
| /**
| * 数据上报记录-天统计 mapper
| * @author zr
| */
| public interface DataUploadRecordDayMapper extends BasicMapper<DataUploadRecordDayPO> {
|
|
| @Select("SELECT point_id,point_name,facility_id,facility_name,min_value,max_value,avg_value,upload_time FROM data_upload_record_day " +
| " WHERE is_delete=0 AND upload_time BETWEEN #{startTime} AND #{endTime}")
| List<DataUploadRecordDayPO> getByTime(Long startTime, Long endTime);
|
| @Select("SELECT point_name,facility_name,columns_code,min_value,max_value,avg_value,TO_CHAR(TO_TIMESTAMP(upload_date, 'YYYY-MM-DD HH24:MI:SS'), 'DD') AS upload_date\n" +
| " FROM data_upload_record_day \n" +
| " WHERE point_id=#{pointId} and columns_code=#{columnsCode} AND upload_time BETWEEN #{beginTime} AND #{LastTime}")
| List<DataUploadRecordDayPO>getLineChart(Long pointId,String columnsCode,Long beginTime,Long LastTime);
| }
|
|
