From d2b8972b4f1bb1869a377a15929bdf0413125a1d Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期三, 12 二月 2025 13:05:57 +0800
Subject: [PATCH] 导入时备注是实验料，质量状态设置为实验料，三种出库后都能补传质量指标
---
src/main/java/com/zy/asrs/service/impl/PlaServiceImpl.java | 2 +-
src/main/java/com/zy/asrs/utils/PlaExcelListener.java | 37 +++++++++++++++++++++++++++++++++++++
2 files changed, 38 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/service/impl/PlaServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/PlaServiceImpl.java
index bd496c1..413bf44 100644
--- a/src/main/java/com/zy/asrs/service/impl/PlaServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/PlaServiceImpl.java
@@ -30,7 +30,7 @@
private PlaQtyService plaQtyService;
public Pla selectByBatchAndPackageNo(String batch, Integer packageNo, String brand) {
- return this.selectOne(new EntityWrapper<Pla>().eq("batch",batch).eq("package_no",packageNo).eq("brand",brand).eq(false,"status","鍏ㄩ儴鍑哄簱"));
+ return this.selectOne(new EntityWrapper<Pla>().eq("batch",batch).eq("package_no",packageNo).eq("brand",brand));
}
@Override
diff --git a/src/main/java/com/zy/asrs/utils/PlaExcelListener.java b/src/main/java/com/zy/asrs/utils/PlaExcelListener.java
index 84b05a5..b36cf1a 100644
--- a/src/main/java/com/zy/asrs/utils/PlaExcelListener.java
+++ b/src/main/java/com/zy/asrs/utils/PlaExcelListener.java
@@ -107,6 +107,40 @@
throw new CoolException("淇濆瓨鍟嗗搧淇℃伅澶辫触锛屾壒鍙凤細" + excel.getBatch() + ", 鍖呭彿锛�" + excel.getPackageNo() + "鍘熷洜涓猴細" + e.getMessage());
}
total++;
+ } else if (Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_2) || Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_3) || Cools.eq(pla.getStatus(),GlobleParameter.PLA_STATUS_4)) {
+ // 琛ヤ紶璐ㄩ噺鎸囨爣
+ pla.setProDate(excel.getProDate());
+ pla.setWeight(excel.getWeight());
+ pla.setPackageType(excel.getPackageType());
+ pla.setZpalletType(excel.getZpalletType());
+ pla.setFingerMelting(excel.getFingerMelting());
+ pla.setWater(excel.getWater());
+ pla.setFusingPoint(excel.getFusingPoint());
+ pla.setVadf1(excel.getVadf1());
+ pla.setVadf2(excel.getVadf2());
+ pla.setYellowness(excel.getYellowness());
+ pla.setOpacity(excel.getOpacity());
+ pla.setL(excel.getL());
+ pla.setA(excel.getA());
+ pla.setB(excel.getB());
+ pla.setFillIn(excel.getFillIn());
+ pla.setStr1(excel.getStr1());
+ pla.setStr2(excel.getStr2());
+ pla.setStr3(excel.getStr3());
+ pla.setStr4(excel.getStr4());
+ pla.setStr5(excel.getStr5());
+ pla.setStr6(excel.getStr6());
+ pla.setMassState(excel.getMassState());
+ pla.setProblem(excel.getProblem());
+ pla.setModifyTime(now);
+ 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());
+ }
+ total++;
}
}
@@ -184,6 +218,9 @@
if(Cools.isEmpty(mat)){
throw new CoolException("鏃犳硶鎵惧埌瀵瑰簲鐨勭墝鍙蜂俊鎭紝鐗屽彿=" + pla.getBrand());
}
+ if (!Cools.isEmpty(excel.getProblem()) && excel.getProblem().contains("瀹為獙鏂�")) {
+ excel.setMassState("瀹為獙鏂�");
+ }
pla.setMatnr(mat.getMatnr());
try {
if(Cools.isEmpty(pla.getType())){
--
Gitblit v1.9.1