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.DataUploadRecordMonthPO;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* 数据上报记录-月统计 mapper
|
* @author zr
|
*/
|
public interface DataUploadRecordMonthMapper extends BasicMapper<DataUploadRecordMonthPO> {
|
|
@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'), 'MM') AS upload_date\n" +
|
" FROM data_upload_record_month \n" +
|
" WHERE point_id=#{pointId} and columns_code=#{columnsCode} AND upload_time BETWEEN #{beginTime} AND #{LastTime}")
|
List<DataUploadRecordMonthPO> getLineChart(Long pointId, String columnsCode, Long beginTime, Long LastTime);
|
}
|
