| | |
|---|
| | | @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); |
|---|
| | | } |
|---|
