From d51d44b7c4fae2e5620ade09f3e728ae8f3a5795 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期五, 02 八月 2024 16:29:27 +0800
Subject: [PATCH] 数据中心service

---
 ycl-pojo/src/main/java/com/ycl/platform/base/AbsQuery.java                        |    8 
 ycl-server/src/main/java/com/ycl/utils/MongoUtil.java                             |   32 ++
 ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java |  586 ++++++++++++++++++++++++++++++++++++++++++++---------
 ycl-server/src/main/java/com/ycl/platform/service/DataCenterService.java          |   28 +-
 4 files changed, 541 insertions(+), 113 deletions(-)

diff --git a/ycl-pojo/src/main/java/com/ycl/platform/base/AbsQuery.java b/ycl-pojo/src/main/java/com/ycl/platform/base/AbsQuery.java
index 69eb752..09bf614 100644
--- a/ycl-pojo/src/main/java/com/ycl/platform/base/AbsQuery.java
+++ b/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;
+    }
 }
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/DataCenterService.java b/ycl-server/src/main/java/com/ycl/platform/service/DataCenterService.java
index 06d1eed..3b86d92 100644
--- a/ycl-server/src/main/java/com/ycl/platform/service/DataCenterService.java
+++ b/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);
 
     /**
      * 浜鸿劯锛氫汉鑴稿崱鍙ｄ俊鎭噰闆嗗噯纭巼
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 b9c0a83..9e70a0e 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
@@ -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;
     }
 
     /**
      * 杞﹁締锛氳溅杈嗗崱鍙ｈ澶噓rl鍙敤鎬�
      *
-     * @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;
     }
 }
diff --git a/ycl-server/src/main/java/com/ycl/utils/MongoUtil.java b/ycl-server/src/main/java/com/ycl/utils/MongoUtil.java
new file mode 100644
index 0000000..4f88595
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/utils/MongoUtil.java
@@ -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锛歺p
+ * @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);
+        }
+    }
+
+}

--
Gitblit v1.8.0