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/task/UYTask.java |  237 ++++++++++++++++++++++++++++++++++++++++++-----------------
 1 files changed, 169 insertions(+), 68 deletions(-)

diff --git a/ycl-server/src/main/java/com/ycl/task/UYTask.java b/ycl-server/src/main/java/com/ycl/task/UYTask.java
index 3afaece..b1dfe89 100644
--- a/ycl-server/src/main/java/com/ycl/task/UYTask.java
+++ b/ycl-server/src/main/java/com/ycl/task/UYTask.java
@@ -15,20 +15,22 @@
 import com.ycl.platform.domain.result.UY.VideoOnlineResult;
 import com.ycl.platform.domain.vo.UpdateOnlineVO;
 import com.ycl.platform.mapper.TMonitorMapper;
+import com.ycl.platform.mapper.WorkOrderMapper;
 import com.ycl.platform.service.UYErrorTypeCheckService;
 import com.ycl.platform.service.WorkOrderService;
 import com.ycl.platform.service.YwPointService;
 import com.ycl.system.domain.SysConfig;
 import com.ycl.system.mapper.SysConfigMapper;
+import com.ycl.system.service.ISysConfigService;
 import com.ycl.thread.OnlineCheckThread;
 import com.ycl.utils.CheckPointUtil;
 import com.ycl.utils.DateUtils;
 import constant.ApiConstants;
-import constant.RedisConstant;
-import enumeration.ErrorType;
-import enumeration.general.WorkOrderStatusEnum;
+import constant.CheckConstants;
 import lombok.RequiredArgsConstructor;
 import lombok.extern.slf4j.Slf4j;
+import org.apache.commons.lang3.StringUtils;
+import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.data.mongodb.core.MongoTemplate;
 import org.springframework.data.mongodb.core.query.Criteria;
@@ -40,6 +42,8 @@
 import java.text.SimpleDateFormat;
 import java.util.*;
 import java.util.concurrent.*;
+import java.util.concurrent.atomic.AtomicReference;
+import java.util.function.Function;
 import java.util.stream.Collectors;
 
 //浼樹簯瀵规帴鏁版嵁浠诲姟
@@ -54,6 +58,7 @@
     private final YwPointService pointService;
     private final TMonitorMapper monitorMapper;
     private final WorkOrderService workOrderService;
+    private final WorkOrderMapper workOrderMapper;
     private final SysConfigMapper sysConfigMapper;
     private final CheckPointUtil checkPointUtil;
     @Value("${youYun.tenantId}")
@@ -68,8 +73,8 @@
     private String passwd;
 
     private static final ExecutorService executorService = new ThreadPoolExecutor(16,
-            128,
-            5000,
+            64,
+            60,
             TimeUnit.SECONDS,
             new ArrayBlockingQueue<>(1000),
             new ThreadPoolExecutor.CallerRunsPolicy()
@@ -100,7 +105,7 @@
                                 item.setNo(item.getDeviceId());
                             }
                         });
-                        pointService.setDeviceTagByGB(records);
+                        pointService.setDeviceTagByGB(records, CheckConstants.Rule_Category_Video);
                         //瀛樻斁鍦╩ongo涓�
                         mongoTemplate.insertAll(records);
                         // 宸ュ崟鐢熸垚
@@ -149,7 +154,7 @@
                                 item.setNo(item.getSerialNumber().getShowValue());
                             }
                         });
-                        pointService.setDeviceTagByGB(records);
+                        pointService.setDeviceTagByGB(records,CheckConstants.Rule_Category_Or);
                         pointService.setNew(records);
                         //瀛樻斁鍦╩ongo涓�
                         mongoTemplate.insertAll(records);
@@ -172,7 +177,9 @@
     }
 
     /**
-     * 鐐逛綅鍦ㄧ嚎妫�娴�
+     * 鐐逛綅鍦ㄧ嚎PING妫�娴�
+     * 浠诲姟浼氬厛鎵ц涓�娆′紭浜戝悓姝ワ紝鐒跺悗鎵цping妫�娴�
+     * online瀛楁鏉ヨ嚜浜庝紭浜戯紝pingOnline涓轰富鍔╬ing妫�娴嬬殑銆傚瓨鍏ongo缁欐暟鎹腑蹇冩煡闃�
      */
     public void pointOnline() throws ExecutionException, InterruptedException {
         log.info("寮�濮嬫娴嬬偣浣嶅湪绾�");
@@ -185,52 +192,37 @@
         } else {
             log.error("璇烽厤缃绾挎鏁帮紝姝ゆ璁剧疆涓洪粯璁ゅ��2");
         }
