From 3b0516a2959e25576e4f3fda697a3b025d06c8c9 Mon Sep 17 00:00:00 2001
From: zxl <763096477@qq.com>
Date: 星期二, 24 六月 2025 14:09:07 +0800
Subject: [PATCH] 每日录像可用指标添加日志,修改大屏为查看当前月平均

---
 ycl-server/src/main/java/com/ycl/calculate/FaceSnapshotDataCalculation.java |  177 ++++++++++++++++++++++++++++++++++++++--------------------
 1 files changed, 115 insertions(+), 62 deletions(-)

diff --git a/ycl-server/src/main/java/com/ycl/calculate/FaceSnapshotDataCalculation.java b/ycl-server/src/main/java/com/ycl/calculate/FaceSnapshotDataCalculation.java
index 4e4818e..209fc63 100644
--- a/ycl-server/src/main/java/com/ycl/calculate/FaceSnapshotDataCalculation.java
+++ b/ycl-server/src/main/java/com/ycl/calculate/FaceSnapshotDataCalculation.java
@@ -10,11 +10,14 @@
 import com.ycl.platform.mapper.TMonitorMapper;
 import com.ycl.platform.service.ICheckIndexFaceService;
 import com.ycl.platform.service.ITMonitorService;
+import com.ycl.system.entity.SysDictData;
 import com.ycl.system.mapper.SysConfigMapper;
-import constant.ApiConstants;
-import constant.CheckConstants;
-import constant.CheckSnapCountConstants;
+import com.ycl.system.mapper.SysDictDataMapper;
+import constant.*;
+import enumeration.general.AreaDeptEnum;
+import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.data.redis.core.RedisTemplate;
 import org.springframework.stereotype.Component;
 import org.springframework.util.CollectionUtils;
 import utils.DateUtils;
@@ -22,20 +25,21 @@
 import java.math.BigDecimal;
 import java.math.RoundingMode;
 import java.time.LocalDate;
+import java.time.temporal.TemporalAdjusters;
 import java.util.*;
 import java.util.function.Function;
 import java.util.stream.Collectors;
 
 /**
- * 璁$畻浜鸿劯鐐逛綅鍦ㄧ嚎鐜囥�佽鍥惧簱瀵规帴绋冲畾鎬�
+ * 璁$畻瑙嗗浘搴撳鎺ョǔ瀹氭��
  * 鎶撴媿鏁版嵁閲忕洃娴嬬粨鏋滄帴鍙f暟鎹�
  * 鑾峰彇鍒嗙渷鍘呫�佸尯鍩熺殑map<k,v> k涓篸eptId鎴栬�匬rovince_deptId
  * 寰幆map璁$畻鐐逛綅鍦ㄧ嚎鐜�
  * 鏇存柊鎴栨柊澧�
  */
 @Component
