From 145580fd820bb31334f2e71643413e846b7ce904 Mon Sep 17 00:00:00 2001
From: shiyunteng <shiyunteng@example.com>
Date: 星期五, 30 十月 2026 15:53:20 +0800
Subject: [PATCH] feat:统计内容1-8页
---
platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/BusinessCustomerServiceImpl.java | 62 ++++++++++++++++++++++++++++--
1 files changed, 57 insertions(+), 5 deletions(-)
diff --git a/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/BusinessCustomerServiceImpl.java b/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/BusinessCustomerServiceImpl.java
index fe543dc..39da843 100644
--- a/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/BusinessCustomerServiceImpl.java
+++ b/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/BusinessCustomerServiceImpl.java
@@ -1,5 +1,6 @@
package com.by4cloud.platformx.business.service.impl;
+import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.util.ObjUtil;
@@ -12,16 +13,18 @@
import com.by4cloud.platformx.business.mapper.BipViewMapper;
import com.by4cloud.platformx.business.mapper.BusinessCustomerMapper;
import com.by4cloud.platformx.business.service.BusinessCustomerService;
-import com.by4cloud.platformx.business.vo.BankNameVo;
-import com.by4cloud.platformx.business.vo.BusinessCustomerMainVo;
-import com.by4cloud.platformx.business.vo.CustBankVo;
-import com.by4cloud.platformx.business.vo.CustInfoVo;
+import com.by4cloud.platformx.business.vo.*;
import com.by4cloud.platformx.common.core.util.R;
+import com.by4cloud.platformx.common.excel.vo.ErrorMessage;
+import com.by4cloud.platformx.common.security.util.SecurityUtils;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
+import org.springframework.validation.BindingResult;
+import java.util.HashSet;
import java.util.List;
+import java.util.Set;
/**
* 瀹㈠晢淇℃伅
@@ -122,11 +125,14 @@
return R.failed("瀹㈠晢鍚嶇О鎴栫ぞ浼氫俊鐢ㄤ唬鐮佷笉鑳戒负绌�");
}
BusinessCustomer bc = baseMapper.selectOne(Wrappers.<BusinessCustomer>lambdaQuery().eq(BusinessCustomer::getCompanyName,addDTO.getCompanyName())
- .eq(BusinessCustomer::getCreditCode,addDTO.getCreditCode()).last("limit 1"));
+ .eq(BusinessCustomer::getCreditCode,addDTO.getCreditCode())
+ .eq(BusinessCustomer::getCompId, SecurityUtils.getUser().getCompId())
+ .last("limit 1"));
if (ObjUtil.isNotNull(bc)){
return R.failed("瀹㈠晢宸插瓨鍦�");
}
BusinessCustomer customer = new BusinessCustomer();
+ customer.setErpCompanyCode(addDTO.getErpCompanyCode());
log.info("涓绘暟鎹煡璇}淇℃伅",addDTO.getCompanyName());
CustInfoVo custInfo = bipViewMapper.selectBaseInfoByCustName(addDTO.getCompanyName());
if (ObjUtil.isNotNull(custInfo)){
@@ -166,4 +172,50 @@
}
return R.failed("涓绘暟鎹鍟嗕俊鎭笉瀛樺湪");
}
+
+ @Override
+ public R importBusinessCustomer(List<BusinessCustomerImportVo> excelVOList, BindingResult bindingResult) {
+ List<ErrorMessage> errorMessageList = (List<ErrorMessage>) bindingResult.getTarget();
+ if (CollUtil.isNotEmpty(excelVOList)) {
+ Long line = 0L;
+ for (BusinessCustomerImportVo excelVO : excelVOList
+ ) {
+ Set<String> errorMsg = new HashSet<>();
+ if (StrUtil.isBlank(excelVO.getCreditCode())||StrUtil.isBlank(excelVO.getErpCompanyCode())){
+ errorMsg.add(excelVO.getCompanyName()+"绀句細淇$敤浠g爜鎴朎RP瀹㈡埛缂栫爜涓嶈兘涓虹┖");
+ errorMessageList.add(new ErrorMessage(line++, errorMsg));
+ continue;
+ }
+ BusinessCustomer customer = baseMapper.selectOne(Wrappers.<BusinessCustomer>lambdaQuery()
+ .eq(BusinessCustomer::getCreditCode, excelVO.getCreditCode())
+ .last("limit 1"));
+ if (ObjUtil.isNull(customer)) {
+ customer = BeanUtil.copyProperties(excelVO, BusinessCustomer.class);
+ CustInfoVo custInfo = bipViewMapper.selectBaseInfoByCertId(excelVO.getCreditCode());
+ if (ObjUtil.isNotNull(custInfo)) {
+ customer.setCreditCode(custInfo.getCertificateId());
+ customer.setRegisterName(custInfo.getCustName());
+ customer.setLegalPerson(custInfo.getLegalPerson());
+ customer.setAddress(custInfo.getRegistrationAddress());
+ customer.setProvince(customer.getCreditCode().substring(2, 4));
+ customer.setInvoiceType("01");
+ log.info("{}涓绘暟鎹煡璇㈠悕绉般�佹硶浜恒�佸湴鍧�銆佷俊鐢ㄧ爜淇℃伅鎴愬姛", excelVO.getCompanyName());
+ List<CustBankVo> bankVoList = bipViewMapper.selectBankByCustName(excelVO.getCompanyName());
+ if (CollUtil.isNotEmpty(bankVoList)) {
+ customer.setBankAccount(bankVoList.get(0).getBankAccount());
+ log.info("{}涓绘暟鎹煡璇㈤摱琛屽崱鍙蜂俊鎭垚鍔�", excelVO.getCompanyName());
+ List<BankNameVo> bankNameVoList = bipBanklViewMapper.selectBankByCode(bankVoList.get(0).getBankName());
+ if (CollUtil.isNotEmpty(bankNameVoList)) {
+ customer.setBankName(bankNameVoList.get(0).getBankNameName());
+ log.info("{}涓绘暟鎹煡璇㈤摱琛屽悕绉颁俊鎭垚鍔�", excelVO.getCompanyName());
+ }
+ }
+ customer.setRegisterName(custInfo.getCustName());
+ baseMapper.insert(customer);
+ }
+ }
+ }
+ }
+ return R.ok();
+ }
}
\ No newline at end of file
--
Gitblit v1.9.1