檢視 預交日延遲分析 的原始碼
←
預交日延遲分析
跳至導覽
跳至搜尋
由於以下原因,您無權編輯此頁面:
您請求的操作只有這個群組的使用者能使用:
使用者
您可以檢視並複製此頁面的原始碼。
==說明== 以搜尋條件查詢加工單客戶預交日與加工預交日來分析訂單交期狀況,並以圖表方式來顯示。 ==搜尋條件== *客戶 *下單日區間 *預交日區間 *加工預交日區間 ==SQL== <sql> SELECT *,WKDAY2-WKDAY1 AS DIFF, (SELECT CASE WHEN WKDAY1<=0 THEN 0 WHEN WKDAY1>0 AND WKDAY1<=5 THEN 1 WHEN WKDAY1>5 AND WKDAY1<=10 THEN 2 WHEN WKDAY1>10 AND WKDAY1<=15 THEN 3 WHEN WKDAY1>15 AND WKDAY1<=20 THEN 4 WHEN WKDAY1>20 AND WKDAY1<=25 THEN 5 WHEN WKDAY1>25 AND WKDAY1<=30 THEN 6 WHEN WKDAY1>30 AND WKDAY1<=35 THEN 7 WHEN WKDAY1>35 AND WKDAY1<=40 THEN 8 WHEN WKDAY1>40 THEN 9 END)WK1, (SELECT CASE WHEN WKDAY2<=0 THEN 0 WHEN WKDAY2>0 AND WKDAY2<=5 THEN 1 WHEN WKDAY2>5 AND WKDAY2<=10 THEN 2 WHEN WKDAY2>10 AND WKDAY2<=15 THEN 3 WHEN WKDAY2>15 AND WKDAY2<=20 THEN 4 WHEN WKDAY2>20 AND WKDAY2<=25 THEN 5 WHEN WKDAY2>25 AND WKDAY2<=30 THEN 6 WHEN WKDAY2>30 AND WKDAY2<=35 THEN 7 WHEN WKDAY2>35 AND WKDAY2<=40 THEN 8 WHEN WKDAY2>40 THEN 9 END)WK2, (SELECT CASE WHEN WKDAY2-WKDAY1 <=0 THEN 0 WHEN WKDAY2-WKDAY1 >0 AND WKDAY2-WKDAY1 <=5 THEN 1 WHEN WKDAY2-WKDAY1 >5 AND WKDAY2-WKDAY1 <=10 THEN 2 WHEN WKDAY2-WKDAY1 >10 AND WKDAY2-WKDAY1 <=15 THEN 3 WHEN WKDAY2-WKDAY1 >15 AND WKDAY2-WKDAY1 <=20 THEN 4 WHEN WKDAY2-WKDAY1 >20 AND WKDAY2-WKDAY1 <=25 THEN 5 WHEN WKDAY2-WKDAY1 >25 AND WKDAY2-WKDAY1 <=30 THEN 6 WHEN WKDAY2-WKDAY1 >30 AND WKDAY2-WKDAY1 <=35 THEN 7 WHEN WKDAY2-WKDAY1 >35 AND WKDAY2-WKDAY1 <=40 THEN 8 WHEN WKDAY2-WKDAY1 >40 THEN 9 END)DF FROM (SELECT CAST(CAST(TD054 AS INTEGER)AS CHAR(9)) AS TA002,TC004, TC075,CAST(TD012*TC009 AS INTEGER) AS TWM,TC003,TD013,REPLACE(CD.UDF05,'/','')AS UDF05, DATEDIFF(DAY,TC003,TD013)- (SELECT COUNT(MP004) FROM CMSMP WHERE MP004 BETWEEN TC003 AND TD013) AS WKDAY1, DATEDIFF(DAY,TC003,CD.UDF05)- (SELECT COUNT(MP004) FROM CMSMP WHERE MP004 BETWEEN TC003 AND CD.UDF05) AS WKDAY2 FROM v_COPTCD CD WHERE TD054 > 15 AND UDF05 >0 )X //已建立views: v_CKDAYS </sql>
返回到「
預交日延遲分析
」。
導覽選單
個人工具
建立帳號
登入
命名空間
頁面
討論
臺灣正體
視圖
閱讀
檢視原始碼
檢視歷史
更多
搜尋
導覽
首頁
近期變更
隨機頁面
MediaWiki說明
工具
連結至此的頁面
相關變更
特殊頁面
頁面資訊