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/FacilityRunTimeMapper.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/fengdu/gas/repository/mapper/FacilityRunTimeMapper.java b/src/main/java/com/fengdu/gas/repository/mapper/FacilityRunTimeMapper.java
new file mode 100644
index 0000000..acd021e
--- /dev/null
+++ b/src/main/java/com/fengdu/gas/repository/mapper/FacilityRunTimeMapper.java
@@ -0,0 +1,24 @@
+package com.fengdu.gas.repository.mapper;
+
+import com.fengdu.gas.repository.BasicMapper;import com.fengdu.gas.repository.po.FacilityRunTimePO;
+import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
+
+/**
+ * 设备运行时长 mapper
+ * @author zr
+ */
+public interface FacilityRunTimeMapper extends BasicMapper<FacilityRunTimePO> {
+ @Select("SELECT r.*\n" +
+ " FROM facility_run_time r\n" +
+ " INNER JOIN (\n" +
+ " SELECT facility_id, MAX(create_time) AS max_timestamp\n" +
+ " FROM facility_run_time WHERE open_time IS NOT NULL AND open_time<>'' AND close_time IS NOT NULL AND close_time <>''\n" +
+ " GROUP BY facility_id\n" +
+ " ) AS latest ON r.facility_id = latest.facility_id AND r.create_time = latest.max_timestamp;")
+ List<FacilityRunTimePO> getDataTime();
+
+ @Select("select * from facility_run_time where is_delete=0 and open_time IS NOT NULL AND open_time<>'' AND close_time IS NOT NULL AND close_time <>'' ")
+ List<FacilityRunTimePO>selectByDataTime();
+}
--
Gitblit v1.9.3