HOLD的处理逻辑

zhgc

SQL:


insert into sfc.r_hold_info_t(serial_number,model_name,mo_number,group_name,hold_time,unhold_time,hold_code,hold_desc,emp_no)  
select serial_Number ,model_name,mo_number,wip_group,now(),null,'001','AAA','GNET'
from sfc.r107 wHERE serial_number = '02041801000397' and wip_group not like 'HOLD%'

UPDATE SFC.r_wip_tracking_t SET group_name = if(SUBSTR(group_name, 1, 4)='HOLD', group_name, concat('HOLD', group_name )),
next_station =  if(SUBSTR(next_station, 1, 4)='HOLD', next_station,  concat('HOLD',next_station  )),
wip_group=if(SUBSTR(wip_group, 1, 4)= 'HOLD',
wip_group,concat('HOLD',wip_group)) WHERE serial_number = '02041801000397'


UPDATE SFC.R_wip_tracking_t a SET a.group_name = if(SUBSTR(a.group_name, 1, 4)='HOLD',
substr(a.group_name,5,length(a.group_name)),a.group_name ),a.next_station =  if(SUBSTR(a.next_station, 1, 4)='HOLD',
substr(a.next_station,5, length(a.next_station)),   a.next_station  ),a.wip_group=if(SUBSTR(a.wip_group, 1, 4)= 'HOLD',
substr(a.wip_group,5,length(a.wip_group)),a.wip_group) where  a.serial_number='02041801000397'


update sfc.r_hold_info_t set unhold_time=now(),emp_no1= 'GNET' WHERE serial_number = '02041801000397' and unhold_time is null