56,687
社区成员
发帖
与我相关
我的任务
分享
SELECT
a.job 料号,
CASE
WHEN TRIM(a.recieve_time)!='' AND TRIM(a.mi_time) is null THEN '待安排'
WHEN TRIM(a.micheck_time)!='' AND TRIM(a.sent_time) is null THEN '待发料'
WHEN TRIM(a.mi_time)!='' AND TRIM(a.ask_time) is null THEN '待发EQ'
WHEN TRIM(a.mi_finish_time)!='' AND TRIM(a.micheck_time) is null THEN '待安排审核'
WHEN TRIM(a.answer_time)!='' AND TRIM(a.mi_finish_time) is null THEN 'MI制作中'
WHEN TRIM(a.sent_time)!='' THEN '已完成'
END AS '订单状态',
( CASE
WHEN TRIM(a.recieve_time)!='' AND TRIM(a.mi_time) is null THEN (SELECT to_be_Arrange FROM TimeCriteria where 1=1 limit 1 )
WHEN TRIM(a.micheck_time)!='' AND TRIM(a.sent_time) is null THEN (SELECT To_Be_IssueMaterial FROM TimeCriteria where 1=1 limit 1 )
WHEN TRIM(a.mi_time)!='' AND TRIM(a.ask_time) is null THEN (SELECT To_Be_IssueQuery FROM TimeCriteria where 1=1 limit 1 )
WHEN TRIM(a.mi_finish_time)!='' AND TRIM(a.micheck_time) is null THEN (SELECT To_Be_Check FROM TimeCriteria where 1=1 limit 1 )
WHEN TRIM(a.answer_time)!='' AND TRIM(a.mi_finish_time) is null THEN (SELECT PrapareMI FROM TimeCriteria where 1=1 limit 1 )
END ) 标准时间,
( CASE
WHEN TRIM(a.recieve_time)!='' AND TRIM(a.mi_time) is null AND (NOW()- a.recieve_time - (SELECT to_be_Arrange FROM TimeCriteria where 1=1 limit 1 )*60*60)>0 THEN (NOW()- a.recieve_time - (SELECT to_be_Arrange FROM TimeCriteria where 1=1 limit 1 )*60*60)
END ) 还剩多少时间,
'' 已超时时间
FROM PartList a
SELECT
a.job 料号,
CASE
WHEN TRIM(a.recieve_time)!='' AND TRIM(a.mi_time)='' THEN '未安排'
WHEN TRIM(a.micheck_time)!='' AND TRIM(a.sent_time)='' THEN '待发料'
WHEN TRIM(a.mi_time)!='' AND TRIM(a.ask_time)='' THEN '待发EQ'
WHEN TRIM(a.mi_finish_time)!='' AND TRIM(a.micheck_time)='' THEN '待安排审核'
WHEN TRIM(a.answer_time)!='' AND TRIM(a.mi_finish_time)='' THEN 'MI制作中'
WHEN TRIM(a.sent_time)!='' THEN '已完成'
END AS '订单状态',
'' 标准时间,
'' 还剩多少时间,
'' 已超时时间
FROM PartList a