package cn.iocoder.yudao.module.srm.service.certificate;
|
|
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.collection.CollectionUtils;
|
import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
|
import cn.iocoder.yudao.module.srm.controller.admin.certificate.vo.SrmSupplierCertificateImportExcelVO;
|
import cn.iocoder.yudao.module.srm.controller.admin.certificate.vo.SrmSupplierCertificateImportReqVO;
|
import cn.iocoder.yudao.module.srm.controller.admin.certificate.vo.SrmSupplierCertificateImportRespVO;
|
import cn.iocoder.yudao.module.srm.controller.admin.certificate.vo.SrmSupplierCertificatePageReqVO;
|
import cn.iocoder.yudao.module.srm.controller.admin.certificate.vo.SrmSupplierCertificateSaveReqVO;
|
import cn.iocoder.yudao.module.srm.dal.dataobject.SrmSupplierCertificateDO;
|
import cn.iocoder.yudao.module.srm.dal.dataobject.SrmSupplierDO;
|
import cn.iocoder.yudao.module.srm.dal.mysql.SrmSupplierCertificateMapper;
|
import cn.iocoder.yudao.module.srm.dal.mysql.SrmSupplierMapper;
|
import cn.iocoder.yudao.module.srm.enums.ErrorCodeConstants;
|
import cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil;
|
import cn.iocoder.yudao.module.system.api.storage.StorageAttachmentApi;
|
import jakarta.annotation.Resource;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.validation.annotation.Validated;
|
|
import java.time.LocalDate;
|
import java.util.ArrayList;
|
import java.util.LinkedHashMap;
|
import java.util.List;
|
|
@Service
|
@Validated
|
public class SrmSupplierCertificateServiceImpl implements SrmSupplierCertificateService {
|
|
/**
|
* 资质证书附件的业务记录类型，对应 {@link cn.iocoder.yudao.module.system.enums.storage.StorageRecordTypeEnum#SRM_SUPPLIER_CERTIFICATE}
|
*/
|
public static final String CERTIFICATE_RECORD_TYPE = "srm_supplier_certificate";
|
|
@Resource
|
private SrmSupplierCertificateMapper certificateMapper;
|
|
@Resource
|
private SrmSupplierMapper supplierMapper;
|
|
@Resource
|
private StorageAttachmentApi storageAttachmentApi;
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public Long createCertificate(SrmSupplierCertificateSaveReqVO createReqVO) {
|
SrmSupplierCertificateDO certificate = BeanUtils.toBean(createReqVO, SrmSupplierCertificateDO.class);
|
updateStatus(certificate);
|
certificateMapper.insert(certificate);
|
// 绑定证书附件
|
if (CollUtil.isNotEmpty(createReqVO.getBlobIds())) {
|
storageAttachmentApi.bindAttachments("file", CERTIFICATE_RECORD_TYPE, certificate.getId(), createReqVO.getBlobIds());
|
}
|
return certificate.getId();
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void updateCertificate(SrmSupplierCertificateSaveReqVO updateReqVO) {
|
validateCertificateExists(updateReqVO.getId());
|
SrmSupplierCertificateDO updateObj = BeanUtils.toBean(updateReqVO, SrmSupplierCertificateDO.class);
|
updateStatus(updateObj);
|
certificateMapper.updateById(updateObj);
|
// 增量更新证书附件
|
storageAttachmentApi.updateAttachments("file", CERTIFICATE_RECORD_TYPE, updateReqVO.getId(), updateReqVO.getBlobIds());
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void deleteCertificate(Long id) {
|
validateCertificateExists(id);
|
// 删除证书附件
|
storageAttachmentApi.deleteAttachmentsByRecord(CERTIFICATE_RECORD_TYPE, id);
|
certificateMapper.deleteById(id);
|
}
|
|
@Override
|
public SrmSupplierCertificateDO getCertificate(Long id) {
|
return certificateMapper.selectById(id);
|
}
|
|
@Override
|
public PageResult<SrmSupplierCertificateDO> getCertificatePage(SrmSupplierCertificatePageReqVO pageReqVO) {
|
return certificateMapper.selectPage(pageReqVO);
|
}
|
|
@Override
|
public List<SrmSupplierCertificateDO> getCertificateListBySupplierId(Long supplierId) {
|
return certificateMapper.selectListBySupplierId(supplierId);
|
}
|
|
@Override
|
public List<SrmSupplierCertificateDO> getExpiringCertificates() {
|
LocalDate now = LocalDate.now();
|
return certificateMapper.selectExpiringList(now, now.plusDays(30));
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public SrmSupplierCertificateImportRespVO importCertificateList(List<SrmSupplierCertificateImportExcelVO> importCertificates,
|
SrmSupplierCertificateImportReqVO importReqVO) {
|
// 1. 校验非空
|
importCertificates = CollectionUtils.filterList(importCertificates,
|
item -> StrUtil.isNotBlank(item.getCertificateName()));
|
if (CollUtil.isEmpty(importCertificates)) {
|
throw ServiceExceptionUtil.exception(ErrorCodeConstants.CERTIFICATE_IMPORT_LIST_IS_EMPTY);
|
}
|
|
// 2. 逐条处理
|
SrmSupplierCertificateImportRespVO respVO = SrmSupplierCertificateImportRespVO.builder()
|
.createCertificateNames(new ArrayList<>())
|
.updateCertificateNames(new ArrayList<>())
|
.failureCertificateNames(new LinkedHashMap<>())
|
.build();
|
importCertificates.forEach(importCertificate -> {
|
try {
|
// 2.1 解析供应商
|
if (StrUtil.isBlank(importCertificate.getSupplierName())) {
|
throw ServiceExceptionUtil.exception(ErrorCodeConstants.CERTIFICATE_IMPORT_SUPPLIER_NAME_REQUIRED);
|
}
|
SrmSupplierDO supplier = supplierMapper.selectByName(importCertificate.getSupplierName());
|
if (supplier == null) {
|
throw ServiceExceptionUtil.exception(ErrorCodeConstants.CERTIFICATE_IMPORT_SUPPLIER_NOT_EXISTS,
|
importCertificate.getSupplierName());
|
}
|
// 2.2 判断是否存在
|
SrmSupplierCertificateDO existCertificate = certificateMapper.selectBySupplierIdAndCertificateName(
|
supplier.getId(), importCertificate.getCertificateName());
|
if (existCertificate == null) {
|
// 2.2.1 新增
|
SrmSupplierCertificateDO certificate = BeanUtils.toBean(importCertificate, SrmSupplierCertificateDO.class)
|
.setSupplierId(supplier.getId());
|
updateStatus(certificate);
|
certificateMapper.insert(certificate);
|
respVO.getCreateCertificateNames().add(importCertificate.getCertificateName());
|
return;
|
}
|
// 2.2.2 已存在，判断是否允许更新
|
if (!importReqVO.getUpdateSupport()) {
|
respVO.getFailureCertificateNames().put(importCertificate.getCertificateName(),
|
StrUtil.format(ErrorCodeConstants.CERTIFICATE_IMPORT_NAME_EXISTS.getMsg(), importCertificate.getCertificateName()));
|
return;
|
}
|
SrmSupplierCertificateDO updateCertificate = BeanUtils.toBean(importCertificate, SrmSupplierCertificateDO.class)
|
.setId(existCertificate.getId()).setSupplierId(supplier.getId());
|
updateStatus(updateCertificate);
|
certificateMapper.updateById(updateCertificate);
|
respVO.getUpdateCertificateNames().add(importCertificate.getCertificateName());
|
} catch (ServiceException ex) {
|
respVO.getFailureCertificateNames().put(importCertificate.getCertificateName(), ex.getMessage());
|
}
|
});
|
return respVO;
|
}
|
|
private void validateCertificateExists(Long id) {
|
if (certificateMapper.selectById(id) == null) {
|
throw ServiceExceptionUtil.exception(ErrorCodeConstants.CERTIFICATE_NOT_EXISTS);
|
}
|
}
|
|
private void updateStatus(SrmSupplierCertificateDO certificate) {
|
if (certificate.getValidEndDate() != null) {
|
LocalDate now = LocalDate.now();
|
if (certificate.getValidEndDate().isBefore(now)) {
|
certificate.setStatus(1); // 已过期
|
} else if (certificate.getValidEndDate().isBefore(now.plusDays(30))) {
|
certificate.setStatus(2); // 即将过期
|
} else {
|
certificate.setStatus(0); // 有效
|
}
|
}
|
}
|
|
}
|
