From b14531e3b850fe6d2fa916ba7b88b3e2bd2ff30a Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期三, 11 九月 2024 16:47:48 +0800 Subject: [PATCH] OSD加标签 --- ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java | 87 +++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 82 insertions(+), 5 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 57ae403..c37308f 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,15 +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.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,4 +32,73 @@ IPage<WorkOrderVO> distributePage(IPage page, @Param("query") DistributeWorkOrderQuery query); + /** + * 澶勭悊涓殑宸ュ崟 + * + * @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); } -- Gitblit v1.8.0