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