From 13575e2a109e607f3daffcb65103ed0233fa7621 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期一, 30 九月 2024 18:12:26 +0800
Subject: [PATCH] 点位在线定时任务卡死修复

---
 ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java |   90 +++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 83 insertions(+), 7 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 6f29f18..378fd6c 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
@@ -1,18 +1,23 @@
 package com.ycl.platform.mapper;
 
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.ycl.platform.domain.entity.WorkOrder;
-import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.ycl.platform.domain.query.DistributeWorkOrderQuery;
-import com.ycl.platform.domain.query.WorkOrderQuery;
+import com.ycl.platform.domain.query.*;
+import com.ycl.platform.domain.vo.DeviceInfoVO;
+import com.ycl.platform.domain.vo.WorkOrderDetailVO;
 import com.ycl.platform.domain.vo.WorkOrderVO;
-import com.ycl.platform.domain.form.WorkOrderForm;
-import java.util.List;
-
-import com.ycl.platform.domain.vo.WorkOrderYwConditionRecordVO;
 import com.ycl.platform.domain.vo.YwPointJobVO;
+import com.ycl.platform.domain.vo.screen.ScreenWorkOrderVO;
+import com.ycl.platform.domain.vo.screen.WorkOrderRegionVO;
+import com.ycl.platform.domain.vo.screen.WorkOrderTotalVO;
 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;
 
 /**
  * 宸ュ崟 Mapper 鎺ュ彛
@@ -24,6 +29,7 @@
 public interface WorkOrderMapper extends BaseMapper<WorkOrder> {
 
     IPage<WorkOrderVO> page(IPage page, @Param("query") WorkOrderQuery query);
+    List<WorkOrderVO> export(@Param("query") WorkOrderExportQuery query);
 
     IPage<WorkOrderVO> distributePage(IPage page, @Param("query") DistributeWorkOrderQuery query);
 
@@ -33,4 +39,74 @@
      * @return
      */
     List<YwPointJobVO> handlingWorkOrderList();
+
+    /**
+     * 缁熻澶у睆宸ュ崟鏁版嵁
+     *
+     * @param query
+     * @return
+     */
+    ScreenWorkOrderVO screenWorkOrder(@Param("query") ScreenQuery query);
+
+    /**
+     * 棣栭〉缁熻鏁版嵁
+     * @param monitorQuery 鏌ヨ鏉′欢
+     * @return 鏁版嵁
+     */
+    List<Map<String, Object>> home(HomeQuery monitorQuery);
+
+    /**
+     * 澶у睆宸ュ崟鎬绘暟
+     * @param dashboardQuery 鏌ヨ鏉′欢
+     * @return 鏁版嵁
+     */
+    WorkOrderTotalVO workOrderTotal(DashboardQuery dashboardQuery);
+
+    /**
+     * 澶у睆宸ュ崟鍒嗗尯
+     * @param dashboardQuery 鏌ヨ鏉′欢
+     * @return 鏁版嵁
+     */
+    List<WorkOrderRegionVO> workOrderRegion(DashboardQuery dashboardQuery);
+
+    /**
+     * 鏌ヨ宸ュ崟璁惧淇℃伅
+     * @return
+     */
+    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);
+
+    /**
+     * 鑾峰彇鏈畬鎴愮殑宸ュ崟
+     *
+     * @param serialNumberList
+     * @return
+     */
+    List<WorkOrder> getNotFinishedWorkOrders(@Param("list") List<String> serialNumberList);
+
+    /**
+     * 宸ュ崟鍙锋煡璇︽儏
+     *
+     * @param workOrderNo
+     * @return
+     */
+    WorkOrderDetailVO detailByNo(@Param("workOrderNo") String workOrderNo);
+
+    /**
+     * 琛ュ厖寮傚父鎭㈠鐩戞帶淇℃伅
+     * @param orders
+     * @return
+     */
+    List<WorkOrderVO> getRecoveryInfo(List<String> orders);
 }

--
Gitblit v1.8.0