From fea89b769738f7db06281f244bc81135fc34ce76 Mon Sep 17 00:00:00 2001 From: 龚焕茏 <2842157468@qq.com> Date: 星期二, 27 八月 2024 11:33:10 +0800 Subject: [PATCH] feat:图像资源计算定时任务完善 --- ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java | 647 +++++++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 542 insertions(+), 105 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 b9c0a83..394332d 100644 --- a/ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java +++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java @@ -1,17 +1,31 @@ package com.ycl.platform.service.impl; +import com.github.pagehelper.Page; +import com.github.pagehelper.PageHelper; +import com.github.pagehelper.PageInfo; +import com.ycl.platform.domain.entity.ImageResourceSecurityDetail; import com.ycl.platform.domain.query.DataCenterQuery; import com.ycl.platform.domain.result.HK.*; +import com.ycl.platform.domain.result.UY.MonitorQualifyResult; +import com.ycl.platform.domain.result.UY.OneMachineFileResult; import com.ycl.platform.domain.result.UY.RecordMetaDSumResult; -import com.ycl.platform.domain.vo.TMonitorVO; +import com.ycl.platform.domain.result.UY.VideoOnlineResult; +import com.ycl.platform.mapper.ImageResourceSecurityDetailMapper; +import com.ycl.platform.mapper.ImageResourceSecurityMapper; import com.ycl.platform.service.DataCenterService; +import com.ycl.system.Result; +import com.ycl.system.page.TableDataInfo; +import com.ycl.utils.MongoUtil; +import constant.HttpStatus; import lombok.RequiredArgsConstructor; +import org.springframework.data.domain.Sort; import org.springframework.data.mongodb.core.MongoTemplate; import org.springframework.data.mongodb.core.query.Criteria; import org.springframework.data.mongodb.core.query.Query; import org.springframework.stereotype.Service; import java.util.List; +import java.util.Objects; /** * 鏁版嵁涓績鎺ュ彛 @@ -24,144 +38,308 @@ public class DataCenterServiceImpl implements DataCenterService { private final MongoTemplate mongoTemplate; + private final ImageResourceSecurityMapper securityMapper; + private final ImageResourceSecurityDetailMapper securityDetailMapper; + private final static String TIME_FIELD = "mongoCreateTime"; /** * 瑙嗛锛氱偣浣嶅湪绾跨巼 * - * @param query + * @param params * @return */ @Override - public List<TMonitorVO> videoPointOnlineRate(DataCenterQuery query) { - - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 瑙嗛锛氫竴鏈轰竴妗f敞鍐岀巼 * - * @param query + * @param params * @return */ @Override - public List<TMonitorVO> videoOneMachineDocumentRegister(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 瑙嗛锛氫竴鏈轰竴妗e悎鏍肩巼 * - * @param query + * @param params * @return */ @Override - public List<TMonitorVO> videoOneMachineDocumentQualified(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 瑙嗛锛氭。妗堣�冩牳姣� * - * @param query + * @param params * @return */ @Override - public List<TMonitorVO> videoAssessmentFileRatio(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 瑙嗛锛氬綍鍍忓彲鐢ㄧ巼 * - * @param query + * @param params * @return */ @Override - public List<RecordMetaDSumResult> videoAvailabilityRate(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 瑙嗛锛氶噸鐐圭偣浣嶅綍鍍忓彲鐢ㄧ巼 * - * @param query + * @param params * @return */ @Override - public List<RecordMetaDSumResult> videoImportantPointAvailabilityRate(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 瑙嗛锛氭爣娉ㄦ纭巼 * - * @param query + * @param params * @return */ - // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲 @Override - public List<TMonitorVO> videoLabelingAccuracy(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 瑙嗛锛氶噸鐐圭偣浣嶆爣娉ㄦ纭巼 * - * @param query + * @param params * @return */ - // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲 @Override - public List<TMonitorVO> videoImportantPointLabelingAccuracy(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 瑙嗛锛氭牎鏃舵纭巼 * - * @param query + * @param params * @return */ - // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲 @Override - public List<TMonitorVO> videoCheckTimeAccuracy(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 瑙嗛锛氶噸鐐圭偣浣嶆牎鏃舵纭巼 * - * @param query + * @param params * @return */ - // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲 @Override - public List<TMonitorVO> videoImportantPointCheckTimeAccuracy(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 瑙嗛锛氶噸鐐圭偣浣嶅湪绾跨巼 * - * @param query + * @param params * @return */ - // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲 @Override - public List<TMonitorVO> videoImportantPointOnlineRate(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 瑙嗛锛氶噸鐐规寚鎸ュ浘鍍忓湪绾跨巼 * - * @param query + * @param params * @return */ - // TODO 杩斿洖鏁版嵁瀵硅薄鏇存崲 @Override - public List<TMonitorVO> videoImportantPointImageOnlineRate(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } @@ -170,206 +348,465 @@ /** * 杞﹁締锛氳鍥惧簱瀵规帴绋冲畾鎬� * - * @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 Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 杞﹁締锛氱偣浣嶅湪绾跨巼 * - * @param query + * @param params * @return */ @Override - public List<SnapshotDataMonitorResult> vehiclePointOnlineRate(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 杞﹁締锛氫簰鑱旂綉鍗″彛璁惧鐩綍涓�鑷存�� * - * @param query + * @param params * @return */ @Override - public List<TMonitorVO> vehicleNetDeviceDirectoryConsistency(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 杞﹁締锛氳溅杈嗗崱鍙d俊鎭噰闆嗗噯纭巼 * - * @param query + * @param params * @return */ @Override - public List<CrossDetailResult> vehicleCollectionConsistency(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶囨姄鎷嶆暟鎹畬鏁存�� * - * @param query + * @param params * @return */ @Override - public List<DataIntegrityMonitoringResult> vehicleCollectionDataIntegrity(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶囨姄鎷嶆暟鎹噯纭�� * - * @param query + * @param params * @return */ @Override - public List<AttrRecognitionMonitorResult> vehicleCollectionDataCaptured(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶囨椂閽熷噯纭�� * - * @param query + * @param params * @return */ @Override - public List<VehicleDeviceInspectionResult> vehicleClockAccuracy(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶囨姄鎷嶆暟鎹笂浼犲強鏃舵�� * - * @param query + * @param params * @return */ @Override - public List<SnapshotDelayMonitorResult> vehicleTimelyUploadAccuracy(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶噓rl鍙敤鎬� * - * @param query + * @param params * @return */ @Override - public List<PicAccessResult> vehicleUrlAccuracy(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 杞﹁締锛氳溅杈嗗崱鍙h澶囨姄鎷嶆暟鎹ぇ鍥惧彲鐢ㄦ�� * - * @param query + * @param params * @return */ @Override - public List<VehicleDeviceSamplingResult> vehicleBigImgAccuracy(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 浜鸿劯锛氳鍥惧簱瀵规帴绋冲畾鎬� * - * @param query + * @param params * @return */ @Override - public List<SnapshotDataMonitorResult> faceViewDockStable(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 浜鸿劯锛氱偣浣嶅湪绾跨巼 * - * @param query + * @param params * @return */ - // TODO 鏇存崲鍝嶅簲缁撴灉 @Override - public List<TMonitorVO> facePointOnlineRate(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 浜鸿劯锛氱洰褰曚竴鑷寸巼 * - * @param query + * @param params * @return */ @Override - public List<TMonitorVO> faceDirectoryConsistency(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 浜鸿劯锛氫汉鑴稿崱鍙d俊鎭噰闆嗗噯纭巼 * - * @param query + * @param params * @return */ @Override - public List<CrossDetailResult> faceCollectionConsistency(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 浜鸿劯锛氳澶囨姄鎷嶅浘鐗囧悎鏍兼�� * - * @param query + * @param params * @return */ @Override - public List<MonitoringDetailResult> faceImgQualification(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 浜鸿劯锛氳澶囨姄鎷嶅浘鐗囨椂閽熷噯纭�� * - * @param query + * @param params * @return */ @Override - public List<FaceDeviceInspectionResult> faceCapturesImagesAccuracy(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 浜鸿劯锛氭姄鎷嶄汉鑴告暟鎹笂浼犲強鏃舵�� * - * @param query + * @param params * @return */ @Override - public List<FaceDeviceInspectionResult> faceTimelyUpload(DataCenterQuery query) { - return null; + public Result 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); + 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); + return Result.ok().data(resultList).total(total); } /** * 浜鸿劯锛氫汉鑴稿崱鍙h澶囨姄鎷嶆暟鎹ぇ鍥惧彲鐢ㄦ�� * + * @param params + * @return + */ + @Override + public Result 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); + 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); + return Result.ok().data(resultList).total(total); + } + /** + * 瑙嗛锛氳棰戝浘鍍忚祫婧愬畨鍏ㄧ鐞� + * * @param query * @return */ @Override - public List<FaceDeviceSamplingResult> faceAvailabilityOfLargeImg(DataCenterQuery query) { - return null; + public Result videoImageResourceSecurity(DataCenterQuery query) { + ImageResourceSecurityDetail imageResourceSecurityDetail = new ImageResourceSecurityDetail(); + Page<ImageResourceSecurityDetail> page = PageHelper.startPage(query.getPageNum(), query.getPageSize()); + securityDetailMapper.selectImageResourceSecurityDetailList(imageResourceSecurityDetail); + + return Result.ok().data(page.getResult()).total(page.getTotal()); + } } -- Gitblit v1.8.0