shiyunteng
2026-10-23 c5ea85558fea4d82b5368073c598a30f905c4bdc
platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ProductServiceImpl.java
@@ -13,6 +13,7 @@
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.by4cloud.platformx.business.dto.ProductAddDTO;
import com.by4cloud.platformx.business.dto.ProductQueryDTO;
@@ -33,6 +34,7 @@
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;
@@ -56,10 +58,42 @@
   private final TaxCodeMapper taxCodeMapper;
   private final StringRedisTemplate redisTemplate;
   @Value("${erp.smj}")
   private String smjErp;
    @Override
   @Value("${erp.smjsc}")
   private String smjscErp;
   @Value("${erp.smjzt}")
   private String smjztErp;
   @Value("${dept.smj}")
   private String smj;
   @Value("${dept.smjsc}")
   private String smjsc;
   @Value("${dept.smjzt}")
   private String smjzt;
   @Value("${dept.smjhw}")
   private String smjhw;
   @Override
   public Page pageScope(Page page, Product product) {
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) {
         List<String> smjList = new ArrayList<>();
         smjList.add(smj);
         smjList.add(smjhw);
         return baseMapper.page(page,product,smjList);
      }
      return baseMapper.pageScope(page,product,DataScope.of("comp_id"));
   }
   @Override
    public List<Tree<Long>> treeList() {
        List<TreeNode<Long>> collect = baseMapper
                .selectListByScope(Wrappers.<Product>lambdaQuery()
@@ -126,9 +160,12 @@
//              .eq(StrUtil.isNotEmpty(queryDTO.getParentId()),Product::getParentId,queryDTO.getParentId())
//            .in(StrUtil.isNotEmpty(queryDTO.getContractCategory())&&StrUtil.equals(queryDTO.getContractCategory(), "water_house"),
//                  Product::getErpCode,erpCodes);
      if (StrUtil.isNotBlank(queryDTO.getProductIds())){
         String[] arr = queryDTO.getProductIds().split(",");
         queryDTO.setProductId(Arrays.stream(arr).collect(Collectors.toList()));
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId()+"","2089995177814495234")||
            StrUtil.equals(SecurityUtils.getUser().getCompId()+"","2089996921978040321")||
            StrUtil.equals(SecurityUtils.getUser().getCompId()+"","2089997578009128962")){
            StrUtil.equals(SecurityUtils.getUser().getCompId()+"","2101966257365045249")){
         List<ProductSelectVo> selectVos = baseMapper.getProductSMJListByParentId(queryDTO, Arrays.asList(erpCodes));
         if (selectVos.size()>2000){
            return R.ok(selectVos.subList(0,1999));
@@ -147,6 +184,9 @@
      if (CollUtil.isNotEmpty(addDTOS)){
         for (ProductAddDTO addDTO:addDTOS
             ) {
            if (StrUtil.isBlank(addDTO.getErpCode())){
               return R.failed("erp编码不能为空");
            }
            List<Product> classPro = baseMapper.selectListByScope(Wrappers.<Product>lambdaQuery()
                        .eq(StrUtil.isNotEmpty(addDTO.getErpTypeCode()),Product::getErpCode,addDTO.getErpTypeCode())
                        .eq(StrUtil.isNotEmpty(addDTO.getErpTypeName()),Product::getProductName,addDTO.getErpTypeName())
@@ -160,27 +200,32 @@
               product.setErpCode(addDTO.getErpTypeCode());
               TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,addDTO.getTaxCode()).last("limit 1"));
               if (ObjUtil.isNotNull(taxCode)){
                  product.setTaxClass(taxCode.getMc());
                  product.setTaxClass(taxCode.getSphwjc());
                  product.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
               }
               baseMapper.insert(product);
               classPro.add(product);
            }
            Product product = new Product();
            product.setProductName(addDTO.getErpName());
            product.setProductType(addDTO.getSpecification());
            product.setParentId(classPro.get(0).getId());
            product.setParentName(classPro.get(0).getProductName());
            product.setErpCode(addDTO.getErpCode());
            TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,addDTO.getTaxCode()).last("limit 1"));
            if (ObjUtil.isNotNull(taxCode)){
               product.setTaxClass(taxCode.getMc());
               product.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
            List<Product> productList = baseMapper.selectListByScope(Wrappers.<Product>lambdaQuery()
                        .eq(StrUtil.isNotEmpty(addDTO.getErpCode()),Product::getErpCode,addDTO.getErpCode())
                  , DataScope.of("comp_id"));
            if (CollUtil.isEmpty(productList)){
               Product product = new Product();
               product.setProductName(addDTO.getErpName());
               product.setProductType(addDTO.getSpecification());
               product.setParentId(classPro.get(0).getId());
               product.setParentName(classPro.get(0).getProductName());
               product.setErpCode(addDTO.getErpCode());
               TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,addDTO.getTaxCode()).last("limit 1"));
               if (ObjUtil.isNotNull(taxCode)){
                  product.setTaxClass(taxCode.getSphwjc());
                  product.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
               }
               baseMapper.insert(product);
            }
            baseMapper.insert(product);
         }
      }
      return R.ok();
      return R.failed("数据为空");
   }
   @Override
