From a2813f7399cb27e6f66e99b5d9577eb21f4ddac3 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期六, 31 八月 2024 12:24:42 +0800
Subject: [PATCH] 下发页面运维单位工单数查询优化
---
ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java | 16 +++++++++++++++-
1 files changed, 15 insertions(+), 1 deletions(-)
diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java
index fdbf66b..517232c 100644
--- a/ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java
+++ b/ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java
@@ -13,6 +13,8 @@
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
+import java.time.LocalDateTime;
+import java.util.Date;
import java.util.List;
import java.util.Map;
@@ -69,5 +71,17 @@
* 鏌ヨ宸ュ崟璁惧淇℃伅
* @return
*/
- List<DeviceInfoVO> hasErrorWorkOrderList();
+ List<DeviceInfoVO> hasErrorWorkOrderList(@Param("start") Date start, @Param("end") Date end);
+
+ List<WorkOrderVO> selectPassOrder(@Param("startTime") LocalDateTime now, @Param("endTime")LocalDateTime thirtyDaysAgo, @Param("status") String status, @Param("auditStatus") String auditStatus);
+
+ int addMany(@Param("workOrderList") List<WorkOrder> workOrderList);
+
+ /**
+ * 鎵归噺淇敼鐘舵��
+ *
+ * @param workOrderList
+ * @return
+ */
+ int updateMany(List<WorkOrder> workOrderList);
}
--
Gitblit v1.8.0