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 |  163 ++++++++++++++++++++++++++++++++++++------------------
 1 files changed, 108 insertions(+), 55 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 7527055..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,7 @@
 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;
 
@@ -55,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}")
@@ -69,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()
@@ -101,7 +105,7 @@
                                 item.setNo(item.getDeviceId());
                             }
                         });
-                        pointService.setDeviceTagByGB(records);
+                        pointService.setDeviceTagByGB(records, CheckConstants.Rule_Category_Video);
                         //瀛樻斁鍦╩ongo涓�
                         mongoTemplate.insertAll(records);
                         // 宸ュ崟鐢熸垚
@@ -150,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);
@@ -174,6 +178,8 @@
 
     /**
      * 鐐逛綅鍦ㄧ嚎PING妫�娴�
+     * 浠诲姟浼氬厛鎵ц涓�娆′紭浜戝悓姝ワ紝鐒跺悗鎵цping妫�娴�
+     * online瀛楁鏉ヨ嚜浜庝紭浜戯紝pingOnline涓轰富鍔╬ing妫�娴嬬殑銆傚瓨鍏ongo缁欐暟鎹腑蹇冩煡闃�
      */
     public void pointOnline() throws ExecutionException, InterruptedException {
         log.info("寮�濮嬫娴嬬偣浣嶅湪绾�");
@@ -186,11 +192,15 @@
         } else {
             log.error("璇烽厤缃绾挎鏁帮紝姝ゆ璁剧疆涓洪粯璁ゅ��2");
         }
+
+
         // 鍏堟煡鍑鸿澶嘔P闆嗗悎,鍓旈櫎鎺夊湪绾挎儏鍐垫槸鏈煡鐨�,骞朵笖鍙娴嬫鍦ㄨ�冩牳鐨勮澶囬伩鍏嶅浣欏伐鍗�
         List<TMonitorResult> monitorList = monitorMapper.getDistinctIP();
         //琛ュ厖閿欒鏃堕棿鐐�
         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()));
+        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){
@@ -204,7 +214,7 @@
                             OnlineCheckThread thread = new OnlineCheckThread(monitor, checkPointUtil, time);
                             return thread.call(); // 鍋囪 OnlineCheckThread 瀹炵幇浜� Callable 鎺ュ彛
                         }, executorService)
-                        .orTimeout(60, TimeUnit.SECONDS)
+                        .orTimeout(180, TimeUnit.SECONDS)
                         .exceptionally(ex -> {
                             if (ex instanceof TimeoutException) {
                                 log.error("浠诲姟鎵ц瓒呮椂:"+monitor.getIp());
@@ -213,36 +223,6 @@
                                 ex.printStackTrace();
                             }
                             return null;
-//                            int checkTimes = 1;
-//                            int offLineTimes = 1;
-//                            Map<String, Object> map = (Map<String, Object>) redisTemplate.opsForHash().get(RedisConstant.ONLINE_KEY, monitor.getNo());
-//                            if (!CollectionUtils.isEmpty(map)) {
-//                                checkTimes = (Integer) map.get("checkTimes") + 1;
-//                                offLineTimes = (Integer) map.get("offLineTimes");
-//                            }else {
-//                                map = new HashMap<>();
-//                            }
-//                            monitor.setPingOnline(Boolean.FALSE);
-//                            monitor.setCheckCount(checkTimes);
-//                            monitor.setOffLineCount(offLineTimes);
-//                            List<Date> offLineTime = monitor.getOffLineTime();
-//                            if(CollectionUtils.isEmpty(offLineTime)) offLineTime = new ArrayList<>();
-//                            offLineTime.add(new Date());
-//                            monitor.setOffLineTime(offLineTime);
-//                            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);
-//                            }
-//                            map.put("checkTimes", checkTimes);
-//                            map.put("offLineTimes", offLineTimes);
-//                            redisTemplate.opsForHash().put(RedisConstant.ONLINE_KEY, monitor.getNo(), map);
-//                            return monitor; // 杩斿洖澶辫触鐨勭粨鏋�
-
                         }))
                 .collect(Collectors.toList());
 
