From c8df02a7b07086e17bacda6cdc015d76ac1f82fe Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期三, 04 九月 2024 17:16:58 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- ycl-server/src/main/java/com/ycl/platform/service/impl/WorkOrderServiceImpl.java | 452 ++++++++++++++++++++++++++++++++++++++++++++++++------- 1 files changed, 391 insertions(+), 61 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 60d3cb8..4c26051 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,52 +1,69 @@ package com.ycl.platform.service.impl; +import com.alibaba.fastjson2.JSON; +import com.alibaba.fastjson2.JSONObject; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; 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.ycl.config.PlatformConfig; +import com.ycl.config.ServerConfig; import com.ycl.exception.ServiceException; import com.ycl.platform.domain.entity.*; import com.ycl.platform.domain.form.*; -import com.ycl.platform.domain.query.DistributeWorkOrderQuery; -import com.ycl.platform.domain.query.HomeQuery; -import com.ycl.platform.domain.query.ScreenQuery; -import com.ycl.platform.domain.query.WorkOrderQuery; -import com.ycl.platform.domain.vo.DistributeWorkOrderVO; -import com.ycl.platform.domain.vo.WorkOrderVO; -import com.ycl.platform.domain.vo.WorkOrderYwConditionRecordVO; +import com.ycl.platform.domain.query.*; +import com.ycl.platform.domain.vo.*; import com.ycl.platform.domain.vo.screen.ScreenWorkOrderVO; -import com.ycl.platform.mapper.WorkOrderAuditingRecordMapper; -import com.ycl.platform.mapper.WorkOrderDistributeRecordMapper; -import com.ycl.platform.mapper.WorkOrderMapper; -import com.ycl.platform.mapper.WorkOrderYwConditionRecordMapper; +import com.ycl.platform.domain.vo.screen.WorkOrderRegionVO; +import com.ycl.platform.domain.vo.screen.WorkOrderTotalVO; +import com.ycl.platform.mapper.*; import com.ycl.platform.service.NotifyService; import com.ycl.platform.service.WorkOrderAuditingRecordService; import com.ycl.platform.service.WorkOrderService; import com.ycl.platform.service.YwPointService; +import com.ycl.platform.wvp.StreamContent; +import com.ycl.platform.wvp.WVPResult; import com.ycl.system.Result; +import com.ycl.system.domain.SysConfig; +import com.ycl.system.mapper.SysConfigMapper; +import com.ycl.system.mapper.SysDictDataMapper; import com.ycl.system.model.LoginUser; import com.ycl.system.page.PageUtil; import com.ycl.utils.DateUtils; import com.ycl.utils.SecurityUtils; +import com.ycl.utils.http.HttpUtils; import com.ycl.utils.redis.RedisCache; import com.ycl.utils.uuid.IdUtils; +import constant.Constants; import enumeration.general.NotifyTypeEnum; import enumeration.general.UrgentLevelEnum; import enumeration.general.WorkOrderDistributeWayEnum; import enumeration.general.WorkOrderStatusEnum; import lombok.RequiredArgsConstructor; +import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.ObjectUtils; +import org.bytedeco.javacv.*; +import org.bytedeco.opencv.global.opencv_imgcodecs; +import org.bytedeco.opencv.opencv_core.Mat; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.Assert; +import org.springframework.util.CollectionUtils; import org.springframework.util.StringUtils; +import javax.imageio.ImageIO; +import javax.swing.*; +import java.awt.image.BufferedImage; +import java.io.File; +import java.io.IOException; import java.time.LocalDateTime; import java.time.ZoneId; import java.util.*; +import java.util.concurrent.TimeUnit; import java.util.stream.Collectors; /** @@ -55,6 +72,7 @@ * @author xp * @since 2024-03-05 */ +@Slf4j @Service @RequiredArgsConstructor public class WorkOrderServiceImpl extends ServiceImpl<WorkOrderMapper, WorkOrder> implements WorkOrderService { @@ -66,12 +84,181 @@ private final WorkOrderYwConditionRecordMapper workOrderYwConditionRecordMapper; private final NotifyService notifyService; private final WorkOrderDistributeRecordMapper workOrderDistributeRecordMapper; + private final WorkOrderErrorTypeServiceImpl workOrderErrorTypeService; + private final SysConfigMapper configMapper; + private final ServerConfig serverConfig; + private final ReportMapper reportMapper; + private final SysDictDataMapper dictDataMapper; + + @Value("${rtsp.server:http://127.0.0.1:7788}") + private String rtspServer; private final String DISTRIBUTE_LOCK_KEY = "distributeLock"; private final static String IMPORTANT = "important"; @Autowired private RedisCache redisCache; + + @Override + @Transactional(rollbackFor = Exception.class) + public Boolean innerAddWorkOrder(List<WorkOrder> workOrderList) { + int total = workOrderList.size(); + workOrderList.stream().filter(item -> { + return StringUtils.hasText(item.getSerialNumber()) && Objects.nonNull(item.getStatus()) && !CollectionUtils.isEmpty(item.getErrorTypeList()); + }); + if (CollectionUtils.isEmpty(workOrderList)) { + return Boolean.TRUE; + } + // 鏍规嵁鍥芥爣鐮佸幓閲� + workOrderList = workOrderList.stream() + .collect(Collectors.toMap( + WorkOrder::getSerialNumber, + p -> p, + (existing, replacement) -> existing // 鍐茬獊鏃朵繚鐣欑涓�涓� + )).values().stream().collect(Collectors.toList()); + List<String> serialNumberList = workOrderList.stream().map(WorkOrder::getSerialNumber).collect(Collectors.toList()); + // 鏌ュ嚭鏁版嵁搴撲腑鍥芥爣鐮佸搴旂殑鏈畬鎴愮殑宸ュ崟 + List<WorkOrder> inDatabaseWorkOrderList = baseMapper.getNotFinishedWorkOrders(serialNumberList); + inDatabaseWorkOrderList.stream().forEach(item -> { + if (StringUtils.hasText(item.getErrorType())) { + item.setErrorTypeList(List.of(item.getErrorType().split(","))); + } else { + item.setErrorTypeList(new ArrayList<>(1)); + } + }); + Map<String, WorkOrder> mapping = inDatabaseWorkOrderList.stream().collect((Collectors.toMap(WorkOrder::getSerialNumber, workOrder -> workOrder))); + List<WorkOrder> waitAddList = new ArrayList<>(48); + List<WorkOrderErrorType> waitAddErrorTypeList = new ArrayList<>(48); + Integer updateNum = 0; + Date now = new Date(); + // 鍥犳晠闅滅被鍨嬩笉涓�鑷磋�岃鏇存柊鐘舵�佺殑宸ュ崟 + List<WorkOrder> willUpdateStatusWorkOrderList = new ArrayList<>(48); + // 鏇存敼宸ュ崟绫诲瀷鑰岃澧炲姞鐨勭郴缁熻繍缁村鐞嗕俊鎭� + List<WorkOrderYwConditionRecord> willAddMsg = new ArrayList<>(48); + // 鍗冲皢瑕佹坊鍔犵殑閿欒绫诲瀷 + List<WorkOrderErrorType> willAddErrorType = new ArrayList<>(96); + for (WorkOrder workOrder : workOrderList) { + WorkOrder databaseWorkOrder = mapping.get(workOrder.getSerialNumber()); + if (Objects.nonNull(databaseWorkOrder)) { + List<String> errorNameList = databaseWorkOrder.getErrorTypeList(); + List<String> errorTypes = workOrder.getErrorTypeList(); + if (errorNameList.containsAll(errorTypes)) { + // 濡傛灉锛屽浗鏍囩爜銆佹晠闅滅被鍨嬮兘涓�鏍凤紝鍒欒烦杩囦笉澶勭悊 + continue; + } else { + for (String errorType : errorTypes) { + if (! errorNameList.contains(errorType)) { + // 閿欒绫诲瀷涓嶄竴鏍凤紝灏辨柊澧炰竴涓敊璇被鍨嬶紝骞朵笖閲嶇疆宸ュ崟鐘舵�佷负寰呭鐞� + WorkOrderErrorType workOrderErrorType = new WorkOrderErrorType(); + workOrderErrorType.setWorkOrderNo(databaseWorkOrder.getWorkOrderNo()); + workOrderErrorType.setCreateTime(now); + workOrderErrorType.setUpdateTime(now); + workOrderErrorType.setErrorName(errorType); + willAddErrorType.add(workOrderErrorType); + } + } + databaseWorkOrder.setStatus(WorkOrderStatusEnum.DISTRIBUTED); + databaseWorkOrder.setUpdateTime(now); + willUpdateStatusWorkOrderList.add(databaseWorkOrder); + updateNum++; + // 鍚屾椂鏂板涓�涓繍缁村鐞嗕俊鎭紝琛ㄦ槑姝ゅ伐鍗曡璋冩暣 + WorkOrderYwConditionRecord ywRecord = new WorkOrderYwConditionRecord(); + ywRecord.setWorkOrderNo(databaseWorkOrder.getWorkOrderNo()); + ywRecord.setCommitUser(1); + ywRecord.setYwCondition("鏁呴殰绫诲瀷鏇存柊锛屽伐鍗曠姸鎬佽皟鏁翠负寰呭鐞�"); + ywRecord.setCreateTime(new Date()); + ywRecord.setSysMsg(Boolean.TRUE); + willAddMsg.add(ywRecord); + } + } else { + workOrder.setCreateTime(new Date()); + workOrder.setUpdateTime(new Date()); +// // 濡傛灉鎶ュ杩囷紝浣跨敤鏈�鏂版姤澶囩殑閿欒绫诲瀷 +// Report report = reportMapper.checkPointReported(workOrder.getSerialNumber()); +// if (Objects.nonNull(report)) { +// workOrder.setErrorType(report.getErrorType()); +// } + waitAddList.add(workOrder); + } + } + if (willAddErrorType.size() > 0) { + workOrderErrorTypeService.getBaseMapper().addMany(willAddErrorType); + } + if (willAddMsg.size() > 0) { + workOrderYwConditionRecordMapper.insertMany(willAddMsg); + } + log.info("灏嗚鏇存柊鐨勫伐鍗曟暟锛�" + willUpdateStatusWorkOrderList.size()); + if (willUpdateStatusWorkOrderList.size() > 0) { + this.baseMapper.updateMany(willUpdateStatusWorkOrderList); + } + if (CollectionUtils.isEmpty(waitAddList)) { + return Boolean.TRUE; + } + List<String> willAddSerialNumber = waitAddList.stream().map(WorkOrder::getSerialNumber).collect(Collectors.toList()); + List<YwPoint> pointList = new LambdaQueryChainWrapper<>(ywPointService.getBaseMapper()) + .select(YwPoint::getUnitId, YwPoint::getSerialNumber, YwPoint::getImportantTag, YwPoint::getImportantTag, YwPoint::getProvinceTag, YwPoint::getImportantCommandImageTag) + .in(YwPoint::getSerialNumber, willAddSerialNumber) + .list(); + Map<String, YwPoint> pointMapping = pointList.stream().collect(Collectors.toMap(YwPoint::getSerialNumber, point -> point)); + // 鏌ュ嚭閲嶇偣鐐逛綅銆佹櫘閫氱偣浣嶇殑澶勭悊鏃堕棿 + SysConfig important = configMapper.checkConfigKeyUnique("important.wordkorder.time"); + SysConfig normal = configMapper.checkConfigKeyUnique("normal.wordkorder.alarm.time"); + // 濡傛灉鍗冲皢鐢熸垚宸ュ崟锛屼絾鏄澶囧浗鏍囩爜鏌ヤ笉鍒扮偣浣嶏紝鍒欎笉娣诲姞锛� + List<WorkOrder> notAddList = new ArrayList<>(); + for (WorkOrder workOrder : waitAddList) { + YwPoint point = pointMapping.get(workOrder.getSerialNumber()); + if (Objects.isNull(point)) { + notAddList.add(workOrder); + continue; + } + workOrder.setWorkOrderNo(IdUtils.randomNO(now)); + if (Objects.nonNull(point.getUnitId())) { + workOrder.setUnitId(Math.toIntExact(point.getUnitId())); + } + if (point.getImportantTag() || point.getImportantCommandImageTag()) { + workOrder.setProcessingPeriod(Integer.valueOf(important.getConfigValue())); + } else { + workOrder.setProcessingPeriod(Integer.valueOf(normal.getConfigValue())); + } + // 淇濆瓨閿欒绫诲瀷 + for (String errorType : workOrder.getErrorTypeList()) { + WorkOrderErrorType workOrderErrorType = new WorkOrderErrorType(); + workOrderErrorType.setWorkOrderNo(workOrder.getWorkOrderNo()); + workOrderErrorType.setCreateTime(now); + workOrderErrorType.setUpdateTime(now); + workOrderErrorType.setErrorName(errorType); + waitAddErrorTypeList.add(workOrderErrorType); + } + } + waitAddList.removeAll(notAddList); + if (CollectionUtils.isEmpty(waitAddList)) { + return Boolean.TRUE; + } + // 淇濆瓨宸ュ崟鍜屾晠闅滅被鍨� + baseMapper.addMany(waitAddList); + if (! CollectionUtils.isEmpty(waitAddErrorTypeList)) { + workOrderErrorTypeService.getBaseMapper().addMany(waitAddErrorTypeList); + } + // 濡傛灉鏄洿鎺ヤ笅鍙戯紝娣诲姞涓嬪彂璁板綍 + if (WorkOrderStatusEnum.DISTRIBUTED.equals(waitAddList.get(0).getStatus())) { + ArrayList<String> list = new ArrayList<>(); + List<WorkOrderDistributeRecord> distributedRecordList = waitAddList.stream().map(item -> { + list.add(item.getSerialNumber()); + WorkOrderDistributeRecord workOrderDistributeRecord = new WorkOrderDistributeRecord(); + workOrderDistributeRecord.setWorkOrderNo(item.getWorkOrderNo()); + workOrderDistributeRecord.setDistributeWay(WorkOrderDistributeWayEnum.DIRECT_DISTRIBUTE); + workOrderDistributeRecord.setUserId(1L); + workOrderDistributeRecord.setCreateTime(now); + workOrderDistributeRecord.setUpdateTime(now); + return workOrderDistributeRecord; + }).collect(Collectors.toList()); + workOrderDistributeRecordMapper.insertBatch(distributedRecordList); + // 鍚屾鐐逛綅鐘舵�� + ywPointService.updateRecovery(list, 1); + } + log.info("浼犲叆宸ュ崟鎬绘暟: {}锛屽疄闄呮坊鍔犲伐鍗曟暟锛歿}, 瀹為檯淇敼宸ュ崟鏁帮細{}", total, waitAddList.size(), updateNum); + return Boolean.TRUE; + } /** * 娣诲姞 @@ -81,9 +268,15 @@ @Override public Result add(WorkOrderForm form) { WorkOrder entity = WorkOrderForm.getEntityByForm(form, null); - entity.setWorkOrderNo(IdUtils.timeAddRandomNO(5)); entity.setCreateTime(DateUtils.getNowDate()); entity.setStatus(WorkOrderStatusEnum.WAIT_DISTRIBUTE); + Date now = new Date(); + entity.setCreateTime(now); + entity.setUpdateTime(now); + entity.setWorkOrderNo(IdUtils.randomNO(now)); + entity.setErrorType(String.join(",", form.getErrorType())); + List<WorkOrderErrorType> workOrderErrorTypes = form.getErrorType().stream().map(errorType -> new WorkOrderErrorType(entity.getWorkOrderNo(), errorType)).toList(); + workOrderErrorTypeService.getBaseMapper().insertWorkOrderErrorTypeList(workOrderErrorTypes); if(baseMapper.insert(entity) > 0) { return Result.ok("娣诲姞鎴愬姛"); } @@ -99,10 +292,11 @@ public Result update(WorkOrderForm form) { WorkOrder entity = baseMapper.selectById(form.getId()); - // 涓虹┖鎶汭llegalArgumentException锛屽仛鍏ㄥ眬寮傚父澶勭悊 Assert.notNull(entity, "璁板綍涓嶅瓨鍦�"); BeanUtils.copyProperties(form, entity); + Date now = new Date(); + entity.setUpdateTime(now); if (baseMapper.updateById(entity) > 0) { return Result.ok("淇敼鎴愬姛"); } @@ -118,7 +312,7 @@ baseMapper.updateById(workOrder); // 娣诲姞涓�鏉″鏍歌褰� WorkOrderAuditingRecord workOrderAuditingRecord = new WorkOrderAuditingRecord(); - workOrderAuditingRecord.setWorkOrderId(workOrder.getId()); + workOrderAuditingRecord.setWorkOrderNo(workOrder.getWorkOrderNo()); workOrderAuditingRecord.setAuditingUser(SecurityUtils.getLoginUser().getUserId().intValue()); workOrderAuditingRecord.setResult(form.getAuditingResult().getDesc()); workOrderAuditingRecord.setRemark(form.getAuditingRemark()); @@ -132,7 +326,7 @@ notifyService.save(notify); // 鍚屾鐐逛綅鐘舵�� if (form.getAuditingResult() == WorkOrderStatusEnum.AUDITING_SUCCESS) { - ywPointService.updateRecovery(Collections.singletonList(workOrder.getPointId()), 0); + ywPointService.updateRecovery(Collections.singletonList(workOrder.getSerialNumber()), 0); } return Result.ok("鎿嶄綔鎴愬姛"); } @@ -144,22 +338,23 @@ List<WorkOrder> list = new LambdaQueryChainWrapper<>(baseMapper) .in(WorkOrder::getStatus, WorkOrderStatusEnum.YW_HANDLE.getValue()) .in(WorkOrder::getErrorType, form.getErrorTypes()) - .select(WorkOrder::getId, WorkOrder::getUnitId, WorkOrder::getWorkOrderNo) + .select(WorkOrder::getId, WorkOrder::getUnitId, WorkOrder::getWorkOrderNo, WorkOrder::getSerialNumber) .list(); if (list.isEmpty()) { return Result.error("娌℃湁宸ュ崟鍙互瀹℃牳"); } - List<Integer> ids = list.stream().map(WorkOrder::getId).collect(Collectors.toList()); + List<String> workOrderNoList = list.stream().map(WorkOrder::getWorkOrderNo).collect(Collectors.toList()); + List<String> serialNumbers = list.stream().map(WorkOrder::getSerialNumber).toList(); // 宸ュ崟鐘舵�� LambdaUpdateWrapper<WorkOrder> lambdaUpdateWrapper = new LambdaUpdateWrapper<>(); - lambdaUpdateWrapper.in(WorkOrder::getId, ids); + lambdaUpdateWrapper.in(WorkOrder::getWorkOrderNo, workOrderNoList); lambdaUpdateWrapper.set(WorkOrder::getStatus, form.getAuditingResult()); baseMapper.update(lambdaUpdateWrapper); // 娣诲姞澶氭潯瀹℃牳璁板綍 List<WorkOrderAuditingRecord> workOrderAuditingRecords = new ArrayList<>(); - for (Integer id : ids) { + for (String workOrderNo : workOrderNoList) { WorkOrderAuditingRecord workOrderAuditingRecord = new WorkOrderAuditingRecord(); - workOrderAuditingRecord.setWorkOrderId(id); + workOrderAuditingRecord.setWorkOrderNo(workOrderNo); workOrderAuditingRecord.setAuditingUser(SecurityUtils.getLoginUser().getUserId().intValue()); workOrderAuditingRecord.setResult(form.getAuditingResult().getDesc()); workOrderAuditingRecord.setRemark(form.getAuditingRemark()); @@ -175,6 +370,10 @@ UrgentLevelEnum.WARNING, workOrder.getWorkOrderNo()); notifies.add(notify); + } + // 鍚屾鐐逛綅鐘舵�� + if (form.getAuditingResult() == WorkOrderStatusEnum.AUDITING_SUCCESS) { + ywPointService.updateRecovery(serialNumbers, 0); } notifyService.saveBatch(notifies); return Result.ok("鎿嶄綔鎴愬姛"); @@ -193,27 +392,32 @@ baseMapper.updateById(workOrder); // 娣诲姞涓�鏉¤繍缁存儏鍐佃褰� WorkOrderYwConditionRecord workOrderYwConditionRecord = new WorkOrderYwConditionRecord(); - workOrderYwConditionRecord.setWorkOrderId(workOrder.getId()); + workOrderYwConditionRecord.setWorkOrderNo(workOrder.getWorkOrderNo()); workOrderYwConditionRecord.setCommitUser(SecurityUtils.getLoginUser().getUserId().intValue()); workOrderYwConditionRecord.setYwCondition(form.getYwCondition()); workOrderYwConditionRecord.setYwProofMaterials(form.getYwProofMaterials()); + workOrderYwConditionRecord.setSysMsg(Boolean.FALSE); workOrderYwConditionRecordMapper.insert(workOrderYwConditionRecord); return Result.ok("鎿嶄綔鎴愬姛"); } @Override - public Result selectYwConditionByYwId(Integer id) { - List<WorkOrderYwConditionRecordVO> ywConditionList = workOrderYwConditionRecordMapper.selectYwConditionByYwId(id); - return Result.ok().data(ywConditionList); + public List<WorkOrderYwConditionRecordVO> selectYwConditionByYwId(String workOrderNo) { + List<WorkOrderYwConditionRecordVO> ywConditionList = workOrderYwConditionRecordMapper.selectYwConditionByYwId(workOrderNo); + ywConditionList.stream().forEach(item -> { + if (Objects.nonNull(item.getSysMsg()) && item.getSysMsg()) { + item.setCommitUserName("绯荤粺娑堟伅"); + } + }); + return ywConditionList; } @Override - public Result selectYwAuditingListByYwId(String id) { - return Result.ok().data( - new LambdaQueryChainWrapper<>(workOrderAuditingRecordMapper) - .eq(WorkOrderAuditingRecord::getWorkOrderId, id) + public List<WorkOrderAuditingRecord> selectYwAuditingListByYwId(String workOrderNo) { + return new LambdaQueryChainWrapper<>(workOrderAuditingRecordMapper) + .eq(WorkOrderAuditingRecord::getWorkOrderNo, workOrderNo) .orderByAsc(WorkOrderAuditingRecord::getCreateTime) - .list()); + .list(); } @Override @@ -260,7 +464,18 @@ @Override public Result page(WorkOrderQuery query) { IPage<WorkOrderVO> page = PageUtil.getPage(query, WorkOrderVO.class); + query.setUnitId(SecurityUtils.getUnitId()); baseMapper.page(page, query); + if (! CollectionUtils.isEmpty(page.getRecords())) { + page.getRecords().stream().forEach(item -> { + if (StringUtils.hasText(item.getErrorType())) { + item.setErrorTypeList(List.of(item.getErrorType().split(","))); + } + if (StringUtils.hasText(item.getImgListStr())) { + item.setImgList(List.of(item.getImgListStr().split(","))); + } + }); + } return Result.ok().data(page.getRecords()).total(page.getTotal()); } @@ -268,11 +483,6 @@ public Result distributePage(DistributeWorkOrderQuery query) { IPage<WorkOrderVO> page = PageUtil.getPage(query, WorkOrderVO.class); baseMapper.distributePage(page, query); - page.getRecords().stream().forEach(workOrder -> { - if (StringUtils.hasText(workOrder.getPointTag()) && workOrder.getPointTag().contains(IMPORTANT)) { - workOrder.setImportant(Boolean.TRUE); - } - }); return Result.ok().data(page).total(page.getTotal()); } @@ -283,9 +493,6 @@ LocalDateTime now = LocalDateTime.now(ZoneId.systemDefault()); data.setEnd(now); switch (data.getFastWay()) { - case LAST_HALF_HOUR: - data.setStart(now.minusMinutes(30)); - break; case LAST_HOUR: data.setStart(now.minusHours(1)); break; @@ -295,11 +502,15 @@ case LAST_DAY: data.setStart(now.minusDays(1)); break; + default: + break; } - + if (Objects.isNull(data.getStart())) { + throw new RuntimeException("鏃犳硶鐢熸垚蹇�熶笅鍙戠殑鏃堕棿鑼冨洿锛岃閫夋嫨姝g‘鐨勫揩閫熶笅鍙戞柟寮�"); + } // 鏌ヨ绗﹀悎鏉′欢鐨勫伐鍗� List<WorkOrder> list = new LambdaQueryChainWrapper<>(baseMapper) - .select(WorkOrder::getId, WorkOrder::getPointId) + .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()) @@ -307,20 +518,20 @@ .orderByDesc(WorkOrder::getCreateTime) .last("limit " + data.getFastNumLimit()) .list(); - List<Integer> ids = list.stream().map(WorkOrder::getId).toList(); - List<Integer> pointIds = list.stream().map(WorkOrder::getPointId).toList(); + List<String> workOrderNoList = list.stream().map(WorkOrder::getWorkOrderNo).toList(); + List<String> serialNumberList = list.stream().map(WorkOrder::getSerialNumber).toList(); - if (ids.isEmpty()) { return Result.error("娌℃湁绗﹀悎鏉′欢鐨勫伐鍗�"); } + if (workOrderNoList.isEmpty()) { return Result.error("娌℃湁绗﹀悎鏉′欢鐨勫伐鍗�"); } if (!getDistributeLock()) { return Result.error("姝ゅ埢鏈変汉涓嬪彂涓紝涓洪伩鍏嶅啿绐侊紝璇风◢鍚庨噸璇�"); } try { new LambdaUpdateChainWrapper<>(baseMapper) .set(WorkOrder::getStatus, WorkOrderStatusEnum.DISTRIBUTED) - .in(WorkOrder::getId, ids) + .in(WorkOrder::getWorkOrderNo, workOrderNoList) .update(); - addDistributeRecord(ids, WorkOrderDistributeWayEnum.FAST_DISTRIBUTE); + addDistributeRecord(workOrderNoList, WorkOrderDistributeWayEnum.FAST_DISTRIBUTE); // 鍚屾鐐逛綅鐘舵�� - ywPointService.updateRecovery(pointIds, 1); - return Result.ok("鎴愬姛涓嬪彂" + ids.size() + "鏉″伐鍗�"); + ywPointService.updateRecovery(serialNumberList, 1); + return Result.ok("鎴愬姛涓嬪彂" + workOrderNoList.size() + "鏉″伐鍗�"); } catch (Exception e) { return Result.error("鎿嶄綔澶辫触"); } finally { @@ -334,27 +545,27 @@ WorkOrderDistributeWayEnum distributeWayEnum = WorkOrderDistributeWayEnum.SELECTED_DISTRIBUTE; if (!getDistributeLock()) { return Result.error("姝ゅ埢鏈変汉涓嬪彂涓紝涓洪伩鍏嶅啿绐侊紝璇风◢鍚庨噸璇�"); } try { - if (query.getIds().isEmpty()) { - query.setIds(new LambdaQueryChainWrapper<>(baseMapper) + if (query.getWorkOrderNOList().isEmpty()) { + query.setWorkOrderNOList(new LambdaQueryChainWrapper<>(baseMapper) .eq(WorkOrder::getStatus, WorkOrderStatusEnum.WAIT_DISTRIBUTE) .eq(Objects.nonNull(query.getUnitId()), WorkOrder::getUnitId, query.getUnitId()) - .select(WorkOrder::getId) + .select(WorkOrder::getWorkOrderNo) .list() .stream() - .map(WorkOrder::getId) + .map(WorkOrder::getWorkOrderNo) .collect(Collectors.toList())); distributeWayEnum = WorkOrderDistributeWayEnum.ALL_DISTRIBUTE; } - if (query.getIds().isEmpty()) { return Result.error("娌℃湁宸ュ崟寰呬笅鍙�"); } + if (query.getWorkOrderNOList().isEmpty()) { return Result.error("娌℃湁宸ュ崟寰呬笅鍙�"); } new LambdaUpdateChainWrapper<>(baseMapper) .set(WorkOrder::getStatus, WorkOrderStatusEnum.DISTRIBUTED) - .in(WorkOrder::getId, query.getIds()) + .in(WorkOrder::getWorkOrderNo, query.getWorkOrderNOList()) .update(); - addDistributeRecord(query.getIds(), distributeWayEnum); + addDistributeRecord(query.getWorkOrderNOList(), distributeWayEnum); // 鍚屾鐐逛綅鐘舵�� - List<Integer> pointIds = new LambdaQueryChainWrapper<>(baseMapper).select(WorkOrder::getPointId).in(WorkOrder::getId, query.getIds()).list().stream().map(WorkOrder::getPointId).toList(); - ywPointService.updateRecovery(pointIds, 1); - return Result.ok("鎴愬姛涓嬪彂" + query.getIds().size() + "鏉″伐鍗�"); + List<String> serialNumberList = new LambdaQueryChainWrapper<>(baseMapper).select(WorkOrder::getSerialNumber).in(WorkOrder::getWorkOrderNo, query.getWorkOrderNOList()).list().stream().map(WorkOrder::getSerialNumber).toList(); + ywPointService.updateRecovery(serialNumberList, 1); + return Result.ok("鎴愬姛涓嬪彂" + query.getWorkOrderNOList().size() + "鏉″伐鍗�"); } catch (Exception e) { return Result.error("鎿嶄綔澶辫触"); } finally { @@ -368,7 +579,7 @@ */ public synchronized Boolean getDistributeLock() { if (Objects.isNull(redisCache.getCacheObject(DISTRIBUTE_LOCK_KEY))) { - redisCache.setCacheObject(DISTRIBUTE_LOCK_KEY, "1"); + redisCache.setCacheObject(DISTRIBUTE_LOCK_KEY, "1", 30, TimeUnit.SECONDS); return true; } else { return false; @@ -384,13 +595,13 @@ /** * 娣诲姞宸ュ崟涓嬪彂璁板綍 - * @param ids 宸ュ崟id + * @param workOrderNoList 宸ュ崟id */ - private void addDistributeRecord(List<Integer> ids, WorkOrderDistributeWayEnum distributeWay) { + private void addDistributeRecord(List<String> workOrderNoList, WorkOrderDistributeWayEnum distributeWay) { LoginUser loginUser = SecurityUtils.getLoginUser(); workOrderDistributeRecordMapper.insertBatch( - ids.stream() - .map(id -> new WorkOrderDistributeRecord(id, loginUser.getUserId(), distributeWay)) + workOrderNoList.stream() + .map(no -> new WorkOrderDistributeRecord(no, loginUser.getUserId(), distributeWay)) .toList() ); } @@ -452,4 +663,123 @@ dataMap.put("pending", data3); return dataMap; } + + @Override + public WorkOrderTotalVO workOrderTotal(DashboardQuery dashboardQuery) { + return baseMapper.workOrderTotal(dashboardQuery); + } + + @Override + public List<WorkOrderRegionVO> workOrderRegion(DashboardQuery dashboardQuery) { + return baseMapper.workOrderRegion(dashboardQuery); + } + + + @Override + public 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); + String imgUrl = null; + if (wvpResult.getCode() == 0) { + JSONObject data = (JSONObject) wvpResult.getData(); + String rtspUrl = data.getString("fmp4"); // 鍙杕p4鍦板潃 + if (StringUtils.hasText(rtspUrl)) { + System.out.println("鐩爣鍦板潃锛�" + rtspUrl); + FFmpegFrameGrabber grabber = null; + try { + grabber = FFmpegFrameGrabber.createDefault(rtspUrl); + grabber.start(); + Frame frame = grabber.grabImage(); // 鐩存帴鎹曡幏涓�甯� + if (frame != null) { + System.out.println("鎴愬姛鎹曡幏涓�甯�"); + // 灏咶rame杞崲涓篗at + OpenCVFrameConverter.ToMat converter = new OpenCVFrameConverter.ToMat(); + Mat mat = converter.convertToMat(frame); + + imgUrl = workOrderNo + "_" + IdUtils.fastSimpleUUID() + ".png"; + // 鐢熸垚鍥剧墖璺緞 + String imgPath = PlatformConfig.getProfile() + "/" + imgUrl; + System.out.println("鍥剧墖淇濆瓨鍦板潃锛�" + imgPath); + imgUrl = Constants.RESOURCE_PREFIX + "/" + imgUrl; + // 淇濆瓨鍥剧墖 + opencv_imgcodecs.imwrite(imgPath, mat); + } else { + System.out.println("鏈崟鑾峰埌甯�"); + } + } catch (FrameGrabber.Exception e) { + e.printStackTrace(); + } finally { + if (grabber != null) { + try { + grabber.stop(); // 鍋滄鎹曡幏 + } catch (FrameGrabber.Exception e) { + e.printStackTrace(); + } + // 閫氬父涓嶉渶瑕佽皟鐢╮elease()锛屽洜涓簊top()浼氬鐞嗚祫婧愰噴鏀� + // grabber.release(); // 閲婃斁璧勬簮 + } + } + } + } else { + System.out.println("璇锋眰澶辫触锛岄敊璇爜锛�" + wvpResult.getCode()); + } + System.out.println("鍥剧墖URL锛�" + imgUrl); + return imgUrl; + } + + @Override + public List<DeviceInfoVO> hasErrorWorkOrderList(Date start, Date end) { + List<DeviceInfoVO> list = baseMapper.hasErrorWorkOrderList(start, end); + return list; + } + + @Override + public void updateImgById(Integer workOrderId, String imgPath) { + new LambdaUpdateChainWrapper<>(baseMapper) + .eq(WorkOrder::getId, workOrderId) + .set(WorkOrder::getYwCheckResult, imgPath) + .update(); + } + + @Override + public Result processImg(String workOrderNo) { + WorkOrder workOrder = new LambdaQueryChainWrapper<>(baseMapper) + .eq(WorkOrder::getWorkOrderNo, workOrderNo) + .one(); + if (Objects.isNull(workOrder)) { + throw new RuntimeException("姝ゅ伐鍗曚笉瀛樺湪"); + } + // 杩愮淮璁板綍 + List<WorkOrderYwConditionRecordVO> workOrderYwConditionRecordVOS = this.selectYwConditionByYwId(workOrderNo); + // 瀹℃牳璁板綍 + List<WorkOrderAuditingRecord> workOrderAuditingRecords = this.selectYwAuditingListByYwId(workOrderNo); + WorkOrderProcessVO process = new WorkOrderProcessVO(); + process.setYwList(workOrderYwConditionRecordVOS); + process.setAuditingList(workOrderAuditingRecords); + // 鏌ヨ鐐逛綅浜嬪墠浜嬪悗鏈�鏂扮殑涓�鏉℃暟鎹槸鍚﹀鏍搁�氳繃 + ReportAuditingRecordVO beforeRecord = ywPointService.getReportResult(workOrder.getSerialNumber(), "浜嬪墠鎶ュ"); + ReportAuditingRecordVO afterRecord = ywPointService.getReportResult(workOrder.getSerialNumber(), "浜嬪悗鎶ュ"); + + Date now = new Date(); + if (Objects.nonNull(beforeRecord)) { + if (now.before(beforeRecord.getBeginCreateTime())) { + process.setBeforeReportMsg("浜嬪墠鎶ュ宸插け鏁�"); + } else if (now.after(beforeRecord.getEndCreateTime())){ + process.setBeforeReportMsg("浜嬪墠鎶ュ鏈敓鏁�"); + } else { + process.setBeforeReportMsg("宸蹭簨鍓嶆姤澶�"); + } + } + if (Objects.nonNull(afterRecord)) { + if (now.before(afterRecord.getBeginCreateTime())) { + process.setAfterReportMsg("浜嬪悗鎶ュ宸插け鏁�"); + } else if (now.after(afterRecord.getEndCreateTime())){ + process.setAfterReportMsg("浜嬪悗鎶ュ鏈敓鏁�"); + } else { + process.setAfterReportMsg("宸蹭簨鍚庢姤澶�"); + } + } + return Result.ok().data(process); + } } -- Gitblit v1.8.0