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/ContractSubjectMatterServiceImpl.java |  343 ++++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 327 insertions(+), 16 deletions(-)

diff --git a/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ContractSubjectMatterServiceImpl.java b/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ContractSubjectMatterServiceImpl.java
index 1e9a195..fe0192c 100644
--- a/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ContractSubjectMatterServiceImpl.java
+++ b/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ContractSubjectMatterServiceImpl.java
@@ -1,16 +1,27 @@
 package com.by4cloud.platformx.business.service.impl;
 
 import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.util.ObjUtil;
+import cn.hutool.core.util.StrUtil;
+import cn.hutool.http.HttpRequest;
+import cn.hutool.http.HttpResponse;
+import cn.hutool.http.HttpUtil;
+import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.by4cloud.platformx.admin.api.entity.SysDept;
 import com.by4cloud.platformx.admin.api.vo.DeptExcelVO;
 import com.by4cloud.platformx.business.dto.ContractSubjectMatterAddDTO;
+import com.by4cloud.platformx.business.dto.ContractSubjectMatterAnnotateDTO;
+import com.by4cloud.platformx.business.entity.Contract;
 import com.by4cloud.platformx.business.entity.ContractSubjectMatter;
 import com.by4cloud.platformx.business.entity.Product;
+import com.by4cloud.platformx.business.entity.TaxCode;
+import com.by4cloud.platformx.business.mapper.ContractMapper;
 import com.by4cloud.platformx.business.mapper.ContractSubjectMatterMapper;
 import com.by4cloud.platformx.business.mapper.ProductMapper;
+import com.by4cloud.platformx.business.mapper.TaxCodeMapper;
 import com.by4cloud.platformx.business.service.ContractSubjectMatterService;
 import com.by4cloud.platformx.business.vo.ContractSubjectMatterVo;
 import com.by4cloud.platformx.business.vo.SubjectMatterExcelVO;
@@ -21,6 +32,9 @@
 import com.by4cloud.platformx.common.security.util.SecurityUtils;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
 import lombok.RequiredArgsConstructor;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Value;
+import org.springframework.data.redis.core.StringRedisTemplate;
 import org.springframework.stereotype.Service;
 import org.springframework.validation.BindingResult;
 
@@ -37,24 +51,59 @@
  */
 @Service
 @RequiredArgsConstructor
+@Slf4j
 public class ContractSubjectMatterServiceImpl extends ServiceImpl<ContractSubjectMatterMapper, ContractSubjectMatter> implements ContractSubjectMatterService {
 
+	private final ContractMapper contractMapper;
+
 	private final ProductMapper productMapper;
+
+	private final TaxCodeMapper taxCodeMapper;
+
+	private final StringRedisTemplate redisTemplate;
+
+	@Value("${dept.smj}")
+	private String smj;
+
+	@Value("${dept.smjhw}")
+	private String smjhw;
+
+	@Value("${dept.smjsc}")
+	private String smjsc;
+
+	@Value("${dept.smjzt}")
+	private String smjzt;
+
+	@Value("${dept.sgb}")
+	private String sgb;
+
+	@Value("${dept.tfgs}")
+	private String tfgs;
+
+	@Value("${dept.jxc}")
+	private String jxc;
+
+	@Value("${dept.ymj}")
+	private String ymj;
+
+	@Value("${erp.smj}")
+	private String smjErp;
 
 	@Override
 	public R selectSubjectMatterProcess(Long id) {
 		MPJLambdaWrapper<ContractSubjectMatter> wrapper = new MPJLambdaWrapper<ContractSubjectMatter>()
 				.selectAll(ContractSubjectMatter.class)
-				.eq(ContractSubjectMatter::getContractId,id)
+				.eq(ContractSubjectMatter::getContractId, id)
 				.orderByAsc(ContractSubjectMatter::getCreateTime);
-		List<ContractSubjectMatterVo> matterVoList = baseMapper.selectJoinList(ContractSubjectMatterVo.class,wrapper);
+		List<ContractSubjectMatterVo> matterVoList = baseMapper.selectJoinList(ContractSubjectMatterVo.class, wrapper);
 		return R.ok(matterVoList);
 	}
 
 	@Override
 	public R selectSubjectMatter(Long contractId) {
-		return R.ok(baseMapper.selectListByScope(Wrappers.<ContractSubjectMatter>lambdaQuery().eq(ContractSubjectMatter::getContractId,contractId)
-				.orderByAsc(ContractSubjectMatter::getCreateTime), DataScope.of("comp_id")));
+		return R.ok(baseMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
+				.eq(ContractSubjectMatter::getContractId, contractId)
+				.orderByAsc(ContractSubjectMatter::getCreateTime)));
 	}
 
 	@Override
