From bcf8c46e009d5d825a7bf07b9eac46fb7432418b Mon Sep 17 00:00:00 2001
From: liulin <lin.liu@88.com>
Date: 星期四, 17 七月 2025 08:42:13 +0800
Subject: [PATCH] 添加首页大屏数据统计
---
src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordDayMapper.java | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordDayMapper.java b/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordDayMapper.java
index 367c4c1..4c2122e 100644
--- a/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordDayMapper.java
+++ b/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordDayMapper.java
@@ -16,4 +16,9 @@
@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);
}
--
Gitblit v1.9.3