From be61c90200910a3e48c72596f3bbd459a2a73f25 Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期日, 25 五月 2025 13:47:13 +0800 Subject: [PATCH] 取消写入后回答延时 --- src/main/java/com/zy/asrs/controller/CrnController.java | 53 ++++++++++++++++++++++++++++++++++++++++++----------- 1 files changed, 42 insertions(+), 11 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/CrnController.java b/src/main/java/com/zy/asrs/controller/CrnController.java index 067f4a5..9d7b618 100644 --- a/src/main/java/com/zy/asrs/controller/CrnController.java +++ b/src/main/java/com/zy/asrs/controller/CrnController.java @@ -1,5 +1,6 @@ package com.zy.asrs.controller; +import com.alibaba.excel.EasyExcel; import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.core.annotations.ManagerAuth; @@ -13,11 +14,12 @@ import com.zy.asrs.domain.vo.CrnListVo; import com.zy.asrs.domain.vo.CrnMsgTableVo; import com.zy.asrs.domain.vo.CrnStateTableVo; -import com.zy.asrs.entity.BasCrnError; -import com.zy.asrs.entity.BasCrnp; -import com.zy.asrs.entity.LocMast; -import com.zy.asrs.entity.WrkMast; +import com.zy.asrs.entity.*; +import com.zy.asrs.importexcle.ImportCrnErrDto; +import com.zy.asrs.importexcle.ImportCrnErrListener; import com.zy.asrs.mapper.BasCrnErrorMapper; +import com.zy.asrs.mapper.TaskWrkMapper; +import com.zy.asrs.service.BasCrnErrorService; import com.zy.asrs.service.BasCrnpService; import com.zy.asrs.service.LocMastService; import com.zy.asrs.service.WrkMastService; @@ -37,8 +39,12 @@ import com.zy.core.properties.SystemProperties; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.transaction.annotation.Transactional; import org.springframework.web.bind.annotation.*; +import org.springframework.web.multipart.MultipartFile; +import javax.annotation.Resource; +import java.io.IOException; import java.util.ArrayList; import java.util.HashMap; import java.util.List; @@ -63,6 +69,30 @@ private BasCrnpService basCrnpService; @Autowired private LocMastService locMastService; + + @Resource + private TaskWrkMapper taskWrkMapper; + + @Resource + private BasCrnErrorService basCrnErrorService; + + @PostMapping("/importCrnErr") + @ManagerAuth(memo = "瀵煎叆鍫嗗灈鏈哄紓甯歌〃") + public R importCrnErr(@RequestParam("file") MultipartFile multipartFile) { + try { + importCrnErrExec(multipartFile); + } catch (Exception e) { + e.printStackTrace(); + return R.error(e.getMessage()); + } + return R.ok("瀵煎叆鎴愬姛"); + } + + @Transactional(rollbackFor = Exception.class) + public void importCrnErrExec(MultipartFile multipartFile) throws IOException { + EasyExcel.read(multipartFile.getInputStream(), ImportCrnErrDto.class, + new ImportCrnErrListener(basCrnErrorService)).sheet().doReadSync(); + } @ManagerAuth(memo = "杩涜涓殑鍛戒护") @@ -186,13 +216,14 @@ vo.setWorkNo(crnProtocol.getTaskNo()); // 浠诲姟鍙� if (crnProtocol.getTaskNo() > 0) { - WrkMast wrkMast = wrkMastService.selectById(crnProtocol.getTaskNo()); - if (wrkMast != null) { - vo.setStatus(CrnStatusType.process(wrkMast.getIoType()).getDesc()); // 妯″紡鐘舵�� - vo.setSourceStaNo(wrkMast.getSourceStaNo$()); // 婧愮珯 - vo.setStaNo(wrkMast.getStaNo$()); // 鐩爣绔� - vo.setSourceLocNo(wrkMast.getSourceLocNo()); // 婧愬簱浣� - vo.setLocNo(wrkMast.getLocNo()); // 鐩爣搴撲綅 +// WrkMast wrkMast = wrkMastService.selectById(crnProtocol.getTaskNo()); + TaskWrk taskWrk = taskWrkMapper.selectByWrkNo(Integer.valueOf(crnProtocol.getTaskNo())); + if (taskWrk != null) { + vo.setStatus(CrnStatusType.process(taskWrk.getIoType()).getDesc()); // 妯″紡鐘舵�� + vo.setSourceStaNo(taskWrk.getStartPoint()); // 婧愮珯 + vo.setStaNo(taskWrk.getTargetPoint()); // 鐩爣绔� + vo.setSourceLocNo(taskWrk.getStartPoint()); // 婧愬簱浣� + vo.setLocNo(taskWrk.getTargetPoint()); // 鐩爣搴撲綅 } } else { vo.setStatus(crnProtocol.modeType.equals(CrnModeType.AUTO) ? CrnStatusType.MACHINE_AUTO.getDesc() : CrnStatusType.MACHINE_UN_AUTO.getDesc()); // 妯″紡鐘舵�� -- Gitblit v1.9.1