每日录像可用指标添加日志，修改大屏为查看当前月平均

zxl

12 小时以前 3b0516a2959e25576e4f3fda697a3b025d06c8c9

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

@@ -3,13 +3,22 @@
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;
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.LocalDate;
import java.time.LocalDateTime;
import java.util.Date;
import java.util.List;
import java.util.Map;

@@ -23,6 +32,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);

@@ -53,12 +63,66 @@
     * @param dashboardQuery 查询条件
     * @return 数据
     */
    Map<String, Object> workOrderTotal(DashboardQuery dashboardQuery);
    WorkOrderTotalVO workOrderTotal(DashboardQuery dashboardQuery);

    /**
     * 大屏工单分区
     * @param dashboardQuery 查询条件
     * @return 数据
     */
    Map<String, Object> workOrderRegion(DashboardQuery dashboardQuery);
    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,@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);

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

    WorkOrderDetailVO detailByNoButNoDistributeRecord(String workOrderNo);

    List<WorkOrderVO> distributeList();
}