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 | 391 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 391 insertions(+), 0 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 43c9c85..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,10 +1,48 @@
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;
+import com.by4cloud.platformx.common.core.util.R;
+import com.by4cloud.platformx.common.data.datascope.DataScope;
+import com.by4cloud.platformx.common.data.mybatis.BaseModel;
+import com.by4cloud.platformx.common.excel.vo.ErrorMessage;
+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;
+
+import java.util.ArrayList;
+import java.util.HashSet;
+import java.util.List;
+import java.util.Set;
+
/**
* 鍚堝悓鏍囩殑鐗╂槑缁嗚〃
*
@@ -12,5 +50,358 @@
* @date 2026-04-29 16:39:29
*/
@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)
+ .orderByAsc(ContractSubjectMatter::getCreateTime);
+ List<ContractSubjectMatterVo> matterVoList = baseMapper.selectJoinList(ContractSubjectMatterVo.class, wrapper);
+ return R.ok(matterVoList);
+ }
+
+ @Override
+ public R selectSubjectMatter(Long contractId) {
+ return R.ok(baseMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
+ .eq(ContractSubjectMatter::getContractId, contractId)
+ .orderByAsc(ContractSubjectMatter::getCreateTime)));
+ }
+
+ @Override
+ public R importSubjectMatter(List<SubjectMatterExcelVO> excelVOList, BindingResult bindingResult) {
+ List<ErrorMessage> errorMessageList = (List<ErrorMessage>) bindingResult.getTarget();
+ List<ContractSubjectMatterAddDTO> addDTOList = new ArrayList<>();
+ for (SubjectMatterExcelVO item : excelVOList) {
+ Set<String> errorMsg = new HashSet<>();
+ if (StrUtil.isBlank(item.getMaterialCode())) {
+ errorMsg.add(item.getMaterialCode() + "erp缂栫爜涓嶈兘涓虹┖");
+ // 鏁版嵁涓嶅悎娉曟儏鍐�
+ errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
+ continue;
+ }
+ 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());
+ 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() + "", 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.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