. */ include("./include/include.php"); admin_header(); if( !in_array("application_viewfee", $_SESSION['sess_functions']) ) { echoln("You are not authorized to see this page."); }else { echoln("

Fee income

"); $query="SELECT `FeePaid`, COUNT(`FeePaid`) AS `count` FROM `persons` WHERE `FeePaid`>=0 AND ".$_SESSION['sess_sel']." GROUP BY `FeePaid` ORDER BY `FeePaid`"; if( @mysql_num_rows( $res=doquery($query) )>0 ) { echoln(""); echoln(" "); $i=0; $total=0; while( $row=mysql_fetch_array($res) ) { $i++; if( ($i%2)==1 ) echoln(" "); else echoln(" "); echoln(" "); echoln(" "); echoln(" "); $total += $row['FeePaid']*$row['count']; echoln(" "); } if( ($i%2)==1 ) echoln(" "); else echoln(" "); echoln(" "); echoln(" "); echoln("

Fee	Count	Amount
€ ".number_format($row['FeePaid'], 2, ",", ".")."	".$row['count']."	€ ".number_format($row['FeePaid']*$row['count'], 2, ",", ".")."
Total:		€ ".number_format($total, 2, ",", ".")."

"); }else { echoln("No paid fee found."); } } admin_footer(); ?>