From 726f9fd86e790386732906769c4ee5f9c3e3087b Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期三, 14 一月 2026 11:08:15 +0800
Subject: [PATCH] yys 付款，回款改为绑定台账，产品

---
 src/main/java/com/ruoyi/basic/service/impl/ProductModelServiceImpl.java |   68 +++++++++++++++++++++++++++++++++
 1 files changed, 67 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/ruoyi/basic/service/impl/ProductModelServiceImpl.java b/src/main/java/com/ruoyi/basic/service/impl/ProductModelServiceImpl.java
index 754d93f..bc3840f 100644
--- a/src/main/java/com/ruoyi/basic/service/impl/ProductModelServiceImpl.java
+++ b/src/main/java/com/ruoyi/basic/service/impl/ProductModelServiceImpl.java
@@ -1,18 +1,32 @@
 package com.ruoyi.basic.service.impl;
 
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.ruoyi.basic.dto.ProductDto;
 import com.ruoyi.basic.dto.ProductModelDto;
+import com.ruoyi.basic.mapper.ProductMapper;
 import com.ruoyi.basic.mapper.ProductModelMapper;
+import com.ruoyi.basic.pojo.Product;
 import com.ruoyi.basic.pojo.ProductModel;
 import com.ruoyi.basic.service.IProductModelService;
 import com.ruoyi.common.utils.bean.BeanUtils;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.common.utils.uuid.IdUtils;
+import com.ruoyi.sales.mapper.SalesLedgerProductMapper;
+import com.ruoyi.sales.pojo.SalesLedgerProduct;
 import lombok.AllArgsConstructor;
 import org.springframework.stereotype.Service;
+import org.springframework.web.multipart.MultipartFile;
 
+import java.time.LocalDate;
+import java.time.format.DateTimeFormatter;
 import java.util.Arrays;
 import java.util.List;
+import java.util.Map;
+import java.util.stream.Collectors;
 
 /**
  * 銆愯濉啓鍔熻兘鍚嶇О銆慡ervice涓氬姟灞傚鐞�
@@ -24,6 +38,8 @@
 @AllArgsConstructor
 public class ProductModelServiceImpl extends ServiceImpl<ProductModelMapper, ProductModel> implements IProductModelService {
 
+    private final ProductMapper productMapper;
+    private final SalesLedgerProductMapper salesLedgerProductMapper;
     private ProductModelMapper productModelMapper;
 
     @Override
@@ -32,14 +48,29 @@
         if (productModelDto.getId() == null) {
             ProductModel productModel = new ProductModel();
             BeanUtils.copyProperties(productModelDto,productModel);
-            return productModelMapper.insert(productModel);
+            productModelMapper.insert(productModel);
+
+            String dateStr = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd"));
+            String idStr = String.format("%06d", productModel.getId()); // 鍏綅琛�0
+            String newProductCode = "BM" + dateStr + idStr;
+            // 鏇存柊鏁版嵁搴撲腑鐨刾roductCode
+            productModel.setProductCode(newProductCode);
+            return productModelMapper.updateById(productModel);
         } else {
             return productModelMapper.updateById(productModelDto);
         }
     }
 
+
+
     @Override
     public int delProductModel(Long[] ids) {
+        List<SalesLedgerProduct> salesLedgerProducts = salesLedgerProductMapper.selectList(new QueryWrapper<SalesLedgerProduct>()
+                .lambda().in(SalesLedgerProduct::getProductModelId, ids));
+        if (salesLedgerProducts != null && salesLedgerProducts.size() > 0) {
+
+            throw new RuntimeException("宸茬粡瀛樺湪璇ヤ骇鍝佺殑閿�鍞彴璐﹀拰閲囪喘鍙拌处");
+        }
         return productModelMapper.deleteBatchIds(Arrays.asList(ids));
     }
 
@@ -49,4 +80,39 @@
         queryWrapper.eq(ProductModel::getProductId, productDto.getId());
         return productModelMapper.selectList(queryWrapper);
     }
+
+    /**
+     * 鏍规嵁id鏌ヨ浜у搧瑙勬牸鍒嗛〉鏌ヨ
+     * @param page
+     * @param productDto
+     * @return
+     */
+    @Override
+    public IPage<ProductModel> modelListPage(Page page, ProductDto productDto) {
+        LambdaQueryWrapper<ProductModel> queryWrapper = new LambdaQueryWrapper<>();
+        queryWrapper.eq(ProductModel::getProductId, productDto.getId());
+        return productModelMapper.selectPage(page, queryWrapper);
+    }
+
+    @Override
+    public Boolean importProduct(MultipartFile file) {
+        try {
+            ExcelUtil<ProductModel> productModelExcelUtil = new ExcelUtil<>(ProductModel.class);
+            List<ProductModel> productModelList = productModelExcelUtil.importExcel(file.getInputStream());
+            Map<String, List<ProductModel>> collect = productModelList.stream().collect(Collectors.groupingBy(ProductModel::getProductName));
+            collect.forEach((k,v)->{
+                Product product = productMapper.selectOne(new LambdaQueryWrapper<Product>().eq(Product::getProductName, k).last("LIMIT 1"));
+                if (product != null) {
+                    v.forEach(productModel -> {
+                        productModel.setProductId(product.getId());
+                    });
+                    this.saveOrUpdateBatch(v);
+                }
+            });
+            return true;
+        }catch (Exception e) {
+            e.printStackTrace();
+        }
+        return false;
+    }
 }

--
Gitblit v1.9.3