Warning: include(../connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\bk_ps_rpt_sales_person_all.php on line 12
Warning: include() [function.include]: Failed opening '../connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\bk_ps_rpt_sales_person_all.php on line 12
Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\bk_ps_rpt_sales_person_all.php on line 13
Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\bk_ps_rpt_sales_person_all.php on line 13
SELECT oh.OASMCD+''+cm.JUTX40 as SALEMAN,
CONVERT(DECIMAL(10,2),sum(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100))) AS TOT_AMT,
CONVERT(DECIMAL(10,2),sum(oh.OANTLA*oh.OAOTDP/100)) AS DIS_AMOUNT,
CONVERT(DECIMAL(10,2),(select sum(ol.OBNEPR) from MVXJDTA.OOLINE as ol where (((ol.OBITDS like 'DIS%') or (ol.OBITDS like 'PRO%')) 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'))) THEN 'CREDIT'
WHEN ((oh.OASMCD like '1%') AND (oh.OASMCD in('10001','10034'))) 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'))) AND (oh.OAORSL NOT IN ('99'))) AND
(oh.OAORTP IN ('021', '921', '011', '911', '041', '941', '051', '031', '035','034','281','A31'))
AND (oh.OASMCD not in('11000','30001','30002','30003','30004'))
GROUP BY oh.OASMCD,cm.JUTX40
ORDER BY oh.OASMCD ASC
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in E:\www\mobile\no\_ps\bk_ps_rpt_sales_person_all.php on line 50
SUMMARY
SALEMAN |
AMOUNT |
DISCOUNT_LINE |
TOT_AMOUNT |
CHANNEL |
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in E:\www\mobile\no\_ps\bk_ps_rpt_sales_person_all.php on line 65
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\mobile\no\_ps\bk_ps_rpt_sales_person_all.php on line 67
|
| TOTAL |
0.00 |
0.00 |
0.00 |
|