From fea22e82e7e49691f6e0c20a29b228d0ab3173e9 Mon Sep 17 00:00:00 2001
From: zxl <763096477@qq.com>
Date: 星期三, 29 十月 2025 17:08:38 +0800
Subject: [PATCH] 修改问题

---
 ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorServiceImpl.java |  356 ++++++++++++++++++++++++++++++++++++-----------------------
 1 files changed, 217 insertions(+), 139 deletions(-)

diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorServiceImpl.java
index d7ac0b3..d837e1a 100644
--- a/ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorServiceImpl.java
+++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/TMonitorServiceImpl.java
@@ -6,6 +6,7 @@
 import com.mongodb.client.AggregateIterable;
 import com.mongodb.client.MongoCollection;
 import com.mongodb.client.MongoDatabase;
+import com.ycl.platform.domain.entity.MonitorConstruction;
 import com.ycl.platform.domain.entity.TMonitor;
 import com.ycl.platform.domain.excel.*;
 import com.ycl.platform.domain.form.VideoExportForm;
@@ -31,6 +32,7 @@
 import com.ycl.platform.mapper.TMonitorMapper;
 import com.ycl.platform.mapper.WorkOrderMapper;
 import com.ycl.platform.mapper.YwPointMapper;
+import com.ycl.platform.service.IMonitorConstructionService;
 import com.ycl.platform.service.ITMonitorService;
 import com.ycl.system.Result;
 import com.ycl.system.entity.SysDictData;
@@ -74,6 +76,8 @@
 import java.util.regex.Pattern;
 import java.util.stream.Collectors;
 
