= '$today' " .
"and status = 'Active' " .
"order by $scheduleSortOrder " .
"limit 0,1";
$schedules = db_query($query);
$schedule_num = 0;
if (db_num_rows($schedules) > 0) {
$row = db_fetch_array($schedules);
$schedule_num = $row['record_num'];
$schedule_name = $row['schedule_name'];
}
// Initialize row counter
$count = 0;
$otipSpans = "";
$otipSpanIDs = array();
echo("\n\n");
//
// Get set of students
//
$CurrentUserType = $_SESSION['UserInfo']['type'];
switch ($CurrentUserType) {
case 'SuperUser':
case 'System Administrator':
case 'Application Administrator':
case 'Administration Team':
case 'Schedule Team':
if (!isset($PageTitle)) {
if ($school_record['student_button_text']) $PageTitle = $school_record['student_button_text'] . " List";
else $PageTitle = getLanguageText('TEXT-STUDENT') . " List";
}
$swhere = "";
// Select by class if required
if ($action == 'class-students') {
if (array_key_exists('current_class_num',$_GET)) $current_class_num = intval($_GET['current_class_num']);
if (array_key_exists('current_class_num',$_POST)) $current_class_num = intval($_POST['current_class_num']);
if (strlen($current_class_num) && $current_class_num > 0) {
if ($school_record['implement_meal_locations'] == 'Y') $swhere .= "and (class_num = $current_class_num OR meal_location = $current_class_num) ";
else $swhere .= "and class_num = $current_class_num ";
$PageTitle = getLanguageText('TEXT-STUDENT-CLASS-LIST') . "
" . getClassInfo($current_class_num);
}
}
// Select by status if required
if ($action == 'students-unverified' || $naction == 'list-unverified') {
$swhere .= "and st.status = 'Unverified' ";
if (isset($PageTitle)) $PageTitle .= "
\n";
$PageTitle .= getLanguageText('TEXT-STUDENT-UNVERIFIED-LIST');
$override_naction = 'list-unverified';
}
// Select by status if required
if ($action == 'students-inactive' || $naction == 'list-inactive') {
$swhere .= "and st.status = 'Inactive' ";
if (isset($PageTitle)) $PageTitle .= "
\n";
$PageTitle .= getLanguageText('TEXT-INACTIVE');
$override_naction = 'list-inactive';
}
// Get students linked to an account
if ($action == 'account-students') {
if (array_key_exists('uid',$_GET)) $uid = intval($_GET['uid']);
if (array_key_exists('uid',$_POST)) $uid = intval($_POST['uid']);
$userid = "";
if (isset($uid) && $uid > 0) {
$swhere .= "and st.user_num = $uid ";
$query = "select userid from users where school_num = $school_num and record_num = $uid";
$userid = db_getVal($query);
$PageTitle = getLanguageText('TEXT-STUDENT-ACCOUNT-LIST') . " $userid";
}
}
// Get students with no class assigned
if ($naction == 'students-without-class-number') {
$swhere = "and (class_num IN (0,1,2) or class_num is null or user_num = 0 or user_num is null) ";
if (isset($PageTitle)) $PageTitle .= "
\n";
$PageTitle .= getLanguageText('TEXT-STUDENT-NO-CLASS-NUM-LIST');
$override_naction = 'students-without-class-number';
db_query("UPDATE people SET class_num = 1 WHERE school_num = $base_school_num AND class_num IS NULL");
}
// Get students with no student number
if ($naction == 'students-without-student-number') {
$swhere = "AND (student_number IS NULL OR student_number = '') ";
if (isset($PageTitle)) $PageTitle .= "
\n";
$PageTitle .= getLanguageText('TEXT-STUDENT-NO-STUDENT-NUMBER');
$override_naction = 'students-without-student-number';
}
$show_type = "";
if (array_key_exists('show_type',$_GET)) $show_type = $_GET['show_type'];
if (array_key_exists('show_type',$_POST)) $show_type = $_POST['show_type'];
if (strlen($show_type)) $swhere .= "AND people_type = '$show_type' ";
$cwhere = "and st.active != 'N' ";
if (array_key_exists('show_non_current',$_GET)) $cwhere = "and st.active = 'N' ";
// Build the query
// $lookup_where = str_replace("st.","",$lookup_where);
if (!isset($lookup_where)) $lookup_where = '';
$lookup_where = urldecode($lookup_where);
$query = "select st.* from people AS st, users AS u " .
"where st.school_num = $base_school_num " .
"and people_type IN ('Student','Customer','Staff') " .
"and u.school_num = $base_school_num " .
"and st.user_num = u.record_num " .
$cwhere .
$swhere .
$lookup_where .
"order by last_name, first_name";
break;
case 'Staff':
$unum = intval($_SESSION['UserInfo']['record_num']);
// Get people table record num for this staff person
$tnum = db_getVal("select record_num from people where school_num = $base_school_num and user_num = $unum");
// Get staff person's class_num
$class_num = db_getVal("select record_num from classes where teacher1 = $tnum or teacher2 = $tnum or teacher3 = $tnum or teacher4 = $tnum or teacher5 = $tnum");
// Build the query to get the students
$query = "select * from people " .
"where school_num = $base_school_num " .
"and people_type IN ('Student') " .
"and class_num = $class_num " .
"order by last_name, first_name";
$PageTitle = getLanguageText('TEXT-STUDENT-LIST');
break;
}
// Display the data
$message_width = $default_data_width;
include "form.messages.php";
$columnHeaders = array();
$columnHeaders[] = getLanguageText('TEXT-NAME');
$columnHeaders[] = getLanguageText('TEXT-ACCOUNT');
$columnHeaders[] = getLanguageText('TEXT-ORDERS');
$columnHeaders[] = getLanguageText('TEXT-STATUS');
$columnAlign = array('left','center','center','center','center','center');
if ($school_record['participant_grouping'] != 'None') {
if ($school_record['i_display_division'] == 'Y') {
$columnHeaders = array();
$columnHeaders[] = getLanguageText('TEXT-NAME');
if ($school_record['collect_student_number'] == 'Y') $columnHeaders[] = getLanguageText('TEXT-STUDENT-NUMBER');
$columnHeaders[] = $GlobalText['Class'];
$columnHeaders[] = getLanguageText('TEXT-DIVISION');
$columnHeaders[] = getLanguageText('TEXT-STATUS');
$columnHeaders[] = getLanguageText('TEXT-DISPLAY');
$columnHeaders[] = getLanguageText('TEXT-ACCOUNT');
$columnHeaders[] = getLanguageText('TEXT-ORDERS');
$columnAlign = array('left','center','center','center','center','center','center','center','center');
}
else {
$columnHeaders = array();
$columnHeaders[] = getLanguageText('TEXT-NAME');
if ($school_record['collect_student_number'] == 'Y') $columnHeaders[] = getLanguageText('TEXT-STUDENT-NUMBER');
$columnHeaders[] = $GlobalText['Class'];
$columnHeaders[] = getLanguageText('TEXT-STATUS');
$columnHeaders[] = getLanguageText('TEXT-DISPLAY');
$columnHeaders[] = getLanguageText('TEXT-ACCOUNT');
$columnHeaders[] = getLanguageText('TEXT-ORDERS');
$columnAlign = array('left','center','center','center','center','center','center','center','center');
}
}
// echo($query);
$students = db_query($query);
$data = array();
while ($row = db_fetch_array($students)) {
extract($row);
$student_num = $record_num;
$eclass = '';
// Create the class info tool tip
$span_id = "class_" . $class_num;
if ($class_num > 1 && !in_array($span_id,$otipSpanIDs)) {
$class_info = getClassInfo($class_num,'internal');
}
$gfield = 'grade';
if ($class_num > 1) {
// Get division info if required
if ($school_record['participant_grouping'] != 'None' && $school_record['i_display_division'] == 'Y' && $class_num > 1) {
$div = db_getVal("SELECT division FROM classes WHERE school_num = $base_school_num AND record_num = $class_num");
}
if ($class_num == 1) $grade = getLanguageText('TEXT-STAFF');
if ($class_num == 2) $grade = getLanguageText('TEXT-PARENT');
if ($class_num > 2) {
$query = "SELECT * FROM classes WHERE school_num = $base_school_num AND record_num = $class_num";
$results = db_query($query);
$row = db_fetch_array($results);
$grade = $row['grade'];
$gfield = 'grade';
if (!strlen($grade)) {
$grade = $row['label_description'];
$gfield = 'label_description';
if (strlen($grade) == 0 && strlen($row['description'])) {
$grade = $row['description'];
$gfield = 'description';
}
if (strlen($grade) == 0 && strlen($row['division'])) {
$grade = $row['division'];
$gfield = 'division';
}
if (!strlen($grade)) {
if ($people_type != 'Staff') {
$grade = " error ";
$eclass = " error";
$class_info = '';
}
}
}
}
}
else {
if ($class_num == 1) {
if ($people_type == 'Student') {
$grade = " error ";
$eclass = " error";
}
else {
$grade = getLanguageText('TEXT-CUSTOMER');
$eclass = " error";
}
}
if (intval($class_num) == 0) {
$grade = " error ";
if ($people_type == 'Staff') {
$grade = getLanguageText('TEXT-STAFF');;
}
}
}
if (!isset($class_info)) $class_info = '';
$grade = "$grade";
// Create the user account tooltip
$user_num = $user_num;
$user = "";
// If there is a valid user_num create the tip
if (isset($user_num) && $user_num > 0) {
$span_id = "user_$user_num";
$user = db_getVal("SELECT userid FROM users WHERE school_num = $base_school_num AND record_num = $user_num");
if (!in_array($span_id,$otipSpanIDs)) {
$uresults = db_query("SELECT * FROM users WHERE school_num = $base_school_num and record_num = $user_num");
if (db_num_rows($uresults)) {
$urow = db_fetch_array($uresults);
$user_balance = db_getVal("select sum(transaction_amount) as balance from user_account where school_num = $school_num and user_num = $user_num AND (deleted != 'Y' OR deleted IS NULL)");
$num_students = db_getVal("SELECT count(*) FROM people WHERE school_num = $base_school_num AND user_num = $user_num");
$user_balance = floatval($user_balance);
$otipSpans .= "" . $otipTABLE .
sprintf($otipROW2,"User ID: ",$urow['userid']) .
sprintf($otipROW2,"User Type: ",$urow['type']) .
sprintf($otipROW2,"Name: ",$urow['first_name'] . ' ' . $urow['last_name']) .
sprintf($otipROW2,"Email: ",$urow['email']) .
sprintf($otipROW2,"Phone: ",$urow['home_phone']) .
sprintf($otipROW2,"Status: ",$urow['status']) .
sprintf($otipROW2,"Students: ",$num_students) .
sprintf($otipROW2,"Reminder: ",$urow['email_reminders']) .
sprintf($otipROW2,"Date Added: ",$urow['date_added']) .
sprintf($otipROW2,'' . getLanguageText('TEXT-CURRENT-BALANCE') . ': ',$currencySymbol . number_format($user_balance,2)) .
"\n";
$otipSpanIDs[] = $span_id;
}
else {
unset($span_id);
$user = " error ";
}
}
if (isset($span_id)) $user = "$user";
}
$snums = $school_record['linked_sites'];
$orders = db_getVal("SELECT count(*) FROM hotlunch_order_header WHERE school_num IN ($snums) AND ordered_by_num = $record_num");
$status = "$status";
$mcat = strtolower(str_replace(' ','',$menu_price_category));
if ($menu_price_category != 'Regular') $menu_price_category = "$menu_price_category";
$menu_price_category = "$menu_price_category";
$status .= "
$menu_price_category";
if ($school_record['participant_grouping'] != 'None') {
$ntitle = "$people_type";
$name = "$last_name, $first_name";
if ($school_record['i_display_division'] == 'Y') {
$entry = array();
$entry[] = $name;
if ($school_record['collect_student_number'] == 'Y') $entry[] = $student_number;
$entry[] = $grade;
$entry[] = $div;
$entry[] = $status;
$entry[] = $display;
$entry[] = $user;
$entry[] = $orders;
$entry['record_num'] = $record_num;
$data[] = $entry;
}
else {
$entry = array();
$entry[] = $name;
if ($school_record['collect_student_number'] == 'Y') $entry[] = $student_number;
$entry[] = $grade;
$entry[] = $status;
$entry[] = $display;
$entry[] = $user;
$entry[] = $orders;
$entry['record_num'] = $record_num;
$data[] = $entry;
}
}
else $data[] = array("$last_name,$first_name",$user,$orders,$menu_price_category,"record_num" => $record_num);
}
?>
\n");
echo("$PageTitle
\n");
echo("\n");
$verified_icon = "
";
$contacts_icon = "
";
$order_icon = "
";
$class_icon = "
";
$money_icon = "
";
if (isset($override_naction)) $action .= "&override_naction=$override_naction";
if (isset($current_class_num)) $action .= "¤t_class_num=$current_class_num";
if ($action == 'account-students') $action .= "&uid=$uid";
if (!isset($current_teacher_id)) $current_teacher_id = '';
$commands = array("$verified_icon");
if ($school_record['display_class_lists'] != 'N') {
$commands[] = "$contacts_icon";
}
if ($school_record['participant_grouping'] != 'None') {
$commands[] = "$class_icon";
}
$commands[] = "$money_icon";
listData($data,$columnHeaders,$action,$commands,'N',$columnAlign);
echo("\n\n\n\n");
$extra = "";
if ($action == 'account-students') $extra = "&uid=$uid";
?>