From 211ae7e060b36da7c1bc790c12ccd2159aaec011 Mon Sep 17 00:00:00 2001 From: LSH Date: 星期日, 12 十一月 2023 18:06:04 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/utils/OutLocBoxExcelListener.java | 62 +++++++++++++++++++++++++++++- 1 files changed, 59 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/zy/asrs/utils/OutLocBoxExcelListener.java b/src/main/java/com/zy/asrs/utils/OutLocBoxExcelListener.java index e0a4fd3..d037b41 100644 --- a/src/main/java/com/zy/asrs/utils/OutLocBoxExcelListener.java +++ b/src/main/java/com/zy/asrs/utils/OutLocBoxExcelListener.java @@ -2,10 +2,21 @@ import com.alibaba.excel.context.AnalysisContext; import com.alibaba.excel.event.AnalysisEventListener; +import com.baomidou.mybatisplus.mapper.EntityWrapper; +import com.core.common.BaseRes; import com.core.common.Cools; +import com.core.common.R; import com.core.common.SpringUtils; import com.core.exception.CoolException; +import com.zy.asrs.entity.LocDetl; +import com.zy.asrs.entity.OrderDetl; +import com.zy.asrs.entity.param.StockOutParam; +import com.zy.asrs.service.LocDetlService; +import com.zy.asrs.service.OrderDetlService; +import com.zy.asrs.service.TagService; +import com.zy.asrs.service.WorkService; import com.zy.common.entity.OutLocBoxExcel; +import com.zy.common.model.LocDto; import lombok.extern.slf4j.Slf4j; import java.util.ArrayList; @@ -21,7 +32,7 @@ private int total = 0; private Long userId; - List<String> batchs = new ArrayList<>(); + List<String[]> OutLocBoxCs = new ArrayList<>(); public OutLocBoxExcelListener() { } @@ -50,7 +61,11 @@ @Override public void invoke(OutLocBoxExcel excel, AnalysisContext ctx) { String batch = excel.getBatch(); - batchs.add(batch); + String orderNo = excel.getOrderNo(); + String[] s=new String[2]; + s[0] = batch; + s[1] = orderNo; + OutLocBoxCs.add(s); total++; } @@ -60,7 +75,48 @@ */ @Override public void doAfterAllAnalysed(AnalysisContext ctx) { - log.info("鐢熸垚{}鏉″嚭搴撲换鍔★紒", total); + if (!Cools.isEmpty(OutLocBoxCs) && OutLocBoxCs.size() != 0) { + LocDetlService locDetlService = SpringUtils.getBean(LocDetlService.class); + WorkService workService = SpringUtils.getBean(WorkService.class); + List<LocDto> locDtos = new ArrayList<>(); + for (String[] outLocBoxC:OutLocBoxCs){ + LocDetl locDetl = locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("batch", outLocBoxC[0])); + if (Cools.isEmpty(locDetl)){ + total--; + continue; + } + LocDto locDto = new LocDto(locDetl.getManu(), locDetl.getMatnr(), locDetl.getMaktx(),locDetl.getModel(),locDetl.getSpecs(), + locDetl.getBatch(),locDetl.getBrand(),locDetl.getBarcode(), outLocBoxC[1],locDetl.getAnfme()); + locDtos.add(locDto); + } + + StockOutParam param = new StockOutParam(); + ArrayList<StockOutParam.LocDetl> locDetls = new ArrayList<>(); + for (LocDto locDto:locDtos){ + StockOutParam.LocDetl locDetl = new StockOutParam.LocDetl(); + locDetl.setBrand(locDto.getBrand()); + locDetl.setLocNo(locDto.getLocNo()); + locDetl.setAnfme(locDto.getAnfme()); + locDetl.setMatnr(locDto.getMatnr()); + locDetl.setBatch(locDto.getBatch()); + locDetl.setModel(locDto.getModel()); + locDetl.setSpecs(locDto.getSpecs()); + locDetl.setZpallet(locDto.getZpallet()); + + param.setOrderNo(locDto.getOrderNo()); + + locDetls.add(locDetl); + } + param.setLocDetls(locDetls); + + if (total>0){ + workService.startupFullTakeStoreOrder(param,9999L); + } + + } + + + log.info("瀵煎叆{}鏉$鍙凤紒", total); } public int getTotal() { -- Gitblit v1.9.1