platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ContractSubjectMatterServiceImpl.java
@@ -1,6 +1,12 @@
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;
@@ -9,8 +15,10 @@
import com.by4cloud.platformx.business.dto.ContractSubjectMatterAddDTO;
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.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 +29,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,9 +48,41 @@
 */
@Service
@RequiredArgsConstructor
@Slf4j
public class ContractSubjectMatterServiceImpl extends ServiceImpl<ContractSubjectMatterMapper, ContractSubjectMatter> implements ContractSubjectMatterService {
   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) {
@@ -53,8 +96,9 @@
   @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,16 +107,23 @@
      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 (one == null) {
            if (ObjUtil.isNull(one)) {
            errorMsg.add(item.getMaterialCode()+"erp编码不存在");
         }
         if (CollUtil.isEmpty(errorMsg)) {
               // 数据不合法情况
               errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
            } else {
            ContractSubjectMatterAddDTO addDTO = new ContractSubjectMatterAddDTO();
            addDTO.setMaterialCode(item.getMaterialCode());
            addDTO.setMaterialInternalName(one.getProductName());
@@ -82,9 +133,187 @@
            addDTO.setSpecification(one.getProductType());
            addDTOList.add(addDTO);
         }
         else {
         }
         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)) {
@@ -92,6 +321,59 @@
      }
      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("石煤机产品获取token入参:{}", loginJson.toJSONString());
      String loginResp = HttpUtil.post(smjErp + "/api/account/v1/login", loginJson.toJSONString());
      log.info("石煤机产品获取token回参:{}", 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("石煤机erp 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("石煤机——tenant1合同新增产品导入查询入参:{}", erpCode);
      HttpResponse response = HttpRequest.get(smjErp + "/api/item/v1/detail?itemNo=" + erpCode + "&tenantId=tenant1")
            .header("token", token)       // 添加认证头
            .execute();                                         // 执行请求.post(ymjErp,request.toJSONString());
      log.info("石煤机——tenant1合同新增产品导入查询回参:{}", response.body());
      return R.ok(response.body());
   }
}