Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at E:\www\mobile\ps\no\ps_show_sale_report.php.bak:1) in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 2
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at E:\www\mobile\ps\no\ps_show_sale_report.php.bak:1) in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 2
Warning: include(../connect/connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 3
Warning: include() [function.include]: Failed opening '../connect/connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 3
Warning: include(../config_period.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 4
Warning: include() [function.include]: Failed opening '../config_period.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 4
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 23
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 23
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 25
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 86
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 86
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 87
ยอดขายสินค้าเทียบเป้าหมาย (บาท)
| เป้าหมาย | ยอดขาย | +/- จากเป้าหมาย | %เทียบเป้าหมาย | Ranking |
| 0.00 | 0.00 | 0.00 | 0.00% | # |
...
ยอดขายสินค้าตามกลุ่มสินค้า
| กลุ่ม | กลุ่มสินค้า | เป้าหมาย (ลัง) | ยอดขาย (ลัง) | คิดเป็น % | วางแผนขาย | %จากการวางแผน | - |
SELECT m.GRP_CODE,m.GRP_DESC,sum(qty_ctn) as TOT_QTY,a.tg,a.all_qty_target,a.all_amt_target,
ts.area
FROM transale ts
LEFT JOIN itemfplus p ON ts.itemno=p.ITNO
LEFT JOIN item_group_report m ON p.GREPORT=m.GRP_CODE
LEFT JOIN sale_target_mobile a ON (((ts.area=a.area) and (a.period='')) and (m.GRP_CODE=a.grp_target))
WHERE ((orderdate like '%') and (ts.area=''))
AND m.GRP_CODE NOT IN('G11')
GROUP BY m.GRP_DESC,ts.area
ORDER BY ts.AREA,GRP_CODE
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 134
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 134
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 135
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 220
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\mobile\ps\no\ps_show_sale_report.php.bak on line 220
| สรุปรวม | 0.00 | 0.00 | 0.00% | 0.00 | 0.00% | |