From 145580fd820bb31334f2e71643413e846b7ce904 Mon Sep 17 00:00:00 2001
From: shiyunteng <shiyunteng@example.com>
Date: 星期五, 30 十月 2026 15:53:20 +0800
Subject: [PATCH] feat:统计内容1-8页

---
 platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ProductServiceImpl.java |  272 +++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 268 insertions(+), 4 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 84c2812..1e73e39 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
@@ -224,6 +224,7 @@
 					baseMapper.insert(product);
 				}
 			}
+			return R.ok();
 		}
 		return R.failed("鏁版嵁涓虹┖");
 	}
@@ -259,7 +260,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);
@@ -273,7 +274,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);
@@ -383,6 +384,7 @@
 						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);
 						}
@@ -395,8 +397,8 @@
 						productNew.setParentId(productClass.getId());
 						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("%","")));
+							productNew.setTaxClass(taxCode.getSphwjc());
+							productNew.setTaxRate(Double.valueOf(taxCode.getSl().replace("%","")));
 						}
 						baseMapper.insert(productNew);
 						log.info("浜у搧锛歿}鏂板鎴愬姛",product.getString("itemNo"));
@@ -426,4 +428,266 @@
 		}
 		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