Warning: include(../connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\use_ps_get_free_item.php on line 14
Warning: include() [function.include]: Failed opening '../connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\use_ps_get_free_item.php on line 14
Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\use_ps_get_free_item.php on line 15
Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\use_ps_get_free_item.php on line 15
00
'','','','','','',''
SELECT ol.OBITNO AS ITEMNO,
ol.OBITDS AS ITEMNAME,
CONVERT(DECIMAL(10,2),sum(ol.OBORQA)) AS QTY,
CONVERT(DECIMAL(10,2),sum(ol.OBORQA*ol.OBNEPR)) AS NET_AMOUNT,
case
WHEN oh.OAORTP in('021','921') THEN 'CREDIT'
WHEN oh.OAORTP in('051') THEN 'PC'
WHEN oh.OAORTP in('031','035') THEN 'CASH'
WHEN oh.OAORTP in('011','911') THEN 'MT'
WHEN oh.OAORTP in('041','941') THEN 'IDS'
END AS CHANNEL,
it.MMITGR AS WEIGHT
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 oh.OASMCD = cm.JUUSID
WHERE (oh.OAORDT LIKE '00%') 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<=0)
AND (ol.OBORQA>='1')
AND (ol.OBITNO in('','','','','','',''))
GROUP BY oh.OAORTP,ol.OBITNO,ol.OBITDS,it.MMITGR
ORDER BY oh.OAORTP,it.MMITGR ASCSUMMARY
ItemCode |
ItemName |
Qty |
Amount |
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in E:\www\mobile\no\_ps\use_ps_get_free_item.php on line 97
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in E:\www\mobile\no\_ps\use_ps_get_free_item.php on line 99
|
| TOTAL |
|
0.00 |
0.00 |