From ddb3068a51a8af8aa9a8f8c2cb9b6e9228b0c8d9 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期三, 28 八月 2024 11:53:27 +0800
Subject: [PATCH] 同步国标设备、点播定时任务优化

---
 ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java |   93 +++++++++++++++++++++++++++-------------------
 1 files changed, 55 insertions(+), 38 deletions(-)

diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java
index 7e35095..394332d 100644
--- a/ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java
+++ b/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());
+
+    }
 }

--
Gitblit v1.8.0