Warning: include(../connect_mysql.php) [function.include]: failed to open stream: No such file or directory in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 12

Warning: include() [function.include]: Failed opening '../connect_mysql.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 12

Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 13

Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 13

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 25

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 25

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 26
SELECT sum(qty_ctn) as TOT_QTY FROM transale ts LEFT JOIN c_product p ON ts.itemno=p.ITNO LEFT JOIN m_prd_group m ON p.GRP=m.GRP_CODE WHERE ((orderdate like '%') and area='') and amount>0 AND (m.GRP_CODE NOT IN('G099','G088','G010')) ORDER BY COUNT(distinct ts.custno) desc

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 54

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 54

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 55

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 59

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 59

สัดส่วนการกระจายตามกลุ่มสินค้า

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www\_kpi\ps\nouse\ps_gp_buy_by_group.php.bak on line 73

Product Group	จำนวนร้านค้า ที่ซื้อ	% จากฐานลูกค้า ราย	จำนวนลัง	-	ร้านค้าที่ ไม่ซื้อ

กลุ่มสินค้าที่ไม่มีการสั่งซื้อ :