From 608ab8beb553ca8996c95bdd50ec61c253d36ec1 Mon Sep 17 00:00:00 2001
From: zhanghl <253316343@qq.com>
Date: 星期四, 22 五月 2025 18:13:36 +0800
Subject: [PATCH] 钣金计划大表：增加需求追溯号逻辑
---
aps-modules/aps-core/src/main/resources/mapper/core/ApsPlate/ApsPlateProcessShopStatMapper.xml | 8 ++++++++
1 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlate/ApsPlateProcessShopStatMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlate/ApsPlateProcessShopStatMapper.xml
index cf6ba64..cd5fdee 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlate/ApsPlateProcessShopStatMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlate/ApsPlateProcessShopStatMapper.xml
@@ -141,9 +141,16 @@
left join aps_process_route as pr on ap.document_number=pr.work_order_no
where cast(pr.process_number as numeric) > cast(ap.process_number as numeric)
group by ap.document_number
+ ),
+ b as (
+ select app.doc_no, string_agg( app.require_track_id ,',') as require_track_id
+ from aps_plate_standard_require_bom_order_detail as app
+ where del_flag='0'
+ group by app.doc_no
)
select
app.id,
+ b.require_track_id,
app.main_part_number,
app.customer,
app.business_type,
@@ -168,6 +175,7 @@
a.remained_process
from aps_plate_plan as app
left join a on app.document_number=a.document_number
+ left join b on app.document_number=b.doc_no
where app.del_flag='0';
</select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3