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/DataUploadRecordMonthMapper.java | 12 +++++++++++-
1 files changed, 11 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordMonthMapper.java b/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordMonthMapper.java
index 18f9080..b019e83 100644
--- a/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordMonthMapper.java
+++ b/src/main/java/com/fengdu/gas/repository/mapper/DataUploadRecordMonthMapper.java
@@ -1,10 +1,20 @@
package com.fengdu.gas.repository.mapper;
-import com.fengdu.gas.repository.BasicMapper;import com.fengdu.gas.repository.po.DataUploadRecordMonthPO;
+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);
}
--
Gitblit v1.9.3