代码注释,运维监控报表接口统计sql重新编写

zxl

2025-02-19 002372c5cfd2c9b9881fda5e527c2b6c4ee4d599

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

}