From cc9dcfec975f6a10121be67eac6d029d159b9460 Mon Sep 17 00:00:00 2001
From: shiyunteng <shiyunteng@example.com>
Date: 星期二, 20 十月 2026 14:19:42 +0800
Subject: [PATCH] feat:长期协议,不定期新增单位,标的物 历史导入标的物,根据接口查询 石煤机乙方总公司选总公司 和 分公司 银行流水加 时间拉取 流水数据 产品加拉取按钮 盖章件关闭控制

---
 platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/BusinessCustomerServiceImpl.java |   57 +++++++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 53 insertions(+), 4 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..19e3f92 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,17 @@
 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 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;
 
 /**
  * 瀹㈠晢淇℃伅
@@ -127,6 +129,7 @@
 			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 +169,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