From cb7d99d810f2356096b67fbccd3fac556e638d83 Mon Sep 17 00:00:00 2001
From: 龚焕茏 <2842157468@qq.com>
Date: 星期四, 22 八月 2024 11:22:56 +0800
Subject: [PATCH] feat：查询条件优化

---
 ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java |   67 +++++++++++++++------------------
 1 files changed, 30 insertions(+), 37 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..f779f18 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
@@ -52,9 +52,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 +77,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 +102,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 +127,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 +152,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 +177,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 +189,6 @@
      * @param params
      * @return
      */
-    // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲
     @Override
     public Result videoLabelingAccuracy(DataCenterQuery params) {
         Query query = new Query();
@@ -203,9 +202,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 +214,6 @@
      * @param params
      * @return
      */
-    // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲
     @Override
     public Result videoImportantPointLabelingAccuracy(DataCenterQuery params) {
         Query query = new Query();
@@ -229,9 +227,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 +239,6 @@
      * @param params
      * @return
      */
-    // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲
     @Override
     public Result videoCheckTimeAccuracy(DataCenterQuery params) {
         Query query = new Query();
@@ -255,9 +252,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 +264,6 @@
      * @param params
      * @return
      */
-    // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲
     @Override
     public Result videoImportantPointCheckTimeAccuracy(DataCenterQuery params) {
         Query query = new Query();
@@ -281,9 +277,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 +289,6 @@
      * @param params
      * @return
      */
-    // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲
     @Override
     public Result videoImportantPointOnlineRate(DataCenterQuery params) {
         Query query = new Query();
@@ -307,9 +302,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 +314,6 @@
      * @param params
      * @return
      */
-    // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲
     @Override
     public Result videoImportantPointImageOnlineRate(DataCenterQuery params) {
         Query query = new Query();
@@ -333,9 +327,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 +355,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 +380,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 +405,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 +430,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 +455,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 +480,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 +505,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 +530,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 +555,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 +580,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 +605,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 +617,6 @@
      * @param params
      * @return
      */
-    // TODO 鏇存崲鍝嶅簲缁撴灉
     @Override
     public Result facePointOnlineRate(DataCenterQuery params) {
         Query query = new Query();
@@ -637,9 +630,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 +655,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 +680,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 +705,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 +730,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 +755,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 +780,9 @@
             );
         }
         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);
     }
 }

--
Gitblit v1.8.0