-//TODD:绯荤粺閰嶇疆閲岀殑鍖哄垎浜鸿劯鍜岃溅杈嗐�佺疮鍔犳鏁扮殑姒傚康銆佸尯鍘夸笉灏戜簬40璺紝涓嶈揪鏍囧競宸炵殑褰撴湀璇ラ」鎴愮哗涓嶈兘寰楀垎銆�
-public class FaceSnapshotDataCalculation extends IndexCalculationServe implements CalculationStrategy<SnapshotDataMonitorResult> {
+@Slf4j
+public class FaceSnapshotDataCalculation extends IndexCalculationServe<SnapshotDataMonitorResult, FaceSnapshotDataCalculation.AreaStats> implements CalculationStrategy<SnapshotDataMonitorResult> {
     @Autowired
     private CheckIndexFaceMapper checkIndexFaceMapper;
     @Autowired
@@ -44,51 +48,44 @@
     private SysConfigMapper sysConfigMapper;
     @Autowired
     private TMonitorMapper monitorMapper;
+    @Autowired
+    private RedisTemplate redisTemplate;
+    @Autowired
+    private SysDictDataMapper dictDataMapper;
 
     //鍖哄煙浜鸿劯鐐逛綅鍦ㄧ嚎鎸囨爣鐨勫唴閮ㄧ被
-    private static class AreaStats {
+    protected static class AreaStats {
         int totalSites = 0;
-        int onlineSites = 0;
         int totalDataSum = 0;
+        //鍔犳潈鍚庣殑鍚屾湡鎶撴媿閲�
+        int lastSnapCount = 0;
     }
 
     @Override
     public void calculate(List<SnapshotDataMonitorResult> list) {
-        if (CollectionUtils.isEmpty(list)) {
-            return;
+        //鑾峰彇鍒嗗尯鍩熺殑鎸囨爣鏁伴噺
+        Map<String, FaceSnapshotDataCalculation.AreaStats> areaStatsMap = getAreaStatsMap(list, Boolean.FALSE);
+        if (areaStatsMap == null) return;
+
+        // 鑾峰彇褰撳墠鏃ユ湡
+        LocalDate today = LocalDate.now();
+        // 鑾峰彇鏈湀鐨勭涓�澶�
+        LocalDate firstDayOfMonth = today.with(TemporalAdjusters.firstDayOfMonth());
+        // 鍒ゆ柇浠婂ぉ鏄惁鏄湰鏈堢殑绗竴澶�
+        if (today.equals(firstDayOfMonth)) {
+            // 濡傛灉鏄紝鍒欐竻闄edis涓褰曚腑鏂鏁扮殑鏁版嵁
+            redisTemplate.delete(RedisConstant.Check_Face_ViewConnect);
         }
-        //杩斿洖浠ュ浗鏍囩爜涓簁ey鐨勮澶噈ap
-        Map<String, TMonitorVO> monitorMap = monitorMapper.selectListByIds(list.stream().map(SnapshotDataMonitorResult::getExternalIndexCode).collect(Collectors.toList()))
-                .stream().collect(Collectors.toMap(TMonitorVO::getSerialNumber, Function.identity()));
-        //鑾峰彇鐪佸巺鍥芥爣鐮侀泦鍚�
-        List<String> provinceIds = getProvince();
-
-        Map<String, AreaStats> areaStatsMap = new HashMap<>();
-
-        for (SnapshotDataMonitorResult result : list) {
-            TMonitorVO monitor = monitorMap.get(result.getExternalIndexCode());
-            if (monitor == null) continue;
-
-            String deptId = monitor.getDeptId().toString();
-            updateAreaStats(areaStatsMap, deptId, result);
-
-            // 澶勭悊鐪佸巺鏁版嵁
-            if (!CollectionUtils.isEmpty(provinceIds) && provinceIds.contains(monitor.getSerialNumber())) {
-                String provinceKey = ApiConstants.Province + deptId;
-                updateAreaStats(areaStatsMap, provinceKey, result);
-            }
-        }
-
-        //鑾峰彇2022鍚屾湡鎶撴媿骞冲潎鍊� 鐪佸巺銆佸競灞�
-        BigDecimal cityCountAvg = getAverageCount(CheckSnapCountConstants.Face_City);
-        BigDecimal countyCountAvg = getAverageCount(CheckSnapCountConstants.Face_County);
-
+        //浠庡瓧鍏歌幏鍙栧悓鏈熸姄鎷嶉噺
+        List<SysDictData> lastSnap = dictDataMapper.selectDictDataByType(CheckConstants.DICT_LAST_SNAP);
+        //鏍规嵁鍚勪釜鍖哄幙鐐逛綅鏁版嵁瀵瑰悓鏈熸姄鎷嶉噺鍋氬姞鏉冨鐞�
+        fillLastSnap(areaStatsMap, lastSnap);
         // 鏌ヨ浠婃棩鏁版嵁
         List<CheckIndexFace> checkIndexFaceList = checkIndexFaceMapper.selectToday(DateUtils.getDate());
         List<CheckIndexFace> checkIndexFaces = new ArrayList<>();
         areaStatsMap.forEach((deptId, stats) -> {
             if (stats.totalSites > 0) {
-                CheckIndexFace checkIndexFace = createOrUpdateCheckIndexFace(deptId, stats, cityCountAvg, countyCountAvg, checkIndexFaceList);
+                CheckIndexFace checkIndexFace = createOrUpdateCheckIndexFace(deptId, stats, checkIndexFaceList, lastSnap);
                 if (checkIndexFace != null) {
                     checkIndexFaces.add(checkIndexFace);
                 }
@@ -98,46 +95,102 @@
         checkIndexFaceService.saveOrUpdateBatch(checkIndexFaces);
     }
 
+    //鏍规嵁鐐逛綅鏁伴噺瀵瑰悓鏈熸姄鎷嶉噺浣滃姞鏉冨鐞�
+    private void fillLastSnap(Map<String, AreaStats> areaStatsMap, List<SysDictData> lastSnap) {
+        //鐪佸巺鎬荤偣浣嶆暟
+        int provinceTotalSites = 0;
+        //鍖哄幙鎬荤偣浣嶆暟
+        int countyTotalSites = 0;
+        //鍚屾湡鐪佸巺鎶撴媿閲�
+        int lastProvinceSnap = 0;
+        //鍚屾湡鍖哄幙鎶撴媿閲�
+        int lastCountySnap = 0;
+        //浠庡瓧鍏搁噷绛涢�夌渷鍘呭��
+        Optional<SysDictData> first = lastSnap.stream().filter(sysDictData -> CheckConstants.SNAP_PROVINCE_FACE.equals(sysDictData.getDictLabel())).findFirst();
+        if (first.isPresent()) {
+            lastProvinceSnap = Integer.parseInt(first.get().getDictValue());
+        }
+        //浠庡瓧鍏搁噷绛涢�夊尯鍘垮��
+        Optional<SysDictData> first2 = lastSnap.stream().filter(sysDictData -> CheckConstants.SNAP_COUNTY_FACE.equals(sysDictData.getDictLabel())).findFirst();
+        if (first2.isPresent()) {
+            lastCountySnap = Integer.parseInt(first2.get().getDictValue());
+        }
+        //璁$畻鎬绘暟
+        for (Map.Entry<String, AreaStats> entry : areaStatsMap.entrySet()) {
+            String key = entry.getKey();
+            AreaStats value = entry.getValue();
+            if (key.startsWith(ApiConstants.Province)) {
+                provinceTotalSites += value.totalSites;
+            } else {
+                countyTotalSites += value.totalSites;
+            }
+        }
+        //鍔犳潈鎿嶄綔,琛ュ厖鍚屾湡鎶撴媿閲�
+        for (Map.Entry<String, AreaStats> entry : areaStatsMap.entrySet()) {
+            String key = entry.getKey();
+            AreaStats value = entry.getValue();
+            //鐪佸巺
+            if (key.startsWith(ApiConstants.Province)) {
+                if (value.totalSites == 0) {
+                    value.lastSnapCount = 0;
+                } else {
+                    BigDecimal result = new BigDecimal(value.totalSites)
+                            .divide(new BigDecimal(provinceTotalSites), 2, RoundingMode.HALF_UP)
+                            .multiply(new BigDecimal(lastProvinceSnap));
+                    value.lastSnapCount = result.setScale(0, RoundingMode.HALF_UP).intValue();
+                }
+            } else {
+                //鍖哄幙
+                if (value.totalSites == 0) {
+                    value.lastSnapCount = 0;
+                } else {
+                    BigDecimal result = new BigDecimal(value.totalSites)
+                            .divide(new BigDecimal(countyTotalSites), 2, RoundingMode.HALF_UP)
+                            .multiply(new BigDecimal(lastCountySnap));
+                    value.lastSnapCount = result.setScale(0, RoundingMode.HALF_UP).intValue();
+                }
+            }
+        }
+    }
+
     //绱鎬荤偣浣嶆暟銆佺绾挎暟銆佹�绘姄鎷嶉噺
-    private void updateAreaStats(Map<String, AreaStats> areaStatsMap, String key, SnapshotDataMonitorResult result) {
+    @Override
+    public void updateAreaStats(Map<String, AreaStats> areaStatsMap, String key, SnapshotDataMonitorResult result) {
         //杩斿洖瀵硅薄鐨勫紩鐢紝濡傛灉涓嶅瓨鍦ㄤ細鏀惧叆鏂扮殑key,value
         AreaStats stats = areaStatsMap.computeIfAbsent(key, k -> new AreaStats());
         stats.totalSites++;
         if (ApiConstants.HK_SnapCount_ResultType_Null != result.getResultType()) {
-            stats.onlineSites++;
-        } else {
             stats.totalDataSum += result.getDataCount();
         }
     }
 
-    //鑾峰彇2022鍚屾湡鎶撴媿骞冲潎鍊�
-    private BigDecimal getAverageCount(String configKey) {
-        String count = sysConfigMapper.checkConfigKeyUnique(configKey).getConfigValue();
-        return new BigDecimal(count)
-                .multiply(new BigDecimal(CheckSnapCountConstants.Multiply))
-                .divide(new BigDecimal(CheckSnapCountConstants.CountyNum), 10, RoundingMode.HALF_UP)
-                .divide(new BigDecimal(LocalDate.now().getDayOfMonth()), 0, RoundingMode.HALF_UP);
-    }
 
-    //杞﹁締鐐逛綅鍦ㄧ嚎鐜囧拰瑙嗗浘搴撳鎺ョǔ瀹氭��
-    private CheckIndexFace createOrUpdateCheckIndexFace(String key, AreaStats stats, BigDecimal cityCountAvg, BigDecimal countyCountAvg, List<CheckIndexFace> checkIndexFaceList) {
+    //浜鸿劯瑙嗗浘搴撳鎺ョǔ瀹氭��
+    private CheckIndexFace createOrUpdateCheckIndexFace(String key, AreaStats stats, List<CheckIndexFace> checkIndexFaceList, List<SysDictData> faceSnap) {
         CheckIndexFace checkIndexFace = getCheckIndex(key, checkIndexFaceList, CheckIndexFace.class);
         if (checkIndexFace == null) {
             return null;
         }
-        //璋冪敤鐐逛綅鍦ㄧ嚎璁$畻鏂规硶
-        Map<String, Object> siteOnlineParam = new HashMap<>();
-        siteOnlineParam.put("totalSites", stats.totalSites);
-        siteOnlineParam.put("onlineSites", stats.onlineSites);
-        BigDecimal siteOnline = siteOnline(siteOnlineParam);
-        checkIndexFace.setSiteOnline(siteOnline);
         //瑙嗗浘搴撳鎺ョǔ瀹氭��
-        BigDecimal avgCount = key.startsWith(ApiConstants.Province) ? cityCountAvg : countyCountAvg;
-        Map<String, Object> viewConnectParam = new HashMap<>();
-        viewConnectParam.put("totalDataSum", stats.totalDataSum);
-        viewConnectParam.put("avgCount", avgCount);
-        BigDecimal viewConnectStability = viewConnectStability(viewConnectParam);
-        checkIndexFace.setViewConnectStability(viewConnectStability);
+        //Redis璁板綍璇ュ尯鍘垮綋鏈堟棤鏁版嵁涓婁紶娆℃暟
+        Integer noDateCount = (Integer) redisTemplate.opsForHash().get(RedisConstant.Check_Face_ViewConnect, key);
+        // 濡傛灉鍊间负null锛屽垯鍒濆鍖栦负0
+        if (noDateCount == null) {
+            noDateCount = 0;
+        }
+        Double deductScore = 0.1 * noDateCount;
+        if (stats.totalDataSum != 0) {
+            Map<String, Object> viewConnectParam = new HashMap<>();
+            viewConnectParam.put("totalDataSum", stats.totalDataSum);
+            viewConnectParam.put("lastCount", new BigDecimal(stats.lastSnapCount).multiply(new BigDecimal(CheckConstants.MultiplyNum)).divide(new BigDecimal(LocalDate.now().getDayOfMonth()), 0, RoundingMode.HALF_UP));
+            BigDecimal viewConnectStability = viewConnectStability(viewConnectParam);
+            viewConnectStability = viewConnectStability.subtract(new BigDecimal(deductScore)).max(BigDecimal.ZERO).min(BigDecimal.ONE);
+            checkIndexFace.setViewConnectStability(viewConnectStability);
+        } else {
+            noDateCount++;
+        }
+        // 灏嗘柊鐨勫�兼斁鍥濰ash涓�
+        redisTemplate.opsForHash().put(RedisConstant.Check_Face_ViewConnect, key, noDateCount);
         return checkIndexFace;
     }
 }

--
Gitblit v1.8.0