@@ -63,15 +112,87 @@
 		List<ContractSubjectMatterAddDTO> addDTOList = new ArrayList<>();
 		for (SubjectMatterExcelVO item : excelVOList) {
 			Set<String> errorMsg = new HashSet<>();
-
-			Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
-					.eq(Product::getErpCode, item.getMaterialCode())
-					.eq(Product::getCompId, SecurityUtils.getUser().getCompId()));
-
-			if (one == null) {
-				errorMsg.add(item.getMaterialCode()+"erp缂栫爜涓嶅瓨鍦�");
+			if (StrUtil.isBlank(item.getMaterialCode())) {
+				errorMsg.add(item.getMaterialCode() + "erp缂栫爜涓嶈兘涓虹┖");
+				// 鏁版嵁涓嶅悎娉曟儏鍐�
+				errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
+				continue;
 			}
-			if (CollUtil.isEmpty(errorMsg)) {
+			if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", tfgs) ||
+					StrUtil.equals(SecurityUtils.getUser().getCompId() + "", jxc) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", ymj)) {
+				Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
+						.eq(Product::getErpCode, item.getMaterialCode())
+						.eq(Product::getCompId, SecurityUtils.getUser().getCompId())
+						.last("limit 1"));
+				if (ObjUtil.isNull(one)) {
+					errorMsg.add(item.getMaterialCode() + "erp缂栫爜涓嶅瓨鍦�");
+					// 鏁版嵁涓嶅悎娉曟儏鍐�
+					errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
+				} else {
+					ContractSubjectMatterAddDTO addDTO = new ContractSubjectMatterAddDTO();
+					addDTO.setMaterialCode(item.getMaterialCode());
+					addDTO.setMaterialInternalName(one.getProductName());
+					addDTO.setMaterialName(item.getMaterialName());
+					addDTO.setUnitPrice(item.getUnitPrice());
+					addDTO.setQuantity(item.getQuantity());
+					addDTO.setSpecification(one.getProductType());
+					addDTOList.add(addDTO);
+				}
+			}
+
+			if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) {
+				List<String> smjList = new ArrayList<>();
+				smjList.add(smj);
+				smjList.add(smjhw);
+				Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
+						.eq(Product::getErpCode, item.getMaterialCode())
+						.in(Product::getCompId, smjList)
+						.last("limit 1"));
+				if (ObjUtil.isNull(one)) {
+					JSONObject object = syncProductBySMJ("tenant1", item.getMaterialCode());
+					if (ObjUtil.isNotNull(object)) {
+						Product productClass = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
+								.eq(Product::getProductName, object.getString("itemClassName"))
+								.eq(Product::getCompId, "2089995177814495234")
+								.last("limit 1")
+						);
+						if (ObjUtil.isNull(productClass)) {
+							log.info("浜у搧鍒嗙被锛歿}涓嶅瓨鍦�", object.getString("itemClassName"));
+							productClass = new Product();
+							productClass.setProductName(object.getString("itemClassName"));
+							productClass.setErpCode(object.getString("itemClassName"));
+							productClass.setParentId(0L);
+							productClass.setCompId(2089995177814495234L);
+							TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
+							if (ObjUtil.isNotNull(taxCode)) {
+								productClass.setTaxClass(taxCode.getSphwjc());
+								productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
+							}
+							productMapper.insert(productClass);
+							log.info("浜у搧鍒嗙被锛歿}鏂板鎴愬姛", object.getString("itemClassName"));
+						}
+
+						log.info("浜у搧锛歿}涓嶅瓨鍦�", object.getString("itemNo"));
+						Product productNew = new Product();
+						productNew.setProductName(object.getString("note"));
+						productNew.setErpCode(object.getString("itemNo"));
+						productNew.setProductType(object.getString("grade"));
+						productNew.setUnitName(object.getString("unitName"));
+						productNew.setCompId(2089995177814495234L);
+						productNew.setParentId(productClass.getId());
+						TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
+						if (ObjUtil.isNotNull(taxCode)) {
+							productClass.setTaxClass(taxCode.getSphwjc());
+							productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
+						}
+						productMapper.insert(productNew);
+						log.info("浜у搧锛歿}鏂板鎴愬姛", object.getString("itemNo"));
+					}
+					errorMsg.add(item.getMaterialCode() + "erp缂栫爜涓嶅瓨鍦�");
+					// 鏁版嵁涓嶅悎娉曟儏鍐�
+					errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
+					continue;
+				}
 				ContractSubjectMatterAddDTO addDTO = new ContractSubjectMatterAddDTO();
 				addDTO.setMaterialCode(item.getMaterialCode());
 				addDTO.setMaterialInternalName(one.getProductName());
