From c4df5d2cfaa12a1c8a72ef25934fdc31d5be65a1 Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期日, 29 九月 2024 11:21:21 +0800 Subject: [PATCH] 工单导出 --- ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java | 36 +++++++++++++++++++++++++++++++++++- 1 files changed, 35 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 53c5113..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 @@ -5,6 +5,7 @@ import com.ycl.platform.domain.entity.WorkOrder; 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; @@ -14,6 +15,7 @@ import org.apache.ibatis.annotations.Param; import java.time.LocalDateTime; +import java.util.Date; import java.util.List; import java.util.Map; @@ -27,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); @@ -70,9 +73,40 @@ * 鏌ヨ宸ュ崟璁惧淇℃伅 * @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); + + /** + * 鑾峰彇鏈畬鎴愮殑宸ュ崟 + * + * @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