From 845bb3d04da35750101c025e65228916feebf5e4 Mon Sep 17 00:00:00 2001
From: guoyujie <guoyujie@ng.com>
Date: 星期一, 25 八月 2025 16:32:55 +0800
Subject: [PATCH] 修改订单流程查询
---
north-glass-erp/src/main/resources/mapper/pp/Report.xml | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/north-glass-erp/src/main/resources/mapper/pp/Report.xml b/north-glass-erp/src/main/resources/mapper/pp/Report.xml
index 4892304..4deaf88 100644
--- a/north-glass-erp/src/main/resources/mapper/pp/Report.xml
+++ b/north-glass-erp/src/main/resources/mapper/pp/Report.xml
@@ -215,7 +215,10 @@
on c.order_id = d.order_id
# left join mm.finished_goods_inventory as f
# on c.order_id = f.order_id and f.order_number = c.order_number
- left join sd.delivery_detail as dd on dd.order_id = a.order_id and dd.order_number = a.order_number
+ left join (select dd1.order_id,dd1.order_number,sum(dd1.quantity) as quantity from sd.delivery_detail as dd1
+ where dd1.order_id = #{orderId}
+ group by dd1.order_id,dd1.order_number
+ ) as dd on dd.order_id = a.order_id and dd.order_number = a.order_number
left join (SELECT process_id,
order_number,
technology_number,
--
Gitblit v1.8.0