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-eam/src/main/java/org/jeecg/modules/eam/mapper/RepairOrderMapper.java | 21 ++++++++++++++++++++-
1 files changed, 20 insertions(+), 1 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/RepairOrderMapper.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/RepairOrderMapper.java
index a65ba19..8ce2920 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/RepairOrderMapper.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/RepairOrderMapper.java
@@ -6,6 +6,7 @@
import org.jeecg.modules.eam.entity.RepairOrder;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import java.util.Date;
import java.util.List;
import java.util.Map;
@@ -37,11 +38,29 @@
@Param("specificEquipment") String specificEquipment,
@Param("teamId") String teamId,
@Param("equipNums") List<String> equipNums,
- @Param("repairOrderUda1") String repairOrderUda1
+ @Param("repairOrderUda1") String repairOrderUda1,
+ @Param("faultStartTime") Date faultStartTime,
+ @Param("faultEndTime")Date faultEndTime,
+ @Param("createStartTime")Date createStartTime,
+ @Param("createEndTime")Date createEndTime,
+ @Param("equipmentImportanceId")String equipmentImportanceId,
+ @Param("faultCause")String faultCause
+
+
);
IPage<Map<String, Object>> getUserTeam(IPage<Map> pageData, @Param("realname") String realname);
IPage<Map<String, Object>> getMaterialSpareList(IPage<Map> pageData, @Param("num") String num,@Param("status") String status);
+
+ List<Map<String, Object>> getFaultCause(@Param("equipmentId")String equipmentId);
+
+ List<Map<String, Object>> getAllFaultCause();
+
+ List<Map<String, Object>> getFaultCausePie(@Param("params") Map<String,Object> params);
+
+ List<Map<String, Object>> getFaultCauseBar(@Param("params") Map<String,Object> params);
+
+ IPage<Map<String, Object>> getMTPF(IPage<Map> pageData,@Param("params") Map<String,Object> params);
}
--
Gitblit v1.9.3