Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at E:\www\mobile\no\_ps\ps_rpt_sales_person_all.php:1) in E:\www\mobile\no\_ps\ps_rpt_sales_person_all.php on line 2
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at E:\www\mobile\no\_ps\ps_rpt_sales_person_all.php:1) in E:\www\mobile\no\_ps\ps_rpt_sales_person_all.php on line 2
Warning: Cannot modify header information - headers already sent by (output started at E:\www\mobile\no\_ps\ps_rpt_sales_person_all.php:1) in E:\www\mobile\no\_ps\ps_rpt_sales_person_all.php on line 11
Warning: include(../connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\ps_rpt_sales_person_all.php on line 27
Warning: include() [function.include]: Failed opening '../connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\ps_rpt_sales_person_all.php on line 27
Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\ps_rpt_sales_person_all.php on line 28
Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\ps_rpt_sales_person_all.php on line 28
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%')) 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 ())
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\ps_rpt_sales_person_all.php on line 83
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\ps_rpt_sales_person_all.php on line 98
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\mobile\no\_ps\ps_rpt_sales_person_all.php on line 100
|
| TOTAL |
0.00 |
0.00 |
0.00 |
|