+import static com.ycl.utils.PageUtils.startPage;
+
 /**
  * 璁惧璧勪骇Service涓氬姟灞傚鐞�
  *
@@ -99,7 +103,8 @@
     private DynamicColumnMapper dynamicColumnMapper;
     @Autowired
     private ThreadPoolTaskExecutor threadPoolTaskExecutor;
-
+    @Autowired
+    private IMonitorConstructionService monitorConstructionService;
     /**
      * 鏌ヨ璁惧璧勪骇
      *
@@ -129,156 +134,173 @@
             }
             tMonitor.setTime(time);
         }
-        List<TMonitorVO> monitors = tMonitorMapper.selectTMonitorList(tMonitor);
-        // 寮傚父鎭㈠鐩戞帶
-        if (Objects.equals(tMonitor.getRecovery(), 1L)) {
-            //宸ュ崟鍙�
-            List<String> orders = monitors.stream().map(TMonitorVO::getWorkOrderNo).collect(Collectors.toList());
-            if (CollectionUtils.isEmpty(orders)) {
+        List<TMonitorVO> monitors = new ArrayList<>();
+        if (StringUtils.isNotBlank(tMonitor.getConstructionType())){
+            List<MonitorConstruction> list =
+                    monitorConstructionService.getSerialNumberListByConstructionType(tMonitor.getConstructionType());
+            log.info("鎵撳嵃鏌ヨ璁惧鏍囩鏁�:{},寤鸿绫诲瀷鏍囩:{}",list.size(), tMonitor.getConstructionType() );
+            //鑾峰緱璁惧缂栧彿闆嗗悎 閫氳繃寤鸿绫诲瀷鏍囩
+            if(!CollectionUtils.isEmpty(list)){
+                tMonitor.setIds(
+                        list.stream().map(MonitorConstruction::getSerialNumber).collect(Collectors.toList()));
+
+                startPage();
+                monitors = tMonitorMapper.selectTMonitorListAndIds(tMonitor);
+            }
+
+        }else{
+            startPage();
+            monitors = tMonitorMapper.selectTMonitorList(tMonitor);
+        }
+            // 寮傚父鎭㈠鐩戞帶
+            if (Objects.equals(tMonitor.getRecovery(), 1L)) {
+                //宸ュ崟鍙�
+                List<String> orders = monitors.stream().map(TMonitorVO::getWorkOrderNo).collect(Collectors.toList());
+                if (CollectionUtils.isEmpty(orders)) {
+                    return monitors;
+                }
+                List<WorkOrderVO> voList = workOrderMapper.getRecoveryInfo(orders);
+                for (TMonitorVO monitor : monitors) {
+                    if (!CollectionUtils.isEmpty(voList)) {
+                        for (WorkOrderVO workOrderVO : voList) {
+                            if (monitor.getWorkOrderNo() != null && monitor.getWorkOrderNo().equals(workOrderVO.getWorkOrderNo())) {
+                                monitor.setUnitContact(workOrderVO.getUnitContact());
+                                monitor.setUnitContactPhone(workOrderVO.getUnitContactPhone());
+                                monitor.setYwPeopleName(workOrderVO.getYwPeopleName());
+                                monitor.setErrorType(workOrderVO.getErrorType());
+                            }
+                        }
+                    }
+                }
                 return monitors;
             }
-            List<WorkOrderVO> voList = workOrderMapper.getRecoveryInfo(orders);
-            for (TMonitorVO monitor : monitors) {
-                if (!CollectionUtils.isEmpty(voList)) {
-                    for (WorkOrderVO workOrderVO : voList) {
-                        if (monitor.getWorkOrderNo() != null && monitor.getWorkOrderNo().equals(workOrderVO.getWorkOrderNo())) {
-                            monitor.setUnitContact(workOrderVO.getUnitContact());
-                            monitor.setUnitContactPhone(workOrderVO.getUnitContactPhone());
-                            monitor.setYwPeopleName(workOrderVO.getYwPeopleName());
-                            monitor.setErrorType(workOrderVO.getErrorType());
+            //璁惧缂栧彿
+            List<String> numbers = monitors.stream().map(TMonitorVO::getSerialNumber).collect(Collectors.toList());
+            Query query = new Query();
+            Date now = new Date();
+            query.addCriteria(Criteria.where("no").in(numbers)
+                    .and("mongoCreateTime").gte(DateUtils.getDayStart(now)).lt(DateUtils.getDayEnd(now))
+            );
+            //涓�鏈轰竴妗d俊鎭�
+            List<MonitorQualifyResult> monitorQualifyResults = mongoTemplate.find(query, MonitorQualifyResult.class);
+            // 瑙嗛鐩戞帶璁惧
+            if (Objects.equals(tMonitor.getCameraFunType(), "1")) {
+                //OSD淇℃伅
+                List<OsdCheckResult> osdCheckResults = mongoTemplate.find(query, OsdCheckResult.class);
+                //褰曞儚鍙敤淇℃伅
+                List<RecordMetaDSumResult> videoResults = mongoTemplate.find(query, RecordMetaDSumResult.class);
+                for (TMonitorVO monitor : monitors) {
+                    monitor.setMongoCreateTime(now);
+                    //涓�鏈轰竴妗�
+                    setOneFile(monitorQualifyResults, monitor);
+                    //褰曞儚
+                    if (!CollectionUtils.isEmpty(videoResults)) {
+                        for (RecordMetaDSumResult videoResult : videoResults) {
+                            if (monitor.getSerialNumber().equals(videoResult.getNo())) {
+                                monitor.setVideoComplete(videoResult.getRecordStatus());
+                                monitor.setVideoLoseTime(videoResult.getMissDuration());
+                            }
+                        }
+                    }
+                    //OSD
+                    if (!CollectionUtils.isEmpty(osdCheckResults)) {
+                        for (OsdCheckResult osdCheckResult : osdCheckResults) {
+                            if (monitor.getSerialNumber().equals(osdCheckResult.getNo())) {
+                                monitor.setOSD(OsdCheckResult.checkOsd(osdCheckResult));
+                                monitor.setOSDTime(OsdCheckResult.checkTime(osdCheckResult));
+                            }
                         }
                     }
                 }
             }
-            return monitors;
-        }
-        //璁惧缂栧彿
-        List<String> numbers = monitors.stream().map(TMonitorVO::getSerialNumber).collect(Collectors.toList());
-        Query query = new Query();
-        Date now = new Date();
-        query.addCriteria(Criteria.where("no").in(numbers)
-                .and("mongoCreateTime").gte(DateUtils.getDayStart(now)).lt(DateUtils.getDayEnd(now))
-        );
-        //涓�鏈轰竴妗d俊鎭�
-        List<MonitorQualifyResult> monitorQualifyResults = mongoTemplate.find(query, MonitorQualifyResult.class);
-        // 瑙嗛鐩戞帶璁惧
-        if (Objects.equals(tMonitor.getCameraFunType(), "1")) {
-            //OSD淇℃伅
-            List<OsdCheckResult> osdCheckResults = mongoTemplate.find(query, OsdCheckResult.class);
-            //褰曞儚鍙敤淇℃伅
-            List<RecordMetaDSumResult> videoResults = mongoTemplate.find(query, RecordMetaDSumResult.class);
-            for (TMonitorVO monitor : monitors) {
-                monitor.setMongoCreateTime(now);
-                //涓�鏈轰竴妗�
-                setOneFile(monitorQualifyResults, monitor);
-                //褰曞儚
-                if (!CollectionUtils.isEmpty(videoResults)) {
-                    for (RecordMetaDSumResult videoResult : videoResults) {
-                        if (monitor.getSerialNumber().equals(videoResult.getNo())) {
-                            monitor.setVideoComplete(videoResult.getRecordStatus());
-                            monitor.setVideoLoseTime(videoResult.getMissDuration());
-                        }
-                    }
-                }
-                //OSD
-                if (!CollectionUtils.isEmpty(osdCheckResults)) {
-                    for (OsdCheckResult osdCheckResult : osdCheckResults) {
-                        if (monitor.getSerialNumber().equals(osdCheckResult.getNo())) {
-                            monitor.setOSD(OsdCheckResult.checkOsd(osdCheckResult));
-                            monitor.setOSDTime(OsdCheckResult.checkTime(osdCheckResult));
-                        }
-                    }
-                }
-            }
-        }
-        // 杞﹁締鐩戞帶璁惧
-        if (Objects.equals(tMonitor.getCameraFunType(), "2")) {
-            //灞炴�т竴鑷寸巼銆佸ぇ鍥�
-            List<VehicleDeviceSamplingResult> sampleResults = mongoTemplate.find(query, VehicleDeviceSamplingResult.class);
-            List<PicAccessResult> picAccessResults = mongoTemplate.find(query, PicAccessResult.class);
-            //鎶撴媿閲忋�佹椂閽熴�佷笂浼�
-            List<VehicleDeviceInspectionResult> inspectResults = mongoTemplate.find(query, VehicleDeviceInspectionResult.class);
-            for (TMonitorVO monitor : monitors) {
-                monitor.setMongoCreateTime(now);
-                //涓�鏈轰竴妗�
-                setOneFile(monitorQualifyResults, monitor);
-                //url
-                if (!CollectionUtils.isEmpty(sampleResults)) {
-                    for (PicAccessResult picAccessResult : picAccessResults) {
-                        if (monitor.getSerialNumber().equals(picAccessResult.getNo())) {
-                            BigDecimal bigDecimal = PicAccessResult.calUrl(picAccessResult);
-                            monitor.setUrlPercent(bigDecimal);
-                        }
-                    }
-                }
+            // 杞﹁締鐩戞帶璁惧
+            if (Objects.equals(tMonitor.getCameraFunType(), "2")) {
                 //灞炴�т竴鑷寸巼銆佸ぇ鍥�
-                if (!CollectionUtils.isEmpty(sampleResults)) {
-                    for (VehicleDeviceSamplingResult sampleResult : sampleResults) {
-                        if (monitor.getSerialNumber().equals(sampleResult.getNo())) {
-                            if (sampleResult.getBigUseful() != null) {
-                                monitor.setBigUsefulPercent(sampleResult.getBigUseful().getBigUsefulPercent());
-                            }
-                            if (sampleResult.getVehDiff() != null) {
-                                monitor.setImportantConPercent(sampleResult.getVehDiff().getImportantConPercent());
-                                monitor.setMajorConPercent(sampleResult.getVehDiff().getMajorConPercent());
-                            }
-                        }
-                    }
-                }
+                List<VehicleDeviceSamplingResult> sampleResults = mongoTemplate.find(query, VehicleDeviceSamplingResult.class);
+                List<PicAccessResult> picAccessResults = mongoTemplate.find(query, PicAccessResult.class);
                 //鎶撴媿閲忋�佹椂閽熴�佷笂浼�
-                if (!CollectionUtils.isEmpty(inspectResults)) {
-                    for (VehicleDeviceInspectionResult inspectResult : inspectResults) {
-                        if (monitor.getSerialNumber().equals(inspectResult.getNo())) {
-                            monitor.setSnapResult(inspectResult.getSnapResult());
-                            monitor.setSnapCount(inspectResult.getDataCount());
-                            if (inspectResult.getSnapClock() != null)
-                                monitor.setClockPercent(inspectResult.getSnapClock().getClockPercent());
-                            if (inspectResult.getSnapTimely() != null)
-                                monitor.setUploadPercent(inspectResult.getSnapTimely().getTimelyPercent());
-                        }
-                    }
-                }
-            }
-        }
-        // 浜鸿劯鐩戞帶璁惧
-        if (Objects.equals(tMonitor.getCameraFunType(), "3")) {
-            //浜鸿劯鍚堟牸銆佸ぇ鍥俱�乽rl璁块棶寮傚父
-            List<FaceDeviceSamplingResult> sampleResults = mongoTemplate.find(query, FaceDeviceSamplingResult.class);
-            //鎶撴媿閲忋�佹椂閽熴�佷笂浼�
-            List<FaceDeviceInspectionResult> inspectResults = mongoTemplate.find(query, FaceDeviceInspectionResult.class);
-            for (TMonitorVO monitor : monitors) {
-                monitor.setMongoCreateTime(now);
-                //涓�鏈轰竴妗�
-                setOneFile(monitorQualifyResults, monitor);
-                //浜鸿劯鍚堟牸銆佸ぇ鍥�
-                if (!CollectionUtils.isEmpty(sampleResults)) {
-                    for (FaceDeviceSamplingResult sampleResult : sampleResults) {
-                        if (monitor.getSerialNumber().equals(sampleResult.getNo())) {
-                            if (sampleResult.getBigUseful() != null) {
-                                monitor.setBigUsefulPercent(sampleResult.getBigUseful().getBigUsefulPercent());
+                List<VehicleDeviceInspectionResult> inspectResults = mongoTemplate.find(query, VehicleDeviceInspectionResult.class);
+                for (TMonitorVO monitor : monitors) {
+                    monitor.setMongoCreateTime(now);
+                    //涓�鏈轰竴妗�
+                    setOneFile(monitorQualifyResults, monitor);
+                    //url
+                    if (!CollectionUtils.isEmpty(sampleResults)) {
+                        for (PicAccessResult picAccessResult : picAccessResults) {
+                            if (monitor.getSerialNumber().equals(picAccessResult.getNo())) {
+                                BigDecimal bigDecimal = PicAccessResult.calUrl(picAccessResult);
+                                monitor.setUrlPercent(bigDecimal);
                             }
-                            if (sampleResult.getFaceEligibility() != null)
-                                monitor.setFacePercent(sampleResult.getFaceEligibility().getFaceEligPercent());
                         }
                     }
-                }
-                //鎶撴媿閲忋�佹椂閽熴�佷笂浼犮�佸缓妯″け璐ョ巼
-                if (!CollectionUtils.isEmpty(inspectResults)) {
-                    for (FaceDeviceInspectionResult inspectResult : inspectResults) {
-                        if (monitor.getSerialNumber().equals(inspectResult.getNo())) {
-                            monitor.setSnapResult(inspectResult.getSnapResult());
-                            monitor.setSnapCount(inspectResult.getDataCount());
-                            if (inspectResult.getSnapClock() != null)
-                                monitor.setClockPercent(inspectResult.getSnapClock().getClockPercent());
-                            if (inspectResult.getSnapTimely() != null)
-                                monitor.setUploadPercent(inspectResult.getSnapTimely().getTimelyPercent());
-                            if (inspectResult.getSnapValidity() != null)
-                                monitor.setFailPercent(inspectResult.getSnapValidity().getFailPercent());
+                    //灞炴�т竴鑷寸巼銆佸ぇ鍥�
+                    if (!CollectionUtils.isEmpty(sampleResults)) {
+                        for (VehicleDeviceSamplingResult sampleResult : sampleResults) {
+                            if (monitor.getSerialNumber().equals(sampleResult.getNo())) {
+                                if (sampleResult.getBigUseful() != null) {
+                                    monitor.setBigUsefulPercent(sampleResult.getBigUseful().getBigUsefulPercent());
+                                }
+                                if (sampleResult.getVehDiff() != null) {
+                                    monitor.setImportantConPercent(sampleResult.getVehDiff().getImportantConPercent());
+                                    monitor.setMajorConPercent(sampleResult.getVehDiff().getMajorConPercent());
+                                }
+                            }
+                        }
+                    }
+                    //鎶撴媿閲忋�佹椂閽熴�佷笂浼�
+                    if (!CollectionUtils.isEmpty(inspectResults)) {
+                        for (VehicleDeviceInspectionResult inspectResult : inspectResults) {
+                            if (monitor.getSerialNumber().equals(inspectResult.getNo())) {
+                                monitor.setSnapResult(inspectResult.getSnapResult());
+                                monitor.setSnapCount(inspectResult.getDataCount());
+                                if (inspectResult.getSnapClock() != null)
+                                    monitor.setClockPercent(inspectResult.getSnapClock().getClockPercent());
+                                if (inspectResult.getSnapTimely() != null)
+                                    monitor.setUploadPercent(inspectResult.getSnapTimely().getTimelyPercent());
+                            }
                         }
                     }
                 }
             }
-        }
+            // 浜鸿劯鐩戞帶璁惧
+            if (Objects.equals(tMonitor.getCameraFunType(), "3")) {
+                //浜鸿劯鍚堟牸銆佸ぇ鍥俱�乽rl璁块棶寮傚父
+                List<FaceDeviceSamplingResult> sampleResults = mongoTemplate.find(query, FaceDeviceSamplingResult.class);
+                //鎶撴媿閲忋�佹椂閽熴�佷笂浼�
+                List<FaceDeviceInspectionResult> inspectResults = mongoTemplate.find(query, FaceDeviceInspectionResult.class);
+                for (TMonitorVO monitor : monitors) {
+                    monitor.setMongoCreateTime(now);
+                    //涓�鏈轰竴妗�
+                    setOneFile(monitorQualifyResults, monitor);
+                    //浜鸿劯鍚堟牸銆佸ぇ鍥�
+                    if (!CollectionUtils.isEmpty(sampleResults)) {
+                        for (FaceDeviceSamplingResult sampleResult : sampleResults) {
+                            if (monitor.getSerialNumber().equals(sampleResult.getNo())) {
+                                if (sampleResult.getBigUseful() != null) {
+                                    monitor.setBigUsefulPercent(sampleResult.getBigUseful().getBigUsefulPercent());
+                                }
+                                if (sampleResult.getFaceEligibility() != null)
+                                    monitor.setFacePercent(sampleResult.getFaceEligibility().getFaceEligPercent());
+                            }
+                        }
+                    }
+                    //鎶撴媿閲忋�佹椂閽熴�佷笂浼犮�佸缓妯″け璐ョ巼
+                    if (!CollectionUtils.isEmpty(inspectResults)) {
+                        for (FaceDeviceInspectionResult inspectResult : inspectResults) {
+                            if (monitor.getSerialNumber().equals(inspectResult.getNo())) {
+                                monitor.setSnapResult(inspectResult.getSnapResult());
+                                monitor.setSnapCount(inspectResult.getDataCount());
+                                if (inspectResult.getSnapClock() != null)
+                                    monitor.setClockPercent(inspectResult.getSnapClock().getClockPercent());
+                                if (inspectResult.getSnapTimely() != null)
+                                    monitor.setUploadPercent(inspectResult.getSnapTimely().getTimelyPercent());
+                                if (inspectResult.getSnapValidity() != null)
+                                    monitor.setFailPercent(inspectResult.getSnapValidity().getFailPercent());
+                            }
+                        }
+                    }
+                }
+            }
         return monitors;
     }
 
@@ -346,6 +368,13 @@
     @Override
     @DataScope(deptAlias = "d", userAlias = "u")
     public Map<String, String> getVideoCount(TMonitorVO tMonitor) {
+
+        List<MonitorConstruction> list =
+                monitorConstructionService.getSerialNumberListByConstructionType(tMonitor.getConstructionType());
+        //鑾峰緱璁惧缂栧彿闆嗗悎 閫氳繃寤鸿绫诲瀷鏍囩
+        tMonitor.setIds(
+                list.stream().map(MonitorConstruction::getSerialNumber).collect(Collectors.toList()));
+
         return tMonitorMapper.getVideoCount(tMonitor);
     }
 
@@ -556,8 +585,6 @@
         ExcelUtilManySheet<List<ExcelExp>> util = new ExcelUtilManySheet<>(mysheet);
         util.exportExcelManySheet(response, mysheet);
     }
-
-
     /**
      * 瀵煎嚭姣忔棩鍦ㄧ嚎鏁版嵁
      */
