From 1e2fb4b8911cabb279fc173c825dfeab38ef7552 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期一, 30 九月 2024 02:58:02 +0800
Subject: [PATCH] 数据中心点位在线调整
---
ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java | 86 +++++++++++++++++++++++++++---------------
1 files changed, 55 insertions(+), 31 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 ed9dc88..2e7fe8a 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
@@ -10,6 +10,7 @@
import com.ycl.platform.domain.entity.*;
import com.ycl.platform.domain.query.DataCenterQuery;
import com.ycl.platform.domain.result.HK.*;
+import com.ycl.platform.domain.result.SYS.TMonitorResult;
import com.ycl.platform.domain.result.UY.*;
import com.ycl.platform.domain.vo.PointDetailVO;
import com.ycl.platform.mapper.ImageResourceSecurityDetailMapper;
@@ -66,11 +67,15 @@
*/
@Override
public Result videoPointOnlineRate(DataCenterQuery params) {
+ List<String> likeFileds = Arrays.asList("name", "no","ip");
+ Query query = MongoUtil.getQuery(params,TIME_FIELD, likeFileds, null);
+ //鍒嗛〉鏁伴噺
+ long total = mongoTemplate.count(query, TMonitorResult.class);
+ MongoUtil.setPage(query, params, TIME_FIELD);
+ List<TMonitorResult> resultList = mongoTemplate.find(query, TMonitorResult.class);
+
params.setDeptTag(-1);
params.setDeviceType(1);
- IPage<PointDetailVO> page = PageUtil.getPage(params, PointDetailVO.class);
- pointMapper.dataCenterPage(page, params);
-
// 缁熻璁惧鏁伴噺
Integer distinctCount = pointMapper.distinctCount(params);
@@ -87,8 +92,8 @@
}
HashMap<String, Object> map = new HashMap<>();
map.put("count", Arrays.asList(distinctCount + "",this.remove0(onlineRate)));
- map.put("list", page.getRecords());
- return Result.ok().data(map).total(page.getTotal());
+ map.put("list", resultList);
+ return Result.ok().data(map).total(total);
}
/**
@@ -99,12 +104,16 @@
*/
@Override
public Result deptVideoPointOnlineRate(DataCenterQuery params) {
- params.setDeptTag(1);
- params.setDeviceType(1);
- IPage<PointDetailVO> page = PageUtil.getPage(params, PointDetailVO.class);
- pointMapper.dataCenterPage(page, params);
+ List<String> likeFileds = Arrays.asList("name", "no","ip");
+ Query query = MongoUtil.getQuery(params,TIME_FIELD, likeFileds, null);
+ //鍒嗛〉鏁伴噺
+ long total = mongoTemplate.count(query, TMonitorResult.class);
+ MongoUtil.setPage(query, params, TIME_FIELD);
+ List<TMonitorResult> resultList = mongoTemplate.find(query, TMonitorResult.class);
// 缁熻璁惧鏁伴噺
+ params.setDeptTag(1);
+ params.setDeviceType(1);
Integer distinctCount = pointMapper.distinctCount(params);
Date now = new Date();
@@ -121,8 +130,8 @@
}
HashMap<String, Object> map = new HashMap<>();
map.put("count", Arrays.asList(distinctCount + "", this.remove0(onlineRate)));
- map.put("list", page.getRecords());
- return Result.ok().data(map).total(page.getTotal());
+ map.put("list",resultList);
+ return Result.ok().data(map).total(total);
}
/**
@@ -133,11 +142,14 @@
*/
@Override
public Result videoImportantPointOnlineRate(DataCenterQuery params) {
+ List<String> likeFileds = Arrays.asList("name", "no","ip");
+ Query query = MongoUtil.getQuery(params,TIME_FIELD, likeFileds, null);
+ //鍒嗛〉鏁伴噺
+ long total = mongoTemplate.count(query, TMonitorResult.class);
+ MongoUtil.setPage(query, params, TIME_FIELD);
+ List<TMonitorResult> resultList = mongoTemplate.find(query, TMonitorResult.class);
params.setDeptTag(3);
params.setDeviceType(1);
- IPage<PointDetailVO> page = PageUtil.getPage(params, PointDetailVO.class);
- pointMapper.dataCenterPage(page, params);
-
// 缁熻璁惧鏁伴噺
Integer distinctCount = pointMapper.distinctCount(params);
@@ -155,8 +167,8 @@
}
HashMap<String, Object> map = new HashMap<>();
map.put("count", Arrays.asList(distinctCount + "", this.remove0(onlineRate)));
- map.put("list", page.getRecords());
- return Result.ok().data(map).total(page.getTotal());
+ map.put("list", resultList);
+ return Result.ok().data(map).total(total);
}
/**
@@ -167,11 +179,15 @@
*/
@Override
public Result videoImportantPointImageOnlineRate(DataCenterQuery params) {
+ List<String> likeFileds = Arrays.asList("name", "no","ip");
+ Query query = MongoUtil.getQuery(params,TIME_FIELD, likeFileds, null);
+ //鍒嗛〉鏁伴噺
+ long total = mongoTemplate.count(query, TMonitorResult.class);
+ MongoUtil.setPage(query, params, TIME_FIELD);
+ List<TMonitorResult> resultList = mongoTemplate.find(query, TMonitorResult.class);
+
params.setDeptTag(4);
params.setDeviceType(1);
- IPage<PointDetailVO> page = PageUtil.getPage(params, PointDetailVO.class);
- pointMapper.dataCenterPage(page, params);
-
// 缁熻璁惧鏁伴噺
Integer distinctCount = pointMapper.distinctCount(params);
@@ -189,8 +205,8 @@
}
HashMap<String, Object> map = new HashMap<>();
map.put("count", Arrays.asList(distinctCount + "", this.remove0(onlineRate)));
- map.put("list", page.getRecords());
- return Result.ok().data(map).total(page.getTotal());
+ map.put("list", resultList);
+ return Result.ok().data(map).total(total);
}
/**
@@ -867,11 +883,15 @@
*/
@Override
public Result vehiclePointOnlineRate(DataCenterQuery params) {
+ List<String> likeFileds = Arrays.asList("name", "no","ip");
+ Query query = MongoUtil.getQuery(params,TIME_FIELD, likeFileds, null);
+ //鍒嗛〉鏁伴噺
+ long total = mongoTemplate.count(query, TMonitorResult.class);
+ MongoUtil.setPage(query, params, TIME_FIELD);
+ List<TMonitorResult> resultList = mongoTemplate.find(query, TMonitorResult.class);
+
params.setDeptTag(-1);
params.setDeviceType(2);
- IPage<PointDetailVO> page = PageUtil.getPage(params, PointDetailVO.class);
- pointMapper.dataCenterPage(page, params);
-
// 缁熻璁惧鏁伴噺
Integer distinctCount = pointMapper.distinctCount(params);
@@ -889,8 +909,8 @@
}
HashMap<String, Object> map = new HashMap<>();
map.put("count", Arrays.asList(distinctCount + "", this.remove0(onlineRate)));
- map.put("list", page.getRecords());
- return Result.ok().data(map).total(page.getTotal());
+ map.put("list", resultList);
+ return Result.ok().data(map).total(total);
}
/**
@@ -1365,11 +1385,15 @@
*/
@Override
public Result facePointOnlineRate(DataCenterQuery params) {
+ List<String> likeFileds = Arrays.asList("name", "no","ip");
+ Query query = MongoUtil.getQuery(params,TIME_FIELD, likeFileds, null);
+ //鍒嗛〉鏁伴噺
+ long total = mongoTemplate.count(query, TMonitorResult.class);
+ MongoUtil.setPage(query, params, TIME_FIELD);
+ List<TMonitorResult> resultList = mongoTemplate.find(query, TMonitorResult.class);
+
params.setDeptTag(-1);
params.setDeviceType(3);
- IPage<PointDetailVO> page = PageUtil.getPage(params, PointDetailVO.class);
- pointMapper.dataCenterPage(page, params);
-
// 缁熻璁惧鏁伴噺
Integer distinctCount = pointMapper.distinctCount(params);
@@ -1390,8 +1414,8 @@
rList.add(this.remove0(onlineRate));
HashMap<String, Object> map = new HashMap<>();
map.put("count", rList);
- map.put("list", page.getRecords());
- return Result.ok().data(map).total(page.getTotal());
+ map.put("list", resultList);
+ return Result.ok().data(map).total(total);
}
/**
--
Gitblit v1.8.0