From 04b45b8c22594cc5535b164380738a80b0e8cbe2 Mon Sep 17 00:00:00 2001
From: zxl <763096477@qq.com>
Date: 星期一, 26 五月 2025 15:27:57 +0800
Subject: [PATCH] 修改大屏录像可用率指标

---
 ycl-server/src/main/java/com/ycl/platform/service/impl/WorkOrderServiceImpl.java |   91 ++++++++++++++++++++++++++++++++-------------
 1 files changed, 65 insertions(+), 26 deletions(-)

diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/WorkOrderServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/WorkOrderServiceImpl.java
index 4a39cdf..d557e97 100644
--- a/ycl-server/src/main/java/com/ycl/platform/service/impl/WorkOrderServiceImpl.java
+++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/WorkOrderServiceImpl.java
@@ -8,6 +8,7 @@
 import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
 import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.github.pagehelper.util.StringUtil;
 import com.ycl.config.PlatformConfig;
 import com.ycl.exception.ServiceException;
 import com.ycl.platform.domain.entity.*;
@@ -30,6 +31,7 @@
 import com.ycl.system.mapper.SysConfigMapper;
 import com.ycl.system.model.LoginUser;
 import com.ycl.system.page.PageUtil;
+import com.ycl.task.DeleteWorkOrderImgTask;
 import com.ycl.utils.DateUtils;
 import com.ycl.utils.SecurityUtils;
 import com.ycl.utils.http.HttpUtils;
@@ -62,6 +64,7 @@
 import pojo.CascadeOption;
 import utils.file.FileUtils;
 
+import java.time.LocalDate;
 import java.time.LocalDateTime;
 import java.time.ZoneId;
 import java.util.*;
@@ -105,6 +108,8 @@
 
     @Autowired
     private RedisCache redisCache;
+    @Autowired
+    private DeleteWorkOrderImgTask deleteWorkOrderImgTask;
 
     @Override
     public synchronized Boolean innerAddWorkOrder(List<WorkOrder> workOrderList) {
@@ -608,31 +613,41 @@
             img.setWorkOrderNo(workOrder.getWorkOrderNo());
             img.setImgUrl(frameImg);
             img.setCreateTime(new Date());
-            //鍒ゆ柇璇ュ伐鍗曠殑鍥剧墖鏄惁宸茬粡澶т簬5寮犱簡
-            LambdaQueryChainWrapper<WorkOrderCheckImg> qw = new LambdaQueryChainWrapper<>(workOrderCheckImgMapper);
-
-            //鎸夌収鍒涘缓鏃ユ湡闄嶅簭鎺掑垪
-            List<WorkOrderCheckImg> workOrderList = workOrderCheckImgMapper.selectList(
-                    new LambdaQueryChainWrapper<>(workOrderCheckImgMapper)
-                            .eq(WorkOrderCheckImg::getWorkOrderNo, workOrder.getWorkOrderNo())
-                            .orderByDesc(WorkOrderCheckImg::getCreateTime)
-            );
             //淇濈暀鏈�鏂扮殑5寮�
-            if (workOrderList.size()>=5){
-                List<String> imgList = workOrderList.subList(4,workOrderList.size()).stream().map(WorkOrderCheckImg::getImgUrl).collect(Collectors.toList());
-                List<Integer> idList = workOrderList.subList(4, workOrderList.size()).stream().map(WorkOrderCheckImg::getId).collect(Collectors.toList());
-                //鍒犻櫎鐓х墖 锛屽苟涓旂墿鐞嗗垹闄ゆ湇鍔″櫒鍐呭搴旂収鐗囩殑鍚嶅瓧
-                for (String filePath: imgList){
-                    FileUtils.deleteFile( PlatformConfig.getUploadPath()+ filePath);
-                }
-                workOrderCheckImgMapper.deleteBatchIds(idList);
-
-            }
-
-
             workOrderCheckImgMapper.insert(img);
         }
     }
