From 87db70e35f8e562a17c02ef20fa16512871b0e63 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期六, 03 八月 2024 14:17:21 +0800
Subject: [PATCH] 优云录像可用

---
 ycl-common/src/main/java/constant/ApiConstants.java                       |    4 +
 ycl-server/src/main/java/com/ycl/factory/IndexCalculationFactory.java     |    2 
 ycl-common/src/main/java/constant/CalculationStrategyConstants.java       |    4 +
 ycl-server/src/main/java/com/ycl/task/VideoTask.java                      |   18 ++++++
 ycl-server/src/main/java/com/ycl/calculate/VideoUsabilityCalculation.java |  135 +++++++++++++++++++++++++++++++++++++++++++++
 ycl-server/src/main/java/com/ycl/calculate/IndexCalculationServe.java     |    7 ++
 ycl-server/src/main/java/com/ycl/calculate/VideoOnlineCalculation.java    |   10 +-
 7 files changed, 175 insertions(+), 5 deletions(-)

diff --git a/ycl-common/src/main/java/constant/ApiConstants.java b/ycl-common/src/main/java/constant/ApiConstants.java
index aefac02..e4b2164 100644
--- a/ycl-common/src/main/java/constant/ApiConstants.java
+++ b/ycl-common/src/main/java/constant/ApiConstants.java
@@ -46,4 +46,8 @@
     public final static Integer UY_OnlineSite_Online = 1;
     public final static Integer UY_OnlineSite_Unknown = 0;
     public final static Integer UY_OnlineSite_Offline = -1;
+    //浼樹簯褰曞儚瀹屾暣鐘舵��
+    public final static Integer UY_RecordStatus_Integrity = 1;
+    public final static Integer UY_RecordStatus_Interval = 0;
+    public final static Integer UY_RecordStatus_Abnormal = -1;
 }
diff --git a/ycl-common/src/main/java/constant/CalculationStrategyConstants.java b/ycl-common/src/main/java/constant/CalculationStrategyConstants.java
index 280fad8..ab8f49a 100644
--- a/ycl-common/src/main/java/constant/CalculationStrategyConstants.java
+++ b/ycl-common/src/main/java/constant/CalculationStrategyConstants.java
@@ -56,4 +56,8 @@
      * 瑙嗛鐐逛綅鍦ㄧ嚎鐜�
      */
     public static final String Video_SiteOnline = "videoSiteOnline";
+    /**
+     * 瑙嗛褰曞儚鍙敤鐜�
+     */
+    public static final String Video_Usability = "videoUsability";
 }
diff --git a/ycl-server/src/main/java/com/ycl/calculate/IndexCalculationServe.java b/ycl-server/src/main/java/com/ycl/calculate/IndexCalculationServe.java
index 9ab85d9..de0049f 100644
--- a/ycl-server/src/main/java/com/ycl/calculate/IndexCalculationServe.java
+++ b/ycl-server/src/main/java/com/ycl/calculate/IndexCalculationServe.java
@@ -110,6 +110,13 @@
         return picQualifySites.divide(totalSitesCount, 4, RoundingMode.HALF_UP);
     }
 
