OSD加标签

fuliqi

2024-09-11 b14531e3b850fe6d2fa916ba7b88b3e2bd2ff30a

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

@@ -6,7 +6,9 @@
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.screen.MonitorRateVO;
import com.ycl.platform.domain.vo.screen.MonitorTotalVO;
import org.apache.ibatis.annotations.Mapper;
@@ -140,4 +142,34 @@
    int batchUpdateDeviceType(@Param("numbers") List<String> list,@Param("deviceType") Integer deviceType);

    List<TMonitor> selectByNumbers(@Param("numbers")List<String> numbers);

    /**
     * 国标码查国标码
     *
     * @param gbList
     * @return
     */
    List<String> getGBbyGB(@Param("gbList") List<String> gbList);

    /**
     * 查出设备ip集合
     *
     * @return
     */
    List<TMonitor> getDistinctIP();

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


    /**
     * 点位在线率
     *
     * @param tMonitor 设备资产
     * @return 设备资产集合
     */
    public List<TMonitorResult> selectMonitorResult(Short cameraFunType);
}