+
+    /**
+     * 娓呯悊宸ュ崟鍥剧墖
+     * */
+    public void clearWorkOrderImg(String workOrderNo) {
+        //鍒ゆ柇璇ュ伐鍗曠殑鍥剧墖鏄惁宸茬粡澶т簬5寮犱簡
+        //鎸夌収鍒涘缓鏃ユ湡闄嶅簭鎺掑垪
+        if (StringUtil.isEmpty(workOrderNo)) {
+            return;
+        }
+        List<WorkOrderCheckImg> workOrderList = new LambdaQueryChainWrapper<WorkOrderCheckImg>(workOrderCheckImgMapper)
+                .select()
+                .eq(WorkOrderCheckImg::getWorkOrderNo, workOrderNo)
+                .orderByDesc(WorkOrderCheckImg::getCreateTime)
+                .list();
+        if (workOrderList.size()>=5){
+            List<String> imgList = workOrderList.subList(4,workOrderList.size()).stream().map(WorkOrderCheckImg::getImgUrl).collect(Collectors.toList());
+            List<Integer> idList = workOrderList.subList(4, workOrderList.size()).stream().map(WorkOrderCheckImg::getId).collect(Collectors.toList());
+            //鍒犻櫎鐓х墖 锛屽苟涓旂墿鐞嗗垹闄ゆ湇鍔″櫒鍐呭搴旂収鐗囩殑鍚嶅瓧
+
+//                /profile/2024-11-18_1d8e6d37-a4d0-4bba-8473-ff4e50eda83d.png
+            log.error("鍒犻櫎宸ュ崟鐓х墖闆嗗悎url:{}",imgList);
+            log.error("鍒犻櫎宸ュ崟瀛樺偍鏁版嵁闆嗗悎id:{}",idList);
+            for (String filePath: imgList){
+                delImgFormClient(filePath);
+            }
+            workOrderCheckImgMapper.deleteBatchIds(idList);
+        }
+
+    }
+
 
     @Override
     public List<WorkOrderYwConditionRecordVO> selectYwConditionByYwId(String workOrderNo) {
@@ -682,6 +697,24 @@
         return Result.error("鍒犻櫎澶辫触");
     }
 
+    /***
+     * 閫氳繃url鍒犻櫎鏈嶅姟鍣ㄥ唴鐨勫浘鐗�
+     * @param url
+     */
+    public void delImgFormClient(String url){
+        //鎻愬彇鏂囦欢鍚�  /profile/2024-11-17_79c02666-da1e-45ba-9f29-7523c848fa4a.png
+        // 杩欓儴鍒�2024-11-17_79c02666-da1e-45ba-9f29-7523c848fa4a.png
+        String imgPath = FileUtils.getImgName(url);
+        if (imgPath.isEmpty()){
+            log.error("url閿欒锛歿}",imgPath);
+        }else{
+            //鎻愬彇鏃ユ湡閮ㄥ垎 缁勮鐩綍 : /opt/zgyw/uploadPath  + /  + yyyy-MM-dd +
+            String pathName = DeleteWorkOrderImgTask.imgSaveBasePath + "/" + FileUtils.extractDateFromString(url);
+            log.error("鍒犻櫎宸ュ崟鍥剧墖闆嗗悎{}",pathName+"/" + imgPath);
+            FileUtils.deleteFile(pathName+"/" + imgPath);
+        }
+    }
+
     /**
      * id鍒犻櫎
      *
@@ -703,9 +736,8 @@
         log.error("鍒犻櫎璺緞:{}",PlatformConfig.getUploadPath());
 
         for (String filePath: workOrderImg){
-            FileUtils.deleteFile( PlatformConfig.getUploadPath()+ filePath);
+            delImgFormClient(filePath);
         }
-        // /home/zgyw/uploadPath
 
         //鍒犻櫎宸ュ崟鍥剧墖璁板綍
         workOrderCheckImgMapper.delete(new QueryWrapper<WorkOrderCheckImg>().eq("work_order_no", workOrderNo));
@@ -715,9 +747,6 @@
         workOrderErrorTypeMapper.delete(new QueryWrapper<WorkOrderErrorType>().eq("work_order_no", workOrderNo));
         //鍒犻櫎宸ュ崟鎯呭喌璁板綍
         workOrderYwConditionRecordMapper.delete(new QueryWrapper<WorkOrderYwConditionRecord>().eq("work_order_no", workOrderNo));
-
-
-
 
         if (baseMapper.deleteById(id) > 0) {
             return Result.ok("鍒犻櫎鎴愬姛");
@@ -791,6 +820,11 @@
     }
 
     @Override
+    public List<WorkOrderVO> distributeList(){
+        return  baseMapper.distributeList();
+    }
+
+    @Override
     @Transactional
     public Result distributeFast(DistributeWorkOrderVO data) {
         // 鑾峰彇褰撳墠鏃堕棿
@@ -846,6 +880,9 @@
             distributeUnLock();
         }
     }
+
+
+
 
     @Override
     @Transactional
@@ -1207,6 +1244,8 @@
         List<SysDictData> errorList = workOrderErrorTypeService.getBaseMapper().getErrorList(workOrder.getWorkOrderNo());
         List<String> errList = errorList.stream().map(SysDictData::getDictLabel).collect(Collectors.toList());
         workOrder.setErrorTypeList(errList);
+        //璇︽儏鏃跺啀娆℃竻鐞�
+        clearWorkOrderImg(workOrderNo);
         // 妫�娴嬪浘鐗�
         List<WorkOrderCheckImg> imgList = new LambdaQueryChainWrapper<>(workOrderCheckImgMapper)
                 .eq(WorkOrderCheckImg::getWorkOrderNo, workOrderNo)

--
Gitblit v1.8.0