43 lines
1.2 KiB
PHP
43 lines
1.2 KiB
PHP
<?php
|
|
|
|
include "db.php";
|
|
include "include/school-functions.php";
|
|
|
|
$school_num = readline("School Number: ");
|
|
// $schedule_num = readline("Schedule Number: ");
|
|
$menu_num = readline("Menu Number: ");
|
|
// $menu_item_num = readline("Menu Item Number: ");
|
|
|
|
|
|
$school_record = db_getVal("SELECT * FROM schools WHERE record_num = $school_num");
|
|
|
|
$query = "select ordered_by_type, ordered_by_num, menu_item_num, qty from hotlunch_order_items where school_num = $school_num and menu_num = $menu_num";
|
|
$orders = db_query($query);
|
|
|
|
$Students = array();
|
|
|
|
while ($row = db_fetch_assoc($orders)) {
|
|
extract($row);
|
|
$student = db_getVal("SELECT * FROM people WHERE school_num = $base_school_num AND record_num = $ordered_by_num");
|
|
if (!is_array($student)) {
|
|
echo("$ordered_by_num: ERROR\n");
|
|
}
|
|
else {
|
|
extract($student, EXTR_PREFIX_ALL, 's');
|
|
$name = $s_first_name.' '.$s_last_name;
|
|
$class_info = getClassInfo($s_class_num, 'internal');
|
|
$Students["$s_last_name $s_first_name"] = "$ordered_by_num: $name - $class_info ($menu_item_num - $qty)";
|
|
// echo("$ordered_by_num: $name\n");
|
|
}
|
|
}
|
|
|
|
ksort($Students);
|
|
|
|
$i = 1;
|
|
foreach ($Students AS $idx => $name) {
|
|
echo("$i - $name\n");
|
|
$i++;
|
|
}
|
|
|
|
?>
|