package cn.iocoder.yudao.module.mes.service.wm.itemreceipt;
|
|
import cn.hutool.core.collection.CollUtil;
|
import cn.hutool.core.util.ObjUtil;
|
import cn.hutool.core.util.StrUtil;
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.framework.common.util.collection.CollectionUtils;
|
import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
|
import cn.iocoder.yudao.framework.common.util.object.ObjectUtils;
|
import cn.iocoder.yudao.module.mes.controller.admin.wm.itemreceipt.vo.MesWmItemReceiptPageReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.wm.itemreceipt.vo.MesWmItemReceiptImportExcelVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.wm.itemreceipt.vo.MesWmItemReceiptSaveReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.wm.itemreceipt.vo.line.MesWmItemReceiptLineSaveReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.wm.vo.MesWmDocImportRespVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.md.item.MesMdItemDO;
|
import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService;
|
import cn.iocoder.yudao.module.srm.api.supplier.dto.SrmSupplierRespDTO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.arrivalnotice.MesWmArrivalNoticeDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.itemreceipt.MesWmItemReceiptDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.itemreceipt.MesWmItemReceiptDetailDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.itemreceipt.MesWmItemReceiptLineDO;
|
import cn.iocoder.yudao.module.mes.dal.mysql.wm.itemreceipt.MesWmItemReceiptMapper;
|
import cn.iocoder.yudao.module.mes.enums.MesBizTypeConstants;
|
import cn.iocoder.yudao.module.mes.enums.wm.MesWmItemReceiptStatusEnum;
|
import cn.iocoder.yudao.module.mes.enums.wm.MesWmTransactionTypeEnum;
|
import cn.iocoder.yudao.module.bpm.enums.task.BpmTaskStatusEnum;
|
import cn.iocoder.yudao.module.mes.service.qc.iqc.MesQcIqcService;
|
import cn.iocoder.yudao.module.mes.service.wm.arrivalnotice.MesWmArrivalNoticeService;
|
import cn.iocoder.yudao.module.mes.service.wm.arrivalnotice.MesWmArrivalNoticeLineService;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.arrivalnotice.MesWmArrivalNoticeLineDO;
|
import cn.iocoder.yudao.module.mes.service.wm.transaction.MesWmTransactionService;
|
import cn.iocoder.yudao.module.mes.service.wm.transaction.dto.MesWmTransactionSaveReqDTO;
|
import cn.iocoder.yudao.module.bpm.api.task.BpmProcessInstanceApi;
|
import cn.iocoder.yudao.module.bpm.api.task.dto.BpmProcessInstanceCreateReqDTO;
|
import cn.iocoder.yudao.module.erp.api.purchase.ErpPurchaseOrderApi;
|
import cn.iocoder.yudao.module.srm.api.supplier.SrmSupplierApi;
|
import cn.iocoder.yudao.module.mdm.api.item.MdmItemApi;
|
import cn.iocoder.yudao.module.mdm.api.item.dto.MdmItemRespDTO;
|
import org.springframework.security.core.Authentication;
|
import org.springframework.security.core.context.SecurityContextHolder;
|
import jakarta.annotation.Resource;
|
import org.springframework.context.annotation.Lazy;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.PlatformTransactionManager;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.transaction.support.TransactionTemplate;
|
import org.springframework.validation.annotation.Validated;
|
import lombok.extern.slf4j.Slf4j;
|
|
import java.math.BigDecimal;
|
import java.time.LocalDate;
|
import java.time.LocalDateTime;
|
import java.util.ArrayList;
|
import java.util.Collection;
|
import java.util.HashMap;
|
import java.util.LinkedHashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
|
import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertList;
|
import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*;
|
|
/**
|
* MES 采购入库单 Service 实现类
|
*/
|
@Service
|
@Validated
|
@Slf4j
|
public class MesWmItemReceiptServiceImpl implements MesWmItemReceiptService {
|
|
@Resource
|
private MesWmItemReceiptMapper itemReceiptMapper;
|
|
@Resource
|
private MesWmItemReceiptLineService itemReceiptLineService;
|
@Resource
|
private PlatformTransactionManager transactionManager;
|
@Resource
|
private MesWmItemReceiptDetailService itemReceiptDetailService;
|
@Resource
|
@Lazy
|
private MesWmArrivalNoticeService arrivalNoticeService;
|
@Resource
|
@Lazy
|
private SrmSupplierApi srmSupplierApi;
|
@Resource
|
@Lazy
|
private MesQcIqcService iqcService;
|
@Resource
|
private MesWmTransactionService wmTransactionService;
|
|
@Resource
|
private MesWmArrivalNoticeLineService arrivalNoticeLineService;
|
|
@Resource
|
@Lazy
|
private MesMdItemService mdItemService;
|
|
@Resource
|
private BpmProcessInstanceApi processInstanceApi;
|
|
@Resource
|
private ErpPurchaseOrderApi purchaseOrderApi;
|
|
@Resource
|
private MdmItemApi mdmItemApi;
|
|
@Override
|
public Long createItemReceipt(MesWmItemReceiptSaveReqVO createReqVO) {
|
// 校验数据
|
validateItemReceiptSaveData(createReqVO);
|
|
// 插入
|
MesWmItemReceiptDO receipt = BeanUtils.toBean(createReqVO, MesWmItemReceiptDO.class);
|
receipt.setStatus(MesWmItemReceiptStatusEnum.PREPARE.getStatus());
|
itemReceiptMapper.insert(receipt);
|
return receipt.getId();
|
}
|
|
@Override
|
public void updateItemReceipt(MesWmItemReceiptSaveReqVO updateReqVO) {
|
// 校验存在 + 草稿状态
|
validateItemReceiptExistsAndDraft(updateReqVO.getId());
|
// 校验数据
|
validateItemReceiptSaveData(updateReqVO);
|
|
// 更新
|
MesWmItemReceiptDO updateObj = BeanUtils.toBean(updateReqVO, MesWmItemReceiptDO.class);
|
itemReceiptMapper.updateById(updateObj);
|
}
|
|
private void validateItemReceiptSaveData(MesWmItemReceiptSaveReqVO reqVO) {
|
// 校验编码唯一
|
validateCodeUnique(reqVO.getId(), reqVO.getCode());
|
// 校验供应商存在（采购入库使用 ERP 供应商）
|
srmSupplierApi.getSupplier(reqVO.getVendorId());
|
// 校验到货通知单存在
|
if (reqVO.getNoticeId() != null) {
|
MesWmArrivalNoticeDO notice = arrivalNoticeService.validateArrivalNoticeReadyForReceipt(reqVO.getNoticeId());
|
if (ObjUtil.notEqual(notice.getVendorId(), reqVO.getVendorId())) {
|
throw exception(WM_ARRIVAL_NOTICE_VENDOR_MISMATCH);
|
}
|
}
|
// 校验来料检验单存在
|
if (reqVO.getIqcId() != null) {
|
iqcService.validateIqcExists(reqVO.getIqcId());
|
}
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void deleteItemReceipt(Long id) {
|
// 校验存在 + 草稿状态
|
validateItemReceiptExistsAndDraft(id);
|
|
// 级联删除明细和行
|
itemReceiptDetailService.deleteItemReceiptDetailByReceiptId(id);
|
itemReceiptLineService.deleteItemReceiptLineByReceiptId(id);
|
// 删除
|
itemReceiptMapper.deleteById(id);
|
}
|
|
@Override
|
public MesWmItemReceiptDO getItemReceipt(Long id) {
|
return itemReceiptMapper.selectById(id);
|
}
|
|
@Override
|
public PageResult<MesWmItemReceiptDO> getItemReceiptPage(MesWmItemReceiptPageReqVO pageReqVO) {
|
return itemReceiptMapper.selectPage(pageReqVO);
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void submitItemReceipt(Long id) {
|
// 校验存在 + 草稿状态
|
validateItemReceiptExistsAndDraft(id);
|
// 校验至少有一条行
|
List<MesWmItemReceiptLineDO> lines = itemReceiptLineService.getItemReceiptLineListByReceiptId(id);
|
if (CollUtil.isEmpty(lines)) {
|
throw exception(WM_ITEM_RECEIPT_NO_LINE);
|
}
|
|
// 校验物料批次管理：如果物料开启批次管理，则明细的批次号不能为空
|
validateBatchManagement(lines);
|
|
// 提交（草稿 → 待上架）
|
itemReceiptMapper.updateById(new MesWmItemReceiptDO()
|
.setId(id).setStatus(MesWmItemReceiptStatusEnum.APPROVING.getStatus()));
|
}
|
|
/**
|
* 校验物料批次管理：如果物料开启批次管理，则行的批次号不能为空
|
*/
|
private void validateBatchManagement(List<MesWmItemReceiptLineDO> lines) {
|
// 获取所有物料ID
|
List<Long> itemIds = CollectionUtils.convertList(lines, MesWmItemReceiptLineDO::getItemId);
|
Map<Long, MdmItemRespDTO> itemMap = mdmItemApi.getItemMap(itemIds);
|
|
// 遍历每一行，检查物料是否开启批次管理
|
for (MesWmItemReceiptLineDO line : lines) {
|
MdmItemRespDTO item = itemMap.get(line.getItemId());
|
if (item == null) {
|
continue;
|
}
|
// 如果物料开启批次管理，检查行上的批次号是否为空
|
if (Boolean.TRUE.equals(item.getIsBatchManaged()) && line.getBatchId() == null) {
|
throw exception(WM_ITEM_RECEIPT_BATCH_REQUIRED, item.getCode(), item.getName());
|
}
|
}
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void stockItemReceipt(Long id) {
|
// 校验存在
|
MesWmItemReceiptDO receipt = validateItemReceiptExists(id);
|
if (ObjUtil.notEqual(MesWmItemReceiptStatusEnum.APPROVING.getStatus(), receipt.getStatus())) {
|
throw exception(WM_ITEM_RECEIPT_STATUS_ERROR);
|
}
|
// 校验每行明细数量之和是否等于行入库数量
|
List<MesWmItemReceiptLineDO> lines = itemReceiptLineService.getItemReceiptLineListByReceiptId(id);
|
if (CollUtil.isEmpty(lines)) {
|
throw exception(WM_ITEM_RECEIPT_NO_LINE);
|
}
|
for (MesWmItemReceiptLineDO line : lines) {
|
List<MesWmItemReceiptDetailDO> details = itemReceiptDetailService.getItemReceiptDetailListByLineId(line.getId());
|
BigDecimal totalDetailQty = CollectionUtils.getSumValue(details,
|
MesWmItemReceiptDetailDO::getQuantity, BigDecimal::add, BigDecimal.ZERO);
|
if (line.getReceivedQuantity() == null || totalDetailQty.compareTo(line.getReceivedQuantity()) != 0) {
|
throw exception(WM_ITEM_RECEIPT_DETAIL_QUANTITY_MISMATCH);
|
}
|
}
|
|
// 执行上架（待上架 → 待入库）
|
itemReceiptMapper.updateById(new MesWmItemReceiptDO()
|
.setId(id).setStatus(MesWmItemReceiptStatusEnum.APPROVED.getStatus()));
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void finishItemReceipt(Long id) {
|
// 1. 校验存在
|
MesWmItemReceiptDO receipt = validateItemReceiptExists(id);
|
if (ObjUtil.notEqual(MesWmItemReceiptStatusEnum.APPROVED.getStatus(), receipt.getStatus())) {
|
throw exception(WM_ITEM_RECEIPT_STATUS_ERROR);
|
}
|
|
// 2. 遍历所有明细，创建库存事务（增加库存 + 记录流水）
|
createTransactionList(receipt);
|
|
// 3. 更新入库单状态
|
itemReceiptMapper.updateById(new MesWmItemReceiptDO()
|
.setId(id).setStatus(MesWmItemReceiptStatusEnum.FINISHED.getStatus()));
|
|
// 4. 更新关联的到货通知单状态
|
if (receipt.getNoticeId() != null) {
|
arrivalNoticeService.finishArrivalNotice(receipt.getNoticeId());
|
}
|
|
// 5. 回写 ERP 采购订单的入库数量
|
updateErpPurchaseOrderInCount(receipt);
|
}
|
|
/**
|
* 回写 ERP 采购订单的入库数量
|
*/
|
private void updateErpPurchaseOrderInCount(MesWmItemReceiptDO receipt) {
|
// 1. 确定采购订单 ID：优先从入库单头取（从到货通知单带入），其次从行反查
|
Long purchaseOrderId = receipt.getPurchaseOrderId();
|
if (purchaseOrderId == null && receipt.getNoticeId() != null) {
|
// 从关联的到货通知单获取采购订单 ID
|
MesWmArrivalNoticeDO notice = arrivalNoticeService.getArrivalNotice(receipt.getNoticeId());
|
if (notice != null) {
|
purchaseOrderId = notice.getPurchaseOrderId();
|
}
|
}
|
|
// 2. 获取入库单行，按 purchaseOrderItemId 更新入库数量
|
List<MesWmItemReceiptLineDO> lines = itemReceiptLineService.getItemReceiptLineListByReceiptId(receipt.getId());
|
if (CollUtil.isNotEmpty(lines)) {
|
for (MesWmItemReceiptLineDO line : lines) {
|
if (line.getPurchaseOrderItemId() != null && line.getReceivedQuantity() != null) {
|
purchaseOrderApi.updateOrderItemInCount(line.getPurchaseOrderItemId(), line.getReceivedQuantity());
|
// 如果还没拿到 purchaseOrderId，从明细项反查
|
if (purchaseOrderId == null) {
|
cn.iocoder.yudao.module.erp.api.purchase.dto.ErpPurchaseOrderItemRespDTO itemDTO =
|
purchaseOrderApi.getPurchaseOrderItem(line.getPurchaseOrderItemId()).getCheckedData();
|
if (itemDTO != null && itemDTO.getOrderId() != null) {
|
purchaseOrderId = itemDTO.getOrderId();
|
}
|
}
|
}
|
}
|
} else if (receipt.getNoticeId() != null) {
|
// 兜底：入库行为空时，从到货通知单行回写入库数量
|
List<MesWmArrivalNoticeLineDO> noticeLines = arrivalNoticeLineService
|
.getArrivalNoticeLineListByNoticeId(receipt.getNoticeId());
|
for (MesWmArrivalNoticeLineDO noticeLine : noticeLines) {
|
if (noticeLine.getPurchaseOrderItemId() != null) {
|
// 使用合格数量（有 IQC 时为合格数量，否则为到货数量）
|
BigDecimal qty = noticeLine.getQualifiedQuantity() != null
|
? noticeLine.getQualifiedQuantity() : noticeLine.getArrivalQuantity();
|
if (qty != null && qty.compareTo(BigDecimal.ZERO) > 0) {
|
purchaseOrderApi.updateOrderItemInCount(noticeLine.getPurchaseOrderItemId(), qty);
|
}
|
}
|
}
|
}
|
|
// 3. 更新采购订单的入库状态
|
if (purchaseOrderId != null) {
|
purchaseOrderApi.updateOrderInStatus(purchaseOrderId);
|
}
|
}
|
|
private void createTransactionList(MesWmItemReceiptDO receipt) {
|
List<MesWmItemReceiptDetailDO> details = itemReceiptDetailService.getItemReceiptDetailListByReceiptId(receipt.getId());
|
// 获取所有行信息，用于获取批次号
|
List<MesWmItemReceiptLineDO> lines = itemReceiptLineService.getItemReceiptLineListByReceiptId(receipt.getId());
|
Map<Long, MesWmItemReceiptLineDO> lineMap = CollectionUtils.convertMap(lines, MesWmItemReceiptLineDO::getId);
|
|
wmTransactionService.createTransactionList(convertList(details, detail -> {
|
// 从行上获取批次信息（如果明细没有批次号）
|
MesWmItemReceiptLineDO line = lineMap.get(detail.getLineId());
|
Long batchId = detail.getBatchId() != null ? detail.getBatchId() :
|
(line != null ? line.getBatchId() : null);
|
String batchCode = line != null ? line.getBatchCode() : null;
|
|
return new MesWmTransactionSaveReqDTO()
|
.setType(MesWmTransactionTypeEnum.IN.getType()).setItemId(detail.getItemId())
|
.setQuantity(detail.getQuantity())
|
.setBatchId(batchId).setBatchCode(batchCode)
|
.setWarehouseId(detail.getWarehouseId()).setLocationId(detail.getLocationId()).setAreaId(detail.getAreaId())
|
.setVendorId(receipt.getVendorId()).setReceiptTime(receipt.getReceiptDate())
|
.setBizType(MesBizTypeConstants.WM_ITEM_RECEIPT_IN).setBizId(receipt.getId())
|
.setBizCode(receipt.getCode()).setBizLineId(detail.getLineId());
|
}));
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void cancelItemReceipt(Long id) {
|
// 校验存在
|
MesWmItemReceiptDO receipt = validateItemReceiptExists(id);
|
// 已完成和已取消不允许取消
|
if (ObjectUtils.equalsAny(receipt.getStatus(),
|
MesWmItemReceiptStatusEnum.FINISHED.getStatus(),
|
MesWmItemReceiptStatusEnum.CANCELED.getStatus())) {
|
throw exception(WM_ITEM_RECEIPT_CANCEL_NOT_ALLOWED);
|
}
|
// 取消
|
itemReceiptMapper.updateById(new MesWmItemReceiptDO()
|
.setId(id).setStatus(MesWmItemReceiptStatusEnum.CANCELED.getStatus()));
|
}
|
|
@Override
|
public MesWmItemReceiptDO validateItemReceiptEditable(Long id) {
|
MesWmItemReceiptDO receipt = validateItemReceiptExists(id);
|
if (ObjUtil.notEqual(receipt.getStatus(), MesWmItemReceiptStatusEnum.PREPARE.getStatus())
|
&& ObjUtil.notEqual(receipt.getStatus(), MesWmItemReceiptStatusEnum.APPROVING.getStatus())) {
|
throw exception(WM_ITEM_RECEIPT_STATUS_NOT_PREPARE);
|
}
|
return receipt;
|
}
|
|
private MesWmItemReceiptDO validateItemReceiptExists(Long id) {
|
MesWmItemReceiptDO receipt = itemReceiptMapper.selectById(id);
|
if (receipt == null) {
|
throw exception(WM_ITEM_RECEIPT_NOT_EXISTS);
|
}
|
return receipt;
|
}
|
|
/**
|
* 校验采购入库单存在且为草稿状态
|
*/
|
private MesWmItemReceiptDO validateItemReceiptExistsAndDraft(Long id) {
|
MesWmItemReceiptDO receipt = validateItemReceiptExists(id);
|
if (ObjUtil.notEqual(MesWmItemReceiptStatusEnum.PREPARE.getStatus(), receipt.getStatus())) {
|
throw exception(WM_ITEM_RECEIPT_STATUS_NOT_PREPARE);
|
}
|
return receipt;
|
}
|
|
private void validateCodeUnique(Long id, String code) {
|
MesWmItemReceiptDO receipt = itemReceiptMapper.selectByCode(code);
|
if (receipt == null) {
|
return;
|
}
|
if (ObjUtil.notEqual(id, receipt.getId())) {
|
throw exception(WM_ITEM_RECEIPT_CODE_DUPLICATE);
|
}
|
}
|
|
@Override
|
public Long getItemReceiptCountByVendorId(Long vendorId) {
|
return itemReceiptMapper.selectCountByVendorId(vendorId);
|
}
|
|
@Override
|
public List<MesWmItemReceiptDO> getItemReceiptListByVendorId(Long vendorId) {
|
return itemReceiptMapper.selectListByVendorId(vendorId);
|
}
|
|
@Override
|
public List<MesWmItemReceiptDO> getItemReceiptList(Collection<Long> ids) {
|
return itemReceiptMapper.selectByIds(ids);
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public Long generateItemReceiptFromArrivalNotice(Long arrivalNoticeId) {
|
// 1. 校验到货通知单存在且状态为待入库
|
MesWmArrivalNoticeDO notice = arrivalNoticeService.validateArrivalNoticeReadyForReceipt(arrivalNoticeId);
|
|
// 2. 校验是否已生成过入库单（防止重复生成）
|
MesWmItemReceiptDO existReceipt = itemReceiptMapper.selectByNoticeId(arrivalNoticeId);
|
if (existReceipt != null) {
|
throw exception(WM_ITEM_RECEIPT_ALREADY_EXISTS);
|
}
|
|
// 3. 获取到货通知单行
|
List<MesWmArrivalNoticeLineDO> lines = arrivalNoticeLineService.getArrivalNoticeLineListByNoticeId(arrivalNoticeId);
|
if (CollUtil.isEmpty(lines)) {
|
throw exception(WM_ARRIVAL_NOTICE_NO_LINE);
|
}
|
|
// 4. 生成入库单编码
|
String code = generateItemReceiptCode();
|
|
// 5. 创建入库单主表
|
MesWmItemReceiptDO receipt = new MesWmItemReceiptDO();
|
receipt.setCode(code);
|
receipt.setName(notice.getName() + "入库单");
|
receipt.setNoticeId(arrivalNoticeId);
|
receipt.setPurchaseOrderId(notice.getPurchaseOrderId());
|
receipt.setPurchaseOrderCode(notice.getPurchaseOrderCode());
|
receipt.setVendorId(notice.getVendorId());
|
receipt.setReceiptDate(java.time.LocalDateTime.now()); // 入库时间为当前时间
|
receipt.setStatus(MesWmItemReceiptStatusEnum.PREPARE.getStatus());
|
itemReceiptMapper.insert(receipt);
|
|
// 6. 遍历行创建入库单行
|
for (MesWmArrivalNoticeLineDO noticeLine : lines) {
|
MesWmItemReceiptLineDO receiptLine = new MesWmItemReceiptLineDO();
|
receiptLine.setReceiptId(receipt.getId());
|
receiptLine.setArrivalNoticeLineId(noticeLine.getId());
|
receiptLine.setPurchaseOrderItemId(noticeLine.getPurchaseOrderItemId());
|
receiptLine.setItemId(noticeLine.getItemId());
|
// 使用合格数量（如果有 IQC 则是合格数量，否则是到货数量）
|
receiptLine.setReceivedQuantity(noticeLine.getQualifiedQuantity() != null ? noticeLine.getQualifiedQuantity() : noticeLine.getArrivalQuantity());
|
itemReceiptLineService.createItemReceiptLineFromArrivalNoticeLine(receiptLine);
|
}
|
|
return receipt.getId();
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void submitItemReceiptApproval(Long id, String processDefinitionKey) {
|
// 1. 校验存在 + 草稿状态
|
validateItemReceiptExistsAndDraft(id);
|
|
// 2. 创建 BPM 流程实例
|
Long userId = getCurrentUserId();
|
// 全局免审批：业务校验通过后直接执行审批通过逻辑，无需流程模型。
|
if (processInstanceApi.isGlobalAutoApprove()) {
|
itemReceiptMapper.updateById(new MesWmItemReceiptDO()
|
.setId(id)
|
.setStatus(MesWmItemReceiptStatusEnum.APPROVING.getStatus())
|
.setProcessInstanceId(""));
|
updateItemReceiptAuditStatus(id, cn.iocoder.yudao.module.bpm.enums.task.BpmProcessInstanceStatusEnum.APPROVE.getStatus());
|
return;
|
}
|
|
String processInstanceId = processInstanceApi.createProcessInstance(userId,
|
new BpmProcessInstanceCreateReqDTO()
|
.setProcessDefinitionKey(processDefinitionKey)
|
.setBusinessKey(String.valueOf(id)));
|
|
// 3. 更新入库单状态为审批中
|
itemReceiptMapper.updateById(new MesWmItemReceiptDO()
|
.setId(id)
|
.setStatus(MesWmItemReceiptStatusEnum.APPROVING.getStatus())
|
.setProcessInstanceId(processInstanceId));
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void updateItemReceiptAuditStatus(Long id, Integer bpmResult) {
|
// 1. 校验存在
|
MesWmItemReceiptDO receipt = validateItemReceiptExists(id);
|
if (!MesWmItemReceiptStatusEnum.APPROVING.getStatus().equals(receipt.getStatus())) {
|
log.warn("[updateItemReceiptAuditStatus] 入库单({}) 不处于审批中状态", id);
|
return;
|
}
|
|
// 2. 根据审批结果更新状态
|
Integer newStatus = convertBpmResultToReceiptStatus(bpmResult);
|
if (newStatus != null) {
|
itemReceiptMapper.updateById(new MesWmItemReceiptDO()
|
.setId(id).setStatus(newStatus));
|
}
|
}
|
|
/**
|
* 转换 BPM 审批结果为入库单状态
|
*/
|
private Integer convertBpmResultToReceiptStatus(Integer bpmResult) {
|
if (BpmTaskStatusEnum.APPROVE.getStatus().equals(bpmResult)) {
|
return MesWmItemReceiptStatusEnum.APPROVED.getStatus();
|
} else if (BpmTaskStatusEnum.REJECT.getStatus().equals(bpmResult)) {
|
return MesWmItemReceiptStatusEnum.PREPARE.getStatus();
|
} else if (BpmTaskStatusEnum.CANCEL.getStatus().equals(bpmResult)) {
|
return MesWmItemReceiptStatusEnum.CANCELED.getStatus();
|
}
|
return null;
|
}
|
|
/**
|
* 获取当前用户 ID
|
*/
|
private Long getCurrentUserId() {
|
Authentication authentication = SecurityContextHolder.getContext().getAuthentication();
|
if (authentication != null && authentication.getPrincipal() instanceof Long) {
|
return (Long) authentication.getPrincipal();
|
}
|
return 1L; // 默认用户
|
}
|
|
/**
|
* 生成入库单编码
|
*/
|
private String generateItemReceiptCode() {
|
// TODO: 使用编码规则服务生成编码
|
return "IR" + System.currentTimeMillis();
|
}
|
|
// ==================== 批量导入 ====================
|
|
@Override
|
public MesWmDocImportRespVO importItemReceiptList(List<MesWmItemReceiptImportExcelVO> importList) {
|
MesWmDocImportRespVO respVO = MesWmDocImportRespVO.empty();
|
if (CollUtil.isEmpty(importList)) {
|
return respVO;
|
}
|
// 1. 按「入库单编码」归并成单据 + 明细行
|
Map<String, List<MesWmItemReceiptImportExcelVO>> grouped = new LinkedHashMap<>();
|
int index = 0;
|
for (MesWmItemReceiptImportExcelVO row : importList) {
|
index++;
|
String code = StrUtil.trim(row.getReceiptCode());
|
if (StrUtil.isBlank(code)) {
|
respVO.getFailureCodes().put("第 " + index + " 行", "入库单编码不能为空");
|
continue;
|
}
|
grouped.computeIfAbsent(code, k -> new ArrayList<>()).add(row);
|
}
|
|
// 2. 预加载供应商，按名称建索引
|
// 注意：getSupplierSimpleList() 只返回特定状态的供应商，可能缺少历史/停用供应商，
|
// 因此这里以「供应商名称」逐行兜底查询（见 resolveVendorId）。
|
Map<String, Long> vendorMap = new HashMap<>();
|
try {
|
List<SrmSupplierRespDTO> suppliers = srmSupplierApi.getSupplierSimpleList().getCheckedData();
|
if (CollUtil.isNotEmpty(suppliers)) {
|
suppliers.forEach(s -> {
|
if (StrUtil.isNotBlank(s.getName())) {
|
vendorMap.put(s.getName().trim(), s.getId());
|
}
|
});
|
}
|
} catch (Exception e) {
|
log.warn("[importItemReceiptList][加载供应商简洁列表失败，将逐行查询]", e);
|
}
|
|
// 3. 逐张单据处理
|
for (Map.Entry<String, List<MesWmItemReceiptImportExcelVO>> entry : grouped.entrySet()) {
|
String code = entry.getKey();
|
List<MesWmItemReceiptImportExcelVO> rows = entry.getValue();
|
MesWmItemReceiptImportExcelVO head = rows.get(0);
|
try {
|
// 3.1 校验供应商
|
String vendorName = StrUtil.trim(head.getVendorName());
|
Long vendorId = vendorName == null ? null : vendorMap.get(vendorName);
|
if (vendorId == null && vendorName != null) {
|
// 兜底：简洁列表可能未覆盖该供应商，按名称查询
|
SrmSupplierRespDTO supplier = findSupplierByName(vendorName);
|
if (supplier != null) {
|
vendorId = supplier.getId();
|
vendorMap.put(vendorName, vendorId);
|
}
|
}
|
if (vendorId == null) {
|
respVO.getFailureCodes().put(code, "供应商[" + vendorName + "]不存在");
|
continue;
|
}
|
// 3.2 校验日期与编码
|
LocalDateTime receiptDate = parseImportDateTime(head.getReceiptDate());
|
if (receiptDate == null) {
|
respVO.getFailureCodes().put(code, "入库日期不能为空或格式不正确（支持 yyyy-MM-dd / yyyy-MM-dd HH:mm:ss）");
|
continue;
|
}
|
if (itemReceiptMapper.selectByCode(code) != null) {
|
respVO.getFailureCodes().put(code, "入库单编码已存在");
|
continue;
|
}
|
// 3.3 创建单据头
|
MesWmItemReceiptSaveReqVO saveReqVO = new MesWmItemReceiptSaveReqVO();
|
saveReqVO.setCode(code);
|
saveReqVO.setName(StrUtil.blankToDefault(StrUtil.trim(head.getReceiptName()), code));
|
saveReqVO.setVendorId(vendorId);
|
saveReqVO.setReceiptDate(receiptDate);
|
saveReqVO.setPurchaseOrderCode(StrUtil.trim(head.getPurchaseOrderCode()));
|
saveReqVO.setRemark(StrUtil.trim(head.getRemark()));
|
Long receiptId = createItemReceipt(saveReqVO);
|
// 3.4 逐行创建明细
|
int createdLines = 0;
|
for (MesWmItemReceiptImportExcelVO row : rows) {
|
if (createItemReceiptLineByImport(receiptId, row, respVO, code)) {
|
createdLines++;
|
}
|
}
|
if (createdLines == 0) {
|
// 没有任何有效明细时不保留空单，也不报告导入成功。
|
itemReceiptMapper.deleteById(receiptId);
|
} else {
|
respVO.getCreateCodes().add(code);
|
}
|
} catch (Exception e) {
|
respVO.getFailureCodes().put(code, e.getMessage() == null ? "导入失败" : e.getMessage());
|
}
|
}
|
return respVO;
|
}
|
|
/**
|
* 导入时创建单行明细；失败只记录不抛出，避免影响整张单据的其它行
|
*/
|
private boolean createItemReceiptLineByImport(Long receiptId, MesWmItemReceiptImportExcelVO row,
|
MesWmDocImportRespVO respVO, String receiptCode) {
|
String itemCode = StrUtil.trim(row.getItemCode());
|
MesMdItemDO item = itemCode == null ? null : mdItemService.getItemByCode(itemCode);
|
if (item == null) {
|
respVO.getFailureCodes().put(receiptCode, "物料编码[" + itemCode + "]不存在，该行已跳过");
|
return false;
|
}
|
if (row.getReceivedQuantity() == null || row.getReceivedQuantity().signum() <= 0) {
|
respVO.getFailureCodes().put(receiptCode, "物料[" + itemCode + "]入库数量必须大于 0，该行已跳过");
|
return false;
|
}
|
try {
|
MesWmItemReceiptLineSaveReqVO lineReqVO = new MesWmItemReceiptLineSaveReqVO();
|
lineReqVO.setReceiptId(receiptId);
|
lineReqVO.setItemId(item.getId());
|
lineReqVO.setReceivedQuantity(row.getReceivedQuantity());
|
lineReqVO.setProductionDate(parseImportDateTime(row.getProductionDate()));
|
lineReqVO.setExpireDate(parseImportDateTime(row.getExpireDate()));
|
lineReqVO.setLotNumber(StrUtil.trim(row.getLotNumber()));
|
lineReqVO.setRemark(StrUtil.trim(row.getRemark()));
|
// 每行独立事务：批次校验失败时只回滚该行，避免污染整次导入事务。
|
new TransactionTemplate(transactionManager).executeWithoutResult(
|
status -> itemReceiptLineService.createItemReceiptLine(lineReqVO));
|
return true;
|
} catch (Exception e) {
|
respVO.getFailureCodes().put(receiptCode, "物料[" + itemCode + "]明细创建失败：" + e.getMessage());
|
return false;
|
}
|
}
|
|
/**
|
* 按名称查找供应商（兜底）
|
*
|
* getSupplierSimpleList() 只返回已通过准入审批的供应商，
|
* 历史导入或未走准入流程的供应商不在其中，因此退化为全量匹配。
|
*/
|
private SrmSupplierRespDTO findSupplierByName(String name) {
|
try {
|
var simple = srmSupplierApi.getSupplierSimpleList();
|
if (simple != null && CollUtil.isNotEmpty(simple.getCheckedData())) {
|
SrmSupplierRespDTO hit = simple.getCheckedData().stream()
|
.filter(s -> name.equals(StrUtil.trim(s.getName())))
|
.findFirst().orElse(null);
|
if (hit != null) {
|
return hit;
|
}
|
}
|
} catch (Exception e) {
|
log.warn("[findSupplierByName][简洁列表查询失败，改用全量]", e);
|
}
|
try {
|
var all = srmSupplierApi.getSupplierAllList();
|
if (all != null && CollUtil.isNotEmpty(all.getCheckedData())) {
|
return all.getCheckedData().stream()
|
.filter(s -> name.equals(StrUtil.trim(s.getName())))
|
.findFirst().orElse(null);
|
}
|
} catch (Exception e) {
|
log.warn("[findSupplierByName][全量列表查询失败]", e);
|
}
|
return null;
|
}
|
|
/**
|
* 解析导入日期，支持 yyyy-MM-dd 与 yyyy-MM-dd HH:mm:ss，失败返回 null
|
*/
|
private LocalDateTime parseImportDateTime(String text) {
|
if (StrUtil.isBlank(text)) {
|
return null;
|
}
|
String value = text.trim().replace('/', '-');
|
try {
|
if (value.length() <= 10) {
|
return LocalDate.parse(value).atStartOfDay();
|
}
|
return LocalDateTime.parse(value.replace(' ', 'T'));
|
} catch (Exception e) {
|
return null;
|
}
|
}
|
|
}
|
