package cn.iocoder.yudao.module.srm.service.supplier; import cn.hutool.core.collection.CollUtil; 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.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.srm.controller.admin.supplier.vo.SrmSupplierImportExcelVO; import cn.iocoder.yudao.module.srm.controller.admin.supplier.vo.SrmSupplierImportReqVO; import cn.iocoder.yudao.module.srm.controller.admin.supplier.vo.SrmSupplierImportRespVO; import cn.iocoder.yudao.module.srm.controller.admin.supplier.vo.SrmSupplierPageReqVO; import cn.iocoder.yudao.module.srm.controller.admin.supplier.vo.SrmSupplierSaveReqVO; import cn.iocoder.yudao.module.srm.dal.dataobject.*; import cn.iocoder.yudao.module.srm.dal.mysql.SrmBidAwardMapper; import cn.iocoder.yudao.module.srm.dal.mysql.SrmBidEvaluationMapper; import cn.iocoder.yudao.module.srm.dal.mysql.SrmSupplierApplyMapper; import cn.iocoder.yudao.module.srm.dal.mysql.SrmSupplierCategoryMapper; import cn.iocoder.yudao.module.srm.dal.mysql.SrmSupplierContactMapper; import cn.iocoder.yudao.module.srm.dal.mysql.SrmSupplierCertificateMapper; import cn.iocoder.yudao.module.srm.dal.mysql.SrmSupplierMapper; import cn.iocoder.yudao.module.srm.dal.mysql.SrmTenderBidMapper; import cn.iocoder.yudao.module.srm.enums.ErrorCodeConstants; import cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil; import jakarta.annotation.Resource; import org.springframework.stereotype.Service; import org.springframework.validation.annotation.Validated; import org.springframework.transaction.annotation.Transactional; import cn.iocoder.yudao.framework.common.util.collection.CollectionUtils; import cn.hutool.core.collection.CollUtil; import java.util.Collection; import java.util.Collections; import java.util.List; import java.util.ArrayList; import java.util.LinkedHashMap; @Service @Validated public class SrmSupplierServiceImpl implements SrmSupplierService { @Resource private SrmSupplierMapper supplierMapper; @Resource private SrmSupplierContactMapper supplierContactMapper; @Resource private SrmSupplierCategoryMapper supplierCategoryMapper; @Resource private SrmSupplierApplyMapper supplierApplyMapper; @Resource private SrmSupplierCertificateMapper supplierCertificateMapper; @Resource private SrmTenderBidMapper tenderBidMapper; @Resource private SrmBidEvaluationMapper bidEvaluationMapper; @Resource private SrmBidAwardMapper bidAwardMapper; @Override public Long createSupplier(SrmSupplierSaveReqVO createReqVO) { // 校验供应商编码唯一性 validateCodeUnique(createReqVO.getCode(), null); // 插入 SrmSupplierDO supplier = BeanUtils.toBean(createReqVO, SrmSupplierDO.class); supplierMapper.insert(supplier); return supplier.getId(); } @Override public void updateSupplier(SrmSupplierSaveReqVO updateReqVO) { // 校验存在性 validateSupplierExists(updateReqVO.getId()); // 校验编码唯一性 validateCodeUnique(updateReqVO.getCode(), updateReqVO.getId()); // 更新 SrmSupplierDO updateObj = BeanUtils.toBean(updateReqVO, SrmSupplierDO.class); supplierMapper.updateById(updateObj); } @Override @Transactional(rollbackFor = Exception.class) public void deleteSupplier(Long id) { // 校验存在性 validateSupplierExists(id); // 关联数据存在时,不允许删除 validateNoReference(id); // 可直接清理的关联数据 supplierContactMapper.deleteBySupplierId(id); supplierCategoryMapper.deleteBySupplierId(id); // 逻辑删除 supplierMapper.deleteById(id); } @Override public SrmSupplierDO getSupplier(Long id) { return supplierMapper.selectById(id); } @Override public PageResult getSupplierPage(SrmSupplierPageReqVO pageReqVO) { return supplierMapper.selectPage(pageReqVO); } @Override public List getSupplierSimpleList() { return supplierMapper.selectApprovedList(); } @Override public List getSupplierAllList() { return supplierMapper.selectList(new LambdaQueryWrapperX() .orderByAsc(SrmSupplierDO::getId)); } @Override public List getSupplierList(Collection ids) { if (CollUtil.isEmpty(ids)) { return Collections.emptyList(); } return supplierMapper.selectBatchIds(ids); } @Override @Transactional(rollbackFor = Exception.class) public SrmSupplierImportRespVO importSupplierList(List importSuppliers, SrmSupplierImportReqVO importReqVO) { // 1. 校验非空 importSuppliers = CollectionUtils.filterList(importSuppliers, item -> StrUtil.isNotBlank(item.getName())); if (CollUtil.isEmpty(importSuppliers)) { throw ServiceExceptionUtil.exception(ErrorCodeConstants.SUPPLIER_IMPORT_LIST_IS_EMPTY); } // 2. 逐条处理 SrmSupplierImportRespVO respVO = SrmSupplierImportRespVO.builder() .createSupplierNames(new ArrayList<>()) .updateSupplierNames(new ArrayList<>()) .failureSupplierNames(new LinkedHashMap<>()) .build(); importSuppliers.forEach(importSupplier -> { try { // 2.1 校验编码 if (StrUtil.isBlank(importSupplier.getCode())) { throw ServiceExceptionUtil.exception(ErrorCodeConstants.SUPPLIER_IMPORT_CODE_REQUIRED); } // 2.2 判断是否存在 SrmSupplierDO existSupplier = supplierMapper.selectByCode(importSupplier.getCode()); if (existSupplier == null) { // 2.2.1 新增 SrmSupplierDO supplier = BeanUtils.toBean(importSupplier, SrmSupplierDO.class); if (supplier.getStatus() == null) { supplier.setStatus(0); } supplierMapper.insert(supplier); respVO.getCreateSupplierNames().add(importSupplier.getName()); return; } // 2.2.2 已存在,判断是否允许更新 if (!importReqVO.getUpdateSupport()) { respVO.getFailureSupplierNames().put(importSupplier.getName(), StrUtil.format(ErrorCodeConstants.SUPPLIER_IMPORT_CODE_EXISTS.getMsg(), importSupplier.getCode())); return; } SrmSupplierDO updateSupplier = BeanUtils.toBean(importSupplier, SrmSupplierDO.class) .setId(existSupplier.getId()); if (updateSupplier.getStatus() == null) { updateSupplier.setStatus(existSupplier.getStatus()); } supplierMapper.updateById(updateSupplier); respVO.getUpdateSupplierNames().add(importSupplier.getName()); } catch (ServiceException ex) { respVO.getFailureSupplierNames().put(importSupplier.getName(), ex.getMessage()); } }); return respVO; } // ========== 校验方法 ========== private void validateSupplierExists(Long id) { if (supplierMapper.selectById(id) == null) { throw ServiceExceptionUtil.exception(ErrorCodeConstants.SUPPLIER_NOT_EXISTS); } } private void validateCodeUnique(String code, Long id) { SrmSupplierDO existing = supplierMapper.selectByCode(code); if (existing != null && !existing.getId().equals(id)) { throw ServiceExceptionUtil.exception(ErrorCodeConstants.SUPPLIER_CODE_EXISTS); } } private void validateNoReference(Long id) { boolean hasReference = supplierApplyMapper.existsApprovedBySupplierId(id) || supplierCertificateMapper.selectCount(SrmSupplierCertificateDO::getSupplierId, id) > 0 || tenderBidMapper.selectCount(SrmTenderBidDO::getSupplierId, id) > 0 || bidEvaluationMapper.selectCount(SrmBidEvaluationDO::getSupplierId, id) > 0 || bidAwardMapper.selectCount(SrmBidAwardDO::getSupplierId, id) > 0; if (hasReference) { throw ServiceExceptionUtil.exception(ErrorCodeConstants.SUPPLIER_EXISTS_REFERENCE); } } }