「預交日工程單」:修訂間差異
新頁面: ==程式碼== <sql> SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010, (SELECT CASE WHEN TA526<>'' AND TA527<>'' THEN 'OK' WHEN TA526<>'' AND TA527='' THEN '在組裝' WHEN TA524... |
|||
| 第1行: | 第1行: | ||
==程式碼== | ==程式碼== | ||
<sql> | <sql> | ||
SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010, | SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010,TD001,TA520,TA521,TA522,TA523,TA524,TA525,TA526,TA527, | ||
(SELECT CASE | (SELECT CASE | ||
WHEN TA526<>'' AND TA527<>'' THEN 'OK' | WHEN TA526<>'' AND TA527<>'' THEN 'OK' | ||
WHEN TA520<>'' AND TA521='' THEN '在裁線' | |||
WHEN TA522<>'' AND TA523='' THEN '在焊接' | |||
WHEN TA524<>'' AND TA525='' THEN '在端子' | |||
WHEN TA526<>'' AND TA527='' THEN '在組裝' | WHEN TA526<>'' AND TA527='' THEN '在組裝' | ||
WHEN | WHEN TA520='' AND TA522='' AND TA524='' AND TA526='' THEN '排單中' | ||
END) AS TA527,(SELECT CASE WHEN TC012<>'' THEN TC012 ELSE X.UDF02 END)AS TC012 | END) AS TA527,(SELECT CASE WHEN TC012<>'' THEN TC012 ELSE X.UDF02 END)AS TC012 | ||
FROM v_COPTCD X | FROM v_COPTCD X | ||
| 第15行: | 第16行: | ||
AND TD003=(SELECT CASE WHEN TA033<>'' AND TA028='' THEN TD003 ELSE TA028 END) | AND TD003=(SELECT CASE WHEN TA033<>'' AND TA028='' THEN TD003 ELSE TA028 END) | ||
JOIN COPMA ON MA001=TC004 | JOIN COPMA ON MA001=TC004 | ||
WHERE | WHERE TA010='20151207' | ||
</sql> | </sql> | ||
於 2015年12月7日 (一) 12:40 的最新修訂
程式碼
<sql> SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010,TD001,TA520,TA521,TA522,TA523,TA524,TA525,TA526,TA527, (SELECT CASE WHEN TA526<> AND TA527<> THEN 'OK' WHEN TA520<> AND TA521= THEN '在裁線' WHEN TA522<> AND TA523= THEN '在焊接' WHEN TA524<> AND TA525= THEN '在端子' WHEN TA526<> AND TA527= THEN '在組裝' WHEN TA520= AND TA522= AND TA524= AND TA526= THEN '排單中' END) AS TA527,(SELECT CASE WHEN TC012<> THEN TC012 ELSE X.UDF02 END)AS TC012 FROM v_COPTCD X JOIN v_MOCTANOTV ON TD001=(SELECT CASE WHEN TA033<> THEN '400' ELSE TA026 END) AND TD002=(SELECT CASE WHEN TA033<> THEN REPLACE(TA033,'*',) ELSE TA027 END) AND TD003=(SELECT CASE WHEN TA033<> AND TA028= THEN TD003 ELSE TA028 END) JOIN COPMA ON MA001=TC004 WHERE TA010='20151207' </sql>