From 1cad14bca191807e18705c3a5526eda8151be439 Mon Sep 17 00:00:00 2001
From: zhanghua <314079846@qq.com>
Date: 星期一, 14 四月 2025 23:10:22 +0800
Subject: [PATCH] 批量审核和图片保存bug

---
 ycl-platform/src/main/java/com/ycl/task/SynchronizeDHAlarm.java |   49 ++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 48 insertions(+), 1 deletions(-)

diff --git a/ycl-platform/src/main/java/com/ycl/task/SynchronizeDHAlarm.java b/ycl-platform/src/main/java/com/ycl/task/SynchronizeDHAlarm.java
index 7ad52dd..9f42306 100644
--- a/ycl-platform/src/main/java/com/ycl/task/SynchronizeDHAlarm.java
+++ b/ycl-platform/src/main/java/com/ycl/task/SynchronizeDHAlarm.java
@@ -1,12 +1,16 @@
 package com.ycl.task;
 
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.ycl.common.constant.GlobalQueue;
 import com.ycl.entity.video.VideoAlarmReport;
 import com.ycl.entity.video.VideoPoint;
+import com.ycl.service.caseHandler.IBaseCaseService;
 import com.ycl.service.caseHandler.IViolationsService;
 import com.ycl.service.oss.OssService;
+import com.ycl.service.resources.IImageResourcesService;
 import com.ycl.service.video.IVideoAlarmReportService;
 import com.ycl.service.video.impl.IVideoPointService;
+import com.ycl.vo.casePool.BaseCaseVO;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.scheduling.annotation.Scheduled;
 import org.springframework.stereotype.Component;
@@ -14,6 +18,9 @@
 
 import java.io.ByteArrayInputStream;
 import java.io.InputStream;
+import java.io.UnsupportedEncodingException;
+import java.time.LocalDateTime;
+import java.time.format.DateTimeFormatter;
 import java.util.ArrayList;
 import java.util.List;
 
@@ -31,6 +38,12 @@
 
     @Autowired
     private IViolationsService violationsService;
+
+    @Autowired
+    private IBaseCaseService baseCaseService;
+
+    @Autowired
+    private IImageResourcesService imageService;
 
     @Scheduled(cron = "0 */1 * * * ?")
     @Transactional(rollbackFor = Exception.class)
@@ -51,7 +64,7 @@
                     if (videoAlarmReport.getPicByte() != null) {
                         String extension = "jpg";
                         InputStream inputStream = new ByteArrayInputStream(videoAlarmReport.getPicByte());
-                        String picData = ossService.uploadImages(inputStream, extension);
+                        String picData = ossService.uploadImages(inputStream, extension, 0);
 
                         videoAlarmReport.setPicData(picData);
                     }
@@ -68,4 +81,38 @@
             }
         }
     }
+
+
+    @Scheduled(cron = "0 0 0 * * ?")
+//    @Transactional(rollbackFor = Exception.class)
+    public void deleteAlarmTask() {
+        System.out.println("----------------鎵ц娓呴櫎鏁版嵁浠诲姟:");
+        int i = 1;
+        while (true) {
+            String beginTime = "2020-01-01 00:00:00";
+            String endTime = LocalDateTime.now().plusDays(-3).format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
+            Page<BaseCaseVO> page = baseCaseService.selectVideoInspection(i, 10, null, null, beginTime, endTime, null);
+
+            System.out.println("----------------娓呴櫎鏁版嵁浠诲姟鎬绘潯鏁�:" + page.getTotal());
+            if (page.getRecords().size() > 0) {
+                page.getRecords().forEach(baseCaseVO -> {
+                    String picData = baseCaseVO.getPicData();
+                    String[] urls = picData.split(",");
+                    for (String url : urls) {
+                        ossService.deleteImages(url);
+                    }
+
+                    baseCaseService.removeById(baseCaseVO.getBaseId());
+                    violationsService.removeById(baseCaseVO.getBaseId());
+
+                    imageService.removeById(baseCaseVO.getImageId());
+
+                    System.out.println("----------------娓呴櫎鏁版嵁鏁版嵁鎴愬姛锛宨d:" + baseCaseVO.getBaseId());
+                });
+            } else {
+                break;
+            }
+            i++;
+        }
+    }
 }

--
Gitblit v1.8.0