@@ -214,7 +259,7 @@
                     product.setErpCode(addDTO.getErpTypeCode());
                     TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,addDTO.getTaxCode()).last("limit 1"));
                     if (ObjUtil.isNotNull(taxCode)){
                        product.setTaxClass(taxCode.getMc());
                        product.setTaxClass(taxCode.getSphwjc());
                        product.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
                     }
                     baseMapper.insert(product);
@@ -228,7 +273,7 @@
                  product.setErpCode(addDTO.getErpCode());
                  TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,addDTO.getTaxCode()).last("limit 1"));
                  if (ObjUtil.isNotNull(taxCode)){
                     product.setTaxClass(taxCode.getMc());
                     product.setTaxClass(taxCode.getSphwjc());
                     product.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
                  }
                  baseMapper.insert(product);
@@ -265,6 +310,108 @@
      }else {
         startDate = dto.getStartDate();
      }
      String token = "";
      if (redisTemplate.hasKey("SMJ_ERP_TOKEN")) {
         token = (String) redisTemplate.opsForValue().get("SMJ_ERP_TOKEN");
      } else {
         token = getErpToken();
      }
      if (StrUtil.isEmpty(token)){
         return R.failed("石煤机登录获取token失败");
      }
      List<String> list = Arrays.asList("tenant1","tenant2","tenant3");
      for (int i = 0; i < list.size(); i++) {
         String tan = list.get(i);
         HttpResponse response = HttpRequest.get(smjErp + "/api/item/v1/byDateCre?startDate=" + startDate+"&tenantId="+tan)
               .header("token", token)       // 添加认证头
               .execute();                                         // 执行请求.post(ymjErp,request.toJSONString());
         log.info("石煤机——"+tan+"产品获取回参:{}", response.body());
         JSONObject proResult = JSONObject.parseObject(response.body());
         JSONArray items = proResult.getJSONArray("data");
         if (CollUtil.isNotEmpty(items)){
            log.info("石煤机产品获取数量:{}", items.size());
            items.stream().forEach(item->{
               JSONObject product = (JSONObject) item;
               Product productClass = baseMapper.selectOne(Wrappers.<Product>lambdaQuery()
                     .eq(Product::getProductName,product.getString("itemClassName"))
//                     .and(wrapper -> wrapper.eq(Product::getCompId,"2089995177814495234")
//                           .or().eq(Product::getCompId,"2089996921978040321")
//                           .or().eq(Product::getCompId,"2089997578009128962")
//                     )
                     .eq(StrUtil.equals(tan,"tenant1"),Product::getCompId,"2089995177814495234")
                     .eq(StrUtil.equals(tan,"tenant2"),Product::getCompId,"2089996921978040321")
                     .eq(StrUtil.equals(tan,"tenant3"),Product::getCompId,"2089997578009128962")
                     .last("limit 1")
               );
               if(ObjUtil.isNull(productClass)){
                  log.info("产品分类:{}不存在",product.getString("itemClassName"));
                  productClass = new Product();
                  productClass.setProductName(product.getString("itemClassName"));
                  productClass.setErpCode(product.getString("itemClassName"));
                  productClass.setParentId(0L);
                  if(StrUtil.equals(tan,"tenant1")){
                     productClass.setCompId(2089995177814495234L);
                  }
                  if(StrUtil.equals(tan,"tenant2")){
                     productClass.setCompId(2089996921978040321L);
                  }
                  if(StrUtil.equals(tan,"tenant3")){
                     productClass.setCompId(2089997578009128962L);
                  }
                  TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,product.getString("tfTaxClass")).last("limit 1"));
                  if (ObjUtil.isNotNull(taxCode)){
                     productClass.setTaxClass(taxCode.getSphwjc());
                     productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
                  }
                  baseMapper.insert(productClass);
                  log.info("产品分类:{}新增成功",product.getString("itemClassName"));
               }
               Product productNew = baseMapper.selectOne(Wrappers.<Product>lambdaQuery()
                     .eq(Product::getErpCode,product.getString("itemNo"))
//                     .and(wrapper -> wrapper.eq(Product::getCompId,"2089995177814495234")
//                           .or().eq(Product::getCompId,"2089996921978040321")
//                           .or().eq(Product::getCompId,"2089997578009128962")
//                     )
                     .eq(StrUtil.equals(tan,"tenant1"),Product::getCompId,"2089995177814495234")
                     .eq(StrUtil.equals(tan,"tenant2"),Product::getCompId,"2089996921978040321")
                     .eq(StrUtil.equals(tan,"tenant3"),Product::getCompId,"2089997578009128962")
                     .last("limit 1")
               );
               if(ObjUtil.isNull(productNew)){
                  log.info("产品:{}不存在",product.getString("itemNo"));
                  productNew = new Product();
                  productNew.setProductName(product.getString("note"));
                  productNew.setErpCode(product.getString("itemNo"));
                  productNew.setProductType(product.getString("grade"));
                  productNew.setUnitName(product.getString("unitName"));
                  if(StrUtil.equals(tan,"tenant1")){
                     productNew.setCompId(2089995177814495234L);
                  }
                  if(StrUtil.equals(tan,"tenant2")){
                     productNew.setCompId(2089996921978040321L);
                  }
                  if(StrUtil.equals(tan,"tenant3")){
                     productNew.setCompId(2089997578009128962L);
                  }
                  productNew.setParentId(productClass.getId());
                  TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,product.getString("tfTaxClass")).last("limit 1"));
                  if (ObjUtil.isNotNull(taxCode)){
                     productNew.setTaxClass(taxCode.getSphwjc());
                     productNew.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
                  }
                  baseMapper.insert(productNew);
                  log.info("产品:{}新增成功",product.getString("itemNo"));
                  return;
               }
               log.info("产品:{}存在",product.getString("itemNo"));
            });
         }
      }
      return R.ok();
   }
   private String getErpToken() {
      JSONObject loginJson = new JSONObject();
      loginJson.put("username", "admin");
      loginJson.put("password", "Zimafold@2026");
@@ -274,56 +421,270 @@
      JSONObject respJson = JSONObject.parseObject(loginResp);
      if (respJson.getInteger("code") == 0) {
         JSONObject dataJson = JSONObject.parseObject(respJson.getString("data"));
         HttpResponse response = HttpRequest.get(smjErp + "/api/item/v1/byDateCre?startDate=" + startDate)
               .header("token", dataJson.getString("token"))       // 添加认证头
               .execute();                                         // 执行请求.post(ymjErp,request.toJSONString());
         log.info("石煤机产品获取回参:{}", response.body());
         JSONObject proResult = JSONObject.parseObject(response.body());
         JSONArray items = proResult.getJSONArray("data");
         if (CollUtil.isNotEmpty(items)){
            log.info("石煤机产品获取数量:{}", items.size());
            items.stream().forEach(item->{
               JSONObject product = (JSONObject) item;
               Product productClass = baseMapper.selectOne(Wrappers.<Product>lambdaQuery()
                     .eq(Product::getProductName,product.getString("itemClassName"))
                     .and(wrapper -> wrapper.eq(Product::getCompId,"2089995177814495234")
                           .or().eq(Product::getCompId,"2089996921978040321")
                           .or().eq(Product::getCompId,"2089997578009128962")
                           )
                     .last("limit 1")
               );
               if(ObjUtil.isNull(productClass)){
                  log.info("产品分类:{}不存在",product.getString("itemClassName"));
                  productClass = new Product();
                  productClass.setProductName(product.getString("itemClassName"));
                  productClass.setErpCode(product.getString("itemClassName"));
                  productClass.setParentId(0L);
         redisTemplate.opsForValue().set("SMJ_ERP_TOEKN",dataJson.getString("token"));
         log.info("石煤机erp token为:{}",dataJson.getString("token"));
         return dataJson.getString("token");
      }
      return "";
   }
   @Override
   public R pullProductData() {
      String startDate = DateUtil.formatDate(DateUtil.offsetDay(new Date(), -1));
      String token = "";
      if (redisTemplate.hasKey("SMJ_ERP_TOKEN")) {
         token = (String) redisTemplate.opsForValue().get("SMJ_ERP_TOKEN");
      } else {
         token = getErpToken();
      }
      if (StrUtil.isEmpty(token)){
         return R.failed("石煤机登录获取token失败");
      }
      List<String> list = Arrays.asList("tenant1","tenant2","tenant3");
      String tan = "";
      if (StrUtil.equals(smj,SecurityUtils.getUser().getCompId()+"")||StrUtil.equals(smjhw,SecurityUtils.getUser().getCompId()+"")){
         tan = "tenant1";
      }
      if (StrUtil.equals(smjsc,SecurityUtils.getUser().getCompId()+"")){
         tan = "tenant2";
      }
      if (StrUtil.equals(smjzt,SecurityUtils.getUser().getCompId()+"")){
         tan = "tenant3";
      }
      if (StrUtil.isBlank(tan)){
         return R.failed("帐号信息异常请联系技术人员");
      }
      HttpResponse response = HttpRequest.get(smjErp + "/api/item/v1/byDateCre?startDate=" + startDate+"&tenantId="+tan)
            .header("token", token)       // 添加认证头
            .execute();                                         // 执行请求.post(ymjErp,request.toJSONString());
      log.info("石煤机——"+tan+"产品获取回参:{}", response.body());
      JSONObject proResult = JSONObject.parseObject(response.body());
      JSONArray items = proResult.getJSONArray("data");
      if (CollUtil.isNotEmpty(items)){
         log.info("石煤机产品获取数量:{}", items.size());
         String finalTan = tan;
         items.stream().forEach(item->{
            JSONObject product = (JSONObject) item;
            Product productClass = baseMapper.selectOne(Wrappers.<Product>lambdaQuery()
                        .eq(Product::getProductName,product.getString("itemClassName"))
//                     .and(wrapper -> wrapper.eq(Product::getCompId,"2089995177814495234")
//                           .or().eq(Product::getCompId,"2089996921978040321")
//                           .or().eq(Product::getCompId,"2089997578009128962")
//                     )
                        .eq(StrUtil.equals(finalTan,"tenant1"),Product::getCompId,"2089995177814495234")
                        .eq(StrUtil.equals(finalTan,"tenant2"),Product::getCompId,"2089996921978040321")
                        .eq(StrUtil.equals(finalTan,"tenant3"),Product::getCompId,"2089997578009128962")
                        .last("limit 1")
            );
            if(ObjUtil.isNull(productClass)){
               log.info("产品分类:{}不存在",product.getString("itemClassName"));
               productClass = new Product();
               productClass.setProductName(product.getString("itemClassName"));
               productClass.setErpCode(product.getString("itemClassName"));
               productClass.setParentId(0L);
               if(StrUtil.equals(finalTan,"tenant1")){
                  productClass.setCompId(2089995177814495234L);
                  baseMapper.insert(productClass);
                  log.info("产品分类:{}新增成功",product.getString("itemClassName"));
               }
               Product productNew = baseMapper.selectOne(Wrappers.<Product>lambdaQuery()
                     .eq(Product::getErpCode,product.getString("itemNo"))
                     .and(wrapper -> wrapper.eq(Product::getCompId,"2089995177814495234")
                           .or().eq(Product::getCompId,"2089996921978040321")
                           .or().eq(Product::getCompId,"2089997578009128962")
                     )
                     .last("limit 1")
               );
               if(ObjUtil.isNull(productNew)){
                  log.info("产品:{}不存在",product.getString("itemNo"));
                  productNew = new Product();
                  productNew.setProductName(product.getString("note"));
                  productNew.setErpCode(product.getString("itemNo"));
                  productNew.setProductType(product.getString("grade"));
               if(StrUtil.equals(finalTan,"tenant2")){
                  productClass.setCompId(2089996921978040321L);
               }
               if(StrUtil.equals(finalTan,"tenant3")){
                  productClass.setCompId(2089997578009128962L);
               }
               TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,product.getString("tfTaxClass")).last("limit 1"));
               if (ObjUtil.isNotNull(taxCode)){
                  productClass.setTaxClass(taxCode.getSphwjc());
                  productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
               }
               baseMapper.insert(productClass);
               log.info("产品分类:{}新增成功",product.getString("itemClassName"));
            }
            Product productNew = baseMapper.selectOne(Wrappers.<Product>lambdaQuery()
                        .eq(Product::getErpCode,product.getString("itemNo"))
//                     .and(wrapper -> wrapper.eq(Product::getCompId,"2089995177814495234")
//                           .or().eq(Product::getCompId,"2089996921978040321")
//                           .or().eq(Product::getCompId,"2089997578009128962")
//                     )
                        .eq(StrUtil.equals(finalTan,"tenant1"),Product::getCompId,"2089995177814495234")
                        .eq(StrUtil.equals(finalTan,"tenant2"),Product::getCompId,"2089996921978040321")
                        .eq(StrUtil.equals(finalTan,"tenant3"),Product::getCompId,"2089997578009128962")
                        .last("limit 1")
            );
            if(ObjUtil.isNull(productNew)){
               log.info("产品:{}不存在",product.getString("itemNo"));
               productNew = new Product();
               productNew.setProductName(product.getString("note"));
               productNew.setErpCode(product.getString("itemNo"));
               productNew.setProductType(product.getString("grade"));
               productNew.setUnitName(product.getString("unitName"));
               if(StrUtil.equals(finalTan,"tenant1")){
                  productNew.setCompId(2089995177814495234L);
                  productNew.setParentId(productClass.getId());
                  baseMapper.insert(productNew);
                  log.info("产品:{}新增成功",product.getString("itemNo"));
                  return;
               }
               log.info("产品:{}存在",product.getString("itemNo"));
            });
               if(StrUtil.equals(finalTan,"tenant2")){
                  productNew.setCompId(2089996921978040321L);
               }
               if(StrUtil.equals(finalTan,"tenant3")){
                  productNew.setCompId(2089997578009128962L);
               }
               productNew.setParentId(productClass.getId());
               TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,product.getString("tfTaxClass")).last("limit 1"));
               if (ObjUtil.isNotNull(taxCode)){
                  productNew.setTaxClass(taxCode.getSphwjc());
                  productNew.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
               }
               baseMapper.insert(productNew);
               log.info("产品:{}新增成功",product.getString("itemNo"));
               return;
            }
            log.info("产品:{}存在",product.getString("itemNo"));
         });
      }
      return R.ok();
   }
   @Override
   public R pullProductPage() {
      String token = "";
      if (redisTemplate.hasKey("SMJ_ERP_TOKEN")) {
         token = (String) redisTemplate.opsForValue().get("SMJ_ERP_TOKEN");
      } else {
         token = getErpToken();
      }
      if (StrUtil.isEmpty(token)){
         return R.failed("石煤机登录获取token失败");
      }
      List<String> list = Arrays.asList("tenant1","tenant2","tenant3");
      String tan = "";
      if (StrUtil.equals(smj,SecurityUtils.getUser().getCompId()+"")||StrUtil.equals(smjhw,SecurityUtils.getUser().getCompId()+"")){
         tan = "tenant1";
      }
      if (StrUtil.equals(smjsc,SecurityUtils.getUser().getCompId()+"")){
         tan = "tenant2";
      }
      if (StrUtil.equals(smjzt,SecurityUtils.getUser().getCompId()+"")){
         tan = "tenant3";
      }
      if (StrUtil.isBlank(tan)){
         return R.failed("帐号信息异常请联系技术人员");
      }
      JSONObject req = new JSONObject();
      req.put("page","1");
      req.put("size","100");
      HttpResponse response = HttpRequest.post(smjErp + "/api/item/v1/queryPage?tenantId="+tan)
            .header("token", token)   // 添加认证头
            .body(req.toJSONString())
            .execute();                                         // 执行请求.post(ymjErp,request.toJSONString());
      log.info("石煤机——"+tan+"产品获取回参:{}", response.body());
      JSONObject proResult = JSONObject.parseObject(response.body());
      JSONObject data = proResult.getJSONObject("data");
      if (ObjUtil.isNotNull(data)&&data.containsKey("pages")){
         Integer pages = data.getInteger("pages");
         for (int i = 1; i < pages+1; i++) {
            JSONObject reqPage = new JSONObject();
            reqPage.put("page",i);
            reqPage.put("size","100");
            HttpResponse responsePage = HttpRequest.post(smjErp + "/api/item/v1/queryPage?tenantId="+tan)
                  .header("token", token)   // 添加认证头
                  .body(req.toJSONString())
                  .execute();                                         // 执行请求.post(ymjErp,request.toJSONString());
            log.info("石煤机——"+tan+"产品获取回参:{}", responsePage.body());
            JSONObject pageResult = JSONObject.parseObject(response.body());
            JSONObject dataPage = pageResult.getJSONObject("data");
            if (ObjUtil.isNotNull(data)&&dataPage.containsKey("records")&&CollUtil.isNotEmpty(dataPage.getJSONArray("records"))){
               if (CollUtil.isNotEmpty(dataPage.getJSONArray("records"))){
                  log.info("石煤机产品获取数量:{}", dataPage.getJSONArray("records").size());
                  String finalTan = tan;
                  dataPage.getJSONArray("records").stream().forEach(item->{
                     JSONObject product = (JSONObject) item;
                     Product productClass = baseMapper.selectOne(Wrappers.<Product>lambdaQuery()
                                 .eq(Product::getProductName,product.getString("itemClassName"))
//                     .and(wrapper -> wrapper.eq(Product::getCompId,"2089995177814495234")
//                           .or().eq(Product::getCompId,"2089996921978040321")
//                           .or().eq(Product::getCompId,"2089997578009128962")
//                     )
                                 .eq(StrUtil.equals(finalTan,"tenant1"),Product::getCompId,"2089995177814495234")
                                 .eq(StrUtil.equals(finalTan,"tenant2"),Product::getCompId,"2089996921978040321")
                                 .eq(StrUtil.equals(finalTan,"tenant3"),Product::getCompId,"2089997578009128962")
                                 .last("limit 1")
                     );
                     if(ObjUtil.isNull(productClass)){
                        log.info("产品分类:{}不存在",product.getString("itemClassName"));
                        productClass = new Product();
                        productClass.setProductName(product.getString("itemClassName"));
                        productClass.setErpCode(product.getString("itemClassName"));
                        productClass.setParentId(0L);
                        if(StrUtil.equals(finalTan,"tenant1")){
                           productClass.setCompId(2089995177814495234L);
                        }
                        if(StrUtil.equals(finalTan,"tenant2")){
                           productClass.setCompId(2089996921978040321L);
                        }
                        if(StrUtil.equals(finalTan,"tenant3")){
                           productClass.setCompId(2089997578009128962L);
                        }
                        TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,product.getString("tfTaxClass")).last("limit 1"));
                        if (ObjUtil.isNotNull(taxCode)){
                           productClass.setTaxClass(taxCode.getSphwjc());
                           productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
                        }
                        baseMapper.insert(productClass);
                        log.info("产品分类:{}新增成功",product.getString("itemClassName"));
                     }
                     Product productNew = baseMapper.selectOne(Wrappers.<Product>lambdaQuery()
                                 .eq(Product::getErpCode,product.getString("itemNo"))
//                     .and(wrapper -> wrapper.eq(Product::getCompId,"2089995177814495234")
//                           .or().eq(Product::getCompId,"2089996921978040321")
//                           .or().eq(Product::getCompId,"2089997578009128962")
//                     )
                                 .eq(StrUtil.equals(finalTan,"tenant1"),Product::getCompId,"2089995177814495234")
                                 .eq(StrUtil.equals(finalTan,"tenant2"),Product::getCompId,"2089996921978040321")
                                 .eq(StrUtil.equals(finalTan,"tenant3"),Product::getCompId,"2089997578009128962")
                                 .last("limit 1")
                     );
                     if(ObjUtil.isNull(productNew)){
                        log.info("产品:{}不存在",product.getString("itemNo"));
                        productNew = new Product();
                        productNew.setProductName(product.getString("note"));
                        productNew.setErpCode(product.getString("itemNo"));
                        productNew.setProductType(product.getString("grade"));
                        productNew.setUnitName(product.getString("unitName"));
                        if(StrUtil.equals(finalTan,"tenant1")){
                           productNew.setCompId(2089995177814495234L);
                        }
                        if(StrUtil.equals(finalTan,"tenant2")){
                           productNew.setCompId(2089996921978040321L);
                        }
                        if(StrUtil.equals(finalTan,"tenant3")){
                           productNew.setCompId(2089997578009128962L);
                        }
                        productNew.setParentId(productClass.getId());
                        TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,product.getString("tfTaxClass")).last("limit 1"));
                        if (ObjUtil.isNotNull(taxCode)){
                           productNew.setTaxClass(taxCode.getSphwjc());
                           productNew.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
                        }
                        baseMapper.insert(productNew);
                        log.info("产品:{}新增成功",product.getString("itemNo"));
                        return;
                     }
                     if(ObjUtil.isNotNull(productNew)) {
                        log.info("产品:{}存在", product.getString("itemNo"));
                        productNew.setProductType(product.getString("grade"));
                        productNew.setUnitName(product.getString("unitName"));
                        TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm,product.getString("tfTaxClass")).last("limit 1"));
                        if (ObjUtil.isNotNull(taxCode)){
                           productNew.setTaxClass(taxCode.getSphwjc());
                           productNew.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
                        }
                        baseMapper.updateById(productNew);
                     }
                  });
               }
            }
         }
      }
      return R.ok();