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/ProductServiceImpl.java |  489 ++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 473 insertions(+), 16 deletions(-)

diff --git a/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ProductServiceImpl.java b/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ProductServiceImpl.java
index 5259cca..94bc184 100644
--- a/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ProductServiceImpl.java
+++ b/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ProductServiceImpl.java
@@ -1,15 +1,24 @@
 package com.by4cloud.platformx.business.service.impl;
 
 import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.date.DateUtil;
 import cn.hutool.core.lang.tree.Tree;
 import cn.hutool.core.lang.tree.TreeNode;
 import cn.hutool.core.lang.tree.TreeUtil;
 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.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;
+import com.by4cloud.platformx.business.dto.SyncProductDTO;
+import com.by4cloud.platformx.business.entity.BusinessCustomer;
 import com.by4cloud.platformx.business.entity.Product;
 import com.by4cloud.platformx.business.entity.TaxCode;
 import com.by4cloud.platformx.business.mapper.ProductMapper;
@@ -20,8 +29,12 @@
 import com.by4cloud.platformx.common.core.util.R;
 import com.by4cloud.platformx.common.data.datascope.DataScope;
 import com.by4cloud.platformx.common.excel.vo.ErrorMessage;
+import com.by4cloud.platformx.common.security.util.SecurityUtils;
 import jakarta.validation.constraints.NotNull;
 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;
 
@@ -38,13 +51,49 @@
  * @author platformx
  * @date 2026-05-07 10:17:52
  */
+@Slf4j
 @Service
 @RequiredArgsConstructor
 public class ProductServiceImpl extends ServiceImpl<ProductMapper, Product> implements ProductService {
 
 	private final TaxCodeMapper taxCodeMapper;
 
-    @Override
+	private final StringRedisTemplate redisTemplate;
+
+	@Value("${erp.smj}")
+	private String smjErp;
+
+	@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()
@@ -111,6 +160,18 @@
 //        		.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()+"","2101966257365045249")){
+			List<ProductSelectVo> selectVos = baseMapper.getProductSMJListByParentId(queryDTO, Arrays.asList(erpCodes));
+			if (selectVos.size()>2000){
+				return R.ok(selectVos.subList(0,1999));
+			}
+			return R.ok(selectVos);
+		}
 		List<ProductSelectVo> selectVos = baseMapper.getProductListByParentId(queryDTO, Arrays.asList(erpCodes),DataScope.of("comp_id"));
 		if (selectVos.size()>2000){
 			return R.ok(selectVos.subList(0,1999));
@@ -123,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())
@@ -136,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
@@ -190,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);
@@ -204,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);
@@ -232,4 +301,392 @@
 						Math.min((i + 1) * batchSize, totalSize)))
 				.collect(Collectors.toList());
 	}
+
+	@Override
+	public R syncSMJByDate(SyncProductDTO dto) {
+		String startDate = "";
+		if (StrUtil.isBlank(dto.getStartDate())){
+			startDate = DateUtil.formatDate(DateUtil.offsetDay(new Date(), -1));
+		}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("鐭崇叅鏈虹櫥褰曡幏鍙杢oken澶辫触");
+		}
+		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");
+		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 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("鐭崇叅鏈虹櫥褰曡幏鍙杢oken澶辫触");
+		}
+		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);
+					}
+					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;
+				}
+				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("鐭崇叅鏈虹櫥褰曡幏鍙杢oken澶辫触");
+		}
+		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();
+	}
 }
\ No newline at end of file

--
Gitblit v1.9.1