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

Fee expectations

"); echoln("The fee used in the calculations is taken from Setup."); if( in_array($setup['SetupEventType'], array("AGORA", "EBM", "EPM")) ) { if( in_array($setup['SetupEventType'], array("EBM", "EPM")) ) { echoln("

Please note that this are fee calculations for an Agora. They can be an indication for " . $setup['SetupEventType'] . ", but keep in mind there is different people that participate for free.

"); } echoln("

Fee calculation:

"); $numbers = array(); $k = array(); $k[0] = "high"; $k[1] = "low"; $k[2] = "none"; $k[3] = "unknown"; $m = array(); $m[0] = "delegate"; $m[1] = "envoy"; $m[2] = "observer"; $m[3] = "visitor"; $m[4] = "-"; for( $i=0; $i no fee $query="SELECT `applications`.`ParticipantType` AS `ParticipantType`, COUNT(`applications`.`id`) AS `number` FROM `applications`, `ab_bodies` WHERE `applications`.`BodyCode`=`ab_bodies`.`BodyCode` AND (`ab_bodies`.`BodyCategoryOrder`>=0 AND `ab_bodies`.`BodyCategoryOrder`<=2) AND ".$_SESSION['sess_sel']." GROUP BY `applications`.`ParticipantType`"; if( !($res=doquery($query)) ) { echoln("
Unable to calculate the number of participants for bodies whose participants participate for free."); }else { while( $row=mysql_fetch_array($res) ) { $numbers['none'][ $row['ParticipantType'] ] += $row['number']; } } // Calculate for Honorary Members, Alumni Network, Working Groups, Projects, Connections -> unknown fee $query="SELECT `applications`.`ParticipantType` AS `ParticipantType`, COUNT(`applications`.`id`) AS `number` FROM `applications`, `ab_bodies` WHERE `applications`.`BodyCode`=`ab_bodies`.`BodyCode` AND ((`ab_bodies`.`BodyCategoryOrder`>=3 AND `ab_bodies`.`BodyCategoryOrder`<=6) OR `ab_bodies`.`BodyCategoryOrder`=9) AND ".$_SESSION['sess_sel']." GROUP BY `applications`.`ParticipantType`"; if( !($res=doquery($query)) ) { echoln("
Unable to calculate the number of participants for bodies whose participants participate with unknown free."); }else { while( $row=mysql_fetch_array($res) ) { $numbers['unknown'][ $row['ParticipantType'] ] += $row['number']; } } // Calculate for locals, contacts -> low or high fee $query="SELECT `applications`.`ParticipantType` AS `ParticipantType`, `countrycodes`.`Fee` AS `Fee`, COUNT(`applications`.`id`) AS `number` FROM `applications`, `ab_bodies`, `countrycodes` WHERE `applications`.`BodyCode`=`ab_bodies`.`BodyCode` AND `ab_bodies`.`CountryCode`=`countrycodes`.`Postal` AND (`ab_bodies`.`BodyCategoryOrder`=7 OR `ab_bodies`.`BodyCategoryOrder`=8) AND ".$_SESSION['sess_sel']." GROUP BY `applications`.`ParticipantType`, `countrycodes`.`Fee`"; if( !($res=doquery($query)) ) { echoln("
Unable to calculate the number of participants for locals and contacts."); }else { while( $row=mysql_fetch_array($res) ) { $numbers[ $row['Fee'] ][ $row['ParticipantType'] ] += $row['number']; } } echoln("

"); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); $totalfee += $numbers['high']['delegate']*$setup['DelegateHigh'] + $numbers['low']['delegate']*$setup['DelegateLow']; $numberhigh += $numbers['high']['delegate']; $numberlow += $numbers['low']['delegate']; $extrafeemax += $numbers['unknown']['delegate']*$setup['DelegateHigh']; $extrafeemin += $numbers['unknown']['delegate']*$setup['DelegateLow']; if( $numbers['high']['delegate']+$numbers['low']['delegate']>0 ) $extrafeeavg += $numbers['unknown']['delegate'] * ($numbers['high']['delegate']*$setup['DelegateHigh'] + $numbers['low']['delegate']*$setup['DelegateLow']) / ($numbers['high']['delegate']+$numbers['low']['delegate']); else $extrafeeavg += $numbers['unknown']['delegate'] * ($setup['DelegateHigh']+$setup['DelegateLow']) / 2; echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); $totalfee += $numbers['high']['envoy']*$setup['EnvoyHigh'] + $numbers['low']['envoy']*$setup['EnvoyLow']; $numberhigh += $numbers['high']['envoy']; $numberlow += $numbers['low']['envoy']; $extrafeemax += $numbers['unknown']['envoy']*$setup['EnvoyHigh']; $extrafeemin += $numbers['unknown']['envoy']*$setup['EnvoyLow']; if( $numbers['high']['envoy']+$numbers['low']['envoy']>0 ) $extrafeeavg += $numbers['unknown']['envoy'] * ($numbers['high']['envoy']*$setup['EnvoyHigh'] + $numbers['low']['envoy']*$setup['EnvoyLow']) / ($numbers['high']['envoy']+$numbers['low']['envoy']); else $extrafeeavg += $numbers['unknown']['envoy'] * ($setup['EnvoyHigh']+$setup['EnvoyLow']) / 2; echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); $totalfee += $numbers['high']['observer']*$setup['EnvoyHigh'] + $numbers['low']['observer']*$setup['EnvoyLow']; $numberhigh += $numbers['high']['observer']; $numberlow += $numbers['low']['observer']; $extrafeemax += $numbers['unknown']['observer']*$setup['EnvoyHigh']; $extrafeemin += $numbers['unknown']['observer']*$setup['EnvoyLow']; if( $numbers['high']['observer']+$numbers['low']['observer']>0 ) $extrafeeavg += $numbers['unknown']['observer'] * ($numbers['high']['observer']*$setup['EnvoyHigh'] + $numbers['low']['observer']*$setup['EnvoyLow']) / ($numbers['high']['observer']+$numbers['low']['observer']); else $extrafeeavg += $numbers['unknown']['observer'] * ($setup['EnvoyHigh']+$setup['EnvoyLow']) / 2; echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); $totalfee += $numbers['high']['visitor']*$setup['VisitorHigh'] + $numbers['low']['visitor']*$setup['VisitorLow']; $numberhigh += $numbers['high']['visitor']; $numberlow += $numbers['low']['visitor']; $extrafeemax += $numbers['unknown']['visitor']*$setup['VisitorHigh']; $extrafeemin += $numbers['unknown']['visitor']*$setup['VisitorLow']; if( $numbers['high']['visitor']+$numbers['low']['visitor']>0 ) $extrafeeavg += $numbers['unknown']['visitor'] * ($numbers['high']['visitor']*$setup['VisitorHigh'] + $numbers['low']['visitor']*$setup['VisitorLow']) / ($numbers['high']['visitor']+$numbers['low']['visitor']); else $extrafeeavg += $numbers['unknown']['visitor'] * ($setup['VisitorHigh']+$setup['VisitorLow']) / 2; echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); // Unknown column $extrafeemax += $numbers['unknown']['-'] * $setup['VisitorHigh']; $extrafeemin += $numbers['unknown']['-'] * $setup['DelegateLow']; if( $numberhigh+$numberlow>0 ) $extrafeeavg += $numbers['unknown']['-'] * ($totalfee / ($numberhigh+$numberlow)); else $extrafeeavg += $numbers['unknown']['-'] * ($setup['DelegateHigh']+$setup['DelegateLow']+$setup['EnvoyHigh']+$setup['EnvoyLow']+$setup['VisitorHigh']+$setup['VisitorLow']) / 6; $numberhigh += $numbers['high']['-']; $numberlow += $numbers['low']['-']; // High and Low column $extrafeemax += $numbers['high']['-']*$setup['VisitorHigh'] + $numbers['low']['-']*$setup['VisitorLow']; $extrafeemin += $numbers['high']['-']*$setup['DelegateHigh'] + $numbers['low']['-']*$setup['DelegateLow']; if( $numbers['high']['delegate']+$numbers['high']['envoy']+$numbers['high']['observer']+$numbers['high']['visitor']>0 ) $extrafeeavg += $numbers['high']['-'] * ($numbers['high']['delegate']*$setup['DelegateHigh'] + ($numbers['high']['envoy']+$numbers['high']['observer'])*$setup['EnvoyHigh'] + $numbers['high']['visitor']*$setup['VisitorHigh']) / ($numbers['high']['delegate']+$numbers['high']['envoy']+$numbers['high']['observer']+$numbers['high']['visitor']); else $extrafeeavg += $numbers['high']['-'] * ($setup['DelegateHigh']+$setup['EnvoyHigh']+$setup['VisitorHigh']) / 3; if( $numbers['low']['delegate']+$numbers['low']['envoy']+$numbers['low']['observer']+$numbers['low']['visitor']>0 ) $extrafeeavg += $numbers['low']['-'] * ($numbers['low']['delegate']*$setup['DelegateLow'] + ($numbers['low']['envoy']+$numbers['low']['observer'])*$setup['EnvoyLow'] + $numbers['low']['visitor']*$setup['VisitorLow']) / ($numbers['low']['delegate']+$numbers['low']['envoy']+$numbers['low']['observer']+$numbers['low']['visitor']); else $extrafeeavg += $numbers['low']['-'] * ($setup['DelegateLow']+$setup['EnvoyLow']+$setup['VisitorLow']) / 3; echoln("
Higher fee Lower fee No fee Unknown fee
Delegate ".$numbers['high']['delegate']." € ".number_format($numbers['high']['delegate']*$setup['DelegateHigh'], 0, ",", ".")." ".$numbers['low']['delegate']." € ".number_format($numbers['low']['delegate']*$setup['DelegateLow'], 0, ",", ".")." ".$numbers['none']['delegate']." € 0 ".$numbers['unknown']['delegate']." € ?
Envoy ".$numbers['high']['envoy']." € ".number_format($numbers['high']['envoy']*$setup['EnvoyHigh'], 0, ",", ".")." ".$numbers['low']['envoy']." € ".number_format($numbers['low']['envoy']*$setup['EnvoyLow'], 0, ",", ".")." ".$numbers['none']['envoy']." € 0 ".$numbers['unknown']['envoy']." € ?
Observer ".$numbers['high']['observer']." € ".number_format($numbers['high']['observer']*$setup['EnvoyHigh'], 0, ",", ".")." ".$numbers['low']['observer']." € ".number_format($numbers['low']['observer']*$setup['EnvoyLow'], 0, ",", ".")." ".$numbers['none']['observer']." € 0 ".$numbers['unknown']['observer']." € ?
Visitor ".$numbers['high']['visitor']." € ".number_format($numbers['high']['visitor']*$setup['VisitorHigh'], 0, ",", ".")." ".$numbers['low']['visitor']." € ".number_format($numbers['low']['visitor']*$setup['VisitorLow'], 0, ",", ".")." ".$numbers['none']['visitor']." € 0 ".$numbers['unknown']['visitor']." € ?
unknown ".$numbers['high']['-']." € ? ".$numbers['low']['-']." € ? ".$numbers['none']['-']." € 0 ".$numbers['unknown']['-']." € ?
"); echoln("

	Higher fee	Lower fee	No fee	Unknown fee