-        // 鍏堟煡鍑鸿澶嘔P闆嗗悎
+
+
+        // 鍏堟煡鍑鸿澶嘔P闆嗗悎,鍓旈櫎鎺夊湪绾挎儏鍐垫槸鏈煡鐨�,骞朵笖鍙娴嬫鍦ㄨ�冩牳鐨勮澶囬伩鍏嶅浣欏伐鍗�
         List<TMonitorResult> monitorList = monitorMapper.getDistinctIP();
-//        List<Future<TMonitorResult>> futureList = new ArrayList<>(48);
+        //琛ュ厖閿欒鏃堕棿鐐�
+        Query onlineQuery = new Query(Criteria.where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date())));
+        Map<String, TMonitorResult> mongoMap = mongoTemplate.find(onlineQuery, TMonitorResult.class)
+                .stream()
+                .collect(Collectors.toMap(TMonitorResult::getNo, Function.identity(), (existing, replacement) -> replacement));
+        for (TMonitorResult result : monitorList) {
+            TMonitorResult mongoData = mongoMap.get(result.getNo());
+            if(mongoData!=null){
+                result.setOffLineTimeStr(mongoData.getOffLineTimeStr());
+            }
+        }
         List<TMonitorResult> dataList = new ArrayList<>(48);
-//        for (TMonitorResult monitor : monitorList) {
-//            OnlineCheckThread thread = new OnlineCheckThread(monitor, checkPointUtil, times);
-//            Future<TMonitorResult> future = executorService.submit(thread);
-//            futureList.add(future);
-//        }
-//        for (Future<TMonitorResult> future : futureList) {
-//            dataList.add(future.get()); // get鏂规硶浼氶樆濉烇紝鐭ラ亾鎷垮埌缁撴灉鎵嶇户缁墽琛宖or
-//        }
         Integer time = times;
         List<CompletableFuture<TMonitorResult>> futureList = monitorList.stream()
                 .map(monitor -> CompletableFuture.supplyAsync(() -> {
                             OnlineCheckThread thread = new OnlineCheckThread(monitor, checkPointUtil, time);
                             return thread.call(); // 鍋囪 OnlineCheckThread 瀹炵幇浜� Callable 鎺ュ彛
                         }, executorService)
-                        .orTimeout(30, TimeUnit.SECONDS)
+                        .orTimeout(180, TimeUnit.SECONDS)
                         .exceptionally(ex -> {
                             if (ex instanceof TimeoutException) {
-                                log.error("浠诲姟鎵ц瓒呮椂:");
+                                log.error("浠诲姟鎵ц瓒呮椂:"+monitor.getIp());
                             } else {
-                                log.error("浠诲姟鎵ц寮傚父:" + ex);
+                                log.error("浠诲姟鎵ц寮傚父:"+monitor.getIp() +ex);
+                                ex.printStackTrace();
                             }
-                            int checkTimes = 1;
-                            int offLineTimes = 1;
-                            //TODO:BUG
-                            Map<String, Object> map = (Map<String, Object>) redisTemplate.opsForHash().get(RedisConstant.ONLINE_KEY, monitor.getIp());
-                            if (!CollectionUtils.isEmpty(map)) {
-                                checkTimes = (Integer) map.get("checkTimes") + 1;
-                                offLineTimes = (Integer) map.get("offLineTimes");
-                            }
-                            monitor.setOnline(Boolean.FALSE);
-                            monitor.setCheckCount(checkTimes);
-                            monitor.setOffLineCount(offLineTimes);
-                            if (monitor.getOffLineCount() >= time) {
-                                WorkOrder workOrder = new WorkOrder();
-                                workOrder.setSerialNumber(monitor.getNo());
-                                List<String> errList = new ArrayList<>();
-                                errList.add(ErrorType.DEVICE_OFFLINE.getValue());
-                                workOrder.setErrorTypeList(errList);
-                                workOrder.setStatus(WorkOrderStatusEnum.DISTRIBUTED);
-                                monitor.setWorkOrder(workOrder);
-                            }
-                            return monitor; // 杩斿洖澶辫触鐨勭粨鏋�
+                            return null;
                         }))
                 .collect(Collectors.toList());
 
