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); /** * 瑙嗛锛氫竴鏈轰竴妗f敞鍐岀巼 @@ -30,7 +30,7 @@ * @param query * @return */ - List<TMonitorVO> videoOneMachineDocumentRegister(DataCenterQuery query); + List<OneMachineFileResult> videoOneMachineDocumentRegister(DataCenterQuery query); /** * 瑙嗛锛氫竴鏈轰竴妗e悎鏍肩巼 @@ -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); /** * 杞﹁締锛氳溅杈嗗崱鍙d俊鎭噰闆嗗噯纭巼 @@ -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); /** * 浜鸿劯锛氫汉鑴稿崱鍙d俊鎭噰闆嗗噯纭巼 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; } /** * 瑙嗛锛氫竴鏈轰竴妗f敞鍐岀巼 * - * @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; } /** * 瑙嗛锛氫竴鏈轰竴妗e悎鏍肩巼 * - * @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; } /** * 杞﹁締锛氳溅杈嗗崱鍙d俊鎭噰闆嗗噯纭巼 * - * @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; } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶囨姄鎷嶆暟鎹畬鏁存�� * - * @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; } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶囨姄鎷嶆暟鎹噯纭�� * - * @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; } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶囨椂閽熷噯纭�� * - * @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; } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶囨姄鎷嶆暟鎹笂浼犲強鏃舵�� * - * @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; } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶噓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; } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶囨姄鎷嶆暟鎹ぇ鍥惧彲鐢ㄦ�� * - * @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; } /** * 浜鸿劯锛氫汉鑴稿崱鍙d俊鎭噰闆嗗噯纭巼 * - * @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; } /** * 浜鸿劯锛氫汉鑴稿崱鍙h澶囨姄鎷嶆暟鎹ぇ鍥惧彲鐢ㄦ�� * - * @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