xiangpei
2024-08-02 d51d44b7c4fae2e5620ade09f3e728ae8f3a5795
数据中心service
3个文件已修改
1个文件已添加
654 ■■■■ 已修改文件
ycl-pojo/src/main/java/com/ycl/platform/base/AbsQuery.java 8 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ycl-server/src/main/java/com/ycl/platform/service/DataCenterService.java 28 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java 586 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ycl-server/src/main/java/com/ycl/utils/MongoUtil.java 32 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ycl-pojo/src/main/java/com/ycl/platform/base/AbsQuery.java
@@ -18,4 +18,12 @@
    @ApiModelProperty(value = "每页条数", required = true)
    private Long pageSize = 10L;
    /**
     * 获取mongo分页skip跳过的条数
     *
     * @return
     */
    public Long getSkipNum() {
        return (pageNum - 1) * pageSize;
    }
}
ycl-server/src/main/java/com/ycl/platform/service/DataCenterService.java
@@ -2,8 +2,8 @@
import com.ycl.platform.domain.query.DataCenterQuery;
import com.ycl.platform.domain.result.HK.*;
import com.ycl.platform.domain.result.UY.OneMachineFileResult;
import com.ycl.platform.domain.result.UY.RecordMetaDSumResult;
import com.ycl.platform.domain.vo.TMonitorVO;
import java.util.List;
@@ -22,7 +22,7 @@
     * @return
     */
    // TODO 返回数据对象更换
    List<TMonitorVO> videoPointOnlineRate(DataCenterQuery query);
    List<OneMachineFileResult> videoPointOnlineRate(DataCenterQuery query);
    /**
     * 视频:一机一档注册率
@@ -30,7 +30,7 @@
     * @param query
     * @return
     */
    List<TMonitorVO> videoOneMachineDocumentRegister(DataCenterQuery query);
    List<OneMachineFileResult> videoOneMachineDocumentRegister(DataCenterQuery query);
    /**
     * 视频:一机一档合格率
@@ -38,7 +38,7 @@
     * @param query
     * @return
     */
    List<TMonitorVO> videoOneMachineDocumentQualified(DataCenterQuery query);
    List<OneMachineFileResult> videoOneMachineDocumentQualified(DataCenterQuery query);
    /**
     * 视频:档案考核比
@@ -46,7 +46,7 @@
     * @param query
     * @return
     */
    List<TMonitorVO> videoAssessmentFileRatio(DataCenterQuery query);
    List<OneMachineFileResult> videoAssessmentFileRatio(DataCenterQuery query);
    /**
     * 视频:录像可用率
@@ -71,7 +71,7 @@
     * @return
     */
    // TODO 返回数据对象更换
    List<TMonitorVO> videoLabelingAccuracy(DataCenterQuery query);
    List<OneMachineFileResult> videoLabelingAccuracy(DataCenterQuery query);
    /**
     * 视频:重点点位标注正确率
@@ -80,7 +80,7 @@
     * @return
     */
    // TODO 返回数据对象更换
    List<TMonitorVO> videoImportantPointLabelingAccuracy(DataCenterQuery query);
    List<OneMachineFileResult> videoImportantPointLabelingAccuracy(DataCenterQuery query);
    /**
     * 视频:校时正确率
@@ -89,7 +89,7 @@
     * @return
     */
    // TODO 返回数据对象更换
    List<TMonitorVO> videoCheckTimeAccuracy(DataCenterQuery query);
    List<OneMachineFileResult> videoCheckTimeAccuracy(DataCenterQuery query);
    /**
     * 视频:重点点位校时正确率
@@ -98,7 +98,7 @@
     * @return
     */
    // TODO 返回数据对象更换
    List<TMonitorVO> videoImportantPointCheckTimeAccuracy(DataCenterQuery query);
    List<OneMachineFileResult> videoImportantPointCheckTimeAccuracy(DataCenterQuery query);
    /**
     * 视频:重点点位在线率
@@ -107,7 +107,7 @@
     * @return
     */
    // TODO 返回数据对象更换
    List<TMonitorVO> videoImportantPointOnlineRate(DataCenterQuery query);
    List<OneMachineFileResult> videoImportantPointOnlineRate(DataCenterQuery query);
    /**
     * 视频:重点指挥图像在线率
@@ -116,7 +116,7 @@
     * @return
     */
    // TODO 返回数据对象更换
    List<TMonitorVO> videoImportantPointImageOnlineRate(DataCenterQuery query);
    List<OneMachineFileResult> videoImportantPointImageOnlineRate(DataCenterQuery query);