+    //褰曞儚鍙敤鐜�
+    public BigDecimal videoUsability(Map<String, Object> param) {
+        BigDecimal totalSites = new BigDecimal((Integer) param.get("totalSites"));
+        BigDecimal usabilitySites = new BigDecimal((Integer) param.get("usabilitySites"));
+        return usabilitySites.divide(totalSites, 4, RoundingMode.HALF_UP);
+    }
+
     //杩斿洖鐪佸巺鍥芥爣鐮侀泦鍚�
     public List<String> getProvince() {
         // TODO: 鍒嗙渷鍘呭競灞� 闇�瑕佽ˉ鍏呴泦鍚堟暟鎹�
diff --git a/ycl-server/src/main/java/com/ycl/calculate/VideoOnlineCalculation.java b/ycl-server/src/main/java/com/ycl/calculate/VideoOnlineCalculation.java
index fef8088..7b82051 100644
--- a/ycl-server/src/main/java/com/ycl/calculate/VideoOnlineCalculation.java
+++ b/ycl-server/src/main/java/com/ycl/calculate/VideoOnlineCalculation.java
@@ -115,8 +115,8 @@
      * 瑙嗛鐐逛綅鍦ㄧ嚎鐜�
      */
     private CheckIndexVideo createOrUpdateCheckIndexFace(String key, AreaStats stats, List<CheckIndexVideo> checkIndexVideoList) {
-        CheckIndexVideo CheckIndexVideo = getCheckIndex(key, checkIndexVideoList, CheckIndexVideo.class);
-        if (CheckIndexVideo == null) {
+        CheckIndexVideo checkIndexVideo = getCheckIndex(key, checkIndexVideoList, CheckIndexVideo.class);
+        if (checkIndexVideo == null) {
             return null;
         }
         //璋冪敤鐐逛綅鍦ㄧ嚎鐜囪绠楁柟娉�
@@ -124,13 +124,13 @@
         param.put("totalSites", stats.totalSites);
         param.put("onlineSites", stats.onlineSites);
         BigDecimal siteOnline = siteOnline(param);
-        CheckIndexVideo.setSiteOnline(siteOnline);
+        checkIndexVideo.setSiteOnline(siteOnline);
         //璋冪敤鐐逛綅鍦ㄧ嚎鐜囪绠楁柟娉� 璁$畻閲嶇偣鐐逛綅鍦ㄧ嚎鐜�
         Map<String, Object> importantParam = new HashMap<>();
         param.put("totalSites", stats.importantSites);
         param.put("onlineSites", stats.importantOnlineSites);
         BigDecimal importantSiteOnline = siteOnline(importantParam);
-        CheckIndexVideo.setKeySiteOnline(importantSiteOnline);
-        return CheckIndexVideo;
+        checkIndexVideo.setKeySiteOnline(importantSiteOnline);
+        return checkIndexVideo;
     }
 }
diff --git a/ycl-server/src/main/java/com/ycl/calculate/VideoUsabilityCalculation.java b/ycl-server/src/main/java/com/ycl/calculate/VideoUsabilityCalculation.java
new file mode 100644
index 0000000..954343f
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/calculate/VideoUsabilityCalculation.java
@@ -0,0 +1,135 @@
+package com.ycl.calculate;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.ycl.platform.domain.entity.CheckIndexVideo;
+import com.ycl.platform.domain.entity.TMonitor;
+import com.ycl.platform.domain.param.UY.RecordMetaDSumParam;
+import com.ycl.platform.domain.result.UY.QueryVqdResult;
+import com.ycl.platform.mapper.CheckIndexVideoMapper;
+import com.ycl.platform.service.ICheckIndexVideoService;
+import com.ycl.platform.service.ITMonitorService;
+import constant.ApiConstants;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Component;
+import org.springframework.util.CollectionUtils;
+import utils.DateUtils;
+
+import java.math.BigDecimal;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+import java.util.function.Function;
+import java.util.stream.Collectors;
+
+/**
+ * 璁$畻瑙嗛璁惧褰曞儚鍙敤鐜�
+ * 褰曞儚鍙敤鐜囨帴鍙�
+ * 鑾峰彇鍒嗙渷鍘呫�佸尯鍩熺殑map<k,v> k涓篸eptId鎴栬�匬rovince_deptId
+ * 寰幆map璁$畻鏁版嵁涓婁紶鍙婃椂鎬�
+ * 鏇存柊鎴栨柊澧�
+ */
+@Component
+public class VideoUsabilityCalculation extends IndexCalculationServe implements CalculationStrategy<RecordMetaDSumParam> {
+    @Autowired
+    private CheckIndexVideoMapper checkIndexVideoMapper;
+    @Autowired
+    private ITMonitorService monitorService;
+    @Autowired
+    private ICheckIndexVideoService checkIndexVideoService;
+
+    //鍖哄煙瑙嗛鍦ㄧ嚎鐜囩殑鍐呴儴绫�
+    private static class AreaStats {
+        int totalSites = 0;
+        int usabilitySites = 0;
+        int importantSites = 0;
+        int importantUsabilitySites = 0;
+    }
+
+    @Override
+    public void calculate(List<RecordMetaDSumParam> list) {
+        if (CollectionUtils.isEmpty(list)) {
+            return;
+        }
+
+        //鑾峰緱鍥芥爣鐮佷负key鐨勮澶噈ap
+        Map<String, TMonitor> monitorMap = monitorService.list(new QueryWrapper<TMonitor>()
+                        .in("serial_number", list.stream().map(RecordMetaDSumParam::getDeviceId).collect(Collectors.toList())))
+                .stream().collect(Collectors.toMap(TMonitor::getSerialNumber, Function.identity()));
+        //鑾峰彇鐪佸巺鍥芥爣鐮侀泦鍚�
+        List<String> provinceIds = getProvince();
+        //閲嶇偣鐐逛綅闆嗗悎
+        List<String> important = getImportant();
+
+        Map<String, AreaStats> areaStatsMap = new HashMap<>();
+        for (RecordMetaDSumParam result : list) {
+            TMonitor monitor = monitorMap.get(result.getDeviceId());
+            if (monitor == null) continue;
+
+            String deptId = monitor.getDeptId().toString();
+            updateAreaStats(areaStatsMap, deptId, result, important);
+
+            // 澶勭悊鐪佸巺鏁版嵁
+            if (!CollectionUtils.isEmpty(provinceIds) && provinceIds.contains(monitor.getSerialNumber())) {
+                String provinceKey = "Province_" + deptId;
+                updateAreaStats(areaStatsMap, provinceKey, result, important);
+            }
+        }
+
+        // 鏌ヨ鏄惁index琛ㄥ凡缁忓瓨鍦ㄤ粖鏃ユ暟鎹�
+        List<CheckIndexVideo> checkIndexVideoList = checkIndexVideoMapper.selectToday(DateUtils.getDate());
+        List<CheckIndexVideo> checkIndexVideos = new ArrayList<>();
+        areaStatsMap.forEach((deptId, stats) -> {
+            if (stats.totalSites > 0) {
+                CheckIndexVideo CheckIndexVideo = createOrUpdateCheckIndexFace(deptId, stats, checkIndexVideoList);
+                if (CheckIndexVideo != null) {
+                    checkIndexVideos.add(CheckIndexVideo);
+                }
+            }
+        });
+
+        checkIndexVideoService.saveOrUpdateBatch(checkIndexVideos);
+    }
+
+    /**
+     * 绱鎬荤偣浣嶆暟銆佸湪绾跨偣浣嶆暟銆侀噸鐐圭偣浣嶆暟銆侀噸鐐圭偣浣嶅湪绾挎暟
+     */
+    private void updateAreaStats(Map<String, AreaStats> areaStatsMap, String key, RecordMetaDSumParam result, List<String> important) {
+        //杩斿洖瀵硅薄鐨勫紩鐢紝濡傛灉涓嶅瓨鍦ㄤ細鏀惧叆鏂扮殑key,value
+        AreaStats stats = areaStatsMap.computeIfAbsent(key, k -> new AreaStats());
+        stats.totalSites++;
+        boolean flag = important.contains(result.getDeviceId());
+        if(flag){
+            stats.importantSites++;
+        }
+        if (ApiConstants.UY_RecordStatus_Integrity.equals(result.getRecordStatus())){
+            stats.usabilitySites++;
+            if(flag){
+                stats.importantUsabilitySites++;
+            }
+        }
+    }
+
+    /**
+     * 瑙嗛鐐逛綅鍦ㄧ嚎鐜�
+     */
+    private CheckIndexVideo createOrUpdateCheckIndexFace(String key, AreaStats stats, List<CheckIndexVideo> checkIndexVideoList) {
+        CheckIndexVideo checkIndexVideo = getCheckIndex(key, checkIndexVideoList, CheckIndexVideo.class);
+        if (checkIndexVideo == null) {
+            return null;
+        }
+        //璋冪敤褰曞儚鍙敤璁$畻鏂规硶
+        Map<String, Object> param = new HashMap<>();
+        param.put("totalSites", stats.totalSites);
+        param.put("usabilitySites", stats.usabilitySites);
+        BigDecimal videoUsability = videoUsability(param);
+        checkIndexVideo.setVideoAvailable(videoUsability);
+        //璋冪敤褰曞儚鍙敤鐜囪绠楁柟娉� 璁$畻閲嶇偣鐐逛綅褰曞儚鍙敤鐜�
+        Map<String, Object> importantParam = new HashMap<>();
+        param.put("totalSites", stats.importantSites);
+        param.put("usabilitySites", stats.importantUsabilitySites);
+        BigDecimal importantVideoUsability = videoUsability(importantParam);
+        checkIndexVideo.setKeyVideoAvailable(importantVideoUsability);
+        return checkIndexVideo;
+    }
+}
diff --git a/ycl-server/src/main/java/com/ycl/factory/IndexCalculationFactory.java b/ycl-server/src/main/java/com/ycl/factory/IndexCalculationFactory.java
index b34a303..e28b42e 100644
--- a/ycl-server/src/main/java/com/ycl/factory/IndexCalculationFactory.java
+++ b/ycl-server/src/main/java/com/ycl/factory/IndexCalculationFactory.java
@@ -38,6 +38,8 @@
 
         //瑙嗛鐐逛綅鍦ㄧ嚎鐜�
         calculators.put(CalculationStrategyConstants.Video_SiteOnline, new VideoOnlineCalculation());
+        //瑙嗛褰曞儚鍙敤鐜�
+        calculators.put(CalculationStrategyConstants.Video_Usability, new VideoUsabilityCalculation());
 
     }
 