@@ -578,9 +605,34 @@
         // 浣跨敤绾跨▼瀹夊叏鐨凩ist锛岄鍏堟寚瀹氬閲�
         List<ExcelExp> mysheet = Collections.synchronizedList(new ArrayList<>());
         VideoExportForm.convertTags(exportForm);
-        Query query = getQuery(exportForm);
+        Query query = getQuery(exportForm);//瑁呴厤鏉′欢
         // 鏈堜唤姣忔棩鍦ㄧ嚎鏁版嵁
+
         List<TMonitorResult> onlineResult = mongoTemplate.find(query, TMonitorResult.class);
+        log.info("澶у皬:{}",onlineResult.size());
+        //姝ゅ闇�瑕佽繃婊ゆ帀璁惧鍏ㄦ櫙鍦ㄧ嚎 缁嗚妭涓嶅湪绾跨殑鎯呭喌  鍙互鎸� point鍒嗙粍 鍒嗘垜璁稿缁勪箣鍚庡啀鍋氬鐞�
+        Map<String, List<TMonitorResult>> ipToDevices = onlineResult.stream()
+                .collect(Collectors.groupingBy(TMonitorResult::getIp));
+
+//        onlineResult = ipToDevices.values().stream()
+//                .map(devices -> {
+//                    // 妫�鏌ュ垎缁勪腑鏄惁鏈� online = true 鐨勮澶�
+//                    List<TMonitorResult> onlineDevices = devices.stream()
+//                            .filter(monitor -> monitor.getOnline() == 1) // 鍋囪online瀛楁鐨刧etter鏄痠sOnline()
+//                            .collect(Collectors.toList());
+//
+//                    if (!onlineDevices.isEmpty()) {
+//                        // 鑻ュ瓨鍦╫nline=true鐨勮澶囷紝鍙繚鐣欑涓�涓紙鎴栧彇浠绘剰涓�涓紝鎸夐渶璋冩暣锛�
+//                        return onlineDevices.get(0);
+//                    } else {
+//                        // 鑻ュ叏涓簅nline=false锛屽彧淇濈暀绗竴涓�
+//                        return devices.get(0);
+//                    }
+//                })
+//                .collect(Collectors.toList());
+
+
+
         log.info("鏈堜唤鍦ㄧ嚎鏁版嵁:{}鏉℃暟", onlineResult.size());
         // 浣跨敤Collectors.toMap鍘婚噸锛屼繚鐣欐瘡涓狽o鐨勭涓�涓亣鍒扮殑鍏冪礌
         Map<String, TMonitorResult> uniqueResultsMap = onlineResult.stream()
