blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
fuliqi
2024-09-30 b5df1cee65f3e9dcf554efcd3f1642a8c79d1e76 
 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：Redis加锁，从Redis读取当日工单数据量


    public synchronized Boolean innerAddWorkOrder(List<WorkOrder> workOrderList) {


        int total = workOrderList.size();


        workOrderList.stream().filter(item -> {


@@ -231,7 +237,7 @@


            }


            //数字前面补0


            workOrderNum++;


            workOrder.setWorkOrderNo(IdUtils.randomNO(now, String.format("%05d", workOrderNum)));


            workOrder.setWorkOrderNo(IdUtils.workOrderNO(now, String.format("%05d", workOrderNum)));


            if (Objects.nonNull(point.getUnitId())) {


                workOrder.setUnitId(Math.toIntExact(point.getUnitId()));


            }


@@ -292,14 +298,14 @@


    @Override


    public Result add(WorkOrderForm form) {


        //查redis今日工单数量


        int workOrderNum = 1;


        int workOrderNum = 0;


        //UUID作为value，保证上锁的线程自己解锁


        String requestId = IdUtils.fastSimpleUUID();


        boolean result = redisCache.acquireLock(RedisConstant.WORKORDER_NUM_LOCK, requestId, 10000);


        if (result) {


            //查今日工单量


            Object redisNum = redisCache.getCacheObject(RedisConstant.WORKORDER_NUM);


            workOrderNum = redisNum == null ? 1 : (Integer) redisNum;


            workOrderNum = redisNum == null ? 0 : (Integer) redisNum;


            workOrderNum++;


            redisCache.setCacheObject(RedisConstant.WORKORDER_NUM, workOrderNum);


            redisCache.releaseLock(RedisConstant.WORKORDER_NUM_LOCK, requestId);


@@ -312,7 +318,7 @@


        Date now = new Date();


        entity.setCreateTime(now);


        entity.setUpdateTime(now);


        entity.setWorkOrderNo(IdUtils.randomNO(now, String.format("%05d", workOrderNum)));


        entity.setWorkOrderNo(IdUtils.workOrderNO(now, String.format("%05d", workOrderNum)));


        entity.setErrorType(String.join(",", form.getErrorType()));


        List<WorkOrderErrorType> workOrderErrorTypes = form.getErrorType().stream().map(errorType -> new WorkOrderErrorType(entity.getWorkOrderNo(), errorType)).toList();


        workOrderErrorTypeService.getBaseMapper().insertWorkOrderErrorTypeList(workOrderErrorTypes);


@@ -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();


@@ -751,7 +758,7 @@






    @Override


    public String getFrameImgByDevice(String deviceId, String channelId, String workOrderNo) {


    public synchronized String getFrameImgByDevice(String deviceId, String channelId, String workOrderNo) {


        String url = String.format(this.rtspServer + "/api/play/start/%s/%s", deviceId, channelId);


        String result = HttpUtils.sendGet(url);


        WVPResult wvpResult = JSON.parseObject(result, WVPResult.class);


@@ -763,7 +770,9 @@


                System.out.println("目标地址：" + rtspUrl);


                FFmpegFrameGrabber grabber = null;


                try {


                    grabber = FFmpegFrameGrabber.createDefault(rtspUrl);


                    grabber = new FFmpegFrameGrabber(rtspUrl);


//                    grabber.setOption("rtsp_transport", "tcp"); // 使用tcp的方式，不然会丢包很严重


//                    grabber.setVideoOption("probesize", "10000"); // 设置捕获分析的最大字节


                    //设置10s超时


                    grabber.setTimeout(10000);


                    grabber.start();


@@ -793,13 +802,11 @@


                        } catch (FrameGrabber.Exception e) {


                            e.printStackTrace();


                        }


                        // 通常不需要调用release()，因为stop()会处理资源释放


                        // grabber.release(); // 释放资源


                    }


                }


            }


        } else {


            System.out.println("请求失败，错误码：" + wvpResult.getCode());


            System.out.println("请求失败，错误码：" + wvpResult.getCode() + "--" + wvpResult.getMsg());


        }


        System.out.println("图片URL：" + imgUrl);


        return imgUrl;


@@ -942,4 +949,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;


    }


}