工单扣分处理时间调整逻辑

fuliqi

2025-01-16 23302186a81c1b6f3e5f398f21b057350bfd34e8

 ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java

@@ -3,7 +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;
@@ -12,6 +16,8 @@
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;

@@ -25,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);

@@ -63,4 +70,55 @@
     * @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("errorList") List<String> errorList);

    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);

    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);

}