. */ if( !isset($setup['SetupEventType']) ) { exit(); } if( $setup['ShowParticipantList'] OR $_SESSION['sess_uid']>=1 ) { //Load workshops include "./include/g_workshop.php"; //Arrival status if( $setup['UseWebRegister']=="yes" ) { if( get_sql_date($setup['EventDateEnd'])"; $Arrival_status['pending'] = " $\"Not$ "; $Arrival_status['confirmed'] = " $\"Not$ "; }else { $Arrival_status['yes'] = " $\"Not$ "; $Arrival_status['pending'] = " $\"Confirmation$ "; $Arrival_status['confirmed'] = " $\"Confirmed$ "; } $Arrival_status["arrived"]=" $\"Registered\"$ "; } switch( get_var('show') ) { case "byfname": echoln("

Accepted participants by first name

"); $order="ORDER BY `persons`.`Firstname`, `persons`.`Lastname`, `persons`.`Created`"; break; case "byid": echoln("

Accepted participants by ID

"); $order="ORDER BY `persons`.`PersonID`"; break; case "bylname": echoln("

Accepted participants by family name

"); $order="ORDER BY `persons`.`Lastname`, `persons`.`Firstname`, `persons`.`Created`"; break; case "bywsname": echoln("

Accepted participants by 1^st timeslot workshop

"); $order="ORDER BY `persons`.`WorkshopIDSlot1`, `persons`.`Firstname`, `persons`.`Lastname`"; break; case "byws2name": echoln("

Accepted participants by 2^nd timeslot workshop

"); $order="ORDER BY `persons`.`WorkshopIDSlot2`, `persons`.`Firstname`, `persons`.`Lastname`"; break; case "byarrived": echoln("

Accepted participants by arrival status

"); $order="ORDER BY `persons`.`Accepted` DESC, `ab_bodies`.`BodyName`, `persons`.`FirstName`, `persons`.`LastName`"; break; case "parttype": echoln("

Accepted participants by participant type

"); $order="ORDER BY `persons`.`ParticipantType`, `ab_bodies`.`BodyName`, `persons`.`ParticipantOrder`"; break; case "bygym": echoln("

Accepted participants by gym

"); $order="ORDER BY `persons`.`Gym`, `persons`.`FirstName`, `persons`.`LastName`"; break; case "bylocal": default: echoln("

Accepted participants by body name

"); $order="ORDER BY `ab_bodies`.`BodyCategoryOrder`, `ab_bodies`.`BodyNameAscii`, `persons`.`ParticipantType`, `persons`.`Firstname`, `persons`.`Lastname`"; break; } $query = "SELECT `persons`.`PersonID`, `persons`.`FirstName`, `persons`.`LastName`, `ab_bodies`.`BodyName`, "; $query.= "`ab_bodies`.`BodyCategoryOrder` AS `BodyCategoryOrder`, `persons`.`Accepted`, `persons`.`ParticipantType` "; if( $setup['ShowWorkshopSelection'] AND $setup['SetupWSNumber']>=1 ) $query.= ", `persons`.`WorkshopIDSlot1`, `persons`.`WorkshopIDSlot2` "; if( $setup['ApplShowGym'] ) $query.= ", `persons`.`Gym`, `persons`.`LodgingNeeded` "; $query.= "FROM `ab_bodies`, `persons` "; $query.= "WHERE `ab_bodies`.`BodyCode` = `persons`.`BodyCode` AND (`persons`.`Accepted`='yes' OR `persons`.`Accepted`='pending' OR `persons`.`Accepted`='confirmed' OR `persons`.`Accepted`='arrived') "; $query.= $order; if( $res=doquery($query) ) { echoln(""); echoln(" "); echoln(" "); echoln(" "); echoln(" "); if( $setup['ShowWorkshopSelection'] AND $setup['SetupWSNumber']>=1 ) { if( $setup['SetupWSNumber']==1 ) { echoln(" "); }else { echoln(" "); echoln(" "); } }else { echoln(" "); } if( $setup['UseWebRegister']=="yes" ) echoln(" "); if( $setup['ApplShowGym'] ) echoln(" "); echoln(" "); $i=0; $total=0; $GymTot = array(); for( $i=0; $i<=$setup['NumberOfGyms']; $i++ ) $GymTot[$i] = 0; $WorkshopTot1 = array(); if( $setup['ShowWorkshopSelection'] AND $setup['SetupWSNumber']>=1 ) { foreach( array_keys($Workshop) as $key ) { $WorkshopTot1[$key] = 0; } } while( $row=mysql_fetch_array($res) ) { $i++; if( ($i%2)==1 ) { echoln(" "); }else { echoln(" "); } if( isset($row['Gym']) ) { $GymTot[ $row['Gym'] ]++; } if( $setup['ShowWorkshopSelection'] && $setup['SetupWSNumber']>=1 && $row['WorkshopIDSlot1']>0 ) { $WorkshopTot1[ $row["WorkshopIDSlot1"] ]++; } echoln(" "); echoln(" "); if( $row['ParticipantType']=="observer" AND $row['ParticipantType']!="-" AND $row['BodyCategoryOrder']==0 ) { // all observers of AEGEE-Europe are 'official guest' echoln(" "); }else { echoln(" "); } if( $setup['ShowWorkshopSelection'] AND $setup['SetupWSNumber']>=1 ) { echoln(" "); if( $setup['SetupWSNumber']>=2 ) { if( $row["WorkshopIDSlot1"]>0 && $Workshopslot[ $row["WorkshopIDSlot1"] ]=="both" ) { echoln(" "); }elseif( $row["WorkshopIDSlot2"]>0 ) { echoln(" "); $WorkshopTot1[ $row["WorkshopIDSlot2"] ]++; }else { echoln(" "); $WorkshopTot1[ $row["WorkshopIDSlot2"] ]++; } } }else { if( $row["ParticipantType"]=="-" AND $row['FirstName']=="Wim" AND $row['LastName']=="van Ravesteijn" ) { echoln(" "); }else { echoln(" "); } } if( $setup['UseWebRegister']=="yes" ) echoln(" "); if( $setup['ApplShowGym'] ) { if( $row['LodgingNeeded']=="no" ) echoln(" "); else echoln(" "); } echoln(" "); } echoln("

ID	Name	Body name	Workshop	Workshop 1^st timeslot	Workshop 2^nd timeslot	Participant Type	Arrived	Gym
".$EVENTNUMID."-".sprintf("%04d", $row['PersonID'])."	".ucwords(strtolower($row["FirstName"]))." ".$row["LastName"]."	Official guest	".$row["BodyName"]."	".$Workshop[ $row["WorkshopIDSlot1"] ]."		".$Workshop[ $row["WorkshopIDSlot2"] ]."		VIP	".$row["ParticipantType"]."	".$Arrival_status[ $row["Accepted"] ]."	X	".($row['Gym']>0 ? $row['Gym'] : "-")."

"); // Gym overview if( $setup['ApplShowGym'] ) { echoln("

"); echoln(" "); echoln(" "); for( $i=1; $i<=$setup['NumberOfGyms']; $i++ ) { echoln(" "); } echoln("
Gym Number of people Capacity
No selection ".$GymTot[0]." -
".$i." ".$GymTot[$i]." ".$setup['CapacityGym'.$i]."
"); } // Workshops overview if( $setup['ShowWorkshopSelection'] AND $setup['SetupWSNumber']>=1 ) { echoln("

Gym	Number of people	Capacity
No selection	".$GymTot[0]."	-
".$i."	".$GymTot[$i]."	".$setup['CapacityGym'.$i]."

"); echoln(" "); $ws=array_keys($Workshop); for($i=0; $i"); else echoln(" "); echoln(" "); echoln(" "); } echoln("
Workshop Selected
".$Workshop[ $ws[$i] ]." (".$Workshopslot[ $ws[$i] ]." slot) ".$WorkshopTot1[ $ws[$i] ]."
"); } echoln("

Workshop	Selected
".$Workshop[ $ws[$i] ]." (".$Workshopslot[ $ws[$i] ]." slot)	".$WorkshopTot1[ $ws[$i] ]."

Total: ".mysql_num_rows($res)." participants accepted.

"); } }else { echoln("The participants list is currently not available."); echoln("
Most likely the selection is not finished yet, please come back later when the selection has finished."); } ?>