From f02d0df2f1dfc7a8b775cf50d45375e57628a5ef Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期二, 10 十一月 2026 11:26:22 +0800
Subject: [PATCH] feat(ncr): 完善NCR处置联动逻辑与关闭校验

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/qc/iqc/MesQcIqcServiceImpl.java |  196 ++++++++++++++++++++++++++++++++++++++----------
 1 files changed, 155 insertions(+), 41 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/qc/iqc/MesQcIqcServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/qc/iqc/MesQcIqcServiceImpl.java
index 975ddc0..93efc25 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/qc/iqc/MesQcIqcServiceImpl.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/qc/iqc/MesQcIqcServiceImpl.java
@@ -2,11 +2,19 @@
 
 import cn.hutool.core.collection.CollUtil;
 import cn.hutool.core.util.ObjUtil;
+import cn.hutool.core.util.StrUtil;
+import cn.iocoder.yudao.framework.common.exception.ServiceException;
 import cn.iocoder.yudao.framework.common.pojo.PageResult;
 import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.framework.operatelog.core.util.OperateLogUtils;
 import cn.hutool.core.util.ObjectUtil;
+import cn.iocoder.yudao.module.mes.controller.admin.qc.iqc.vo.MesQcIqcImportExcelVO;
 import cn.iocoder.yudao.module.mes.controller.admin.qc.iqc.vo.MesQcIqcPageReqVO;
 import cn.iocoder.yudao.module.mes.controller.admin.qc.iqc.vo.MesQcIqcSaveReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.qc.vo.MesQcImportRespVO;
+import cn.iocoder.yudao.module.mes.enums.DictTypeConstants;
+import cn.iocoder.yudao.module.mes.enums.md.autocode.MesMdAutoCodeRuleCodeEnum;
+import cn.iocoder.yudao.module.mes.service.qc.imports.MesQcImportHelper;
 import cn.iocoder.yudao.module.mes.dal.dataobject.qc.defectrecord.MesQcDefectRecordDO;
 import cn.iocoder.yudao.module.mes.dal.dataobject.qc.iqc.MesQcIqcDO;
 import cn.iocoder.yudao.module.mes.dal.dataobject.qc.template.MesQcTemplateItemDO;
@@ -28,6 +36,7 @@
 import cn.iocoder.yudao.module.srm.api.supplier.SrmSupplierApi;
 import cn.iocoder.yudao.module.mdm.api.item.MdmItemApi;
 import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
+import com.mzt.logapi.starter.annotation.LogRecord;
 import jakarta.annotation.Resource;
 import org.springframework.context.annotation.Lazy;
 import org.springframework.stereotype.Service;
@@ -42,6 +51,7 @@
 
 import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
 import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*;
