From 11d4be720620abf502d35000e2ed40d30c4023bf Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期一, 24 十一月 2025 16:33:34 +0800
Subject: [PATCH] 修复离线时间展示
---
collect/src/main/java/com/qianwen/mdc/collect/mapper/iotdb/DeviceStateMapper.java | 61 ++++++++++++++++++++++++++++++
1 files changed, 60 insertions(+), 1 deletions(-)
diff --git a/collect/src/main/java/com/qianwen/mdc/collect/mapper/iotdb/DeviceStateMapper.java b/collect/src/main/java/com/qianwen/mdc/collect/mapper/iotdb/DeviceStateMapper.java
index 0fa8177..5ed0d79 100644
--- a/collect/src/main/java/com/qianwen/mdc/collect/mapper/iotdb/DeviceStateMapper.java
+++ b/collect/src/main/java/com/qianwen/mdc/collect/mapper/iotdb/DeviceStateMapper.java
@@ -56,5 +56,64 @@
* @param factoryDate
* @return
*/
- long fixPointCountByDate(int factoryDate);
+ Long fixPointCountByDate(int factoryDate);
+
+ /**
+ * 鏍规嵁宸ヤ綅id,鑾峰彇 灏忎簬鏃堕棿鎴� 鐨勯潪鍙嶉鐐规暟鎹�
+ * @param workstationId 宸ヤ綅id
+ * @param time 鏃堕棿鎴�
+ * @return
+ */
+ DeviceState lastNoFeedbackStateLessThanTime(@Param("workstationId")Long workstationId, @Param("time")Long time);
+
+ /**
+ * 鏍规嵁宸ヤ綅id,鑾峰彇 灏忎簬绛変簬鏃堕棿鎴� 鐨勯潪鍙嶉鐐规暟鎹�
+ * @param workstationId
+ * @param time
+ * @return
+ */
+ DeviceState lastNoFeedbackStateLeTime(@Param("workstationId")Long workstationId, @Param("time")Long time);
+ /**
+ * 鏍规嵁宸ヤ綅id鍜屾椂闂存埑绮剧‘鑾峰彇涓�鏉＄姸鎬佹暟鎹�
+ * @param workstationId
+ * @param time
+ * @return
+ */
+ DeviceState getByWorkstationIdAndTime(@Param("workstationId")Long workstationId, @Param("time")Long time);
+
+ /**
+ * 鏍规嵁宸ヤ綅id鍜屾椂闂存埑绮剧‘鑾峰彇涓�鏉＄姸鎬佹暟鎹�
+ * @param workstationId
+ * @param time
+ * @return
+ */
+ DeviceState getLastByWorkstationIdAndLeTimeAndShiftIndexNotNull(@Param("workstationId")Long workstationId, @Param("time")Long time);
+
+ /**
+ * 鏍规嵁鏃堕棿鍜屽伐浣峣d锛岃幏鍙栦竴涓浐瀹氱偣
+ * @param workstationId
+ * @param time
+ * @return
+ */
+ DeviceState getFixPointByWorkstationIdAndTime(@Param("workstationId")Long workstationId, @Param("time")Long time);
+
+ /**
+ * 鑾峰彇鎸囧畾宸ヤ綅鏃堕棿鍖洪棿鍐呯殑闈炲弽棣堢偣鐘舵�佹暟鎹垪琛�
+ * @param workstationId
+ * @param startTime
+ * @param endTime
+ * @return
+ */
+ List<DeviceState> workstationNoFeedbackPointStatesInTimeRange(@Param("workstationId")Long workstationId, @Param("startTime")Long startTime, @Param("endTime")Long endTime);
+
+ /**
+ * 鑾峰彇鎸囧畾宸ヤ綅鏃堕棿鍖洪棿鍐呯殑 鍥哄畾鐐� 鐘舵�佹暟鎹垪琛�
+ * @param workstationId
+ * @param startTime
+ * @param endTime
+ * @return
+ */
+ List<DeviceState> workstationFixPointStatesInTimeRange(@Param("workstationId")Long workstationId, @Param("startTime")Long startTime, @Param("endTime")Long endTime);
+
+ DeviceState lastNoFixedState(@Param("workstationId")long workstationId);
}
--
Gitblit v1.9.3