修改大屏录像可用率指标,点位在线指标，数据中心录像可用率，

zxl

2025-05-29 71f61d13531b3e2a0099ba5afe3f268c99c5bacf

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

@@ -3,18 +3,21 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.ycl.platform.domain.entity.TMonitor;
import com.ycl.platform.domain.excel.TMonitorExp;
import com.ycl.platform.domain.form.VideoExportForm;
import com.ycl.platform.domain.query.DashboardQuery;
import com.ycl.platform.domain.query.DataCenterQuery;
import com.ycl.platform.domain.query.HomeQuery;
import com.ycl.platform.domain.result.SYS.TMonitorResult;
import com.ycl.platform.domain.vo.TMonitorVO;
import com.ycl.platform.domain.vo.UpdateOnlineVO;
import com.ycl.platform.domain.vo.WorkOrderVO;
import com.ycl.platform.domain.vo.screen.MonitorRateVO;
import com.ycl.platform.domain.vo.screen.MonitorTotalVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.security.core.parameters.P;

import java.util.Date;
import java.util.List;
import java.util.Map;

@@ -92,7 +95,7 @@

    /**
     * 获取恢复异常设备
     * @param time 时间
     * @param monitor 时间
     * @return 数据
     */
    Map<String, String> recoveryException(TMonitorVO monitor);
@@ -134,6 +137,8 @@


    void deleteAll();
    Long getAllVideo();
    List<String> getIdListVideo();

    /**
     * 批量修改设备厂商类型
@@ -158,13 +163,19 @@
     *
     * @return
     */
    List<TMonitor> getDistinctIP();
    List<TMonitorResult> getDistinctIP();

    /**
     * 根据ip修改点位表的是否在线字段
     * @param onlineList
     */
    void updateOnline(@Param("onlineList") List<UpdateOnlineVO> onlineList);
    void updateOnlineFromUyOrHk(@Param("onlineList") List<UpdateOnlineVO> onlineList);

    /**
     * 根据国标修改
     * @param onlineList
     */
    void updateOnlineFromHk(@Param("onlineList") List<UpdateOnlineVO> onlineList);


    /**
@@ -173,5 +184,20 @@
     * @param tMonitor 设备资产
     * @return 设备资产集合
     */
    public List<TMonitorResult> selectMonitorResult(@Param("cameraFunType") Short cameraFunType,@Param("deptIds") List<Integer> deptIds);
    public List<TMonitorResult> selectMonitorResult(VideoExportForm exportForm);

    void batchUpdateOnline(@Param("ipList")List<String> ipList,@Param("date") Date date,@Param("online")Integer online);

    List<TMonitor> selectCarOrFace();

    List<TMonitorExp> exportTMonitorList(TMonitorVO tMonitor);

    List<TMonitorResult> getByIp(@Param("ipList")List<String> ips);

    void clearMonitor();

    List<String> getVideoIds();

    Map<String, String> assetManagementCount();

}