| | |
| | | order.setOpStatus(jsonObject.getString("OpStatus")); |
| | | order.setNextOpName(jsonObject.getString("NextOpName")); |
| | | order.setLowOrderCode(jsonObject.getString("LowLevelCode")); |
| | | order.setOrderCreateTime(jsonObject.getDate("CreatedOn")); |
| | | order.setApproveOn(jsonObject.getDate("ApproveOn")); |
| | | order.setStartWorkDate(jsonObject.getDate("StartDatetime")); |
| | | jobs.add(order); |
| | | orderIds.add(order.getOrderId()); |
| | | } catch (Exception e) { |
| | |
| | | plan_start_day,plan_end_day,next_process_deparment, |
| | | is_suspended,is_outsourcing,account, |
| | | id,create_time,del_flag,plant,order_status,std_op,op_status,next_op_name, |
| | | professional_affiliation,order_create_time |
| | | professional_affiliation,order_create_time,approve_on,start_work_date |
| | | ) |
| | | select |
| | | doc_no,mainitem_code,mainitem_figure, |
| | |
| | | is_hold_release,is_out_source,org_code, |
| | | cast(order_id as bigint) as id,now(),'0',org_code,doc_status,std_op,op_status,next_op_name, |
| | | (case when low_order_code='0' then 'main' else 'sub' end ) as professional_affiliation, |
| | | order_create_time |
| | | order_create_time, |
| | | approve_on, |
| | | start_work_date |
| | | from aps_work_order_job |
| | | where ( doc_status in (0,1,2,4) and is_hold_release='0' |
| | | and (item_code like 'M03%' or item_code like 'M04%'or item_code like 'A75%') |