Delegate	".$numbers['high']['delegate']."	*€ ".number_format($numbers['high']['delegate']$setup['DelegateHigh'], 0, ",", ".")."**	".$numbers['low']['delegate']."	*€ ".number_format($numbers['low']['delegate']$setup['DelegateLow'], 0, ",", ".")."**	".$numbers['none']['delegate']."	€ 0	".$numbers['unknown']['delegate']."	€ ?
Envoy	".$numbers['high']['envoy']."	*€ ".number_format($numbers['high']['envoy']$setup['EnvoyHigh'], 0, ",", ".")."**	".$numbers['low']['envoy']."	*€ ".number_format($numbers['low']['envoy']$setup['EnvoyLow'], 0, ",", ".")."**	".$numbers['none']['envoy']."	€ 0	".$numbers['unknown']['envoy']."	€ ?
Observer	".$numbers['high']['observer']."	*€ ".number_format($numbers['high']['observer']$setup['EnvoyHigh'], 0, ",", ".")."**	".$numbers['low']['observer']."	*€ ".number_format($numbers['low']['observer']$setup['EnvoyLow'], 0, ",", ".")."**	".$numbers['none']['observer']."	€ 0	".$numbers['unknown']['observer']."	€ ?
Visitor	".$numbers['high']['visitor']."	*€ ".number_format($numbers['high']['visitor']$setup['VisitorHigh'], 0, ",", ".")."**	".$numbers['low']['visitor']."	*€ ".number_format($numbers['low']['visitor']$setup['VisitorLow'], 0, ",", ".")."**	".$numbers['none']['visitor']."	€ 0	".$numbers['unknown']['visitor']."	€ ?
unknown	".$numbers['high']['-']."	€ ?	".$numbers['low']['-']."	€ ?	".$numbers['none']['-']."	€ 0	".$numbers['unknown']['-']."	€ ?

