From 0c39837bdc6aebf67959fae47d6e409febfee652 Mon Sep 17 00:00:00 2001
From: zhanghl <253316343@qq.com>
Date: 星期三, 30 四月 2025 09:38:38 +0800
Subject: [PATCH] 拆分工单任务：根据工单"料号"区分不同类型订单
---
aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml
index bfeaeaa..8091623 100644
--- a/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml
+++ b/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml
@@ -375,8 +375,8 @@
order_id,now(),'0',org_code,doc_status,std_op,op_status,next_op_name
from aps_work_order_job
where ( doc_status in (0,1,2,4) and is_hold_release='0'
- and (mainitem_code like 'M01%' or mainitem_code like 'M02%'or mainitem_code like 'M05%' or mainitem_code like 'M10%'
- or mainitem_code like 'M14%'or mainitem_code like 'M15%' or mainitem_code like 'F%' or mainitem_code like 'Z%'
+ and (item_code like 'M01%' or item_code like 'M02%'or item_code like 'M05%' or item_code like 'M10%'
+ or item_code like 'M14%'or item_code like 'M15%' or item_code like 'F%' or item_code like 'Z%'
)
);
</insert>
@@ -406,7 +406,7 @@
order_id,now(),'0',org_code,doc_status,std_op,op_status,next_op_name
from aps_work_order_job
where ( doc_status in (0,1,2,4) and is_hold_release='0'
- and (mainitem_code like 'M03%' or mainitem_code like 'M04%'or mainitem_code like 'A75%')
+ and (item_code like 'M03%' or item_code like 'M04%'or item_code like 'A75%')
);
</insert>
@@ -434,9 +434,9 @@
start_date,complete_date,next_dept,
is_hold_release,is_out_source,org_code,
order_id,now(),'0',org_code,doc_status,std_op,op_status,next_op_name,
- case when substr(mainitem_code,0,4)='A65' then 'gas' else 'piping' end as plan_type
+ case when substr(item_code,0,4)='A65' then 'gas' else 'piping' end as plan_type
from aps_work_order_job
where ( doc_status in (0,1,2,4) and is_hold_release='0'
- and (mainitem_code like 'A65%' or mainitem_code like 'W%'));
+ and (item_code like 'A65%' or item_code like 'W%'));
</insert>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3