SELECT oh.OACUNO,cu.OKCUNM,
cu.OKCUA1+' '+cu.OKCUA2+''+cu.OKCUA3++cu.OKCUA4 as ADDR,pv.CKTX40,cu.OKPHNO,cu.OKSDST,cu.OKCFC1,cu.OKCFC9,
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('01') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M1],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('02') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M2],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('03') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M3],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('04') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M4],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('05') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M5],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('06') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M6],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('07') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M7],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('08') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M8],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('09') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M9],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('10') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M10],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('11') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M11],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),5,2) IN('12') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [M12],
Sum(case when substring(cast(oh.OAORDT as VARCHAR(8)),1,4) IN('') then CONVERT(DECIMAL(10,2),(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) else 0 end) [TOTAL]
FROM MVXJDTA.OOHEAD AS oh
INNER JOIN MVXJDTA.CMNUSR AS cm ON oh.OASMCD = cm.JUUSID
INNER JOIN MVXJDTA.OCUSMA AS cu ON oh.OACUNO = cu.OKCUNO
RIGHT JOIN MVXJDTA.CSYSTS AS pv ON ((cu.OKECAR = pv.CKECAR) and pv.CKCONO='380')
WHERE (oh.OAORDT like '%') AND (((oh.OAORST BETWEEN '22' AND '77') OR (oh.OAORST IN ('99'))) AND (oh.OAORSL NOT IN ('99')))
AND (oh.OAORTP IN ()) AND (oh.OASMCD not in('11000','30001','30002','30003','30004'))
group by oh.OACUNO,cu.OKCUNM,cu.OKCUA1,cu.OKCUA2,cu.OKCUA3,cu.OKCUA4,cu.OKPHNO,cu.OKSDST,cu.OKCFC1,cu.OKCFC9,pv.CKTX40ยอดขาย by ร้านค้า
รหัสร้านค้า |
Duo Code |
ชื่อร้านค้า |
ที่อยู่ |
จังหวัด |
เบอร์โทร |
เขต |
พื้นที่ |
JAN |
FEB |
MAR |
APR |
MAY |
JUN |
JUL |
AUG |
SEP |
OCT |
NOV |
DEC |
TOTAL |
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\mangofplus\ps\ps_customer_buy_credit.php on line 163
|