@@ -238,48 +230,99 @@
         CompletableFuture<Void> allOf = CompletableFuture.allOf(
                 futureList.toArray(new CompletableFuture[0])
         );
+
         try {
-            allOf.get(35, TimeUnit.SECONDS); // 缁欎簣棰濆鐨�5绉掓潵鏀堕泦缁撴灉
+            allOf.get(60, TimeUnit.SECONDS); // 缁欎簣棰濆鐨�5绉掓潵鏀堕泦缁撴灉
         } catch (TimeoutException e) {
-            log.warn("閮ㄥ垎浠诲姟鏈湪鎸囧畾鏃堕棿鍐呭畬鎴�");
+            log.error("閮ㄥ垎浠诲姟鏈湪鎸囧畾鏃堕棿鍐呭畬鎴�");
         } catch (Exception e2){
             log.error("鏁版嵁鏀堕泦寮傚父"+e2);
         }
 
         dataList = futureList.stream()
                 .map(CompletableFuture::join)
-                .filter(result -> result != null)
+                .filter(Objects::nonNull)
                 .collect(Collectors.toList());
-        // 鏇存柊point琛ㄧ殑鍦ㄧ嚎鏍囪瘑
+
+
         Date now = new Date();
-        List<UpdateOnlineVO> willUpdateList = dataList.stream().map(item -> {
-            UpdateOnlineVO vo = new UpdateOnlineVO();
-            vo.setOnline(item.getOnline());
-            vo.setIp(item.getIp());
-            vo.setUpdateTime(now);
-            return vo;
-        }).collect(Collectors.toList());
-        monitorMapper.updateOnline(willUpdateList);
-        // 宸ュ崟
-        List<WorkOrder> workOrderList = dataList.stream()
-                .filter(item -> Objects.nonNull(item.getWorkOrder()))
-                .map(TMonitorResult::getWorkOrder)
-                .collect(Collectors.toList());
-        if (!CollectionUtils.isEmpty(workOrderList)) {
-            workOrderService.innerAddWorkOrder(workOrderList);
+        List<String> offLineList = new ArrayList<>();
+        List<String> onLineList = new ArrayList<>();
+        List<String> unKnownList = new ArrayList<>();
+        //鏌ュ嚭鏁版嵁搴撶函杞﹁締鎴栫函浜鸿劯璁惧
+//        List<String> serialNumbers = monitorMapper.selectCarOrFace().stream().map(TMonitor::getSerialNumber).collect(Collectors.toList());
+        dataList.forEach(item->{
+            if(item.getPingOnline()) {
+                onLineList.add(item.getIp());
+            } else if(!item.getPingOnline()) {
+                //绛涢�夊嚭ping绂荤嚎鐨勮澶囷紝鏇存敼鏁版嵁搴撲负绂荤嚎
+                offLineList.add(item.getIp());
+            }else {
+                unKnownList.add(item.getIp());
+            }
+        });
+        log.error("unKnownList:{}",unKnownList);
+        if(!CollectionUtils.isEmpty(offLineList)) {
+            log.error("淇敼绂荤嚎鐨勭偣浣嶉泦鍚�:{}",offLineList);
+            monitorMapper.batchUpdateOnline(offLineList, now, ApiConstants.UY_OnlineSite_Offline);
+        }
+        if(!CollectionUtils.isEmpty(onLineList)) {
+            log.error("淇敼鍦ㄧ嚎鐨勭偣浣嶉泦鍚�:{}",onLineList);
+            monitorMapper.batchUpdateOnline(onLineList, now, ApiConstants.UY_OnlineSite_Online);
         }
         //瀛樻斁鍒癿ongo
         if (!CollectionUtils.isEmpty(dataList)) {
+            List<TMonitorResult> mongoList = new ArrayList<>();
+            dataList.forEach(item->{
+                String monitorType = item.getMonitorType();
+                //鍚屼竴涓澶囧涓被鍨嬫瘡涓被鍨嬪瓨涓�鏉℃暟鎹紝浠ユ鍦ㄤ繚鐣欐暟鎹殑鎯呭喌涓嬪尯鍒嗙渷鍘呮爣绛�
+                if(StringUtils.isNotEmpty(monitorType)){
+                    String[] monitors = monitorType.split("/");
+                    for (String type : monitors) {
+                        TMonitorResult mongoData = new TMonitorResult();
+                        BeanUtils.copyProperties(item,mongoData);
+                        mongoData.setMonitorType(type);
+                        if("1".equals(type)){
+                            mongoData.setProvinceTag(mongoData.getProvinceTagVideo());
+                        }else if("2".equals(type)){
+                            mongoData.setProvinceTag(mongoData.getProvinceTagCar());
+                        }else if("3".equals(type)){
+                            mongoData.setProvinceTag(mongoData.getProvinceTagFace());
+                        }
+                        mongoList.add(mongoData);
+                    }
+                }
+            });
             //濡傛灉瀛樺湪涔嬪墠鐨勬暟鎹厛鍒犻櫎
             Query query = new Query(Criteria.where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date())));
             DeleteResult result = mongoTemplate.remove(query, TMonitorResult.class);
             //瀛樻斁鍦╩ongo涓�
