同步国标设备、点播定时任务优化

xiangpei

2024-08-28 ddb3068a51a8af8aa9a8f8c2cb9b6e9228b0c8d9

 ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java

@@ -1,14 +1,22 @@
package com.ycl.platform.service.impl;

import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.ycl.platform.domain.entity.ImageResourceSecurityDetail;
import com.ycl.platform.domain.query.DataCenterQuery;
import com.ycl.platform.domain.result.HK.*;
import com.ycl.platform.domain.result.UY.MonitorQualifyResult;
import com.ycl.platform.domain.result.UY.OneMachineFileResult;
import com.ycl.platform.domain.result.UY.RecordMetaDSumResult;
import com.ycl.platform.domain.result.UY.VideoOnlineResult;
import com.ycl.platform.mapper.ImageResourceSecurityDetailMapper;
import com.ycl.platform.mapper.ImageResourceSecurityMapper;
import com.ycl.platform.service.DataCenterService;
import com.ycl.system.Result;
import com.ycl.system.page.TableDataInfo;
import com.ycl.utils.MongoUtil;
import constant.HttpStatus;
import lombok.RequiredArgsConstructor;
import org.springframework.data.domain.Sort;
import org.springframework.data.mongodb.core.MongoTemplate;
@@ -30,7 +38,8 @@
public class DataCenterServiceImpl implements DataCenterService {

    private final MongoTemplate mongoTemplate;

    private final ImageResourceSecurityMapper securityMapper;
    private final ImageResourceSecurityDetailMapper securityDetailMapper;
    private final static String TIME_FIELD = "mongoCreateTime";

    /**
@@ -52,9 +61,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, VideoOnlineResult.class);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<VideoOnlineResult> resultList = mongoTemplate.find(query, VideoOnlineResult.class);
        long total = mongoTemplate.count(query, VideoOnlineResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -77,9 +86,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        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);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -102,9 +111,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, MonitorQualifyResult.class);
        query.with(Sort.by(Sort.Order.asc(TIME_FIELD))).skip(params.getSkipNum()).limit(Math.toIntExact(params.getPageSize()));
        List<MonitorQualifyResult> resultList = mongoTemplate.find(query, MonitorQualifyResult.class);
        long total = mongoTemplate.count(query, MonitorQualifyResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -127,9 +136,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        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);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -152,9 +161,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, RecordMetaDSumResult.class);
        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);
        long total = mongoTemplate.count(query, RecordMetaDSumResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -177,9 +186,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, RecordMetaDSumResult.class);
        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);
        long total = mongoTemplate.count(query, RecordMetaDSumResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -189,7 +198,6 @@
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public Result videoLabelingAccuracy(DataCenterQuery params) {
        Query query = new Query();
@@ -203,9 +211,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        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);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -215,7 +223,6 @@
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public Result videoImportantPointLabelingAccuracy(DataCenterQuery params) {
        Query query = new Query();
@@ -229,9 +236,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        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);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -241,7 +248,6 @@
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public Result videoCheckTimeAccuracy(DataCenterQuery params) {
        Query query = new Query();
@@ -255,9 +261,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        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);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -267,7 +273,6 @@
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public Result videoImportantPointCheckTimeAccuracy(DataCenterQuery params) {
        Query query = new Query();
@@ -281,9 +286,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        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);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -293,7 +298,6 @@
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public Result videoImportantPointOnlineRate(DataCenterQuery params) {
        Query query = new Query();
@@ -307,9 +311,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        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);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -319,7 +323,6 @@
     * @param params
     * @return
     */
    // TODO 返回数据对象更换
    @Override
    public Result videoImportantPointImageOnlineRate(DataCenterQuery params) {
        Query query = new Query();
@@ -333,9 +336,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        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);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -361,9 +364,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);
        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);
        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -386,9 +389,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);
        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);
        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -411,9 +414,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        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);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -436,9 +439,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, CrossDetailResult.class);
        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);
        long total = mongoTemplate.count(query, CrossDetailResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -461,9 +464,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, DataIntegrityMonitoringResult.class);
        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);
        long total = mongoTemplate.count(query, DataIntegrityMonitoringResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -486,9 +489,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, AttrRecognitionMonitorResult.class);
        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);
        long total = mongoTemplate.count(query, AttrRecognitionMonitorResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -511,9 +514,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, VehicleDeviceInspectionResult.class);
        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);
        long total = mongoTemplate.count(query, VehicleDeviceInspectionResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -536,9 +539,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, SnapshotDelayMonitorResult.class);
        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);
        long total = mongoTemplate.count(query, SnapshotDelayMonitorResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -561,9 +564,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, PicAccessResult.class);
        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);
        long total = mongoTemplate.count(query, PicAccessResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -586,9 +589,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, VehicleDeviceSamplingResult.class);
        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);
        long total = mongoTemplate.count(query, VehicleDeviceSamplingResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -611,9 +614,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);
        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);
        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -623,7 +626,6 @@
     * @param params
     * @return
     */
    // TODO 更换响应结果
    @Override
    public Result facePointOnlineRate(DataCenterQuery params) {
        Query query = new Query();
@@ -637,9 +639,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);
        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);
        long total = mongoTemplate.count(query, SnapshotDataMonitorResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -662,9 +664,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        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);
        long total = mongoTemplate.count(query, OneMachineFileResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -687,9 +689,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, CrossDetailResult.class);
        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);
        long total = mongoTemplate.count(query, CrossDetailResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -712,9 +714,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, MonitoringDetailResult.class);
        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);
        long total = mongoTemplate.count(query, MonitoringDetailResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -737,9 +739,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, FaceDeviceInspectionResult.class);
        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);
        long total = mongoTemplate.count(query, FaceDeviceInspectionResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -762,9 +764,9 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, FaceDeviceInspectionResult.class);
        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);
        long total = mongoTemplate.count(query, FaceDeviceInspectionResult.class);
        return Result.ok().data(resultList).total(total);
    }

@@ -787,9 +789,24 @@
            );
        }
        query.addCriteria(criteria);
        long total = mongoTemplate.count(query, FaceDeviceSamplingResult.class);
        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);
        long total = mongoTemplate.count(query, FaceDeviceSamplingResult.class);
        return Result.ok().data(resultList).total(total);
    }
    /**
     * 视频：视频图像资源安全管理
     *
     * @param query
     * @return
     */
    @Override
    public Result videoImageResourceSecurity(DataCenterQuery query) {
        ImageResourceSecurityDetail imageResourceSecurityDetail = new ImageResourceSecurityDetail();
        Page<ImageResourceSecurityDetail> page = PageHelper.startPage(query.getPageNum(), query.getPageSize());
        securityDetailMapper.selectImageResourceSecurityDetailList(imageResourceSecurityDetail);

        return  Result.ok().data(page.getResult()).total(page.getTotal());

    }
}