printer.graph.php

<?
include("adodb/adodb.inc.php");
$sucsDB = NewADOConnection('postgres8');
$sucsDB->Connect('dbname=sucs user=apache');
$sucsDB->SetFetchMode(ADODB_FETCH_ASSOC);

$res = $sucsDB->Execute("select username, sum(pages) as pages from printer where username != 'old' group by username order by sum(pages) desc");
$num = $res->RecordCount();
	for ($i=0;$i<$num;$i++) {
	$row[$i] = $res->FetchRow();
		if ($i < 12)
		{
			$item[]=$row[$i]['username'];
			$slice[]=$row[$i]['pages'];
		}
		else {
			$otherSize += $row[$i]['pages'];
		}
	}
//	$itemName[]="Other";
//	$sliceSize[]=$otherSize;
	
	$slice = array_merge(array($otherSize),$slice);
	$item = array_merge(array("Other"), $item);

/*	echo "<pre>";
	print_r($slice);
	print_r($item);*/

	include("../../lib/pieChart.php");
	piechart("Top 12, Users of Printing", $slice, $item,0)
?>