视频点位在线率mongo重构

xiangpei

2024-09-03 bd97fda26e0432ae5634f6756b94f4169350c0f0

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

@@ -1,15 +1,16 @@
package com.ycl.platform.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.ycl.platform.base.BaseSelect;
import com.ycl.platform.domain.entity.YwPoint;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ycl.platform.domain.query.YwPointQuery;
import com.ycl.platform.domain.vo.YwPointVO;
import com.ycl.platform.domain.form.YwPointForm;
import java.util.List;

import com.ycl.system.Result;
import com.ycl.platform.domain.excel.PointExport;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 运维点位 Mapper 接口
@@ -27,4 +28,61 @@
     * @return
     */
    List<BaseSelect> selectData(@Param("keyword") String keyword, @Param("unitId") Integer unitId);

    IPage page(IPage<YwPointVO> page, @Param("query") YwPointQuery query);

    /**
     * 首页到期预警
     * @return 数据
     */
    List<YwPoint> home();

    /**
     * 通过标签查重点点位或省厅点位或重点指挥图像
     */
    List<YwPoint> selectByTag(@Param("important")Boolean important,
                              @Param("province")Boolean province,
                              @Param("commandImage")Boolean commandImage,
                              @Param("deptTag") Boolean deptTag);

    /**
     * 导出数据
     *
     * @param query
     * @return
     */
    List<PointExport> export(@Param("query") YwPointQuery query);

    void deleteAll();

    /**
     * 更新点位信息
     *
     * @param pointList
     */
    int updatePoint(List<YwPoint> pointList);

    /**
     * 统计某点位对应的未完成工单数量，理论上最大值为1个工单
     *
     * @param pointId
     * @return
     */
    YwPointVO countNotFinishedWorkOrderByPointId(@Param("pointId") Integer pointId);

    /**
     * 统计某点位对应的未完成工单数量，理论上最大值为1个工单
     *
     * @param serialNumber
     * @return
     */
    YwPointVO countNotFinishedWorkOrderByGb(@Param("serialNumber") String serialNumber);

    /**
     * 查询有部级标签的点位的国标码
     *
     * @param tagType 0 部级  1 重点  2 重点指挥图像
     * @return
     */
    List<String> getDeptPointGB(@Param("tagType") Integer tagType);
}