From dcf15598a799655041d098bb9d1a97dcb4485629 Mon Sep 17 00:00:00 2001
From: skyouc
Date: 星期二, 09 九月 2025 19:01:06 +0800
Subject: [PATCH] no message
---
zy-asrs-wms/src/main/resources/mapper/asrs/TaskMapper.xml | 24 +++++++++++++-----------
1 files changed, 13 insertions(+), 11 deletions(-)
diff --git a/zy-asrs-wms/src/main/resources/mapper/asrs/TaskMapper.xml b/zy-asrs-wms/src/main/resources/mapper/asrs/TaskMapper.xml
index 86a19a2..0089f18 100644
--- a/zy-asrs-wms/src/main/resources/mapper/asrs/TaskMapper.xml
+++ b/zy-asrs-wms/src/main/resources/mapper/asrs/TaskMapper.xml
@@ -26,18 +26,20 @@
FROM
(
SELECT
- mws.id,
- mws.matnr,
- mws.order_no,
- mws.order_id,
- SUM( mws.anfme ) anfme,
- mws.wave_no,
- SUM( mws.work_qty ) work_qty,
- mws.batch,
- mws.site_no,
- mws.task_detl_id
+ mws.id,
+ mws.matnr,
+ mws.order_no,
+ mws.order_id,
+ od.anfme AS rev_qty,
+ SUM( mws.anfme ) anfme,
+ mws.wave_no,
+ SUM( mws.work_qty ) work_qty,
+ mws.batch,
+ mws.site_no,
+ mws.task_detl_id
FROM
- man_wave_seed mws
+ man_wave_seed mws
+ INNER JOIN man_order_detl od ON mws.order_detl_id = od.id
WHERE
task_detl_id IN ( SELECT mtd.id FROM man_task mt INNER JOIN man_task_detl mtd ON mt.id = mtd.task_id
<if test="taskNo != null and taskNo != ''">
--
Gitblit v1.9.1