From 63d50da13d256f7df075f37054a239740bf172ac Mon Sep 17 00:00:00 2001
From: qushaowei <qushaowei@163.com>
Date: 星期四, 14 三月 2024 16:01:05 +0800
Subject: [PATCH] Merge branch 'master' of http://117.34.109.166:18448/r/mdc_430 into develop
---
lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/MdcHomeMapper.java | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 55 insertions(+), 0 deletions(-)
diff --git a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/MdcHomeMapper.java b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/MdcHomeMapper.java
new file mode 100644
index 0000000..bae0b19
--- /dev/null
+++ b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/MdcHomeMapper.java
@@ -0,0 +1,55 @@
+package org.jeecg.modules.mdc.mapper;
+
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.jeecg.modules.system.entity.MdcProduction;
+import org.springframework.stereotype.Repository;
+
+import java.math.BigDecimal;
+import java.util.List;
+import java.util.Map;
+
+/**
+ * @author Lius
+ * @date 2024/3/14 10:27
+ */
+@Mapper
+@Repository
+public interface MdcHomeMapper {
+
+ /**
+ * 鏍规嵁鐢ㄦ埛id鍜屼笂绾т骇绾縤d鑾峰彇浜х嚎淇℃伅
+ *
+ * @param userId
+ * @param productionId
+ * @return
+ */
+ List<MdcProduction> getProductionByPid(@Param("userId") String userId, @Param("productionId") String productionId);
+
+ /**
+ * 鏍规嵁璁惧闆嗗悎鍜屾棩鏈熻幏鍙栧姞宸ユ椂闂�
+ *
+ * @param equipmentIdList
+ * @param date
+ * @return
+ */
+ BigDecimal getProcessCount(@Param("equipmentIdList") List<String> equipmentIdList, @Param("date") String date);
+
+ /**
+ * 鏍规嵁璁惧闆嗗悎鍜屾棩鏈熻幏鍙杘ee
+ *
+ * @param equipmentIdList
+ * @param date
+ * @return
+ */
+ BigDecimal getOeeByDate(@Param("equipmentIdList") List<String> equipmentIdList, @Param("date") String date);
+
+ /**
+ * 鏍规嵁璁惧id闆嗗悎鍜屾湀浠借幏鍙栧埄鐢ㄧ巼鏁版嵁
+ *
+ * @param equipmentIdList
+ * @param date
+ * @return
+ */
+ Map<String, Object> getUtilizationByMonth(@Param("equipmentIdList") List<String> equipmentIdList, @Param("date") String date);
+}
--
Gitblit v1.9.3