@@ -589,9 +641,14 @@
                         Function.identity(),  // valueMapper锛岀洿鎺ヤ娇鐢ㄥ璞℃湰韬�
                         (existing, replacement) -> existing // mergeFunction锛屽鏋滄湁閲嶅锛屼繚鐣欑涓�涓�
                 ));
+
+
         // 灏� Map 杞崲涓� List
         List<TMonitorResult> tMonitorResults = new ArrayList<>(uniqueResultsMap.values());
         log.info("鍘婚噸鍚庡ぇ灏�:{}", tMonitorResults.size());
+
+
+
         // 鑾峰彇鍔ㄦ�佸垪鏁版嵁骞舵瀯寤虹紦瀛楳ap
         Map<Integer, List<DynamicColumnVO>> dynamicColumnMap = new HashMap<>();
         if (!tMonitorResults.isEmpty()) {
@@ -600,6 +657,8 @@
                     .map(TMonitorResult::getPointId)
                     .distinct() // 鍘婚噸锛屽噺灏戞暟鎹簱鏌ヨ
                     .collect(Collectors.toList());
+
+
             //鑾峰彇闆嗗悎鐐逛綅鐨勮ˉ鍏呭垪淇℃伅
             List<DynamicColumnVO> dynamics = dynamicColumnMapper.getDynamicsByIds("t_yw_point", pointIds);
             if (!CollectionUtils.isEmpty(dynamics)) {
@@ -631,6 +690,9 @@
             CompletableFuture<ExcelExp> future = CompletableFuture.supplyAsync(() -> {
                 // 鐩存帴浠庨鍒嗙粍鐨凪ap涓幏鍙栵紝閬垮厤姣忔杩囨护
                 List<TMonitorResult> monitors = deptMonitorMap.getOrDefault(currentDeptId, Collections.emptyList());
+
+
+
                 if (monitors.isEmpty()) {
                     return null;
                 }
@@ -1458,6 +1520,22 @@
     @Override
     public void export(HttpServletResponse response, TMonitorVO tMonitor) {
         List<TMonitorExp> monitors = tMonitorMapper.exportTMonitorList(tMonitor);
+        //杩囨护鍑鸿澶囧缓璁剧被鍨�
+        if (StringUtils.isNotBlank(tMonitor.getConstructionType())){
+            List<MonitorConstruction> list =
+                    monitorConstructionService.getSerialNumberListByConstructionType(tMonitor.getConstructionType());
+            //鑾峰緱璁惧缂栧彿闆嗗悎 閫氳繃寤鸿绫诲瀷鏍囩
+            List<String> serialNumberList = list.stream().map(MonitorConstruction::getSerialNumber).collect(Collectors.toList());
+            monitors = monitors.stream()
+                    .filter(result -> {
+                        String sn = result.getSerialNumber();
+                        // 浠讳竴瀛楁闈炵┖涓斿湪闆嗗悎涓嵆鍙�
+                        return (sn != null && serialNumberList.contains(sn));
+                    })
+                    .collect(Collectors.toList());
+        }
+
+
         //鑾峰彇鍔ㄦ�佸垪鏁版嵁
         List<Integer> pointIds = monitors.stream().map(TMonitorExp::getPointId).collect(Collectors.toList());
         List<DynamicColumnVO> dynamics = dynamicColumnMapper.getDynamicsByIds("t_yw_point", pointIds);

--
Gitblit v1.8.0