From db75b45e9a7ce347162b8d3a36e4a7f46cfe199e Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期一, 10 二月 2025 15:30:18 +0800
Subject: [PATCH] 核算导出单独对录像扣分的数量做处理

---
 ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java |   39 ++++++++++++++++++++++++++++++++++++++-
 1 files changed, 38 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 517232c..9b48848 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
@@ -3,8 +3,11 @@
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.ycl.platform.domain.entity.WorkOrder;
+import com.ycl.platform.domain.excel.WorkOrderWhiteExport;
+import com.ycl.platform.domain.form.WorkOrderBatchAuditingForm;
 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.vo.YwPointJobVO;
 import com.ycl.platform.domain.vo.screen.ScreenWorkOrderVO;
@@ -28,6 +31,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);
 
@@ -73,7 +77,7 @@
      */
     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);
+    List<WorkOrderVO> selectPassOrder(@Param("startTime") LocalDateTime now, @Param("endTime")LocalDateTime thirtyDaysAgo, @Param("status") String status, @Param("errorList") List<String> errorList,@Param("auditStatus") String auditStatus);
 
     int addMany(@Param("workOrderList") List<WorkOrder> workOrderList);
 
@@ -84,4 +88,37 @@
      * @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);
+
+    List<WorkOrder> selectByNos(@Param("workOrderNos") List<String> workOrderNos);
+
+
+    List<String> getOfflineWorkOrder();
+
+    List<WorkOrderVO> getAuditTimeList(@Param("workOrderNos")List<String> workOrderNos);
+
+    List<WorkOrderVO> getHandleTimeList(@Param("workOrderNos")List<String> workOrderNos);
+
 }

--
Gitblit v1.8.0