From c5ea85558fea4d82b5368073c598a30f905c4bdc Mon Sep 17 00:00:00 2001
From: shiyunteng <shiyunteng@example.com>
Date: 星期五, 23 十月 2026 17:11:49 +0800
Subject: [PATCH] feat:新增统计标注功能

---
 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..d901caa 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.selectBaseInfoByCustName(excelVO.getCompanyName());
+					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