@@ -81,16 +202,206 @@
 				addDTO.setSpecification(one.getProductType());
 				addDTOList.add(addDTO);
 			}
-			else {
-				// 鏁版嵁涓嶅悎娉曟儏鍐�
-				errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
+			if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjsc)) {
+				Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
+						.eq(Product::getErpCode, item.getMaterialCode())
+						.eq(Product::getCompId, smjsc)
+						.last("limit 1"));
+				if (ObjUtil.isNull(one)) {
+					JSONObject object = syncProductBySMJ("tenant2", item.getMaterialCode());
+					if (ObjUtil.isNotNull(object)) {
+						Product productClass = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
+								.eq(Product::getProductName, object.getString("itemClassName"))
+								.eq(Product::getCompId, "2089996921978040321")
+								.last("limit 1")
+						);
+						if (ObjUtil.isNull(productClass)) {
+							log.info("浜у搧鍒嗙被锛歿}涓嶅瓨鍦�", object.getString("itemClassName"));
+							productClass = new Product();
+							productClass.setProductName(object.getString("itemClassName"));
+							productClass.setErpCode(object.getString("itemClassName"));
+							productClass.setParentId(0L);
+							productClass.setCompId(2089996921978040321L);
+							TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
+							if (ObjUtil.isNotNull(taxCode)) {
+								productClass.setTaxClass(taxCode.getSphwjc());
+								productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
+							}
+							productMapper.insert(productClass);
+							log.info("浜у搧鍒嗙被锛歿}鏂板鎴愬姛", object.getString("itemClassName"));
+						}
+
+						log.info("浜у搧锛歿}涓嶅瓨鍦�", object.getString("itemNo"));
+						Product productNew = new Product();
+						productNew.setProductName(object.getString("note"));
+						productNew.setErpCode(object.getString("itemNo"));
+						productNew.setProductType(object.getString("grade"));
+						productNew.setUnitName(object.getString("unitName"));
+						productNew.setCompId(2089996921978040321L);
+						productNew.setParentId(productClass.getId());
+						TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
+						if (ObjUtil.isNotNull(taxCode)) {
+							productClass.setTaxClass(taxCode.getSphwjc());
+							productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
+						}
+						productMapper.insert(productNew);
+						log.info("浜у搧锛歿}鏂板鎴愬姛", object.getString("itemNo"));
+					}
+					errorMsg.add(item.getMaterialCode() + "erp缂栫爜涓嶅瓨鍦�");
+					// 鏁版嵁涓嶅悎娉曟儏鍐�
+					errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
+					continue;
+				}
+				ContractSubjectMatterAddDTO addDTO = new ContractSubjectMatterAddDTO();
+				addDTO.setMaterialCode(item.getMaterialCode());
+				addDTO.setMaterialInternalName(one.getProductName());
+				addDTO.setMaterialName(item.getMaterialName());
+				addDTO.setUnitPrice(item.getUnitPrice());
+				addDTO.setQuantity(item.getQuantity());
+				addDTO.setSpecification(one.getProductType());
+				addDTOList.add(addDTO);
+			}
+			if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjzt)) {
+				Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
+						.eq(Product::getErpCode, item.getMaterialCode())
+						.eq(Product::getCompId, smjzt)
+						.last("limit 1"));
+				if (ObjUtil.isNull(one)) {
+					JSONObject object = syncProductBySMJ("tenant3", item.getMaterialCode());
+					if (ObjUtil.isNotNull(object)) {
+						Product productClass = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
+								.eq(Product::getProductName, object.getString("itemClassName"))
+								.eq(Product::getCompId, "2089997578009128962")
+								.last("limit 1")
+						);
+						if (ObjUtil.isNull(productClass)) {
+							log.info("浜у搧鍒嗙被锛歿}涓嶅瓨鍦�", object.getString("itemClassName"));
+							productClass = new Product();
+							productClass.setProductName(object.getString("itemClassName"));
+							productClass.setErpCode(object.getString("itemClassName"));
+							productClass.setParentId(0L);
+							productClass.setCompId(2089997578009128962L);
+							TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
+							if (ObjUtil.isNotNull(taxCode)) {
+								productClass.setTaxClass(taxCode.getSphwjc());
+								productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
+							}
+							productMapper.insert(productClass);
+							log.info("浜у搧鍒嗙被锛歿}鏂板鎴愬姛", object.getString("itemClassName"));
+						}
+
+						log.info("浜у搧锛歿}涓嶅瓨鍦�", object.getString("itemNo"));
+						Product productNew = new Product();
+						productNew.setProductName(object.getString("note"));
+						productNew.setErpCode(object.getString("itemNo"));
+						productNew.setProductType(object.getString("grade"));
+						productNew.setUnitName(object.getString("unitName"));
+						productNew.setCompId(2089997578009128962L);
+						productNew.setParentId(productClass.getId());
+						TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
+						if (ObjUtil.isNotNull(taxCode)) {
+							productClass.setTaxClass(taxCode.getSphwjc());
+							productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
+						}
+						productMapper.insert(productNew);
+						log.info("浜у搧锛歿}鏂板鎴愬姛", object.getString("itemNo"));
+					}
+					errorMsg.add(item.getMaterialCode() + "erp缂栫爜涓嶅瓨鍦�");
+					// 鏁版嵁涓嶅悎娉曟儏鍐�
+					errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
+					continue;
+				}
+				ContractSubjectMatterAddDTO addDTO = new ContractSubjectMatterAddDTO();
+				addDTO.setMaterialCode(item.getMaterialCode());
+				addDTO.setMaterialInternalName(one.getProductName());
+				addDTO.setMaterialName(item.getMaterialName());
+				addDTO.setUnitPrice(item.getUnitPrice());
+				addDTO.setQuantity(item.getQuantity());
+				addDTO.setSpecification(one.getProductType());
+				addDTOList.add(addDTO);
 			}
 		}
 		if (CollUtil.isNotEmpty(errorMessageList)) {
-			return R.failed(errorMessageList,"閮ㄩ棬瀵煎叆澶辫触");
+			return R.failed(errorMessageList, "閮ㄩ棬瀵煎叆澶辫触");
 		}
 		return R.ok(addDTOList, "閮ㄩ棬瀵煎叆鎴愬姛");
 	}
