. */ include("./include/include.php"); include("./include/g_workshop.php"); admin_header(); if( !in_array("statistics_view", $_SESSION['sess_functions']) ) { echoln("You are not authorized to see this page."); }else { switch( get_var('show') ) { case "percountry": include("./include/g_country.php"); if( isset($_REQUEST['sort']) ) { $sort = $_REQUEST['sort']; }else { $sort = ""; } if( $sort!="Number" ) $sort="CountryCode"; echoln("

Applications per country

"); $query = "SELECT `ab_bodies`.`CountryCode`, count(`applications`.`id`) AS `Number` FROM `ab_bodies`, `applications` WHERE `ab_bodies`.`BodyCode` = `applications`.`BodyCode` AND ".$_SESSION['sess_sel']." GROUP BY `ab_bodies`.`CountryCode` ORDER BY `$sort`"; $query2 = "SELECT COUNT(`id`) AS `total` FROM `applications` WHERE ".$_SESSION['sess_sel']; if( @mysql_num_rows( $res=doquery($query) )>0 AND @mysql_num_rows( $res2=doquery($query2) )==1 ) { $row2 = mysql_fetch_array($res2); $total = $row2['total']; echoln(""); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); $i=0; while( $row=mysql_fetch_array($res) ) { $i++; if( ($i%2)==1 ) echoln(" "); else echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); } echoln("

Country code	Country	Total
".$row["CountryCode"]."	"); if( strlen($CountryPostal[ $row['CountryCode'] ])>0 ) echoln(" ".$CountryPostal[ $row['CountryCode'] ]); else echoln(" Unknown"); echoln("	".$row['Number']."	".number_format($row['Number']/$total*100, 1, ",", ".")." %

"); echoln("
Total: $i counties"); echoln("
Total: $total applications"); } break; case "perbody": if( isset($_REQUEST['sort']) ) { $sort = $_REQUEST['sort']; }else { $sort = ""; } if( $sort!="BodyCode" AND $sort!="CountryCode" AND $sort!="Number" ) $sort="BodyName"; echoln("

Applications per body

"); $query = "SELECT `applications`.`BodyCode`, `ab_bodies`.`BodyName`, `ab_bodies`.`CountryCode`, COUNT( `applications`.`id` ) AS `Number` FROM `ab_bodies`, `applications` WHERE `ab_bodies`.`BodyCode` = `applications`.`BodyCode` AND ".$_SESSION['sess_sel']." GROUP BY `ab_bodies`.`BodyCode` ORDER BY `$sort`"; $query2 = "SELECT COUNT(`id`) AS `total` FROM `applications` WHERE ".$_SESSION['sess_sel']; if( @mysql_num_rows( $res=doquery($query) )>0 AND @mysql_num_rows( $res2=doquery($query2) )==1 ) { $row2 = mysql_fetch_array($res2); $total = $row2['total']; echoln(""); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); $i=0; while( $row=mysql_fetch_array($res) ) { $i++; if( ($i%2)==1 ) echoln(" "); else echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); } echoln("

Body code	Body name	Country	Total
".$row["BodyCode"]."	".$row["BodyName"]."	".$row["CountryCode"]."	".$row["Number"]."	".number_format($row['Number']/$total*100, 1, ",", ".")." %

"); echoln("
Total: $i bodies"); echoln("
Total: $total applications"); } break; case "perday": if( isset($_REQUEST['sort']) ) { $sort = $_REQUEST['sort']; }else { $sort = ""; } if( $sort!="Number" ) $sort="ApplicationDay"; echoln("

Applications per day

"); $query = "SELECT LEFT(`applications`.`Created`,10) AS `ApplicationDay`, COUNT( `applications`.`id` ) AS `Number` FROM `applications` WHERE ".$_SESSION['sess_sel']." GROUP BY LEFT(`applications`.`Created`,10) ORDER BY `$sort`"; $query2 = "SELECT COUNT(`id`) AS `total` FROM `applications` WHERE ".$_SESSION['sess_sel']; if( @mysql_num_rows( $res=doquery($query) )>0 AND @mysql_num_rows( $res2=doquery($query2) )==1 ) { $row2 = mysql_fetch_array($res2); $total = $row2['total']; echoln(""); echoln(" "); echoln(" "); echoln(" "); echoln(" "); $i=0; while( $row=mysql_fetch_array($res) ) { $i++; if( ($i%2)==1 ) echoln(" "); else echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); } echoln("

Date	Total
".get_date($row["ApplicationDay"])."	".$row["Number"]."	".number_format($row['Number']/$total*100, 1, ",", ".")." %

"); echoln("
Total: $total applications"); echoln("

$\"Chart\"$

"); } break; case "arrivalperhour": if( isset($_REQUEST['sort']) ) { $sort = $_REQUEST['sort']; }else { $sort = ""; } if( $sort!="Number" ) $sort="ArrivalHour"; echoln("

Arrivals per hour

"); $query="SELECT LEFT(`DateArrival`,13) AS `ArrivalHour`, COUNT(`id` ) AS `Number` FROM `applications` WHERE ".$_SESSION['sess_sel']." GROUP BY LEFT(`DateArrival`,13) ORDER BY `$sort`"; if( @mysql_num_rows( $res=doquery($query) )>0 ) { echoln(""); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); $i=0; $total=0; while( $row=mysql_fetch_array($res) ) { $i++; $total+=$row["Number"]; if( ($i%2)==1 ) echoln(" "); else echoln(" "); if( $row['ArrivalHour']=="0000-00-00 00" ) echoln(" "); else echoln(" "); echoln(" "); echoln(" "); echoln(" "); } echoln("

Arrival	Total	Cumulative
No selection	".get_date($row["ArrivalHour"])." ".substr($row["ArrivalHour"],11,2).":00:00	".$row["Number"]."	".$total."

"); echoln("
Total: $total applications"); } break; case "departureperhour": if( isset($_REQUEST['sort']) ) { $sort = $_REQUEST['sort']; }else { $sort = ""; } if( $sort!="Number" ) $sort="DepartureHour"; echoln("

Departures per hour

"); $query="SELECT LEFT(`DateDeparture`,13) AS `DepartureHour`, COUNT(`id` ) AS `Number` FROM `applications` WHERE ".$_SESSION['sess_sel']." GROUP BY LEFT(`DateDeparture`,13) ORDER BY `$sort`"; if( @mysql_num_rows( $res=doquery($query) )>0 ) { echoln(""); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); $i=0; $total=0; while( $row=mysql_fetch_array($res) ) { $i++; $total+=$row["Number"]; if( ($i%2)==1 ) echoln(" "); else echoln(" "); if( $row['DepartureHour']=="0000-00-00 00" ) echoln(" "); else echoln(" "); echoln(" "); echoln(" "); echoln(" "); } echoln("

Departure	Total	Cumulative
No selection	".get_date($row["DepartureHour"])." ".substr($row["DepartureHour"],11,2).":00:00	".$row["Number"]."	".$total."

"); echoln("
Total: $total applications"); } break; case "workshop": include("./include/g_workshop.php"); foreach( $Workshop as $key => $value ) { $WorkshopTot1[ $key ] = 0; $WorkshopTot2[ $key ] = 0; $WorkshopTotSel[ $key ] = 0; } echoln("

Workshops

"); $query="SELECT `WorkshopID1`, `WorkshopID2`, `WorkshopID3`, `WorkshopID4`, `WorkshopIDSlot1`, `WorkshopIDSlot2` FROM `applications` WHERE ".$_SESSION['sess_sel']; if( @mysql_num_rows( $res=doquery($query) )>0 ) { while( $row=mysql_fetch_array($res) ) { $WorkshopTot1[ $row["WorkshopID1"] ]++; $WorkshopTot1[ $row["WorkshopID3"] ]++; $WorkshopTot2[ $row["WorkshopID2"] ]++; $WorkshopTot2[ $row["WorkshopID4"] ]++; $WorkshopTotSel[ $row["WorkshopIDSlot1"] ]++; $WorkshopTotSel[ $row["WorkshopIDSlot2"] ]++; } echoln(""); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); $ws=@array_keys($Workshop); for($i=0; $i"); else echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); } echoln("

Workshop	1^st choice	2^nd choice	Total	Selected
".$Workshop[ $ws[$i] ]."	".$WorkshopTot1[ $ws[$i] ]."	".$WorkshopTot2[ $ws[$i] ]."	".($WorkshopTot1[ $ws[$i] ]+$WorkshopTot2[ $ws[$i] ])."	".$WorkshopTotSel[ $ws[$i] ]."

"); } break; case "quorum": echoln("

Quorum

"); $query1 = "SELECT COUNT(`BodyCode`) AS `total` FROM `ab_bodies` WHERE `BodyStatus`='A'"; $query2 = "SELECT COUNT(`ab_bodies`.`BodyCode`) AS `count` FROM `ab_bodies`, `applications` WHERE `ab_bodies`.`BodyCode`=`applications`.`BodyCode` AND `ab_bodies`.`BodyStatus`='A' AND `applications`.`ParticipantType`='delegate' AND ".$_SESSION['sess_sel']." GROUP BY `ab_bodies`.`BodyCode`"; if( @mysql_num_rows( $res1=doquery($query1) )==1 AND @mysql_num_rows( $res2=doquery($query2) )>0 ) { $row1 = mysql_fetch_array($res1); $total = $row1['total']; $present = mysql_num_rows($res2); echoln(""); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln("

Status	Total
Applied	".$present."	".number_format($present/$total*100, 1, ",", ".")." %
Not appied	".($total-$present)."	".number_format(($total-$present)/$total*100, 1, ",", ".")." %

"); echoln("
Total: $total bodies (Antenna & AEGEE-WG) with voting rights"); echoln("
Note: only delegates are considered."); echoln("

$\"Chart\"$

"); } break; case "other": include("./include/g_accesstxt.php"); $query="SELECT COUNT(`id`) AS `total` FROM `applications` WHERE ".$_SESSION['sess_sel']; if( @mysql_num_rows( $res=doquery($query) )>0 ) { $row=mysql_fetch_array($res); $total=$row['total']; } if( $total<1 ) $total=1; // Prevent division by 0 for( $i=1; $i<=3; $i++ ) { $h="RegistrationCustField".$i; if( strlen($setup[$h])>0 ) { $query="SELECT `".$h."` AS `RegistrationCustField`, COUNT(`id`) AS `count` FROM `applications` WHERE ".$_SESSION['sess_sel']." GROUP BY `".$h."`"; if( @mysql_num_rows( $res=doquery($query) )>0 ) { echoln("

".$setup[$h]."

"); echoln(""); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); $a=0; while( $row=mysql_fetch_array($res) ) { $a++; if( ($a%2)==1 ) echoln(" "); else echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); } echoln("

".$setup[$h]."	Total	Percentage
".$row['RegistrationCustField']."	".$row['count']."	".number_format($row['count']/$total*100,0)."%

"); echoln("

$\"Chart\"$

"); } } } $items=array(); $items[]="BoardConfirmed"; $items[]="ParticipantType"; $items[]="Accepted"; $items[]="Sex"; $items[]="Visa"; $items[]="MemberType"; $items[]="AgoraVisited"; $items[]="HasMobile"; $items[]="HasLaptop"; $items[]="ExtraFee"; $items[]="TShirtSize"; $items[]="Gym"; for( $i=0; $i0 ) { echoln("

".$Accesstxt[ $items[$i] ]."

".$Accesstxt[ $items[$i] ]."	Total	Percentage
".$row['Item']."	".$row['count']."	".number_format($row['count']/$total*100,0)."%

"); echoln("

$\"Chart\"$

"); } } } break; default: echoln("Unknown total requested."); } } admin_footer(); ?>