.
*/
include("./include/include.php");
include("./include/Appl.php");
include("./include/g_accepted.php");
include("./include/g_body.php");
include("./include/g_meal.php");
admin_header();
if( !in_array("application_viewremarks", $_SESSION['sess_functions']) ) {
echoln("You are not authorized to see this page.");
}else {
echoln("Meals
");
$query="SELECT `Meals`, COUNT(`PersonID`) AS `Total` FROM `persons` WHERE ".$_SESSION['sess_sel']." GROUP BY `Meals` ORDER BY `Meals`";
if( @mysql_num_rows( $res=doquery($query) )<1 ) {
echoln("Empty selection.");
}else {
echoln("");
echoln(" ");
echoln(" | Meal | ");
echoln(" Total | ");
echoln("
");
$i=0;
$total=0;
while( $row=mysql_fetch_array($res) ) {
$i++;
$total+=$row["Total"];
if( ($i%2)==1 ) echoln(" ");
else echoln("
");
echoln(" | ".$Meals[ $row["Meals"] ]." | ");
echoln(" ".$row["Total"]." | ");
echoln("
");
}
echoln("
");
echoln("Total: ".$total." persons in current selection.
");
}
$usefields = array("BodyCode", "FirstName", "LastName", "Email", "Remarks");
$query = "SELECT `PersonID`, `Accepted`";
$fields = array();
$persons = array();
$dir = dirname($_SERVER["SCRIPT_FILENAME"])."/include/ApplFields/*.php";
if( is_dir(dirname($dir)) ) {
foreach( glob($dir) as $file ) {
if( is_file($file) ) {
if( substr(basename($file, ".php"), 3)!="Separator" AND in_array(substr(basename($file, ".php"), 3), $usefields) ) {
include("./include/ApplFields/".basename($file));
$field = substr(basename($file, ".php"), 3);
$fields[] = $field;
$class = "Appl".$field;
$persons[ $field ] = new $class(0);
$query .= ", `".$field."`";
}
}
}
}else {
debug(dirname($dir)." does not exist, failed loading application form fields");
}
$query .= " FROM `persons` WHERE ".$_SESSION['sess_sel']." AND `Meals`='diet' ORDER BY `Meals`, `FirstName`, `LastName`";
if( mysql_num_rows( $res=doquery($query) )>0 ) {
echoln("Special meals
");
echoln("");
echoln(" ");
echoln(" | | ");
if( $persons['FirstName']->get_access(false)!=Appl::ACCESS_NO )
echoln(" ".$persons['FirstName']->get_print_name_short()." | ");
if( $persons['LastName']->get_access(false)!=Appl::ACCESS_NO )
echoln(" ".$persons['LastName']->get_print_name_short()." | ");
if( $persons['BodyCode']->get_access(false)!=Appl::ACCESS_NO )
echoln(" ".$persons['BodyCode']->get_print_name_short()." | ");
echoln(" Accepted | ");
if( $persons['Remarks']->get_access(false)!=Appl::ACCESS_NO )
echoln(" ".$persons['Remarks']->get_print_name_short()." | ");
echoln("
");
$i=0;
$total=0;
while( $row=mysql_fetch_array($res) ) {
$i++;
if( ($i%2)==1 ) echoln(" ");
else echoln("
");
echoln(" ");
echoln(" ![\"Show](\"./image/info.gif\" "\\"Show") ");
if( $persons['Email']->get_access(false)!=Appl::ACCESS_NO )
echoln(" ![\"Send](\"./image/mail.gif\" "\\"Send") ");
echoln(" | ");
if( $persons['FirstName']->get_access(false)!=Appl::ACCESS_NO )
echoln(" ".$row["FirstName"]." | ");
if( $persons['LastName']->get_access(false)!=Appl::ACCESS_NO )
echoln(" ".$row["LastName"]." | ");
if( $persons['BodyCode']->get_access(false)!=Appl::ACCESS_NO )
echoln(" ".$Body[ $row["BodyCode"] ]." | ");
echoln(" ![\"".$Accepted_text[](\"".$Accepted_img[ "\\"\".$Accepted_text[") | ");
if( $persons['Remarks']->get_access(false)!=Appl::ACCESS_NO )
echoln(" ".$row["Remarks"]." | ");
echoln("
");
}
echoln("
");
}
}
admin_footer();
?>