From c5c284896ce6428cffc5092e9cdef4fefc23409f Mon Sep 17 00:00:00 2001
From: shiyunteng <shiyunteng@example.com>
Date: 星期五, 18 九月 2026 17:12:49 +0800
Subject: [PATCH] feat: 石煤机客商产品查询处理 合同推送新增选商方式和是否关联交易

---
 platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/controller/ProductController.java |  118 ++++++++++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 101 insertions(+), 17 deletions(-)

diff --git a/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/controller/ProductController.java b/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/controller/ProductController.java
index acd3c71..6994108 100644
--- a/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/controller/ProductController.java
+++ b/platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/controller/ProductController.java
@@ -1,16 +1,28 @@
 package com.by4cloud.platformx.business.controller;
 
+import cn.hutool.core.bean.BeanUtil;
+import cn.hutool.core.date.DateUtil;
 import cn.hutool.core.util.ArrayUtil;
 import cn.hutool.core.collection.CollUtil;
 import cn.hutool.core.util.StrUtil;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.by4cloud.platformx.admin.api.vo.DeptExcelVO;
+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.vo.ProductExcelVO;
+import com.by4cloud.platformx.business.vo.ProductTreeVo;
 import com.by4cloud.platformx.common.core.util.R;
+import com.by4cloud.platformx.common.excel.annotation.RequestExcel;
 import com.by4cloud.platformx.common.log.annotation.SysLog;
 import com.by4cloud.platformx.business.entity.Product;
 import com.by4cloud.platformx.business.service.ProductService;
 import com.by4cloud.platformx.common.security.annotation.Inner;
+import com.by4cloud.platformx.common.security.util.SecurityUtils;
+import org.springframework.beans.factory.annotation.Value;
 import org.springframework.security.access.prepost.PreAuthorize;
 import com.by4cloud.platformx.common.excel.annotation.ResponseExcel;
 import io.swagger.v3.oas.annotations.security.SecurityRequirement;
@@ -19,8 +31,10 @@
 import io.swagger.v3.oas.annotations.tags.Tag;
 import io.swagger.v3.oas.annotations.Operation;
 import lombok.RequiredArgsConstructor;
+import org.springframework.validation.BindingResult;
 import org.springframework.web.bind.annotation.*;
 
+import java.util.ArrayList;
 import java.util.List;
 import java.util.Objects;
 
@@ -39,6 +53,15 @@
 
     private final  ProductService productService;
 
+	@Value("${dept.smj}")
+	private String smj;
+
+	@Value("${dept.smjsc}")
+	private String smjsc;
+
+	@Value("${dept.smjzt}")
+	private String smjzt;
+
     /**
      * 鍒嗛〉鏌ヨ
      * @param page 鍒嗛〉瀵硅薄
@@ -49,12 +72,39 @@
     @GetMapping("/page" )
     @PreAuthorize("@pms.hasPermission('business_product_view')" )
     public R getProductPage(@ParameterObject Page page, @ParameterObject Product product) {
+		if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjsc) ||
+				StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjzt)) {
+			LambdaQueryWrapper<Product> wrapper = Wrappers.lambdaQuery();
+			wrapper.eq(product.getParentId()!=null,Product::getParentId,product.getParentId());
+			wrapper.like(StrUtil.isNotEmpty(product.getProductName()),Product::getProductName,product.getProductName());
+			wrapper.like(StrUtil.isNotEmpty(product.getMainCode()),Product::getMainCode,product.getMainCode());
+			wrapper.like(StrUtil.isNotEmpty(product.getErpCode()),Product::getErpCode,product.getErpCode());
+			List<String> smjList = new ArrayList<>();
+			smjList.add(smj);
+			smjList.add(smjsc);
+			smjList.add(smjzt);
+			wrapper.in(Product::getCompId, smjList);
+			wrapper.orderByDesc(Product::getCreateTime);
+			Page<Product> page1 = productService.page(page, wrapper);
+			List<Product> list = page1.getRecords();
+			for(Product product1 : list){
+				Product  parent = productService.getById(product1.getParentId());
+				if(parent==null){
+					product1.setParentName("鏍圭骇浜у搧");
+				}else {
+					product1.setParentName(parent.getProductName());
+				}
+			}
+			page1.setRecords(list);
+			return R.ok(page1);
+		}
         LambdaQueryWrapper<Product> wrapper = Wrappers.lambdaQuery();
         wrapper.eq(product.getParentId()!=null,Product::getParentId,product.getParentId());
         wrapper.like(StrUtil.isNotEmpty(product.getProductName()),Product::getProductName,product.getProductName());
         wrapper.like(StrUtil.isNotEmpty(product.getMainCode()),Product::getMainCode,product.getMainCode());
         wrapper.like(StrUtil.isNotEmpty(product.getErpCode()),Product::getErpCode,product.getErpCode());
-        Page<Product> page1 = productService.page(page, wrapper);
+		wrapper.orderByDesc(Product::getCreateTime);
+        Page<Product> page1 = productService.pageByScope(page, wrapper);
         List<Product> list = page1.getRecords();
         for(Product product1 : list){
             Product  parent = productService.getById(product1.getParentId());
@@ -76,29 +126,28 @@
     @Operation(summary = "鍒嗛〉鏌ヨ" , description = "鍒嗛〉鏌ヨ" )
     @GetMapping("/list" )
     @PreAuthorize("@pms.hasPermission('business_product_view')" )
-    @Inner(value = false)
     public R getProductList(@ParameterObject Product product) {
-        LambdaQueryWrapper<Product> wrapper = Wrappers.lambdaQuery();
-		wrapper.like(StrUtil.isNotEmpty(product.getProductName()),Product::getProductName,product.getProductName());
-		wrapper.last("limit 20");
-        return R.ok(productService.list(wrapper));
+        return R.ok(productService.getProductList(product));
     }
 
     /**
      * 鍒嗛〉鏌ヨ
-     * @param product 浜у搧淇℃伅
+     * @param queryDTO 浜у搧淇℃伅
      * @return
      */
     @Operation(summary = "鍒嗛〉鏌ヨ" , description = "鍒嗛〉鏌ヨ" )
     @GetMapping("/listByParentId" )
