<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="zh-Hant-TW">
	<id>http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%BB%B6%E9%81%B2%E5%88%86%E6%9E%90</id>
	<title>預交日延遲分析 - 修訂紀錄</title>
	<link rel="self" type="application/atom+xml" href="http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%BB%B6%E9%81%B2%E5%88%86%E6%9E%90"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%BB%B6%E9%81%B2%E5%88%86%E6%9E%90&amp;action=history"/>
	<updated>2026-11-16T23:51:21Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%BB%B6%E9%81%B2%E5%88%86%E6%9E%90&amp;diff=3025&amp;oldid=prev</id>
		<title>Root：​新頁面: ==說明== 以搜尋條件查詢加工單客戶預交日與加工預交日來分析訂單交期狀況，並以圖表方式來顯示。 ==搜尋條件== *客戶 *下單日區間 *預交...</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%BB%B6%E9%81%B2%E5%88%86%E6%9E%90&amp;diff=3025&amp;oldid=prev"/>
		<updated>2018-03-31T00:54:25Z</updated>

		<summary type="html">&lt;p&gt;新頁面: ==說明== 以搜尋條件查詢加工單客戶預交日與加工預交日來分析訂單交期狀況，並以圖表方式來顯示。 ==搜尋條件== *客戶 *下單日區間 *預交...&lt;/p&gt;
&lt;p&gt;&lt;b&gt;新頁面&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==說明==&lt;br /&gt;
以搜尋條件查詢加工單客戶預交日與加工預交日來分析訂單交期狀況，並以圖表方式來顯示。&lt;br /&gt;
==搜尋條件==&lt;br /&gt;
*客戶&lt;br /&gt;
*下單日區間&lt;br /&gt;
*預交日區間&lt;br /&gt;
*加工預交日區間&lt;br /&gt;
&lt;br /&gt;
==SQL==&lt;br /&gt;
&amp;lt;sql&amp;gt;&lt;br /&gt;
SELECT *,WKDAY2-WKDAY1 AS DIFF,&lt;br /&gt;
(SELECT CASE WHEN WKDAY1&amp;lt;=0 THEN 0&lt;br /&gt;
						 WHEN WKDAY1&amp;gt;0 AND WKDAY1&amp;lt;=5 THEN 1&lt;br /&gt;
						 WHEN WKDAY1&amp;gt;5 AND WKDAY1&amp;lt;=10 THEN 2&lt;br /&gt;
						 WHEN WKDAY1&amp;gt;10 AND WKDAY1&amp;lt;=15 THEN 3&lt;br /&gt;
						 WHEN WKDAY1&amp;gt;15 AND WKDAY1&amp;lt;=20 THEN 4&lt;br /&gt;
						 WHEN WKDAY1&amp;gt;20 AND WKDAY1&amp;lt;=25 THEN 5&lt;br /&gt;
						 WHEN WKDAY1&amp;gt;25 AND WKDAY1&amp;lt;=30 THEN 6&lt;br /&gt;
						 WHEN WKDAY1&amp;gt;30 AND WKDAY1&amp;lt;=35 THEN 7&lt;br /&gt;
						 WHEN WKDAY1&amp;gt;35 AND WKDAY1&amp;lt;=40 THEN 8&lt;br /&gt;
						 WHEN WKDAY1&amp;gt;40 THEN 9 END)WK1,&lt;br /&gt;
(SELECT CASE WHEN WKDAY2&amp;lt;=0 THEN 0&lt;br /&gt;
						 WHEN WKDAY2&amp;gt;0 AND WKDAY2&amp;lt;=5 THEN 1&lt;br /&gt;
						 WHEN WKDAY2&amp;gt;5 AND WKDAY2&amp;lt;=10 THEN 2&lt;br /&gt;
						 WHEN WKDAY2&amp;gt;10 AND WKDAY2&amp;lt;=15 THEN 3&lt;br /&gt;
						 WHEN WKDAY2&amp;gt;15 AND WKDAY2&amp;lt;=20 THEN 4&lt;br /&gt;
						 WHEN WKDAY2&amp;gt;20 AND WKDAY2&amp;lt;=25 THEN 5&lt;br /&gt;
						 WHEN WKDAY2&amp;gt;25 AND WKDAY2&amp;lt;=30 THEN 6&lt;br /&gt;
						 WHEN WKDAY2&amp;gt;30 AND WKDAY2&amp;lt;=35 THEN 7&lt;br /&gt;
						 WHEN WKDAY2&amp;gt;35 AND WKDAY2&amp;lt;=40 THEN 8&lt;br /&gt;
						 WHEN WKDAY2&amp;gt;40 THEN 9 END)WK2,&lt;br /&gt;
(SELECT CASE WHEN WKDAY2-WKDAY1 &amp;lt;=0 THEN 0&lt;br /&gt;
						 WHEN WKDAY2-WKDAY1 &amp;gt;0 AND WKDAY2-WKDAY1 &amp;lt;=5 THEN 1&lt;br /&gt;
						 WHEN WKDAY2-WKDAY1 &amp;gt;5 AND WKDAY2-WKDAY1 &amp;lt;=10 THEN 2&lt;br /&gt;
						 WHEN WKDAY2-WKDAY1 &amp;gt;10 AND WKDAY2-WKDAY1 &amp;lt;=15 THEN 3&lt;br /&gt;
						 WHEN WKDAY2-WKDAY1 &amp;gt;15 AND WKDAY2-WKDAY1 &amp;lt;=20 THEN 4&lt;br /&gt;
						 WHEN WKDAY2-WKDAY1 &amp;gt;20 AND WKDAY2-WKDAY1 &amp;lt;=25 THEN 5&lt;br /&gt;
						 WHEN WKDAY2-WKDAY1 &amp;gt;25 AND WKDAY2-WKDAY1 &amp;lt;=30 THEN 6&lt;br /&gt;
						 WHEN WKDAY2-WKDAY1 &amp;gt;30 AND WKDAY2-WKDAY1 &amp;lt;=35 THEN 7&lt;br /&gt;
						 WHEN WKDAY2-WKDAY1 &amp;gt;35 AND WKDAY2-WKDAY1 &amp;lt;=40 THEN 8&lt;br /&gt;
						 WHEN WKDAY2-WKDAY1 &amp;gt;40 THEN 9 END)DF&lt;br /&gt;
&lt;br /&gt;
 FROM&lt;br /&gt;
(SELECT  CAST(CAST(TD054 AS INTEGER)AS CHAR(9)) AS TA002,TC004,&lt;br /&gt;
					TC075,CAST(TD012*TC009 AS INTEGER) AS TWM,TC003,TD013,REPLACE(CD.UDF05,&amp;#039;/&amp;#039;,&amp;#039;&amp;#039;)AS UDF05,&lt;br /&gt;
					DATEDIFF(DAY,TC003,TD013)- (SELECT COUNT(MP004) FROM CMSMP WHERE MP004 BETWEEN TC003 AND TD013) AS WKDAY1,&lt;br /&gt;
					DATEDIFF(DAY,TC003,CD.UDF05)- (SELECT COUNT(MP004) FROM CMSMP WHERE MP004 BETWEEN TC003 AND CD.UDF05) AS WKDAY2&lt;br /&gt;
 					FROM v_COPTCD CD&lt;br /&gt;
					WHERE TD054 &amp;gt; 15 AND UDF05 &amp;gt;0  )X&lt;br /&gt;
//已建立views: v_CKDAYS&lt;br /&gt;
&amp;lt;/sql&amp;gt;&lt;/div&gt;</summary>
		<author><name>Root</name></author>
	</entry>
</feed>