-            mongoTemplate.insertAll(dataList);
+
+            log.error("瀛樺叆鍚屾鍦ㄧ嚎mongo鏁版嵁{}" , mongoList );
+            mongoTemplate.insertAll(mongoList);
+        }
+        //宸ュ崟锛堝悓涓�IP鍙敓鎴愪竴涓伐鍗曪級
+        //鏌ヨ鏁版嵁搴撳凡瀛樺湪鐨勭绾垮伐鍗曡幏鍙杋p闆嗗悎锛屽墧闄�
+        List<String> ips = workOrderMapper.getOfflineWorkOrder();
+        List<WorkOrder> workOrderList = dataList.stream()
+                .filter(item -> Objects.nonNull(item.getWorkOrder()) && (CollectionUtils.isEmpty(ips) || !ips.contains(item.getIp())))
+                .collect(Collectors.toMap(
+                        TMonitorResult::getIp,
+                        Function.identity(),
+                        (existing, replacement) -> existing // 濡傛灉閬囧埌鐩稿悓鐨� IP锛屼繚鐣欑涓�涓� TMonitorResult 瀵硅薄
+                ))
+                .values()
+                .stream()
+                .map(TMonitorResult::getWorkOrder)
+                .collect(Collectors.toList());
+        if (!CollectionUtils.isEmpty(workOrderList)) {
+            log.error("pointOnline鑾峰緱鎻掑叆宸ュ崟:{}",workOrderList);
+            workOrderService.innerAddWorkOrder(workOrderList);
         }
         log.info("鐐逛綅鍦ㄧ嚎鐩戞祴瀹屾垚");
     }
 
-    //锛堝純鐢級鐐逛綅鍦ㄧ嚎鐜�
+    //鐐逛綅鍦ㄧ嚎鐜囷紙浼樹簯锛�
     public void videoOnlineTask() {
         //瑙嗛鍥惧儚璐ㄩ噺
         log.info("寮�濮嬫墽琛岀偣浣嶅湪绾挎暟鎹悓姝�");
@@ -301,10 +344,35 @@
                         Query query = new Query(Criteria
                                 .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date())));
                         DeleteResult result = mongoTemplate.remove(query, VideoOnlineResult.class);
+                        //鎵撴爣绛�
+                        records.forEach(item -> {
+                            if (Objects.nonNull(item.getDeviceId())) {
+                                item.setNo(item.getDeviceId());
+                            }
+                        });
+                        pointService.setDeviceTagByGB(records,CheckConstants.Rule_Category_Video);
+                        log.error("鐐逛綅鍦ㄧ嚎鐜囨彃鍏ユ暟鎹ぇ灏弡}",records.size());
                         //瀛樻斁鍦╩ongo涓�
                         mongoTemplate.insertAll(records);
