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_detail.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\ps_rpt_sales_person_detail.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\ps_rpt_sales_person_detail.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\ps_rpt_sales_person_detail.php on line 13
SELECT ol.OBSMCD+''+cm.JUTX40 AS SALENAME,
ol.OBITNO AS ITEMNO,
ol.OBITDS AS ITEMNAME,
CONVERT(DECIMAL(10,2),(sum(ol.OBORQT)/(select max(un.MUCOFA) from MVXJDTA.MITAUN as un where ol.OBITNO=un.MUITNO))) as QTY,
,
CASE
WHEN ((ol.OBSMCD like '1%') AND (ol.OBSMCD not in('10001','10034'))) THEN 'CREDIT'
WHEN ((ol.OBSMCD like '1%') AND (ol.OBSMCD in('10001','10034'))) THEN 'MT'
WHEN (ol.OBSMCD like '2%') THEN 'CASH'
WHEN (ol.OBSMCD like '3%') THEN 'PC'
WHEN (ol.OBSMCD like '4%') THEN 'IDS'
END AS CHANNEL
FROM MVXJDTA.OOHEAD AS oh
INNER JOIN MVXJDTA.OOLINE AS ol ON oh.OAORNO = ol.OBORNO
INNER JOIN MVXJDTA.OCUSMA AS cu ON oh.OACUNO = cu.OKCUNO
INNER JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO
INNER JOIN MVXJDTA.CMNUSR as cm ON ol.OBSMCD = cm.JUUSID
WHERE (oh.OAORDT LIKE '%') AND
(oh.OAORTP IN ()) AND
(((oh.OAORST between '22' and '77') OR (oh.OAORST in ('99'))) and (oh.OAORSL not in('99'))) AND
(ol.OBORST not in ('90','99')) AND
(ol.OBSAPR>=1)
AND (ol.OBSMCD not in('11000','30001','30002','30003','30004'))
GROUP BY ol.OBSMCD,cm.JUTX40,ol.OBITNO,ol.OBITDS
ORDER BY ol.OBSMCD,ol.OBITNO ASC
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in E:\www\mobile\no\_ps\ps_rpt_sales_person_detail.php on line 74
SUMMARY
SALEMAN |
ITEMNO |
ITEMNAME |
QTY |
NETAMOUNT |
CHANNEL |
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in E:\www\mobile\no\_ps\ps_rpt_sales_person_detail.php on line 91
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\mobile\no\_ps\ps_rpt_sales_person_detail.php on line 93
|
| TOTAL |
|
|
|
0.00 |
|