+import static cn.iocoder.yudao.module.mes.enums.LogRecordConstants.*;
 
 /**
  * MES 鏉ユ枡妫�楠屽崟锛圛QC锛� Service 瀹炵幇绫�
@@ -51,6 +61,9 @@
 @Service
 @Validated
 public class MesQcIqcServiceImpl implements MesQcIqcService {
+
+    @Resource
+    private cn.iocoder.yudao.module.mes.service.qc.MesQcCompletionHelper completionHelper;
 
     @Resource
     private MesQcIqcMapper iqcMapper;
@@ -83,6 +96,9 @@
     @Lazy
     private MesQcNcrService ncrService;
 
+    @Resource
+    private MesQcImportHelper qcImportHelper;
+
     @Override
     @Transactional(rollbackFor = Exception.class)
     public Long createIqc(MesQcIqcSaveReqVO createReqVO) {
@@ -91,33 +107,15 @@
         // 1.2 鏍¢獙鏉ユ簮鍗曟嵁鍙傛暟锛屽苟楠岃瘉鏁版嵁瀛樺湪
         String sourceDocCode = validateAndGetSourceDocCode(
                 createReqVO.getSourceDocType(), createReqVO.getSourceDocId(), createReqVO.getSourceLineId());
-        // 1.3 鏍规嵁浜у搧 + IQC 绫诲瀷鏌ユ壘鍙敤璐ㄦ鏂规锛堟敮鎸佸墠绔樉寮忔寚瀹氾級
-        List<MesQcTemplateItemDO> templateItems = templateItemService.getTemplateItemList(
-                createReqVO.getItemId(), MesQcTypeEnum.IQC.getType(), null, null);
-        if (CollUtil.isEmpty(templateItems)) {
-            throw exception(QC_NO_TEMPLATE);
-        }
-        MesQcTemplateItemDO templateItem = templateItems.get(0);
-        if (createReqVO.getTemplateId() != null) {
-            templateItem = templateItems.stream()
-                    .filter(item -> Objects.equals(item.getTemplateId(), createReqVO.getTemplateId()))
-                    .findFirst().orElse(null);
-            if (templateItem == null) {
-                throw exception(QC_NO_TEMPLATE); // 鎸囧畾浜嗘柟妗堜絾涓嶅湪鍖归厤鍒楄〃涓紝鎷掔粷
-            }
-        }
-        Long templateId = templateItem.getTemplateId();
+        // 鏂板缓璐ㄦ鍗曚笉渚濊禆璐ㄦ鏂规銆�
 
         // 2. 鎻掑叆涓昏〃
         MesQcIqcDO iqc = BeanUtils.toBean(createReqVO, MesQcIqcDO.class)
-                .setTemplateId(templateId)
+                .setTemplateId(null)
                 .setCheckQuantity(createReqVO.getQualifiedQuantity().add(createReqVO.getUnqualifiedQuantity()))
                 .setSourceDocCode(sourceDocCode)
                 .setStatus(MesQcStatusEnum.DRAFT.getStatus());
         iqcMapper.insert(iqc);
-
-        // 3. 浠庢ā鏉挎寚鏍囪嚜鍔ㄧ敓鎴愭楠岃
-        iqcLineService.createLinesFromTemplate(iqc.getId(), templateId);
         return iqc.getId();
     }
 
@@ -138,11 +136,18 @@
     }
 
     private void validateIqcSaveData(MesQcIqcSaveReqVO reqVO) {
+        // 绌哄瓧绗︿覆涔熼渶瑕佸啓鍏ワ紝浠ユ敮鎸佺紪杈戞椂娓呯┖鎵嬪~鍚嶇О銆�
+        if (reqVO.getVendorName() != null) {
+            reqVO.setVendorName(reqVO.getVendorName().trim());
+        }
         // 鏍¢獙缂栧彿鍞竴
         validateIqcCodeUnique(reqVO.getId(), reqVO.getCode());
         // 鏍¢獙渚涘簲鍟嗗瓨鍦�
         if (reqVO.getVendorId() != null) {
-            srmSupplierApi.getSupplier(reqVO.getVendorId());
+            var supplier = srmSupplierApi.getSupplier(reqVO.getVendorId()).getCheckedData();
+            if (reqVO.getVendorName() == null && supplier != null) {
+                reqVO.setVendorName(supplier.getName());
+            }
         }
         // 鏍¢獙鐗╂枡瀛樺湪锛堜娇鐢� MDM 鐗╂枡锛�
         if (reqVO.getItemId() != null) {
@@ -155,17 +160,16 @@
     @Override
     @Transactional(rollbackFor = Exception.class)
     public void finishIqc(Long id) {
+        completionHelper.lockDocument("iqc", id);
         // 1.1 鏍¢獙瀛樺湪 + 鑽夌鐘舵��
         MesQcIqcDO iqc = validateIqcStatusPrepare(id);
-        if (iqc.getCheckResult() == null) {
-            throw exception(QC_IQC_CHECK_RESULT_EMPTY);
-        }
-        // 1.2 鏍¢獙鑷冲皯瀛樺湪涓�鏉℃娴嬬粨鏋�
-        indicatorResultService.validateIndicatorResultExistsByQcIdAndType(id, MesQcTypeEnum.IQC.getType());
+        int result = completionHelper.validateAndGetResult("iqc", id, iqc.getQualifiedQuantity(), iqc.getUnqualifiedQuantity(), iqc.getCheckQuantity());
+        iqc.setCheckResult(result);
+
 
         // 2. 鏇存柊鐘舵�佷负宸插畬鎴�
         MesQcIqcDO updateObj = new MesQcIqcDO()
-                .setId(id).setStatus(MesQcStatusEnum.FINISHED.getStatus());
+                .setId(id).setStatus(MesQcStatusEnum.FINISHED.getStatus()).setCheckResult(result);
         iqcMapper.updateById(updateObj);
 
         // 3. 涓嶅悎鏍兼椂鑷姩鍒涘缓 NCR
@@ -367,17 +371,6 @@
     @Override
     @Transactional(rollbackFor = Exception.class)
     public Long createIqcFromArrivalNotice(Long noticeId, MesWmArrivalNoticeLineDO line, String noticeCode, Long vendorId) {
-        // 1. 鏍¢獙鐗╂枡鏄惁閰嶇疆浜� IQC 妫�楠屾ā鏉�
-        MesQcTemplateItemDO templateItem;
-        try {
-            templateItem = templateItemService.getRequiredTemplateByItemIdAndType(
-                    line.getItemId(), MesQcTypeEnum.IQC.getType());
-        } catch (Exception e) {
-            // 鑾峰彇鐗╂枡淇℃伅锛屾彁渚涙洿鏄庣‘鐨勯敊璇彁绀�
-            String itemInfo = getItemInfo(line.getItemId());
-            throw exception(QC_NO_TEMPLATE_FOR_ITEM, itemInfo);
-        }
-        Long templateId = templateItem.getTemplateId();
 
         // 2. 鐢熸垚妫�楠屽崟缂栫爜
         String code = "IQC" + System.currentTimeMillis();
@@ -386,12 +379,18 @@
         MesQcIqcDO iqc = new MesQcIqcDO();
         iqc.setCode(code);
         iqc.setName(noticeCode + "-鐗╂枡妫�楠�");
-        iqc.setTemplateId(templateId);
+
         iqc.setSourceDocType(MesBizTypeConstants.WM_ARRIVAL_NOTICE);
         iqc.setSourceDocId(noticeId);
         iqc.setSourceLineId(line.getId());
         iqc.setSourceDocCode(noticeCode);
         iqc.setVendorId(vendorId);
+        if (vendorId != null) {
+            var supplier = srmSupplierApi.getSupplier(vendorId).getCheckedData();
+            if (supplier != null) {
+                iqc.setVendorName(supplier.getName());
+            }
+        }
         iqc.setItemId(line.getItemId());
         iqc.setReceivedQuantity(line.getArrivalQuantity());
         iqc.setCheckQuantity(BigDecimal.ZERO); // 寰呭~鍐�
@@ -401,8 +400,6 @@
         iqc.setStatus(MesQcStatusEnum.DRAFT.getStatus());
         iqcMapper.insert(iqc);
 
-        // 4. 浠庢ā鏉挎寚鏍囪嚜鍔ㄧ敓鎴愭楠岃
-        iqcLineService.createLinesFromTemplate(iqc.getId(), templateId);
 
         return iqc.getId();
     }
@@ -425,4 +422,121 @@
         return "鐗╂枡ID:" + itemId;
     }
 
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    @LogRecord(type = MES_QC_IQC_TYPE, subType = MES_QC_IQC_IMPORT_SUB_TYPE, bizNo = "0",
+            success = MES_QC_IQC_IMPORT_SUCCESS)
+    public MesQcImportRespVO importIqcList(List<MesQcIqcImportExcelVO> importList) {
+        MesQcImportRespVO respVO = MesQcImportRespVO.builder()
+                .createList(new ArrayList<>()).failureList(new LinkedHashMap<>()).build();
+        if (CollUtil.isEmpty(importList)) {
+            // 绌烘枃浠朵篃瑕佺粰鏃ュ織鏂囨鍏滃簳锛岄伩鍏� {{#importSummary}} 鍙栦笉鍒板��
+            OperateLogUtils.putImportSummary(respVO.getCreateList(), null, respVO.getFailureList());
+            return respVO;
+        }
+        qcImportHelper.startImport();
+        Map<String, Integer> firstRowNoByKey = new HashMap<>();
+        for (int i = 0; i < importList.size(); i++) {
+            MesQcIqcImportExcelVO row = importList.get(i);
+            if (isImportRowEmpty(row)) {
+                continue; // 璺宠繃绌鸿
+            }
+            String label = StrUtil.isNotBlank(row.getCode()) ? "妫�楠屽崟缂栧彿 " + row.getCode().trim()
+                    : "绗� " + (i + 2) + " 琛�";
+            String importKey = buildImportKey(row);
+            try {
+                Integer firstRowNo = firstRowNoByKey.get(importKey);
+                if (firstRowNo != null) {
+                    throw MesQcImportHelper.duplicateRowException(firstRowNo, buildImportKeyDesc(row));
+                }
+                respVO.getCreateList().add(createIqcByImport(row));
+                firstRowNoByKey.putIfAbsent(importKey, i + 2);
+            } catch (Exception ex) {
+                respVO.getFailureList().put(label, MesQcImportHelper.resolveImportErrorMessage(ex));
+            }
+        }
+        // 璁板綍瀵煎叆缁撴灉姹囨�伙紝渚� @LogRecord 鐨� success 鏂囨寮曠敤
+        OperateLogUtils.putImportSummary(respVO.getCreateList(), null, respVO.getFailureList());
+        return respVO;
+    }
+
+    private boolean isImportRowEmpty(MesQcIqcImportExcelVO row) {
+        return row == null || (StrUtil.isBlank(row.getCode()) && StrUtil.isBlank(row.getName())
+                && StrUtil.isBlank(row.getItemCode()) && StrUtil.isBlank(row.getVendorName())
+                && StrUtil.isBlank(row.getVendorBatch()) && StrUtil.isBlank(row.getTemplateName())
+                && row.getReceivedQuantity() == null && row.getQualifiedQuantity() == null
+                && row.getUnqualifiedQuantity() == null && StrUtil.isBlank(row.getCheckResult())
+                && StrUtil.isBlank(row.getInspectorName()) && StrUtil.isBlank(row.getInspectDate())
+                && StrUtil.isBlank(row.getReceiveDate()) && StrUtil.isBlank(row.getRemark()));
+    }
+
+    /**
+     * 渚濇嵁瀵煎叆琛屽垱寤轰竴寮犳潵鏂欐楠屽崟锛氱姸鎬佷负銆屽緟妫�楠屻�嶏紝妫�楠岃鐢辫川妫�鏂规鑷姩鐢熸垚
+     *
+     * @return 妫�楠屽崟缂栧彿
+     */
+    private String createIqcByImport(MesQcIqcImportExcelVO row) {
+        MesQcIqcSaveReqVO reqVO = new MesQcIqcSaveReqVO();
+        // 1. 妫�楠屽崟缂栧彿锛氬~鍐欏垯浣跨敤锛岀暀绌鸿嚜鍔ㄧ敓鎴�
+        String code = StrUtil.isNotBlank(row.getCode()) ? row.getCode().trim()
+                : qcImportHelper.generateCode(MesMdAutoCodeRuleCodeEnum.QC_IQC_CODE.getCode());
+        if (iqcMapper.selectByCode(code) != null) {
+            throw new IllegalArgumentException("妫�楠屽崟缂栧彿宸插瓨鍦細" + code
+                    + "銆傝淇敼妯℃澘涓殑銆屾楠屽崟缂栧彿銆嶏紝鎴栧厛鍦ㄧ郴缁熶腑鍒犻櫎璇ョ紪鍙风殑妫�楠屽崟鍚庨噸鏂板鍏�");
+        }
+        reqVO.setCode(code);
+        // 2. 鍚嶇О銆佺墿鏂欍�佷緵搴斿晢銆佽川妫�鏂规
+        if (StrUtil.isBlank(row.getName())) {
+            throw new IllegalArgumentException("妫�楠屽崟鍚嶇О涓嶈兘涓虹┖锛氳濉啓妯℃澘涓琛岀殑銆屾楠屽崟鍚嶇О銆嶅垪");
+        }
+        reqVO.setName(row.getName().trim());
+        reqVO.setItemId(qcImportHelper.resolveItemId(row.getItemCode()));
+        reqVO.setVendorName(StrUtil.trimToEmpty(row.getVendorName()));
+        reqVO.setVendorBatch(StrUtil.trimToNull(row.getVendorBatch()));
+        reqVO.setTemplateId(qcImportHelper.resolveTemplateId(row.getTemplateName()));
+        // 3. 鏁伴噺锛氬悎鏍煎搧 + 涓嶅悎鏍煎搧 蹇呴』绛変簬鏈鎺ユ敹鏁伴噺锛堟帴鏀舵暟閲忕暀绌哄垯鑷姩鍚堣锛�
+        BigDecimal qualified = qcImportHelper.resolveQuantity(row.getQualifiedQuantity(), "鍚堟牸鍝佹暟閲�", true);
+        BigDecimal unqualified = qcImportHelper.resolveQuantity(row.getUnqualifiedQuantity(), "涓嶅悎鏍煎搧鏁伴噺", true);
+        reqVO.setQualifiedQuantity(qualified);
+        reqVO.setUnqualifiedQuantity(unqualified);
+        reqVO.setReceivedQuantity(qcImportHelper.resolveCheckQuantity(
+                row.getReceivedQuantity(), qualified, unqualified, "鏈鎺ユ敹鏁伴噺"));
+        // 4. 妫�楠屼俊鎭�
+        reqVO.setCheckResult(qcImportHelper.resolveDictValue(row.getCheckResult(),
+                DictTypeConstants.MES_QC_CHECK_RESULT, "妫�娴嬬粨鏋�", false));
+        reqVO.setInspectorUserId(qcImportHelper.resolveInspectorUserId(row.getInspectorName()));
+        reqVO.setInspectDate(qcImportHelper.parseRequiredDateTime(row.getInspectDate(), "妫�娴嬫棩鏈�"));
+        reqVO.setReceiveDate(qcImportHelper.parseRequiredDateTime(row.getReceiveDate(), "鏉ユ枡鏃ユ湡"));
+        reqVO.setRemark(StrUtil.trimToNull(row.getRemark()));
+        // 5. 鍘婚噸锛氬悓涓� 鐗╂枡 + 渚涘簲鍟� + 渚涘簲鍟嗘壒娆� + 鏉ユ枡鏃ユ湡 鐨勬潵鏂欐楠屽崟涓嶅彲閲嶅瀵煎叆
+        MesQcIqcDO duplicate = CollUtil.getFirst(iqcMapper.selectListByImportKey(reqVO.getItemId(), reqVO.getVendorName(),
+                reqVO.getVendorBatch(), reqVO.getReceiveDate()));
+        if (duplicate != null) {
+            throw MesQcImportHelper.duplicateExistingException(buildImportKeyDesc(row), "鏉ユ枡妫�楠屽崟",
+                    duplicate.getCode(), "璐ㄩ噺绠$悊-鏉ユ枡妫�楠�");
+        }
+        // 6. 澶嶇敤鍒涘缓閫昏緫锛氭牎楠岀墿鏂�/渚涘簲鍟�/浜哄憳銆佹寜鐗╂枡鍖归厤璐ㄦ鏂规銆佺敓鎴愭楠岃
+        try {
+            createIqc(reqVO);
+        } catch (ServiceException ex) {
+            MesQcImportHelper.rethrowTemplateError(ex, row.getItemCode(), "鏉ユ枡妫�楠�(IQC)");
+        }
+        return code;
+    }
+
+    /**
+     * 瀵煎叆鍘婚噸閿細鍚屼竴 鐗╂枡 + 渚涘簲鍟� + 渚涘簲鍟嗘壒娆� + 鏉ユ枡鏃ユ湡 瑙嗕负鍚屼竴鎵规潵鏂欐暟鎹�
+     */
+    private String buildImportKey(MesQcIqcImportExcelVO row) {
+        return String.join("|", StrUtil.trimToEmpty(row.getItemCode()), StrUtil.trimToEmpty(row.getVendorName()),
+                StrUtil.trimToEmpty(row.getVendorBatch()), StrUtil.trimToEmpty(row.getReceiveDate()));
+    }
+
+    private String buildImportKeyDesc(MesQcIqcImportExcelVO row) {
+        return "鐗╂枡[" + MesQcImportHelper.describeImportValue(row.getItemCode())
+                + "]銆佷緵搴斿晢[" + MesQcImportHelper.describeImportValue(row.getVendorName())
+                + "]銆佷緵搴斿晢鎵规[" + MesQcImportHelper.describeImportValue(row.getVendorBatch())
+                + "]銆佹潵鏂欐棩鏈焄" + MesQcImportHelper.describeImportValue(row.getReceiveDate()) + "]";
+    }
+
 }

--
Gitblit v1.9.3