-                        // 宸ュ崟鐢熸垚
-                        uyErrorTypeCheckService.videoOnlineCheck(records);
+                        //鏇存柊point琛ㄥ湪绾跨姸鎬�
+                        Date now = new Date();
+                        List<UpdateOnlineVO> willUpdateList = records.stream().map(item -> {
+                            UpdateOnlineVO vo = new UpdateOnlineVO();
+                            vo.setOnline(item.getStatus());
+                            vo.setIp(item.getIpAddr());
+                            vo.setUpdateTime(now);
+                            return vo;
+                        }).collect(Collectors.toList());
+                        monitorMapper.updateOnlineFromUyOrHk(willUpdateList);
+                        //绂荤嚎鐢熸垚宸ュ崟,涓�涓猧p鍙敓鎴愪竴涓伐鍗�
+                        List<VideoOnlineResult> workOrders = new ArrayList<>(records.stream()
+                                .filter(item -> ApiConstants.UY_OnlineSite_Offline.equals(item.getStatus()))
+                                .collect(Collectors.toMap(
+                                        VideoOnlineResult::getIpAddr,
+                                        Function.identity(),
+                                        (existing, replacement) -> existing // 濡傛灉閬囧埌鐩稿悓鐨� IP锛屼繚鐣欑涓�涓紙existing锛�
+                                )).values());
+                        uyErrorTypeCheckService.videoOnlineCheck(workOrders);
                     } else {
                         log.error("鐐逛綅鍦ㄧ嚎缁撴灉鏁版嵁涓虹┖{}", data);
                     }
@@ -322,6 +390,21 @@
 //        uyErrorTypeCheckService.videoOnlineCheck(mongoTemplate.find(query, VideoOnlineResult.class));
         log.info("缁撴潫鎵ц鐐逛綅鍦ㄧ嚎鏁版嵁鍚屾");
     }
+    private final ISysConfigService configService;
+
+    public double getSySMinTime(){
+        //鑾峰彇绯荤粺鍙傛暟
+        String dictLabel =  configService.selectConfigByKey("recording_min_time");
+        double recordingMinTime;
+        try {
+            recordingMinTime = Double.parseDouble(dictLabel) / 60; // 濡傛灉 dictLabel 鏄互灏忔椂涓哄崟浣嶏紝鍒欐棤闇�闄や互 60
+        } catch (Exception e) {
+            log.error("閰嶇疆鐨勫垹闄ゆ椂闂磋寖鍥存牸寮忎笉姝g‘: {}", dictLabel, e);
+            return  12.0; // 榛樿 12 灏忔椂锛堜互灏忔椂涓哄崟浣嶏級
+        }
+
+        return recordingMinTime;
+    }
 
     //褰曞儚鍙敤
     public void recordMetaDSumTask() {
@@ -333,9 +416,13 @@
         instance.setTime(new Date());
         instance.add(Calendar.DAY_OF_MONTH, -1);
         SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
+
         String yesterday = format.format(instance.getTime());
         param.setStatTime(yesterday);
+        log.error("寮�濮嬪悓姝ongodb褰曞儚鍙敤鏁版嵁鏃ユ湡涓簕}",yesterday);
         JSONObject jsonObject = uyClient.recordMetaDSumList(param);
+        double minTime = getSySMinTime();
+        AtomicReference<Integer> count = new AtomicReference<>(0);
         if (jsonObject != null) {
             if (ApiConstants.UYSuccessCodeStr.equals(jsonObject.getString("code"))) {
                 List<RecordMetaDSumResult> records = jsonObject.getList("data", RecordMetaDSumResult.class);
@@ -348,12 +435,26 @@
                         if (Objects.nonNull(item.getDeviceId())) {
                             item.setNo(item.getDeviceId());
                         }
+
+                        //鍒ゆ柇 骞朵慨鏀瑰綍鍍忕己灏戠姸鎬�
+                        if (item.getRecordStatus() != -1){
+
+                            count.getAndSet(count.get() + 1);
+                            if (item.getMissDuration() > minTime){
+                                item.setRecordStatus(0);
+                            }else if (item.getMissDuration() < minTime){
+                                item.setRecordStatus(1);
+                            }
+                        }
                     });
-                    pointService.setDeviceTagByGB(records);
+                    //鎵撴爣绛�
+                    pointService.setDeviceTagByGB(records,CheckConstants.Rule_Category_Video);
+                    log.error("鍙戠敓鐘舵�佹敼鍙樻暟閲�:{}",count);
                     //瀛樻斁鍦╩ongo涓�
+                    log.error("鏂板mongodb鏁版嵁澶у皬锛歿}",records.size());
                     mongoTemplate.insertAll(records);
-                    // 宸ュ崟鐢熸垚
-                    uyErrorTypeCheckService.recordMetaDSumCheck(records);
+//                    // 宸ュ崟鐢熸垚
+//                    uyErrorTypeCheckService.recordMetaDSumCheck(records);
                 }
             } else {
                 log.error("褰曞儚鍙敤鏁版嵁涓虹┖{}", jsonObject);

--
Gitblit v1.8.0