From 567d0c8dd0fcd4496066b1053a7652141b98e0d2 Mon Sep 17 00:00:00 2001
From: Lius <Lius2225@163.com>
Date: 星期一, 15 四月 2024 16:09:14 +0800
Subject: [PATCH] 设备监控设备状态sql优化
---
lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IMdcHomeService.java | 28 ++++++++++++++++++++++++++++
1 files changed, 28 insertions(+), 0 deletions(-)
diff --git a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IMdcHomeService.java b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IMdcHomeService.java
index 41759d8..236c42c 100644
--- a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IMdcHomeService.java
+++ b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IMdcHomeService.java
@@ -1,6 +1,8 @@
package org.jeecg.modules.mdc.service;
+import org.jeecg.modules.mdc.entity.MdcOverallEquipmentEfficiency;
import org.jeecg.modules.mdc.vo.MdcCommonVo;
+import org.jeecg.modules.mdc.vo.MdcHomeEfficiencyVo;
import java.util.List;
import java.util.Map;
@@ -30,4 +32,30 @@
* 璁惧OEE鍜屽埄鐢ㄧ巼缁熻鏌辩姸鍥�
*/
Map<String, Object> getEquipmentMonthStatistics(String userId, String key);
+
+ /**
+ * 宸ユ绾у墠涓冨ぉ鍒╃敤鐜囨姌绾垮浘
+ */
+ Map<String, Object> getEquipmentDayUtilizationStatistics(String userId, String key);
+
+ /**
+ * 鏌ヨ璁惧涓婃湀OEE
+ */
+ List<MdcOverallEquipmentEfficiency> getEquipmentOEEMonthStatistics(String userId, String key);
+
+ /**
+ * 宸ユ绾ц澶囨晥鐜�
+ */
+ MdcHomeEfficiencyVo getEquipmentEfficiencyStatistics(String userId, String key);
+
+ /**
+ * 璁惧绾ф晥鐜囩粺璁�
+ */
+ MdcHomeEfficiencyVo getEquipmentLevelEfficiencyStatistics(String equipmentId);
+
+ /**
+ * 璁惧绾ф暣骞村害鍒╃敤鐜囧拰OEE
+ */
+ Map<String, Object> getEquipmentAnnualEfficiencyStatistics(String equipmentId);
+
}
--
Gitblit v1.9.3