From 2b5c36b4830adf4227f248d4e10bdb90b1e5f3d8 Mon Sep 17 00:00:00 2001
From: liulin <lin.liu@88.com>
Date: 星期四, 17 七月 2025 08:42:39 +0800
Subject: [PATCH] 添加首页大屏数据统计
---
src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordHourMapper.java | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordHourMapper.java b/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordHourMapper.java
index f99669d..6dd54c5 100644
--- a/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordHourMapper.java
+++ b/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordHourMapper.java
@@ -14,4 +14,9 @@
@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);
+
+ @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'), 'HH24') AS upload_date\n" +
+ " FROM data_upload_record_hour \n" +
+ " WHERE point_id=#{pointId} and columns_code=#{columnsCode} AND upload_time BETWEEN #{beginTime} AND #{LastTime}")
+ List<DataUploadRecordHourPO>getLineChart(Long pointId,String columnsCode,Long beginTime,Long LastTime);
}
--
Gitblit v1.9.3