From 3351ade035a3a027d38e0372e496a5669cd7bde2 Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期一, 30 九月 2024 00:34:42 +0800 Subject: [PATCH] 下发工单bug --- ycl-server/src/main/java/com/ycl/platform/service/impl/WorkOrderServiceImpl.java | 39 ++++++++++++++++++++++++++++++++------- 1 files changed, 32 insertions(+), 7 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 6f47e90..b9edc3a 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 @@ -1,5 +1,6 @@ package com.ycl.platform.service.impl; +import com.alibaba.excel.annotation.format.DateTimeFormat; import com.alibaba.fastjson2.JSON; import com.alibaba.fastjson2.JSONObject; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; @@ -55,6 +56,12 @@ import org.springframework.util.CollectionUtils; import org.springframework.util.StringUtils; +import java.net.HttpURLConnection; +import java.net.URL; +import java.net.URLDecoder; +import java.net.URLEncoder; +import java.nio.charset.StandardCharsets; +import java.text.SimpleDateFormat; import java.time.LocalDateTime; import java.time.ZoneId; import java.util.*; @@ -93,7 +100,6 @@ @Override @Transactional(rollbackFor = Exception.class) - //TODO锛氭竻绌篟edis瀹氭椂浠诲姟 public synchronized Boolean innerAddWorkOrder(List<WorkOrder> workOrderList) { int total = workOrderList.size(); workOrderList.stream().filter(item -> { @@ -558,7 +564,7 @@ .select(WorkOrder::getSerialNumber, WorkOrder::getWorkOrderNo) .eq(WorkOrder::getStatus, WorkOrderStatusEnum.WAIT_DISTRIBUTE) .eq(Objects.nonNull(data.getUnitId()), WorkOrder::getUnitId, data.getUnitId()) - .eq(WorkOrder::getErrorType, data.getErrorType()) + .in(WorkOrder::getErrorType, data.getErrorType()) .between(WorkOrder::getCreateTime, data.getStart(), data.getEnd()) .orderByDesc(WorkOrder::getCreateTime) .last("limit " + data.getFastNumLimit()) @@ -620,6 +626,7 @@ ywPointService.updateRecovery(serialNumberList, 1); return Result.ok("鎴愬姛涓嬪彂" + query.getWorkOrderNOList().size() + "鏉″伐鍗�"); } catch (Exception e) { + System.out.println(e.getMessage()); return Result.error("鎿嶄綔澶辫触"); } finally { distributeUnLock(); @@ -764,8 +771,6 @@ FFmpegFrameGrabber grabber = null; try { grabber = FFmpegFrameGrabber.createDefault(rtspUrl); - //璁剧疆10s瓒呮椂 - grabber.setTimeout(10000); grabber.start(); Frame frame = grabber.grabImage(); // 鐩存帴鎹曡幏涓�甯� if (frame != null) { @@ -784,17 +789,16 @@ } else { System.out.println("鏈崟鑾峰埌甯�"); } - } catch (FrameGrabber.Exception e) { + } catch (Exception e) { e.printStackTrace(); } finally { if (grabber != null) { try { grabber.stop(); // 鍋滄鎹曡幏 + grabber.release(); } catch (FrameGrabber.Exception e) { e.printStackTrace(); } - // 閫氬父涓嶉渶瑕佽皟鐢╮elease()锛屽洜涓簊top()浼氬鐞嗚祫婧愰噴鏀� - // grabber.release(); // 閲婃斁璧勬簮 } } } @@ -942,4 +946,25 @@ workOrder.setImgList(imgList); return Result.ok().data(workOrder); } + + @Override + public List<WorkOrderVO> export(WorkOrderExportQuery query) { + query.setUnitId(SecurityUtils.getUnitId()); + SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + if (query.getStart() == null) { + query.setStart(format.format(DateUtils.getDayStart(new Date()))); + } else { + query.setStart(query.getStart() + " 00:00:00"); + } + if (query.getEnd() == null) { + query.setStart(format.format(DateUtils.getDayEnd(new Date()))); + } else { + query.setEnd(query.getEnd() + " 23:59:59"); + } + + List<WorkOrderVO> export = baseMapper.export(query); + + System.out.println(export); + return export; + } } -- Gitblit v1.8.0