+	@Override
+	public JSONObject syncProductBySMJ(String tenant1, String materialCode) {
+		String token = "";
+		if (redisTemplate.hasKey("SMJ_ERP_TOKEN")) {
+			token = (String) redisTemplate.opsForValue().get("SMJ_ERP_TOKEN");
+		} else {
+			token = getErpToken();
+		}
+		log.info("鐭崇叅鏈衡�斺��" + tenant1 + "鍚堝悓鏂板浜у搧瀵煎叆鏌ヨ鍏ュ弬锛歿}", materialCode);
+		HttpResponse response = HttpRequest.get(smjErp + "/api/item/v1/detail?itemNo=" + materialCode + "&tenantId=" + tenant1)
+				.header("token", token)       // 娣诲姞璁よ瘉澶�
+				.execute();                                         // 鎵ц璇锋眰.post(ymjErp,request.toJSONString());
+		log.info("鐭崇叅鏈衡�斺��" + tenant1 + "鍚堝悓鏂板浜у搧瀵煎叆鏌ヨ鍥炲弬锛歿}", response.body());
+		JSONObject resp = JSONObject.parseObject(response.body());
+		if (StrUtil.equals(resp.getString("code"), "0")) {
+			return resp.getJSONObject("data");
+		}
+		if (StrUtil.equals(resp.getString("code"), "401001")) {
+			getErpToken();
+		}
+		return null;
+	}
 
