官网 › 汉之殇攻略兵法 › 汉之殇——全骑凹型阵！！（第一期）

东丶迁 发表于 2013-4-14 00:06:34

路过看看

kitara2 发表于 2013-4-14 02:31:08

kan yikan .......

xuxi547258 发表于 2013-4-14 06:54:19

谢谢楼主

Lenwe 发表于 2013-4-14 09:36:50

最近喜欢上了全骑玩法，果断看看~

飞将军海岩 发表于 2013-4-14 10:49:20

sdffs               

达摩 发表于 2013-4-14 10:54:42

楼主好人啊

qw232698727 发表于 2013-4-14 11:08:16

看看~! 什么阵法~!

hq1992825 发表于 2013-4-14 11:17:20

好好学习

531275865 发表于 2013-4-14 11:31:57

不管东西咋样 还是先谢谢了

亟枫叶影 发表于 2013-4-14 11:44:44

路过看看。。。。。

八神 发表于 2013-4-14 11:55:45

要来顶〜

夜幕星空 发表于 2013-4-14 12:01:39

打酱油的

西凉小卒 发表于 2013-4-14 13:45:52

看看。。。。

weilujie1121 发表于 2013-4-14 14:43:54

看看学习

祭司 发表于 2013-4-14 14:45:15

学习一下啊 啊

grey1212 发表于 2013-4-14 19:20:37

香烟，瓜子，杜蕾斯

gztx 发表于 2013-4-15 22:54:51

這個必須要支持呀~

wbwuvb 发表于 2013-4-15 23:17:10

RE: 汉之殇——全骑凹型阵！！（第一期） [修改]

三国迷糊剑 发表于 2013-4-15 23:55:49

hahahah bxnasnsjsff

2276960970 发表于 2013-4-16 13:20:58

CREATE or REPLACE VIEW scm_rpt_o_0270_vw    /*t4品番表（SCM_MTL_MATERIAL_TBL）
t1库存明细单（SCM_WMS_INV_PROC_DTL_TBL）t2库存处理单（SCM_WMS_INV_PROC_TBL）
t3采购订单（SCM_PO_ORDER_TBL）*/
AS
SELECT t4.RETROFIT_TYPE ,t4.DIST_TYPE,
DATE_FORMAT(CONVERT(CONCAT(t1.ACT_RCPT_DATE,'01'),datetime),'%Y') as YYYY,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '01' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_01,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '01' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_01,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '02' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_02,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '02' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_02,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '03' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_03,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '03' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_03,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '04' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_04,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '04' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_04,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '05' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_05,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '05' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_05,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '06' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_06,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '06' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_06,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '07' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_07,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '07' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_07,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '08' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_08,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '08' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_08,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '09' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_09,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '09' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_09,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '10' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_10,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '10' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_10,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '11' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_11,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '11' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_11,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '12' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)>=t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_WITHIN_12,
CASE WHEN mid(t1.ACT_RCPT_DATE,5,2) = '12' THEN (CASE WHEN DATE_SUB(t3.CREATE_DATE,INTERVAL 30

DAY)<t1.ACT_RCPT_DATE THEN t1.PO_RECONCIL_QTY ELSE NULL END) ELSE NULL END AS

SELL_BEYOND_12,
t1.ID


               FROM SCM_WMS_INV_PROC_DTL_TBL t1 INNER JOIN
                                        SCM_WMS_INV_PROC_TBL t2 ON t1.BILL_ID=t2.ID
                                        INNER JOIN SCM_PO_ORDER_TBL t3 ON t1.DATA_SOURCE_ID=t3.ID
                                        INNER JOIN SCM_MTL_MATERIAL_TBL t4 ON t1.ITEM_ID=t4.ID
               WHERE t1.DATA_SOURCE_BILL='PO_ORDER'

查看完整版本: 汉之殇——全骑凹型阵！！（第一期）