@@ -250,6 +230,7 @@
         CompletableFuture<Void> allOf = CompletableFuture.allOf(
                 futureList.toArray(new CompletableFuture[0])
         );
+
         try {
             allOf.get(60, TimeUnit.SECONDS); // 缁欎簣棰濆鐨�5绉掓潵鏀堕泦缁撴灉
         } catch (TimeoutException e) {
@@ -262,31 +243,69 @@
                 .map(CompletableFuture::join)
                 .filter(Objects::nonNull)
                 .collect(Collectors.toList());
-        //绛涢�夊嚭ping绂荤嚎鐨勮澶囷紝鏇存敼鏁版嵁搴撲负绂荤嚎锛屽苟涓旀洿鏂扮函杞﹁締鎴栫函浜鸿劯鐨勮澶囩殑鍦ㄧ嚎鐘舵��(杩欓儴鍒嗚澶囦笉浼氭媺娴佹娴�)
+
+
         Date now = new Date();
-        List<UpdateOnlineVO> onlineUpdateList = dataList.stream().map(item -> {
-            UpdateOnlineVO vo = new UpdateOnlineVO();
+        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()) {
-                vo.setOnline(ApiConstants.UY_OnlineSite_Online);
-            }else if(!item.getPingOnline()){
-                vo.setOnline(ApiConstants.UY_OnlineSite_Offline);
+                onLineList.add(item.getIp());
+            } else if(!item.getPingOnline()) {
+                //绛涢�夊嚭ping绂荤嚎鐨勮澶囷紝鏇存敼鏁版嵁搴撲负绂荤嚎
+                offLineList.add(item.getIp());
+            }else {
+                unKnownList.add(item.getIp());
             }
-            vo.setIp(item.getIp());
-            vo.setUpdateTime(now);
-            return vo;
-        }).collect(Collectors.toList());
-        monitorMapper.updateOnline(onlineUpdateList);
+        });
+        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()))
+                .filter(item -> Objects.nonNull(item.getWorkOrder()) && (CollectionUtils.isEmpty(ips) || !ips.contains(item.getIp())))
                 .collect(Collectors.toMap(
                         TMonitorResult::getIp,
                         Function.identity(),
@@ -297,6 +316,7 @@
                 .map(TMonitorResult::getWorkOrder)
                 .collect(Collectors.toList());
         if (!CollectionUtils.isEmpty(workOrderList)) {
+            log.error("pointOnline鑾峰緱鎻掑叆宸ュ崟:{}",workOrderList);
             workOrderService.innerAddWorkOrder(workOrderList);
         }
         log.info("鐐逛綅鍦ㄧ嚎鐩戞祴瀹屾垚");
@@ -330,7 +350,8 @@
                                 item.setNo(item.getDeviceId());
                             }
                         });
-                        pointService.setDeviceTagByGB(records);
+                        pointService.setDeviceTagByGB(records,CheckConstants.Rule_Category_Video);
+                        log.error("鐐逛綅鍦ㄧ嚎鐜囨彃鍏ユ暟鎹ぇ灏弡}",records.size());
                         //瀛樻斁鍦╩ongo涓�
                         mongoTemplate.insertAll(records);
                         //鏇存柊point琛ㄥ湪绾跨姸鎬�
@@ -342,7 +363,7 @@
                             vo.setUpdateTime(now);
                             return vo;
                         }).collect(Collectors.toList());
-                        monitorMapper.updateOnline(willUpdateList);
+                        monitorMapper.updateOnlineFromUyOrHk(willUpdateList);
                         //绂荤嚎鐢熸垚宸ュ崟,涓�涓猧p鍙敓鎴愪竴涓伐鍗�
                         List<VideoOnlineResult> workOrders = new ArrayList<>(records.stream()
                                 .filter(item -> ApiConstants.UY_OnlineSite_Offline.equals(item.getStatus()))
@@ -369,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() {
@@ -380,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);
@@ -395,10 +435,23 @@
                         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);

--
Gitblit v1.8.0