@@ -144,7 +144,7 @@
     * @param query
     * @return
     */
    List<TMonitorVO> vehicleNetDeviceDirectoryConsistency(DataCenterQuery query);
    List<OneMachineFileResult> vehicleNetDeviceDirectoryConsistency(DataCenterQuery query);
    /**
     * 车辆:车辆卡口信息采集准确率
@@ -225,7 +225,7 @@
     * @return
     */
    // TODO 更换响应结果
    List<TMonitorVO> facePointOnlineRate(DataCenterQuery query);
    List<OneMachineFileResult> facePointOnlineRate(DataCenterQuery query);
    /**
     * 人脸:目录一致率
@@ -233,7 +233,7 @@
     * @param query
     * @return
     */
    List<TMonitorVO> faceDirectoryConsistency(DataCenterQuery query);
    List<OneMachineFileResult> faceDirectoryConsistency(DataCenterQuery query);
    /**
     * 人脸:人脸卡口信息采集准确率
ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java
@@ -2,16 +2,20 @@
import com.ycl.platform.domain.query.DataCenterQuery;
import com.ycl.platform.domain.result.HK.*;
import com.ycl.platform.domain.result.UY.OneMachineFileResult;
import com.ycl.platform.domain.result.UY.RecordMetaDSumResult;
import com.ycl.platform.domain.vo.TMonitorVO;
import com.ycl.platform.service.DataCenterService;
import com.ycl.utils.MongoUtil;
import lombok.RequiredArgsConstructor;
import org.springframework.data.domain.Sort;
import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.data.mongodb.core.query.Criteria;
import org.springframework.data.mongodb.core.query.Query;
import org.springframework.data.mongodb.core.query.TextCriteria;
import org.springframework.stereotype.Service;
import java.util.List;
import java.util.Objects;
/**
 * 数据中心接口
@@ -25,143 +29,300 @@
    private final MongoTemplate mongoTemplate;
    private final static String TIME_FIELD = "mongoCreateTime";
    /**
     * 视频:点位在线率
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<TMonitorVO> videoPointOnlineRate(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> videoPointOnlineRate(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 视频:一机一档注册率
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<TMonitorVO> videoOneMachineDocumentRegister(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> videoOneMachineDocumentRegister(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 视频:一机一档合格率
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<TMonitorVO> videoOneMachineDocumentQualified(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> videoOneMachineDocumentQualified(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 视频:档案考核比
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<TMonitorVO> videoAssessmentFileRatio(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> videoAssessmentFileRatio(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 视频:录像可用率
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<RecordMetaDSumResult> videoAvailabilityRate(DataCenterQuery query) {
        return null;
    public List<RecordMetaDSumResult> videoAvailabilityRate(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<RecordMetaDSumResult> resultList = mongoTemplate.find(query, RecordMetaDSumResult.class);
        return resultList;
    }
    /**
     * 视频:重点点位录像可用率
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<RecordMetaDSumResult> videoImportantPointAvailabilityRate(DataCenterQuery query) {
        return null;
    public List<RecordMetaDSumResult> videoImportantPointAvailabilityRate(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<RecordMetaDSumResult> resultList = mongoTemplate.find(query, RecordMetaDSumResult.class);
        return resultList;
    }
    /**
     * 视频:标注正确率
     *
     * @param query
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public List<TMonitorVO> videoLabelingAccuracy(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> videoLabelingAccuracy(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 视频:重点点位标注正确率
     *
     * @param query
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public List<TMonitorVO> videoImportantPointLabelingAccuracy(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> videoImportantPointLabelingAccuracy(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 视频:校时正确率
     *
     * @param query
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public List<TMonitorVO> videoCheckTimeAccuracy(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> videoCheckTimeAccuracy(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 视频:重点点位校时正确率
     *
     * @param query
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public List<TMonitorVO> videoImportantPointCheckTimeAccuracy(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> videoImportantPointCheckTimeAccuracy(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 视频:重点点位在线率
     *
     * @param query
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public List<TMonitorVO> videoImportantPointOnlineRate(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> videoImportantPointOnlineRate(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 视频:重点指挥图像在线率
     *
     * @param query
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public List<TMonitorVO> videoImportantPointImageOnlineRate(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> videoImportantPointImageOnlineRate(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
@@ -170,206 +331,433 @@
    /**
     * 车辆:视图库对接稳定性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<SnapshotDataMonitorResult> vehicleViewDockStable(DataCenterQuery query) {
        //
        Criteria criteria = new Criteria().andOperator(
                Criteria.where("name").is("xp"),
                Criteria.where("age").lte(50)
        );
        List<SnapshotDataMonitorResult> ts = mongoTemplate.find(Query.query(criteria), SnapshotDataMonitorResult.class);
        return null;
    public List<SnapshotDataMonitorResult> vehicleViewDockStable(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<SnapshotDataMonitorResult> resultList = mongoTemplate.find(query, SnapshotDataMonitorResult.class);
        return resultList;
    }
    /**
     * 车辆:点位在线率
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<SnapshotDataMonitorResult> vehiclePointOnlineRate(DataCenterQuery query) {
        return null;
    public List<SnapshotDataMonitorResult> vehiclePointOnlineRate(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<SnapshotDataMonitorResult> resultList = mongoTemplate.find(query, SnapshotDataMonitorResult.class);
        return resultList;
    }
    /**
     * 车辆:互联网卡口设备目录一致性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<TMonitorVO> vehicleNetDeviceDirectoryConsistency(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> vehicleNetDeviceDirectoryConsistency(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 车辆:车辆卡口信息采集准确率
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<CrossDetailResult> vehicleCollectionConsistency(DataCenterQuery query) {
        return null;
    public List<CrossDetailResult> vehicleCollectionConsistency(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<CrossDetailResult> resultList = mongoTemplate.find(query, CrossDetailResult.class);
        return resultList;
    }
    /**
     * 车辆:车辆卡口设备抓拍数据完整性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<DataIntegrityMonitoringResult> vehicleCollectionDataIntegrity(DataCenterQuery query) {
        return null;
    public List<DataIntegrityMonitoringResult> vehicleCollectionDataIntegrity(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<DataIntegrityMonitoringResult> resultList = mongoTemplate.find(query, DataIntegrityMonitoringResult.class);
        return resultList;
    }
    /**
     * 车辆:车辆卡口设备抓拍数据准确性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<AttrRecognitionMonitorResult> vehicleCollectionDataCaptured(DataCenterQuery query) {
        return null;
    public List<AttrRecognitionMonitorResult> vehicleCollectionDataCaptured(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<AttrRecognitionMonitorResult> resultList = mongoTemplate.find(query, AttrRecognitionMonitorResult.class);
        return resultList;
    }
    /**
     * 车辆:车辆卡口设备时钟准确性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<VehicleDeviceInspectionResult> vehicleClockAccuracy(DataCenterQuery query) {
        return null;
    public List<VehicleDeviceInspectionResult> vehicleClockAccuracy(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<VehicleDeviceInspectionResult> resultList = mongoTemplate.find(query, VehicleDeviceInspectionResult.class);
        return resultList;
    }
    /**
     * 车辆:车辆卡口设备抓拍数据上传及时性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<SnapshotDelayMonitorResult> vehicleTimelyUploadAccuracy(DataCenterQuery query) {
        return null;
    public List<SnapshotDelayMonitorResult> vehicleTimelyUploadAccuracy(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<SnapshotDelayMonitorResult> resultList = mongoTemplate.find(query, SnapshotDelayMonitorResult.class);
        return resultList;
    }
    /**
     * 车辆:车辆卡口设备url可用性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<PicAccessResult> vehicleUrlAccuracy(DataCenterQuery query) {
        return null;
    public List<PicAccessResult> vehicleUrlAccuracy(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<PicAccessResult> resultList = mongoTemplate.find(query, PicAccessResult.class);
        return resultList;
    }
    /**
     * 车辆:车辆卡口设备抓拍数据大图可用性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<VehicleDeviceSamplingResult> vehicleBigImgAccuracy(DataCenterQuery query) {
        return null;
    public List<VehicleDeviceSamplingResult> vehicleBigImgAccuracy(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<VehicleDeviceSamplingResult> resultList = mongoTemplate.find(query, VehicleDeviceSamplingResult.class);
        return resultList;
    }
    /**
     * 人脸:视图库对接稳定性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<SnapshotDataMonitorResult> faceViewDockStable(DataCenterQuery query) {
        return null;
    public List<SnapshotDataMonitorResult> faceViewDockStable(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<SnapshotDataMonitorResult> resultList = mongoTemplate.find(query, SnapshotDataMonitorResult.class);
        return resultList;
    }
    /**
     * 人脸:点位在线率
     *
     * @param query
     * @param params
     * @return
     */
    // TODO 更换响应结果
    @Override
    public List<TMonitorVO> facePointOnlineRate(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> facePointOnlineRate(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 人脸:目录一致率
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<TMonitorVO> faceDirectoryConsistency(DataCenterQuery query) {
        return null;
    public List<OneMachineFileResult> faceDirectoryConsistency(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<OneMachineFileResult> resultList = mongoTemplate.find(query, OneMachineFileResult.class);
        return resultList;
    }
    /**
     * 人脸:人脸卡口信息采集准确率
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<CrossDetailResult> faceCollectionConsistency(DataCenterQuery query) {
        return null;
    public List<CrossDetailResult> faceCollectionConsistency(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<CrossDetailResult> resultList = mongoTemplate.find(query, CrossDetailResult.class);
        return resultList;
    }
    /**
     * 人脸:设备抓拍图片合格性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<MonitoringDetailResult> faceImgQualification(DataCenterQuery query) {
        return null;
    public List<MonitoringDetailResult> faceImgQualification(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<MonitoringDetailResult> resultList = mongoTemplate.find(query, MonitoringDetailResult.class);
        return resultList;
    }
    /**
     * 人脸:设备抓拍图片时钟准确性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<FaceDeviceInspectionResult> faceCapturesImagesAccuracy(DataCenterQuery query) {
        return null;
    public List<FaceDeviceInspectionResult> faceCapturesImagesAccuracy(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<FaceDeviceInspectionResult> resultList = mongoTemplate.find(query, FaceDeviceInspectionResult.class);
        return resultList;
    }
    /**
     * 人脸:抓拍人脸数据上传及时性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<FaceDeviceInspectionResult> faceTimelyUpload(DataCenterQuery query) {
        return null;
    public List<FaceDeviceInspectionResult> faceTimelyUpload(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<FaceDeviceInspectionResult> resultList = mongoTemplate.find(query, FaceDeviceInspectionResult.class);
        return resultList;
    }
    /**
     * 人脸:人脸卡口设备抓拍数据大图可用性
     *
     * @param query
     * @param params
     * @return
     */
    @Override
    public List<FaceDeviceSamplingResult> faceAvailabilityOfLargeImg(DataCenterQuery query) {
        return null;
    public List<FaceDeviceSamplingResult> faceAvailabilityOfLargeImg(DataCenterQuery params) {
        Query query = new Query();
        // 全文索引查询
        MongoUtil.fullText(query, params.getKeyword());
        Criteria criteria = new Criteria();
        // 普通查询
        if (Objects.nonNull(params.getStartTime()) && Objects.nonNull(params.getEndTime())) {
            criteria.andOperator(
                    Criteria.where(TIME_FIELD).gte(params.getStartTime()).lte(params.getEndTime())
            );
        }
        query.addCriteria(criteria);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<FaceDeviceSamplingResult> resultList = mongoTemplate.find(query, FaceDeviceSamplingResult.class);
        return resultList;
    }
}
ycl-server/src/main/java/com/ycl/utils/MongoUtil.java
New file
@@ -0,0 +1,32 @@
package com.ycl.utils;
import org.springframework.data.mongodb.core.query.Query;
import org.springframework.data.mongodb.core.query.TextCriteria;
import org.springframework.util.StringUtils;
import java.lang.reflect.Field;
import java.util.Date;
import java.util.Objects;
/**
 * mongo工具类
 *
 * @author:xp
 * @date:2024/8/2 15:18
 */
public class MongoUtil {
    /**
     * 构造全文索引的条件
     *
     * @param query
     * @param keyword
     */
    public static void fullText(Query query, String keyword) {
        if (StringUtils.hasText(keyword)) {
            TextCriteria criteria = TextCriteria.forDefaultLanguage().matching(keyword);
            query.addCriteria(criteria);
        }
    }
}