From 23e8f3896a37b67d5d96fe10afcb3213bb73aad4 Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期二, 20 一月 2026 16:25:32 +0800
Subject: [PATCH] feat(sales): 添加销售台账产品库存判断功能

---
 src/main/java/com/ruoyi/sales/controller/SalesLedgerProductController.java |   39 +++++++++++++++++++++++++++++----------
 1 files changed, 29 insertions(+), 10 deletions(-)

diff --git a/src/main/java/com/ruoyi/sales/controller/SalesLedgerProductController.java b/src/main/java/com/ruoyi/sales/controller/SalesLedgerProductController.java
index b964e4c..79e6cb5 100644
--- a/src/main/java/com/ruoyi/sales/controller/SalesLedgerProductController.java
+++ b/src/main/java/com/ruoyi/sales/controller/SalesLedgerProductController.java
@@ -5,9 +5,11 @@
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.framework.web.domain.R;
 import com.ruoyi.procurementrecord.dto.ProcurementPageDto;
 import com.ruoyi.procurementrecord.dto.ProcurementPageDtoCopy;
 import com.ruoyi.procurementrecord.service.ProcurementRecordService;
+import com.ruoyi.procurementrecord.utils.StockUtils;
 import com.ruoyi.sales.dto.SalesLedgerProductDto;
 import com.ruoyi.sales.pojo.SalesLedgerProduct;
 import com.ruoyi.sales.service.ISalesLedgerProductService;
@@ -25,11 +27,12 @@
 import com.ruoyi.framework.web.domain.AjaxResult;
 import com.ruoyi.framework.web.page.TableDataInfo;
 
+import java.math.BigDecimal;
 import java.util.List;
 
 /**
  * 浜у搧淇℃伅Controller
- * 
+ *
  * @author ruoyi
  * @date 2025-05-08
  */
@@ -41,6 +44,8 @@
     private ISalesLedgerProductService salesLedgerProductService;
     @Autowired
     private ProcurementRecordService procurementRecordService;
+    @Autowired
+    private StockUtils stockUtils;
 
 
     /**
@@ -71,15 +76,23 @@
     {
         List<SalesLedgerProduct> list = salesLedgerProductService.selectSalesLedgerProductList(salesLedgerProduct);
         list.forEach(item -> {
-            ProcurementPageDto procurementDto = new ProcurementPageDto();
-            procurementDto.setSalesLedgerProductId(item.getId());
-            procurementDto.setProductCategory(item.getProductCategory());
-            IPage<ProcurementPageDtoCopy> result = procurementRecordService.listPageCopyByProduction(new Page<>(1,-1), procurementDto);
-            if(result.getTotal()==0) return;
-            ProcurementPageDtoCopy procurementDtoCopy = result.getRecords().get(0);
-            if(item.getQuantity().compareTo(procurementDtoCopy.getInboundNum0())>=0){
-                item.setApproveStatus(1);
-                salesLedgerProductService.addOrUpdateSalesLedgerProduct(item);
+                if (item.getFutureTickets().compareTo(BigDecimal.ZERO) == 0) {
+                    item.setFutureTickets(item.getQuantity());
+                }
+            if (item.getFutureTicketsAmount().compareTo(BigDecimal.ZERO) == 0) {
+                item.setFutureTicketsAmount(item.getTaxInclusiveTotalPrice());
+            }
+//            ProcurementPageDto procurementDto = new ProcurementPageDto();
+//            procurementDto.setSalesLedgerProductId(item.getId());
+//            procurementDto.setProductCategory(item.getProductCategory());
+//            IPage<ProcurementPageDtoCopy> result = procurementRecordService.listPageCopyByProduction(new Page<>(1,-1), procurementDto);
+            BigDecimal stockQuantity = stockUtils.getStockQuantity(item.getProductModelId()).get("stockQuantity");
+            if(stockQuantity != null) {
+//                ProcurementPageDtoCopy procurementDtoCopy = result.getRecords().get(0);
+                if (item.getQuantity().compareTo(stockQuantity) <= 0 && item.getApproveStatus() == 0) {
+                    item.setApproveStatus(1);
+                    salesLedgerProductService.addOrUpdateSalesLedgerProduct(item);
+                }
             }
         });
         return AjaxResult.success(list);
@@ -128,4 +141,10 @@
         }
         return toAjax(salesLedgerProductService.deleteSalesLedgerProductByIds(ids));
     }
+
+    //鏍规嵁浜у搧id鑾峰彇bom鍒ゆ柇搴撳瓨鏄惁鍏呰冻
+    @GetMapping("/judgmentInventory")
+    public R judgmentInventory(SalesLedgerProduct salesLedgerProduct) {
+        return  salesLedgerProductService.judgmentInventory(salesLedgerProduct);
+    }
 }

--
Gitblit v1.9.3