From e235d483194ab95bf62d1cfd343a172ff12781e8 Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期六, 13 四月 2024 14:58:24 +0800 Subject: [PATCH] 聚乳酸库存明细 1.批号与包号排序需同步,增加水分,挥发段,分解段搜索,按照最大最小范围,包装类型跟托盘类型增加删选功能。 2.已经出库的物料,在明细表里面隐藏掉,但是数据保留。 3.增加二个跟聚乳酸一样的明细表,分改性树脂,纯树脂库存明细表,所有功能跟总的聚乳酸库存明细表一样 4.明细表整体框架调整一下,相对压缩一下,搜索功能框看看能否弄成二行 5.表里面的包装类型与托盘类型这些不主要的信息放到指标后面 6.关于分包再处理,举例原有系统里面销售选定的10包物料,再二次重新弄后,车间打印新标签,使用新的包号,在明细表里面体现原有所有指标信息及批号,包号,牌号跟新的关联 7.出库时候时间可选历史,不要就只能出现4天 8.提取库存里面需要有最大包号跟最小包号选择 --- src/main/java/com/zy/asrs/utils/PlaExcelListener.java | 19 +++++++++++-------- 1 files changed, 11 insertions(+), 8 deletions(-) diff --git a/src/main/java/com/zy/asrs/utils/PlaExcelListener.java b/src/main/java/com/zy/asrs/utils/PlaExcelListener.java index 4cf7385..e971964 100644 --- a/src/main/java/com/zy/asrs/utils/PlaExcelListener.java +++ b/src/main/java/com/zy/asrs/utils/PlaExcelListener.java @@ -18,10 +18,7 @@ import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; -import java.util.ArrayList; -import java.util.Date; -import java.util.List; -import java.util.Map; +import java.util.*; /** * Created by vincent on 2019-11-25 @@ -35,6 +32,7 @@ private int total = 0; private int index = 1; + private String recordLog = ""; private Long userId; public PlaExcelListener() { @@ -69,14 +67,16 @@ MatService matService = SpringUtils.getBean(MatService.class); Date now = new Date(); + + // 鍟嗗搧 if(Cools.isEmpty(excel.getBatch()) || Cools.isEmpty(excel.getPackageNo())){ - return; + throw new CoolException("绗�" + index++ + "鏁版嵁閿欒锛屽寘鍙锋垨鑰呮壒鍙蜂负绌�"); } - Pla pla = plaService.selectByBatchAndPackageNo(excel.getBatch(),excel.getPackageNo()); + Pla pla = plaService.selectByBatchAndPackageNo(excel.getBatch(),excel.getPackageNo(),excel.getBrand()); if (pla == null) { + pla = plaCreate(pla,excel,matService,nodeService); pla.setCreateTime(new Date()); - plaCreate(pla,excel,matService,nodeService); try { plaService.insert(pla); }catch (Exception e){ @@ -93,11 +93,14 @@ excel.setStatus(pla.getStatus()); excel.setPakinTime(pla.getPakinTime()); excel.setStash(pla.getStash()); - excel.setLocNo(pla.getLocNo()); + if(Cools.isEmpty(excel.getLocNo())){ + excel.setLocNo(pla.getLocNo()); + } BeanUtils.copyProperties(excel,pla); pla = plaCreate(pla,excel,matService,nodeService); try { plaService.updateById(pla); + recordLog = recordLog + index + "," + pla.getBatch() + "," + pla.getPackageNo() + ";" ; }catch (Exception e){ log.error("淇濆瓨鍟嗗搧淇℃伅澶辫触锛屾壒鍙凤細" + excel.getBatch() + ", 鍖呭彿锛�" + excel.getPackageNo() + "鍘熷洜涓猴細" + e.getMessage()); throw new CoolException("淇濆瓨鍟嗗搧淇℃伅澶辫触锛屾壒鍙凤細" + excel.getBatch() + ", 鍖呭彿锛�" + excel.getPackageNo() + "鍘熷洜涓猴細" + e.getMessage()); -- Gitblit v1.9.1