-    @PreAuthorize("@pms.hasPermission('business_product_view')" )
-    //@Inner(value = false)
-    public R getProductListByParentId(@ParameterObject Product product) {
-        LambdaQueryWrapper<Product> wrapper = Wrappers.lambdaQuery();
-        wrapper.like(StrUtil.isNotEmpty(product.getProductName()),Product::getProductName,product.getProductName());
-        wrapper.eq(product.getParentId()!=null,Product::getParentId,product.getParentId());
-        wrapper.last("limit 30");
-        return R.ok(productService.list(wrapper));
+    public R getProductListByParentId(@ParameterObject ProductQueryDTO queryDTO) {
+//        LambdaQueryWrapper<Product> wrapper = Wrappers.lambdaQuery();
+//        wrapper.like(StrUtil.isNotEmpty(queryDTO.getProductName()),Product::getProductName,queryDTO.getProductName());
+//        wrapper.eq(StrUtil.isNotEmpty(queryDTO.getParentId()),Product::getParentId,queryDTO.getParentId());
+//		if (StrUtil.isNotEmpty(queryDTO.getContractCategory())&&StrUtil.equals(queryDTO.getContractCategory(), "water_house")){
+//			String[] erpCodes = new String[]{"鎴跨绉熻祦","dianli","water"};
+//			wrapper.in(Product::getErpCode,erpCodes);
+//			return R.ok(BeanUtil.copyToList(productService.listByScope(wrapper), ProductTreeVo.class));
+//		}
+//        return R.ok(BeanUtil.copyToList(productService.listByScope(wrapper), ProductTreeVo.class));
+		return productService.getProductListByParentId(queryDTO);
     }
 
     /**
@@ -108,10 +157,9 @@
      */
     @Operation(summary = "灞傜骇鏌ヨ" , description = "灞傜骇鏌ヨ" )
     @GetMapping("/treeList" )
-    //@PreAuthorize("@pms.hasPermission('business_product_view')" )
     @Inner(value = false)
     public R getNewsCategoryTree(@ParameterObject Product product) {
-        return R.ok(productService.treeList(product.getParentId(), product.getProductName()));
+        return R.ok(productService.treeList());
     }
 
 
@@ -137,6 +185,9 @@
     @PostMapping
     @PreAuthorize("@pms.hasPermission('business_product_add')" )
     public R save(@RequestBody Product product) {
+		if (CollUtil.isNotEmpty(productService.listByScope(Wrappers.lambdaQuery(product).eq(Product::getErpCode,product.getErpCode())))){
+			return R.failed("浜у搧Erp缂栫爜宸插瓨鍦�");
+		}
         return R.ok(productService.save(product));
     }
 
@@ -179,4 +230,37 @@
     public List<Product> export(Product product,Long[] ids) {
         return productService.list(Wrappers.lambdaQuery(product).in(ArrayUtil.isNotEmpty(ids), Product::getId, ids));
     }
+
+	/**
+	 * 鏂板浜у搧淇℃伅
+	 * @param addDTOS 浜у搧淇℃伅
+	 * @return R
+	 */
+	@Operation(summary = "鍚勫叕鍙告柊澧炰骇鍝佷俊鎭�" , description = "鍚勫叕鍙告柊澧炰骇鍝佷俊鎭�" )
+	@SysLog("鍚勫叕鍙告柊澧炰骇鍝佷俊鎭�" )
+	@PostMapping("/saveErpProduct")
+	public R saveErpProduct(@RequestBody List<ProductAddDTO> addDTOS) {
+		return productService.saveErpProduct(addDTOS);
+	}
+
+	/**
+	 * 瀵煎叆閮ㄩ棬
+	 * @param excelVOList
+	 * @param bindingResult
+	 * @return
+	 */
+	@PostMapping("/importProduct")
+	public R importProduct(@RequestExcel List<ProductExcelVO> excelVOList, BindingResult bindingResult) {
+		return productService.importProduct(excelVOList, bindingResult);
+	}
+
+	/**
+	 * 鐭崇叅鏈轰骇鍝佸悓姝�
+	 * @return
+	 */
+	@Inner(value = false)
+	@GetMapping("/syncSMJByDate")
+	public R syncSMJByDate(@ParameterObject SyncProductDTO dto) {
+		return productService.syncSMJByDate(dto);
+	}
 }
\ No newline at end of file

--
Gitblit v1.9.1