diff --git a/ycl-server/src/main/java/com/ycl/task/VideoTask.java b/ycl-server/src/main/java/com/ycl/task/VideoTask.java
index f910de4..1e98bbe 100644
--- a/ycl-server/src/main/java/com/ycl/task/VideoTask.java
+++ b/ycl-server/src/main/java/com/ycl/task/VideoTask.java
@@ -3,6 +3,7 @@
 
 import com.ycl.calculate.CalculationStrategy;
 import com.ycl.factory.IndexCalculationFactory;
+import com.ycl.platform.domain.param.UY.RecordMetaDSumParam;
 import com.ycl.platform.domain.result.HK.SnapshotDataMonitorResult;
 import com.ycl.platform.domain.result.UY.QueryVqdResult;
 import com.ycl.utils.DateUtils;
@@ -39,4 +40,21 @@
         CalculationStrategy calculator = IndexCalculationFactory.getCalculator(CalculationStrategyConstants.Video_SiteOnline);
         calculator.calculate(results);
     }
+    public void videoUsabilityTask(){
+        Date yesterday = DateUtils.addDays(new Date(), -1);
+        //璁$畻褰曞儚鍙敤鐜囧拰閲嶇偣褰曞儚鍙敤鐜�
+        Query query = new Query();
+        query.addCriteria(Criteria
+                .where("mongoCreateTime").gte(DateUtils.getDayStart(yesterday)).lt(DateUtils.getDayEnd(yesterday)));
+
+        List<RecordMetaDSumParam> results = mongoTemplate.find(query, RecordMetaDSumParam.class);
+        CalculationStrategy calculator = IndexCalculationFactory.getCalculator(CalculationStrategyConstants.Video_Usability);
+        calculator.calculate(results);
+    }
+    public void oneMonitorFileTask(){
+        //璁$畻涓�鏈轰竴妗f敞鍐岀巼銆佷竴鏈轰竴妗e悎鏍肩巼銆佹。妗堣�冩牳姣�
+    }
+    public void platformOnlineTask(){
+        //璁$畻骞冲彴鍦ㄧ嚎鐜�
+    }
 }

--
Gitblit v1.8.0