From b34e423b1820193b7269a96731c734c8f03665c5 Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期四, 08 一月 2026 14:49:15 +0800
Subject: [PATCH] 生产工单-列表返回生产订单号
---
src/main/resources/mapper/production/ProductWorkOrderMapper.xml | 4 +++-
src/main/java/com/ruoyi/production/dto/ProductWorkOrderDto.java | 3 +++
2 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/ruoyi/production/dto/ProductWorkOrderDto.java b/src/main/java/com/ruoyi/production/dto/ProductWorkOrderDto.java
index f43789e..2191029 100644
--- a/src/main/java/com/ruoyi/production/dto/ProductWorkOrderDto.java
+++ b/src/main/java/com/ruoyi/production/dto/ProductWorkOrderDto.java
@@ -26,4 +26,7 @@
private String unit;
+ //鐢熶骇璁㈠崟鍙�
+ @ApiModelProperty(value = "鐢熶骇璁㈠崟鍙�")
+ private String productOrderNpsNo;
}
diff --git a/src/main/resources/mapper/production/ProductWorkOrderMapper.xml b/src/main/resources/mapper/production/ProductWorkOrderMapper.xml
index e1fdbd6..6c05996 100644
--- a/src/main/resources/mapper/production/ProductWorkOrderMapper.xml
+++ b/src/main/resources/mapper/production/ProductWorkOrderMapper.xml
@@ -24,10 +24,12 @@
pp.NAME as processName,
pm.model,
pm.unit,
- p.product_name AS productName
+ p.product_name AS productName,
+ po.nps_no AS productOrderNpsNo
FROM
`product_work_order` pwo
LEFT JOIN product_process_route_item ppri ON ppri.id = pwo.product_process_route_item_id
+ LEFT JOIN product_order po ON po.id = pwo.product_order_id
LEFT JOIN product_process pp ON pp.id = ppri.process_id
LEFT JOIN product_model pm ON pm.id = ppri.product_model_id
LEFT JOIN product p ON p.id = pm.product_id
--
Gitblit v1.9.3