SELECT oh.OASMCD+''+cm.JUTX40 as SALEMAN,
,
,
CONVERT(DECIMAL(10,2),(select sum(ol.OBNEPR)
from MVXJDTA.OOLINE as ol
where (((ol.OBITDS like 'DIS%') or (ol.OBITDS like 'PRO%')
or (ol.OBITNO in('VARY','DC01'))) and (oh.OASMCD=ol.OBSMCD)) and (ol.OBRGDT like '%'))) as DISCOUNT_LINE,
CASE
WHEN ((oh.OASMCD like '1%') AND (oh.OASMCD not in('10001','10034','10061'))) THEN 'CREDIT'
WHEN ((oh.OASMCD like '1%') AND (oh.OASMCD in('10001','10034','10061'))) THEN 'MT'
WHEN (oh.OASMCD like '2%') THEN 'CASH'
WHEN (oh.OASMCD like '3%') THEN 'PC'
WHEN (oh.OASMCD like '4%') THEN 'IDS'
END AS CHANNEL
FROM MVXJDTA.OOHEAD AS oh
INNER JOIN MVXJDTA.CMNUSR AS cm ON oh.OASMCD = cm.JUUSID
WHERE (oh.OAORDT LIKE '%') AND
(((oh.OAORST BETWEEN '22' AND '77') OR (oh.OAORST IN ('99','90'))) AND (oh.OAORSL NOT IN ('99','90'))) AND
(oh.OAORTP IN ())
AND (oh.OASMCD not in('11000','30001','30002','30003','30004'))
GROUP BY oh.OASMCD,cm.JUTX40
ORDER BY oh.OASMCD ASC
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ','., SQL state 37000 in SQLExecDirect in E:\www\_mango2\ps\ps_rpt_sales_person_all.php on line 100
SUMMARY
SALEMAN |
AMOUNT |
DISCOUNT_LINE |
TOT_AMOUNT |
CHANNEL |
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ','., SQL state 37000 in SQLExecDirect in E:\www\_mango2\ps\ps_rpt_sales_person_all.php on line 115
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\_mango2\ps\ps_rpt_sales_person_all.php on line 117
|
| TOTAL |
0.00 |
0.00 |
0.00 |
|