From 78652d3173ffbe79a6e9b88035e5481a65020f97 Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期六, 25 四月 2026 11:46:50 +0800
Subject: [PATCH] feat(production): 生产计划添加销售相关字段

---
 src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java         |    3 +++
 src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java |    4 ++--
 src/main/resources/mapper/production/ProductionPlanMapper.xml                         |    7 +++++--
 src/main/java/com/ruoyi/production/bean/vo/ProductionPlanVo.java                      |    9 +++++++++
 4 files changed, 19 insertions(+), 4 deletions(-)

diff --git a/src/main/java/com/ruoyi/production/bean/vo/ProductionPlanVo.java b/src/main/java/com/ruoyi/production/bean/vo/ProductionPlanVo.java
index 842fc9b..a39c83a 100644
--- a/src/main/java/com/ruoyi/production/bean/vo/ProductionPlanVo.java
+++ b/src/main/java/com/ruoyi/production/bean/vo/ProductionPlanVo.java
@@ -21,4 +21,13 @@
 
     @Schema(description = "浜у搧ID")
     private Long productId;
+
+    @Schema(description = "閿�鍞悎鍚屽彿")
+    private String salesContractNo;
+
+    @Schema(description = "瀹㈡埛鍚嶇О")
+    private String customerName;
+
+    @Schema(description = "椤圭洰鍚嶇О")
+    private String projectName;
 }
diff --git a/src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java b/src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java
index 24c06d7..cfac357 100644
--- a/src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java
+++ b/src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java
@@ -245,8 +245,8 @@
             }
             ProductionAccount productionAccount = new ProductionAccount();
             productionAccount.setProductionProductMainId(productionProductMain.getId());
-            productionAccount.setSalesLedgerId(productionOrder.getSalesLedgerId());
-            productionAccount.setSalesLedgerProductId(productionOrder.getSalesLedgerProductId() == null ? null : productionOrder.getSalesLedgerProductId().longValue());
+//            productionAccount.setSalesLedgerId(productionOrder.getSalesLedgerId());
+//            productionAccount.setSalesLedgerProductId(productionOrder.getSalesLedgerProductId() == null ? null : productionOrder.getSalesLedgerProductId().longValue());
             productionAccount.setSchedulingUserId(user == null ? null : user.getUserId());
             productionAccount.setSchedulingUserName(user == null ? dto.getUserName() : user.getNickName());
             productionAccount.setFinishedNum(productQty);
diff --git a/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java b/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java
index 98f03b4..be2c03f 100644
--- a/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java
+++ b/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerProductServiceImpl.java
@@ -253,6 +253,7 @@
         if (!salesLedgerProduct.getIsProduction()) {
             return;
         }
+        SalesLedger salesLedger = salesLedgerMapper.selectById(salesLedgerProduct.getSalesLedgerId());
         ProductionPlan productionPlan = new ProductionPlan();
         productionPlan.setSalesLedgerId(salesLedgerProduct.getSalesLedgerId());
         productionPlan.setSalesLedgerProductId(salesLedgerProduct.getId());
@@ -261,6 +262,8 @@
         productionPlan.setQtyRequired(salesLedgerProduct.getQuantity());
         productionPlan.setSource("閿�鍞�");
         productionPlan.setStatus(0);
+        productionPlan.setRequiredDate(salesLedger.getDeliveryDate());//闇�姹傛棩鏈�=浜よ揣鏃ユ湡
+        productionPlan.setPromisedDeliveryDate(salesLedger.getDeliveryDate());//鎵胯鏃ユ湡=浜よ揣鏃ユ湡
         productionPlanMapper.insert(productionPlan);
 
     }
diff --git a/src/main/resources/mapper/production/ProductionPlanMapper.xml b/src/main/resources/mapper/production/ProductionPlanMapper.xml
index 9984fcf..f2ff70f 100644
--- a/src/main/resources/mapper/production/ProductionPlanMapper.xml
+++ b/src/main/resources/mapper/production/ProductionPlanMapper.xml
@@ -16,7 +16,6 @@
         <result column="qty_required" property="qtyRequired"/>
         <result column="issued" property="issued"/>
         <result column="source" property="source"/>
-        <result column="is_audit" property="isAudit"/>
         <result column="promised_delivery_date" property="promisedDeliveryDate"/>
     </resultMap>
 
@@ -26,10 +25,14 @@
         pm.model,
         p.id as productId,
         p.product_name AS productName,
-        pm.unit
+        pm.unit,
+        sl.sales_contract_no,
+        sl.customer_name,
+        sl.project_name
         FROM production_plan pp
         left join product_model pm on pp.product_model_id = pm.id
         left join product p on pm.product_id = p.id
+        left join sales_ledger sl on pp.sales_ledger_id = sl.id
         <where>
             <if test="c != null">
                 <if test="c.id != null">

--
Gitblit v1.9.3