='" . ($currentyear-2) . "-01-01' GROUP BY date_format(date,'%M %Y') ORDER BY date ASC"; $result = full_query($query); while ($data = mysql_fetch_array($result)) { $month = (int)$data[0]; $year = (int)$data[1]; $amountin = $data[2]; $fees = $data[3]; $amountout = $data[4]; $monthlybalance = $amountin - $fees - $amountout; $reportvalues[$year][$month] = array($amountin, $fees, $amountout, $monthlybalance); } foreach ($months as $k => $monthName) { if ($monthName) { $amountin = $reportvalues[$currentyear][$k][0]; $fees = $reportvalues[$currentyear][$k][1]; $amountout = $reportvalues[$currentyear][$k][2]; $monthlybalance = $reportvalues[$currentyear][$k][3]; $reportdata['tablevalues'][] = array( $monthName . ' ' . $currentyear, formatCurrency($amountin), formatCurrency($fees), formatCurrency($amountout), formatCurrency($monthlybalance), ); $overallbalance += $monthlybalance; } } $reportdata['footertext'] = '

Balance: ' . formatCurrency($overallbalance) . '

'; $chartdata['cols'][] = array('label'=>'Days Range','type'=>'string'); $chartdata['cols'][] = array('label'=>$currentyear-2,'type'=>'number'); $chartdata['cols'][] = array('label'=>$currentyear-1,'type'=>'number'); $chartdata['cols'][] = array('label'=>$currentyear,'type'=>'number'); for ($i = 1; $i <= 12; $i++) { $chartdata['rows'][] = array( 'c'=>array( array( 'v'=>$months[$i], ), array( 'v'=>$reportvalues[$currentyear-2][$i][3], 'f'=>formatCurrency($reportvalues[$currentyear-2][$i][3]), ), array( 'v'=>$reportvalues[$currentyear-1][$i][3], 'f'=>formatCurrency($reportvalues[$currentyear-1][$i][3]), ), array( 'v'=>$reportvalues[$currentyear][$i][3], 'f'=>formatCurrency($reportvalues[$currentyear][$i][3]), ), ), ); } $args = array(); $args['colors'] = '#3070CF,#F9D88C,#cb4c30'; $args['chartarea'] = '80,20,90%,350'; $reportdata['headertext'] = $chart->drawChart('Column',$chartdata,$args,'400px');