导入时备注是实验料，质量状态设置为实验料，三种出库后都能补传质量指标

pang.jiabao

2025-02-12 d2b8972b4f1bb1869a377a15929bdf0413125a1d

导入时备注是实验料，质量状态设置为实验料，三种出库后都能补传质量指标

 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

 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())){