+	private String getErpToken() {
+		JSONObject loginJson = new JSONObject();
+		loginJson.put("username", "admin");
+		loginJson.put("password", "Zimafold@2026");
+		log.info("鐭崇叅鏈轰骇鍝佽幏鍙杢oken鍏ュ弬锛歿}", loginJson.toJSONString());
+		String loginResp = HttpUtil.post(smjErp + "/api/account/v1/login", loginJson.toJSONString());
+		log.info("鐭崇叅鏈轰骇鍝佽幏鍙杢oken鍥炲弬锛歿}", loginResp);
+		JSONObject respJson = JSONObject.parseObject(loginResp);
+		if (respJson.getInteger("code") == 0) {
+			JSONObject dataJson = JSONObject.parseObject(respJson.getString("data"));
+			redisTemplate.opsForValue().set("SMJ_ERP_TOEKN", dataJson.getString("token"));
+			log.info("鐭崇叅鏈篹rp token涓猴細{}", dataJson.getString("token"));
+			return dataJson.getString("token");
+		}
+		return "";
+	}
 
+	@Override
+	public R smjProduct(String erpCode) {
+		String token = "";
+		if (redisTemplate.hasKey("SMJ_ERP_TOKEN")) {
+			token = (String) redisTemplate.opsForValue().get("SMJ_ERP_TOKEN");
+		} else {
+			token = getErpToken();
+		}
+		log.info("鐭崇叅鏈衡�斺�攖enant1鍚堝悓鏂板浜у搧瀵煎叆鏌ヨ鍏ュ弬锛歿}", erpCode);
+		HttpResponse response = HttpRequest.get(smjErp + "/api/item/v1/detail?itemNo=" + erpCode + "&tenantId=tenant1")
+				.header("token", token)       // 娣诲姞璁よ瘉澶�
+				.execute();                                         // 鎵ц璇锋眰.post(ymjErp,request.toJSONString());
+		log.info("鐭崇叅鏈衡�斺�攖enant1鍚堝悓鏂板浜у搧瀵煎叆鏌ヨ鍥炲弬锛歿}", response.body());
+		return R.ok(response.body());
+	}
+
+	@Override
+	public R annotate(List<ContractSubjectMatterAnnotateDTO> annotateDTOList) {
+		if (CollUtil.isNotEmpty(annotateDTOList)){
+			Long contractId = annotateDTOList.get(0).getContractId();
+			annotateDTOList.stream().forEach(annotateDTO->{
+				ContractSubjectMatter subjectMatter = baseMapper.selectById(annotateDTO.getId());
+				subjectMatter.setProductSection(annotateDTO.getProductSection());
+				subjectMatter.setBusinessProject(annotateDTO.getBusinessProject());
+				subjectMatter.setProductCategory(annotateDTO.getProductCategory());
+				baseMapper.updateById(subjectMatter);
+			});
+			List<ContractSubjectMatter> subjectMatterList = baseMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
+					.eq(ContractSubjectMatter::getContractId,contractId)
+					.and(wrapper -> wrapper.isNull(ContractSubjectMatter::getProductSection)
+							.or().isNull(ContractSubjectMatter::getBusinessProject)
+							.or().isNull(ContractSubjectMatter::getProductCategory)));
+			if (CollUtil.isEmpty(subjectMatterList)){
+				contractMapper.update(Wrappers.<Contract>lambdaUpdate().eq(Contract::getId,contractId).set(Contract::getAnnotateFlag,"1"));
+			}
+		}
+		return R.ok();
+	}
 }
\ No newline at end of file

--
Gitblit v1.9.1