package com.chinaztt.mes.quality.utils;
|
|
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.chinaztt.mes.quality.entity.HwWeightLabelConfig;
|
import com.chinaztt.mes.quality.entity.QualityHw19Code;
|
import com.chinaztt.mes.quality.entity.QualityHw19Gross;
|
import com.chinaztt.mes.quality.mapper.HwWeightLabelConfigMapper;
|
import com.chinaztt.mes.quality.mapper.QualityHw19CodeMapper;
|
import com.chinaztt.mes.quality.mapper.QualityHw19GrossMapper;
|
import com.chinaztt.ztt.common.core.util.R;
|
import lombok.AllArgsConstructor;
|
import org.springframework.stereotype.Service;
|
|
import javax.script.ScriptEngine;
|
import javax.script.ScriptEngineManager;
|
import java.math.BigDecimal;
|
import java.text.DecimalFormat;
|
import java.util.List;
|
|
/**
|
* @Description :华为称重标签配置参数工具类
|
* @Author : sll
|
* @Date: 2023-01-14 17:23
|
*/
|
@Service
|
@AllArgsConstructor
|
public class HwWeightLabelConfigUtils {
|
private HwWeightLabelConfigMapper hwWeightLabelConfigMapper;
|
private QualityHw19GrossMapper qualityHw19GrossMapper;
|
private QualityHw19CodeMapper qualityHw19CodeMapper;
|
private static final ScriptEngineManager manager = new ScriptEngineManager();
|
|
/**
|
* 根据客户物料编码获取称重配置数据
|
* @param materialCode
|
* @return
|
*/
|
public List<HwWeightLabelConfig> getConfigs(String materialCode) {
|
List<HwWeightLabelConfig> hwWeightLabelConfigList = hwWeightLabelConfigMapper.selectList(Wrappers.<HwWeightLabelConfig>lambdaQuery().eq(HwWeightLabelConfig::getMaterialCode,materialCode));
|
|
if (CollectionUtils.isEmpty(hwWeightLabelConfigList)){
|
throw new RuntimeException("客户物料编码 = 【" + materialCode + "】 -> 查无称重标签配置数据");
|
}
|
|
return hwWeightLabelConfigList;
|
}
|
|
public HwWeightLabelConfig getConfigLine(List<HwWeightLabelConfig> hwWeightLabelConfigList, BigDecimal length) throws Exception {
|
ScriptEngine se = manager.getEngineByName("js");
|
String s;
|
|
for (HwWeightLabelConfig hwWeightLabelConfig : hwWeightLabelConfigList) {
|
//将公式中的x替换成长度数值
|
s = hwWeightLabelConfig.getLengthScope().replace("x", length.toString());
|
|
if ((Boolean)se.eval(s)){
|
//返回找到的配置记录行
|
return hwWeightLabelConfig;
|
}
|
}
|
|
//根据长度配没找到配置记录行
|
throw new RuntimeException("客户物料编码 = 【" + hwWeightLabelConfigList.get(0).getMaterialCode() + "】 -> 对应的长度 = 【" + length + "】 -> 查无称重标签配置数据");
|
}
|
|
/**
|
* 打印校验
|
* @param id 记录行id
|
*/
|
public R printCheck(Long id) throws Exception {
|
QualityHw19Gross qualityHw19Gross = qualityHw19GrossMapper.selectById(id);
|
if (null == qualityHw19Gross){
|
throw new RuntimeException("根据记录行id = 【" + id + "】 -> 查无数据");
|
}
|
|
//根据19条码获取客户物料编码
|
List<QualityHw19Code> qualityHw19CodeList = qualityHw19CodeMapper.selectList(Wrappers.<QualityHw19Code>lambdaQuery().eq(QualityHw19Code::getBarCode,qualityHw19Gross.getBarCode()));
|
if (CollectionUtils.isEmpty(qualityHw19CodeList)){
|
throw new RuntimeException("19条码 = 【" + qualityHw19Gross.getBarCode() + "】 -> 查无生码记录");
|
}
|
|
if (qualityHw19CodeList.size() != 1) {
|
throw new RuntimeException("19条码 = 【" + qualityHw19Gross.getBarCode() + "】 -> 存在多条生码记录");
|
}
|
|
//根据客户物料编码获取称重配置数据
|
List<HwWeightLabelConfig> hwWeightLabelConfigList = getConfigs(qualityHw19CodeList.get(0).getMaterialCode());
|
|
//根据客户物料编码及长度获取对应的配置记录行
|
HwWeightLabelConfig hwWeightLabelConfig = getConfigLine(hwWeightLabelConfigList, qualityHw19CodeList.get(0).getLength());
|
|
//判断是否需要打印称重标签
|
if (!hwWeightLabelConfig.getIsNeedPrint() || !hwWeightLabelConfig.getActive()){
|
throw new RuntimeException("客户物料编码 = 【" + qualityHw19CodeList.get(0).getMaterialCode() + "】 -> 长度 = 【" + qualityHw19CodeList.get(0).getLength() + "】 -> 无需打印称重标签");
|
}
|
|
//初始化实际净重
|
BigDecimal actualNetWeight = BigDecimal.ZERO;
|
//初始化理论净重 = 长度 * 米重
|
BigDecimal theoryNetWeight = qualityHw19CodeList.get(0).getLength().multiply(hwWeightLabelConfig.getMeterWeight());
|
|
BigDecimal a = new BigDecimal("1");
|
//防呆范围浮动参数
|
BigDecimal b = hwWeightLabelConfig.getFloatParam();
|
|
switch (hwWeightLabelConfig.getPackMaterial()) {
|
case "纸箱" :
|
//实际净重 = 毛重 - 纸箱重量
|
actualNetWeight = qualityHw19Gross.getGrossWei().subtract(hwWeightLabelConfig.getCartonWeight());
|
|
//校验实际净重
|
return checkWeight(actualNetWeight,theoryNetWeight,a,b,qualityHw19Gross);
|
case "盘具" :
|
//实际净重 = 毛重 - 空盘具重量 + 纸板重量
|
actualNetWeight = qualityHw19Gross.getGrossWei().subtract(hwWeightLabelConfig.getEmptyTrayWeight()).add(hwWeightLabelConfig.getPaperboardWeight());
|
|
//校验实际净重
|
return checkWeight(actualNetWeight,theoryNetWeight,a,b,qualityHw19Gross);
|
default:
|
throw new RuntimeException("包装材质 = 【" + hwWeightLabelConfig.getPackMaterial() + "】 -> 不合规");
|
}
|
}
|
|
/**
|
* 校验实际净重
|
* @param actualNetWeight 实际净重
|
* @param theoryNetWeight 理论净重
|
* @param a 常量 1
|
* @param b 防呆范围浮动参数
|
* @param qualityHw19Gross 毛重记录行
|
* @return
|
*/
|
public R checkWeight(BigDecimal actualNetWeight, BigDecimal theoryNetWeight, BigDecimal a, BigDecimal b, QualityHw19Gross qualityHw19Gross) {
|
//更新称重标签记录行中的净重，方便后期用户修改配置数据后，重新计算实际净重
|
qualityHw19Gross.setNetWei(actualNetWeight);
|
qualityHw19GrossMapper.updateById(qualityHw19Gross);
|
|
BigDecimal min = theoryNetWeight.multiply(a.subtract(b));
|
BigDecimal max = theoryNetWeight.multiply(a.add(b));
|
|
if (actualNetWeight.compareTo(min) >= 0 && actualNetWeight.compareTo(max) <= 0) {
|
//满足条件
|
return R.ok();
|
} else {
|
//不满足条件
|
DecimalFormat decimalFormatTip = new DecimalFormat("00.00");//报错提示精度
|
return R.failed("实际净重 = 【" + decimalFormatTip.format(actualNetWeight) + "】 -> 超出标准范围 -> [" + decimalFormatTip.format(min) + "," + decimalFormatTip.format(max) + "]");
|
}
|
}
|
}
|
