云
2026-10-25 bc1b16a708ca7bec89d2e1a435c023477f107a59
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/qc/oqc/MesQcOqcServiceImpl.java
@@ -25,6 +25,7 @@
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productsales.MesWmProductSalesLineDO;
import cn.iocoder.yudao.module.crm.api.customer.CrmCustomerApi;
import cn.iocoder.yudao.module.mdm.api.item.MdmItemApi;
import cn.iocoder.yudao.module.mdm.api.item.dto.MdmItemRespDTO;
import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
import jakarta.annotation.Resource;
import org.springframework.context.annotation.Lazy;
@@ -39,6 +40,18 @@
import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*;
import cn.iocoder.yudao.module.mes.controller.admin.qc.oqc.vo.MesQcOqcImportExcelVO;
import cn.iocoder.yudao.module.mes.controller.admin.qc.oqc.vo.MesQcOqcImportRespVO;
import cn.iocoder.yudao.module.crm.api.customer.dto.CrmCustomerRespDTO;
import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService;
import cn.iocoder.yudao.framework.common.exception.ServiceException;
import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.util.StrUtil;
import cn.hutool.core.date.DateUtil;
import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.concurrent.atomic.AtomicInteger;
/**
 * MES 出货检验单(OQC) Service 实现类
@@ -48,6 +61,9 @@
@Service
@Validated
public class MesQcOqcServiceImpl implements MesQcOqcService {
    @Resource
    private MesMdItemService itemService;
    @Resource
    private MesQcOqcMapper oqcMapper;
@@ -163,10 +179,7 @@
        if (unqualifiedQty == null || unqualifiedQty.compareTo(BigDecimal.ZERO) <= 0) {
            return;
        }
        String ncrCode = "NCR" + java.time.LocalDateTime.now()
                .format(java.time.format.DateTimeFormatter.ofPattern("yyyyMMddHHmmssSSS"));
        MesQcNcrSaveReqVO saveReqVO = new MesQcNcrSaveReqVO();
        saveReqVO.setCode(ncrCode);
        saveReqVO.setName("不合格品处理单");
        saveReqVO.setQcType(MesQcTypeEnum.OQC.getType());
        saveReqVO.setQcId(oqc.getId());
@@ -384,4 +397,78 @@
        return "物料ID:" + itemId;
    }
    @Override
    public MesQcOqcImportRespVO importOqcList(List<MesQcOqcImportExcelVO> importList, boolean updateSupport) {
        if (CollUtil.isEmpty(importList)) {
            throw exception(QC_OQC_IMPORT_LIST_IS_EMPTY);
        }
        MesQcOqcImportRespVO respVO = MesQcOqcImportRespVO.builder()
                .createCodes(new ArrayList<>()).updateCodes(new ArrayList<>())
                .failureCodes(new LinkedHashMap<>()).build();
        AtomicInteger index = new AtomicInteger(1);
        importList.forEach(importItem -> {
            int currentIndex = index.getAndIncrement();
            String key = "第 " + currentIndex + " 行";
            if (StrUtil.isBlank(importItem.getClientName())) {
                respVO.getFailureCodes().put(key, "客户名称不能为空");
                return;
            }
            if (StrUtil.isBlank(importItem.getItemCode())) {
                respVO.getFailureCodes().put(key, "产品物料编码不能为空");
                return;
            }
            if (importItem.getOutQuantity() == null || importItem.getCheckQuantity() == null
                    || importItem.getQualifiedQuantity() == null || importItem.getUnqualifiedQuantity() == null) {
                respVO.getFailureCodes().put(key, "出货数量、检测数量、合格品数量、不合格品数量均不能为空");
                return;
            }
            if (importItem.getCheckQuantity().compareTo(importItem.getQualifiedQuantity().add(importItem.getUnqualifiedQuantity())) != 0) {
                respVO.getFailureCodes().put(key, "检测数量必须等于合格品数量与不合格品数量之和");
                return;
            }
            if (importItem.getInspectorUserId() == null) {
                respVO.getFailureCodes().put(key, "检测人员不能为空");
                return;
            }
            if (importItem.getOutDate() == null) {
                respVO.getFailureCodes().put(key, "出货日期不能为空");
                return;
            }
            if (importItem.getInspectDate() == null) {
                respVO.getFailureCodes().put(key, "检测日期不能为空");
                return;
            }
            cn.iocoder.yudao.module.crm.api.customer.dto.CrmCustomerRespDTO customer = customerApi.getCustomerByName(importItem.getClientName());
            if (customer == null) {
                respVO.getFailureCodes().put(key, "客户不存在:" + importItem.getClientName());
                return;
            }
            // 出货检验单的物料以 MDM 为准,导入按 MDM 物料编码解析
            MdmItemRespDTO item = mdmItemApi.getItemByCode(importItem.getItemCode()).getCheckedData();
            if (item == null) {
                respVO.getFailureCodes().put(key, "物料不存在:" + importItem.getItemCode());
                return;
            }
            try {
                MesQcOqcSaveReqVO createReqVO = BeanUtils.toBean(importItem, MesQcOqcSaveReqVO.class);
                createReqVO.setCode(generateImportCode("OQC", index));
                createReqVO.setName(StrUtil.blankToDefault(importItem.getName(), "出货检验单"));
                createReqVO.setClientId(customer.getId());
                createReqVO.setItemId(item.getId());
                Long id = createOqc(createReqVO);
                MesQcOqcDO created = oqcMapper.selectById(id);
                respVO.getCreateCodes().add(created != null && StrUtil.isNotBlank(created.getCode()) ? created.getCode() : key);
            } catch (ServiceException e) {
                respVO.getFailureCodes().put(key, e.getMessage());
            }
        });
        return respVO;
    }
    private String generateImportCode(String prefix, AtomicInteger seq) {
        return prefix + DateUtil.format(LocalDateTime.now(), "yyyyMMddHHmmss")
                + String.format("%03d", seq.incrementAndGet());
    }
}