From 4f8c9cafd9ccd2816e77716eefa04e0f42819f0c Mon Sep 17 00:00:00 2001
From: zhanghl <253316343@qq.com>
Date: 星期日, 27 四月 2025 14:07:34 +0800
Subject: [PATCH] 零件统计问题修复
---
aps-modules/aps-core/src/main/resources/mapper/core/ApsPartRouteStatMapper.xml | 4 +---
1 files changed, 1 insertions(+), 3 deletions(-)
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPartRouteStatMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPartRouteStatMapper.xml
index 75d31fb..821ef5c 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPartRouteStatMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPartRouteStatMapper.xml
@@ -123,9 +123,7 @@
from aps_part_plan as pl
left join aps_process_route as rt on pl.document_number=rt.work_order_no
left join aps_resource_group as rs on rs.resource_group_name=rt.process_name
- where document_status in (0,1,2,4)
- /*宸ュ簭璁″垝寮�宸ユ棩 灏忎簬绛変簬 璧勬簮缁勭殑鎴鏃ユ湡*/
- and rt.process_plan_start_day <= rs.request_date
+ where rt.process_plan_start_day <= rs.request_date
order by rt.work_order_no,process_plan_start_day
</select>
--
Gitblit v1.9.3