The total known fee as shown in this table is € ".number_format($totalfee, 0, ",", ".")."."); echoln("
The total unknown fee (fields marked with '?') will add between € ".number_format($extrafeemin, 0, ",", ".")." and € ".number_format($extrafeemax, 0, ",", ".")." "); echoln("with an estimate of € ".number_format($extrafeeavg, 0, ",", ".")."."); echoln("
The total expected fee income is € ".number_format($totalfee+$extrafeeavg, 0, ",", ".").".

"); echoln("

For an Agora, the members of the following bodies participate don't pay a fee:"); echoln("

Comité Directeur
Chair team
Audit Commission
Juridical Commission
Members Commission
Network Commission
Liaison Officers

"); echoln("

Members from locals and contacts pay a fee based on the country they are in. Locals based in EU-25 or EFTA pay the higher "); echoln("fee, the others pay the lower fee. There is also a division made in the fee based on the participant type (delegate, envoy, observer and visitor).

"); echoln(""); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln(" "); echoln("

Higher fee	Lower fee
"); $query="SELECT `Name` FROM `countrycodes` WHERE `Fee`='high' ORDER BY `Name`"; if( @mysql_num_rows( $res=doquery($query) )>0 ) { echoln(" "); while( $row=mysql_fetch_array($res) ) { echoln(" ".ucwords(strtolower($row['Name']))." "); } echoln(" "); }else { echoln("No countries with the higher fee found."); } echoln("	"); $query="SELECT `Name` FROM `countrycodes` WHERE `Fee`='low' ORDER BY `Name`"; if( @mysql_num_rows( $res=doquery($query) )>0 ) { echoln(" "); while( $row=mysql_fetch_array($res) ) { echoln(" ".ucwords(strtolower($row['Name']))." "); } echoln(" "); }else { echoln("No countries with the lower fee found."); } echoln("

"); echoln("

The column 'Unknown fee' contains participants from Honorary Members, Alumni Network, Working Groups, Projects and Connections. Also Locals and Contacts for which its "); echoln("country is not mentioned in the table above, or locals without the country set will end up in this column.

"); }else { echoln("There is no fee calculations available for this type of event."); } } admin_footer(); ?>