From 9b015b51b72ba050b4c38a6ba79eb45b7065e67d Mon Sep 17 00:00:00 2001
From: Lius <Lius2225@163.com>
Date: 星期四, 25 七月 2024 10:11:52 +0800
Subject: [PATCH] 调整sql

---
 lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IMdcEquipmentService.java |   68 ++++++++++++++++++++++++++++++++++
 1 files changed, 68 insertions(+), 0 deletions(-)

diff --git a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IMdcEquipmentService.java b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IMdcEquipmentService.java
index 78f11f9..1edd84c 100644
--- a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IMdcEquipmentService.java
+++ b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IMdcEquipmentService.java
@@ -3,12 +3,18 @@
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.IService;
+import org.jeecg.modules.mdc.dto.MdcEquDepDto;
+import org.jeecg.modules.mdc.dto.MdcEquProDto;
 import org.jeecg.modules.mdc.dto.MdcEquipmentDto;
 import org.jeecg.modules.mdc.entity.MdcEquipment;
 import org.jeecg.modules.mdc.entity.MdcEquipmentMonitor;
 import org.jeecg.modules.mdc.model.MdcEquipmentTree;
+import org.jeecg.modules.mdc.vo.MdcEfficiencyReportQueryVo;
+import org.jeecg.modules.mdc.vo.MdcEfficiencyReportShiftQueryVo;
 import org.jeecg.modules.mdc.vo.MdcEquipmentVo;
+import org.jeecg.modules.mdc.vo.WorkshopEquipmentVo;
 
+import javax.servlet.http.HttpServletRequest;
 import java.util.List;
 import java.util.Map;
 
@@ -124,6 +130,7 @@
 
     /**
      * 鏍规嵁璁惧id鏌ヨ璁惧鍚嶇О
+     *
      * @param equipmentId
      * @return
      */
@@ -139,4 +146,65 @@
      */
     MdcEquipment getEquipmentByPid(String pid, String userId);
 
+    /**
+     * 鏍规嵁璁惧缂栧彿鏌ヨ璁惧淇℃伅鍜岄儴闂ㄤ俊鎭�
+     *
+     * @param equipmentIdList
+     * @return
+     */
+    List<MdcEquDepDto> findEquDepList(List<String> equipmentIdList);
+
+    /**
+     * 鏍规嵁璁惧缂栧彿鏌ヨ璁惧淇℃伅鍜屼骇绾夸俊鎭�
+     *
+     * @param equipmentIdList
+     * @return
+     */
+    List<MdcEquProDto> findEquProList(List<String> equipmentIdList);
+
+    /**
+     * 鏍规嵁閮ㄩ棬灞傜骇鏌ヨ璁惧鍗曚釜
+     */
+    MdcEquipment getEquipmentByDepPid(String pid, String userId);
+
+    /**
+     * 鏍规嵁澶у睆杞﹂棿id鏌ヨ璁惧鍒楄〃
+     */
+    IPage<MdcEquipment> getEquipmentByWorkshopId(Page<MdcEquipment> page, WorkshopEquipmentVo workshopEquipmentVo);
+
+    List<String> listEquipmentId(MdcEfficiencyReportQueryVo vo);
+
+    /**
+     * 鍒楄〃鏌ヨ
+     */
+    IPage<MdcEquipment> pageList(Page<MdcEquipment> page, MdcEquipmentVo mdcEquipment, HttpServletRequest req);
+
+    /**
+     * 鐩戞帶璁惧杩愯鍙傛暟浠诲姟
+     */
+    void monitoringSpeedProcess();
+
+    /**
+     * 瀵煎嚭List
+     * @param mdcEquipment
+     * @return
+     */
+    List<MdcEquipment> exportXlsList(MdcEquipmentVo mdcEquipment);
+
+    /**
+     * 閫氳繃杞﹂棿ids鑾峰彇璁惧鏍�
+     * @param ids
+     * @return
+     */
+    List<MdcEquipmentTree> loadTreeListByProductionIds(String ids);
+
+    /**
+     * 鏌ヨ鍗曡〃鏁版嵁
+     * @param tableName
+     * @return
+     */
+    MdcEquipmentDto getWorkLineLast(String tableName);
+
+    List<String> listEquipmentIdShift(MdcEfficiencyReportShiftQueryVo vo);
+
 }

--
Gitblit v1.9.3