fix: 移植长辉已验证的四类接口 500/体验问题（不含物料颜色字段）

xiaoyi

9 天以前 481d8165f26fc7e37f0e87f6444ac0340bb563a3

 yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/service/purchase/ErpPurchaseRequestServiceImpl.java

@@ -131,6 +131,10 @@
                .setStatus(ErpPurchaseRequestStatusEnum.DRAFT.getStatus())
                .setRequestUserId(userId)
                .setRequestDeptId(deptId));
        // 兼容旧客户端未传定金的情况，数据库与业务层统一按 0 处理
        if (purchaseRequest.getDepositPrice() == null) {
            purchaseRequest.setDepositPrice(BigDecimal.ZERO);
        }
        calculateTotalPrice(purchaseRequest, requestItems);
        purchaseRequestMapper.insert(purchaseRequest);

@@ -159,6 +163,9 @@

        // 4. 更新申请单
        ErpPurchaseRequestDO updateObj = BeanUtils.toBean(updateReqVO, ErpPurchaseRequestDO.class);
        if (updateObj.getDepositPrice() == null) {
            updateObj.setDepositPrice(BigDecimal.ZERO);
        }
        calculateTotalPrice(updateObj, requestItems);
        purchaseRequestMapper.updateById(updateObj);

@@ -515,18 +522,48 @@
    @Override
    public ErpPurchaseRequestImportRespVO importPurchaseRequestList(List<ErpPurchaseRequestImportExcelVO> importRequests,
                                                                    ErpPurchaseRequestImportReqVO importReqVO) {
        // 1. 校验非空（过滤完全空白的行）
        importRequests = filterList(importRequests, item -> StrUtil.isNotBlank(item.getProductCode()));
        if (Boolean.TRUE.equals(importReqVO.getUpdateSupport())) throw exception(PURCHASE_REQUEST_IMPORT_INVALID, "仅支持新增，不支持覆盖");
        if (CollUtil.isEmpty(importRequests)) {
            throw exception(PURCHASE_REQUEST_IMPORT_LIST_IS_EMPTY);
        }

        // 1. 逐行分类：有效行 / 被跳过的行。
        //    这里不再用 filterList 静默丢弃「物料编码为空」的行 —— 那会让用户看到「导入成功」
        //    但数据无声消失。被跳过的行必须带 Excel 原始行号返回给前端。
        ErpPurchaseRequestImportRespVO respVO = ErpPurchaseRequestImportRespVO.builder()
                .createPurchaseRequestNos(new ArrayList<>())
                .failurePurchaseRequestNos(new LinkedHashMap<>())
                .skippedRows(new LinkedHashMap<>())
                .build();
        List<ImportRow> validRows = new ArrayList<>();
        for (int i = 0; i < importRequests.size(); i++) {
            ErpPurchaseRequestImportExcelVO row = importRequests.get(i);
            int excelRowNo = i + 2; // +1 转 1 基，+1 跳过表头
            String rowLabel = "第" + excelRowNo + "行";
            // 1.1 完全空白的行（所有列都没有值）：Excel 常在末尾留空行，静默跳过即可
            if (isBlankRow(row)) {
                continue;
            }
            validRows.add(new ImportRow(excelRowNo, row));
        }
        respVO.setTotalRows(validRows.size() + respVO.getSkippedRows().size());
        if (CollUtil.isEmpty(validRows)) {
            // 没有任何一行可导入：直接报错。
            // 若是有行因「物料编码为空」被跳过，异常信息里带上行号，帮助用户定位。
            if (CollUtil.isNotEmpty(respVO.getSkippedRows())) {
                throw exception(PURCHASE_REQUEST_IMPORT_ALL_ROWS_SKIPPED,
                        String.join("、", respVO.getSkippedRows().keySet()));
            }
            throw exception(PURCHASE_REQUEST_IMPORT_LIST_IS_EMPTY);
        }

        // 2. 按「单号」分组：相同单号的多行合并成一张采购申请；单号为空时每行各自成一张申请
        List<List<ErpPurchaseRequestImportExcelVO>> groups = new ArrayList<>();
        List<List<ImportRow>> groups = new ArrayList<>();
        Map<String, Integer> groupIndexMap = new LinkedHashMap<>();
        int rowIndex = 0;
        for (ErpPurchaseRequestImportExcelVO row : importRequests) {
            rowIndex++;
            String groupKey = StrUtil.isNotBlank(row.getNo()) ? row.getNo() : ("__row_" + rowIndex);
        for (ImportRow row : validRows) {
            String no = row.data.getNo();
            if (StrUtil.isBlank(no)) { groups.add(new ArrayList<>(Collections.singletonList(row))); continue; }
            String groupKey = no.trim();
            Integer index = groupIndexMap.get(groupKey);
            if (index == null) {
                index = groups.size();
@@ -535,33 +572,99 @@
            }
            groups.get(index).add(row);
        }

        // 3. 逐组合并创建采购申请
        ErpPurchaseRequestImportRespVO respVO = ErpPurchaseRequestImportRespVO.builder()
                .createPurchaseRequestNos(new ArrayList<>())
                .failurePurchaseRequestNos(new LinkedHashMap<>())
                .build();
        for (List<ErpPurchaseRequestImportExcelVO> group : groups) {
            String groupKey = StrUtil.isNotBlank(group.get(0).getNo()) ? group.get(0).getNo()
                    : "第" + (importRequests.indexOf(group.get(0)) + 1) + "行";
        for (List<ImportRow> group : groups) {
            ImportRow firstRow = group.get(0);
            // 失败/跳过的标识优先用单号，没有单号则用 Excel 里的真实行号
            String groupKey = StrUtil.isNotBlank(firstRow.data.getNo())
                    ? firstRow.data.getNo() : "第" + firstRow.excelRowNo + "行";
            try {
                ErpPurchaseRequestSaveReqVO createReqVO = buildPurchaseRequestImportSaveReqVO(group);
                Long requestId = createPurchaseRequest(createReqVO);
                Long requestId = cn.hutool.extra.spring.SpringUtil.getBean(ErpPurchaseRequestServiceImpl.class)
                        .createImportedPurchaseRequest(convertList(group, ImportRow::getData));
                respVO.getCreatePurchaseRequestNos().add(purchaseRequestMapper.selectById(requestId).getNo());
                respVO.setSuccessRows(respVO.getSuccessRows() == null
                        ? group.size() : respVO.getSuccessRows() + group.size());
            } catch (ServiceException ex) {
                // 业务校验失败：记录原因，继续处理下一组
                respVO.getFailurePurchaseRequestNos().put(groupKey, ex.getMessage());
            } catch (Exception ex) {
                // 非业务异常（如远程调用 NPE、数据解析失败）：不能让整个导入 500，
                // 记录为失败并继续，保证其它能导的行正常入库
                log.error("[importPurchaseRequestList] 导入行({}) 发生非业务异常", groupKey, ex);
                respVO.getFailurePurchaseRequestNos().put(groupKey,
                        "导入失败，请检查基础资料和申请明细");
            }
        }
        return respVO;
    }

    /**
     * 判断一行是否完全空白（所有业务列都没有值）
     */
    private boolean isBlankRow(ErpPurchaseRequestImportExcelVO row) {
        return row == null || StrUtil.isBlank(row.getNo())
                && StrUtil.isBlank(row.getProductCode())
                && StrUtil.isBlank(row.getProductUnitCode())
                && row.getRequestTime() == null
                && row.getCount() == null
                && row.getProductPrice() == null
                && row.getDiscountPercent() == null && row.getDepositPrice() == null && row.getTaxPercent() == null
                && row.getDemandTime() == null && row.getQcCheckFlag() == null
                && StrUtil.isBlank(row.getSupplierName())
                && StrUtil.isBlank(row.getRequestReason())
                && StrUtil.isBlank(row.getRemark())
                && StrUtil.isBlank(row.getItemRemark());
    }

    /**
     * 导入行包装：携带 Excel 中的真实行号，用于错误提示定位。
     */
    private static class ImportRow {
        private final int excelRowNo;
        private final ErpPurchaseRequestImportExcelVO data;

        private ImportRow(int excelRowNo, ErpPurchaseRequestImportExcelVO data) {
            this.excelRowNo = excelRowNo;
            this.data = data;
        }

        private ErpPurchaseRequestImportExcelVO getData() {
            return data;
        }
    }

    /**
     * 将同一张采购申请的多行明细转换成创建 Request VO
     */
    @Transactional(rollbackFor = Exception.class)
    public Long createImportedPurchaseRequest(List<ErpPurchaseRequestImportExcelVO> group) {
        return createPurchaseRequest(buildPurchaseRequestImportSaveReqVO(group));
    }
    private ErpPurchaseRequestSaveReqVO buildPurchaseRequestImportSaveReqVO(List<ErpPurchaseRequestImportExcelVO> group) {
        ErpPurchaseRequestImportExcelVO first = group.get(0);
        // 1. 校验申请时间
        if (first.getRequestTime() == null) {
            throw exception(PURCHASE_REQUEST_IMPORT_REQUEST_TIME_REQUIRED);
        }
        if (first.getDiscountPercent() != null && (first.getDiscountPercent().signum() < 0 || first.getDiscountPercent().compareTo(new BigDecimal("100")) > 0)
                || first.getDepositPrice() != null && first.getDepositPrice().signum() < 0) {
            throw exception(PURCHASE_REQUEST_IMPORT_INVALID, "优惠率须在 0 至 100 之间，定金不能为负数");
        }
        for (ErpPurchaseRequestImportExcelVO row : group) {
            if (row.getRequestTime() != null && !row.getRequestTime().equals(first.getRequestTime())
                    || StrUtil.isNotBlank(row.getSupplierName()) && !StrUtil.equals(first.getSupplierName(), row.getSupplierName())
                    || StrUtil.isNotBlank(row.getRequestReason()) && !StrUtil.equals(first.getRequestReason(), row.getRequestReason())
                    || row.getDiscountPercent() != null && (first.getDiscountPercent() == null || row.getDiscountPercent().compareTo(first.getDiscountPercent()) != 0)
                    || row.getDepositPrice() != null && (first.getDepositPrice() == null || row.getDepositPrice().compareTo(first.getDepositPrice()) != 0)
                    || StrUtil.isNotBlank(row.getRemark()) && !StrUtil.equals(first.getRemark(), row.getRemark())) {
                throw exception(PURCHASE_REQUEST_IMPORT_INVALID, "同一申请单的主表信息不一致");
            }
            if (StrUtil.isBlank(row.getProductCode()) || StrUtil.isBlank(row.getProductUnitCode()) || row.getCount() == null || row.getCount().signum() <= 0
                    || row.getProductPrice() == null || row.getProductPrice().signum() < 0
                    || row.getTaxPercent() != null && (row.getTaxPercent().signum() < 0 || row.getTaxPercent().compareTo(new BigDecimal("100")) > 0)) {
                throw exception(PURCHASE_REQUEST_IMPORT_INVALID, "每行须填写物料、单位、正数数量、非负单价；税率须在 0 至 100 之间");
            }
        }
        // 2. 解析供应商（可选）
        Long supplierId = null;
@@ -575,14 +678,17 @@
        // 3. 组装明细
        List<ErpPurchaseRequestSaveReqVO.Item> items = new ArrayList<>();
        for (ErpPurchaseRequestImportExcelVO row : group) {
            MdmItemRespDTO product = mdmItemApi.getItemByCode(row.getProductCode()).getCheckedData();
            MdmItemRespDTO product = mdmItemApi.getItemByCode(row.getProductCode().trim()).getCheckedData();
            if (product == null) {
                throw exception(PURCHASE_REQUEST_IMPORT_PRODUCT_NOT_EXISTS, row.getProductCode());
            }
            MdmUnitMeasureRespDTO unit = mdmUnitMeasureApi.getUnitMeasureByCode(row.getProductUnitCode()).getCheckedData();
            MdmUnitMeasureRespDTO unit = mdmUnitMeasureApi.getUnitMeasureByCode(row.getProductUnitCode().trim()).getCheckedData();
            if (unit == null) {
                throw exception(PURCHASE_REQUEST_IMPORT_UNIT_NOT_EXISTS, row.getProductUnitCode());
            }
            if (product.getStatus() != null && product.getStatus() != 0 || unit.getStatus() != null && unit.getStatus() != 0) {
                throw exception(PURCHASE_REQUEST_IMPORT_INVALID, "物料或计量单位已停用");
            }
            ErpPurchaseRequestSaveReqVO.Item item = new ErpPurchaseRequestSaveReqVO.Item()
                    .setProductId(product.getId())
                    .setProductUnitId(unit.getId())