package cn.iocoder.yudao.module.crm.service.credit; 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.module.crm.controller.admin.credit.vo.CrmCreditRatingImportExcelVO; import cn.iocoder.yudao.module.crm.controller.admin.credit.vo.CrmCreditRatingImportReqVO; import cn.iocoder.yudao.module.crm.controller.admin.credit.vo.CrmCreditRatingImportRespVO; import cn.iocoder.yudao.module.crm.controller.admin.credit.vo.CrmCreditRatingPageReqVO; import cn.iocoder.yudao.module.crm.controller.admin.credit.vo.CrmCreditRatingRespVO; import cn.iocoder.yudao.module.crm.controller.admin.credit.vo.CrmCreditRatingSaveReqVO; import cn.iocoder.yudao.module.crm.dal.dataobject.credit.CrmCreditRatingDO; import cn.iocoder.yudao.module.crm.dal.dataobject.customer.CrmCustomerDO; import cn.iocoder.yudao.module.crm.dal.mysql.credit.CrmCreditRatingMapper; import cn.iocoder.yudao.module.crm.dal.mysql.customer.CrmCustomerMapper; import cn.iocoder.yudao.module.crm.enums.ErrorCodeConstants; import jakarta.annotation.Resource; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.validation.annotation.Validated; import java.time.LocalDateTime; import java.util.ArrayList; import java.util.LinkedHashMap; import java.util.List; import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception; import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.filterList; import static cn.iocoder.yudao.framework.security.core.util.SecurityFrameworkUtils.getLoginUserId; import static cn.iocoder.yudao.module.crm.enums.ErrorCodeConstants.*; @Service @Validated public class CrmCreditRatingServiceImpl implements CrmCreditRatingService { @Resource private CrmCreditRatingMapper creditRatingMapper; @Resource private CrmCustomerMapper customerMapper; @Override @Transactional(rollbackFor = Exception.class) public Long createCreditRating(CrmCreditRatingSaveReqVO createReqVO) { CrmCustomerDO customer = customerMapper.selectById(createReqVO.getCustomerId()); if (customer == null) { throw exception(ErrorCodeConstants.CUSTOMER_NOT_EXISTS); } if (StrUtil.isBlank(createReqVO.getOperatorName())) { createReqVO.setOperatorName(customer.getName()); } if (createReqVO.getOperateTime() == null) { createReqVO.setOperateTime(LocalDateTime.now()); } CrmCreditRatingDO entity = BeanUtils.toBean(createReqVO, CrmCreditRatingDO.class, vo -> vo.setCustomerName(customer.getName())); creditRatingMapper.insert(entity); customer.setCreditLevel(entity.getLevel()); customer.setCreditScore(entity.getScore()); customerMapper.updateById(customer); return entity.getId(); } @Override public void updateCreditRating(CrmCreditRatingSaveReqVO updateReqVO) { CrmCreditRatingDO exists = creditRatingMapper.selectById(updateReqVO.getId()); if (exists == null) { throw exception(ErrorCodeConstants.CRM_CREDIT_RATING_NOT_EXISTS); } CrmCreditRatingDO entity = BeanUtils.toBean(updateReqVO, CrmCreditRatingDO.class); creditRatingMapper.updateById(entity); CrmCreditRatingDO latest = creditRatingMapper.selectLatestByCustomerId(exists.getCustomerId()); CrmCustomerDO customer = customerMapper.selectById(exists.getCustomerId()); if (customer != null && latest != null && latest.getId().equals(entity.getId())) { customer.setCreditLevel(latest.getLevel()); customer.setCreditScore(latest.getScore()); customerMapper.updateById(customer); } } @Override public void deleteCreditRating(Long id) { CrmCreditRatingDO exists = creditRatingMapper.selectById(id); if (exists == null) { throw exception(ErrorCodeConstants.CRM_CREDIT_RATING_NOT_EXISTS); } creditRatingMapper.deleteById(id); CrmCreditRatingDO latest = creditRatingMapper.selectLatestByCustomerId(exists.getCustomerId()); CrmCustomerDO customer = customerMapper.selectById(exists.getCustomerId()); if (customer != null) { customer.setCreditLevel(latest == null ? null : latest.getLevel()); customer.setCreditScore(latest == null ? null : latest.getScore()); customerMapper.updateById(customer); } } @Override public CrmCreditRatingRespVO getCreditRating(Long id) { CrmCreditRatingDO entity = creditRatingMapper.selectById(id); return entity == null ? null : BeanUtils.toBean(entity, CrmCreditRatingRespVO.class); } @Override public PageResult getCreditRatingPage(CrmCreditRatingPageReqVO pageReqVO) { return BeanUtils.toBean(creditRatingMapper.selectPage(pageReqVO), CrmCreditRatingRespVO.class); } @Override public List getCreditRatingList(CrmCreditRatingPageReqVO reqVO) { return BeanUtils.toBean(creditRatingMapper.selectList(reqVO), CrmCreditRatingRespVO.class); } @Override public CrmCreditRatingRespVO getLatestByCustomerId(Long customerId) { CrmCreditRatingDO entity = creditRatingMapper.selectLatestByCustomerId(customerId); return entity == null ? null : BeanUtils.toBean(entity, CrmCreditRatingRespVO.class); } @Override @Transactional(rollbackFor = Exception.class) public CrmCreditRatingImportRespVO importCreditRatingList(List importCreditRatings, CrmCreditRatingImportReqVO importReqVO) { // 1. 校验非空 importCreditRatings = filterList(importCreditRatings, item -> StrUtil.isNotBlank(item.getCustomerName())); if (CollUtil.isEmpty(importCreditRatings)) { throw exception(CRM_CREDIT_RATING_IMPORT_LIST_IS_EMPTY); } // 2. 操作人:为空则默认当前操作人 Long operatorId = importReqVO.getOperatorId() != null ? importReqVO.getOperatorId() : getLoginUserId(); // 3. 逐条处理 CrmCreditRatingImportRespVO respVO = CrmCreditRatingImportRespVO.builder() .createCreditRatingNames(new ArrayList<>()) .updateCreditRatingNames(new ArrayList<>()) .failureCreditRatingNames(new LinkedHashMap<>()) .build(); importCreditRatings.forEach(importCreditRating -> { try { // 3.1 解析客户 CrmCustomerDO customer = customerMapper.selectByCustomerName(importCreditRating.getCustomerName()); if (customer == null) { throw exception(CRM_CREDIT_RATING_IMPORT_CUSTOMER_NOT_EXISTS, importCreditRating.getCustomerName()); } // 3.2 判断该客户是否已存在评级 CrmCreditRatingDO existRating = creditRatingMapper.selectLatestByCustomerId(customer.getId()); if (existRating == null) { // 3.2.1 新增 if (StrUtil.isBlank(importCreditRating.getOperatorName())) { importCreditRating.setOperatorName(customer.getName()); } if (importCreditRating.getOperateTime() == null) { importCreditRating.setOperateTime(LocalDateTime.now()); } CrmCreditRatingDO entity = BeanUtils.toBean(importCreditRating, CrmCreditRatingDO.class, vo -> vo.setCustomerId(customer.getId()).setCustomerName(customer.getName()) .setOperatorId(operatorId)); creditRatingMapper.insert(entity); customer.setCreditLevel(entity.getLevel()); customer.setCreditScore(entity.getScore()); customerMapper.updateById(customer); respVO.getCreateCreditRatingNames().add(importCreditRating.getCustomerName()); return; } // 3.2.2 已存在,判断是否允许更新 if (!importReqVO.getUpdateSupport()) { respVO.getFailureCreditRatingNames().put(importCreditRating.getCustomerName(), StrUtil.format(CRM_CREDIT_RATING_NAME_EXISTS.getMsg(), importCreditRating.getCustomerName())); return; } CrmCreditRatingDO entity = BeanUtils.toBean(importCreditRating, CrmCreditRatingDO.class, vo -> vo.setId(existRating.getId()).setCustomerId(customer.getId()) .setCustomerName(customer.getName()).setOperatorId(operatorId)); creditRatingMapper.updateById(entity); CrmCreditRatingDO latest = creditRatingMapper.selectLatestByCustomerId(customer.getId()); if (latest != null && latest.getId().equals(entity.getId())) { customer.setCreditLevel(latest.getLevel()); customer.setCreditScore(latest.getScore()); customerMapper.updateById(customer); } respVO.getUpdateCreditRatingNames().add(importCreditRating.getCustomerName()); } catch (ServiceException ex) { respVO.getFailureCreditRatingNames().put(importCreditRating.getCustomerName(), ex.getMessage()); } }); return respVO; } }