= '$today' " .
"and status = 'Active' " .
"and schedule_for = 'Anyone' " .
"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'];
}
if (!isset($PageTitle)) {
$PageTitle = getLanguageText('TEXT-CUSTOMERS');
}
// Initialize row counter
$count = 0;
$otipSpans = "";
$otipSpanIDs = array();
//
// Get set of students
//
$CurrentUserType = $_SESSION['UserInfo']['type'];
switch ($CurrentUserType) {
case 'SuperUser':
case 'System Administrator':
case 'Application Administrator':
case 'Administration Team':
case 'Schedule Team':
// Build the query
$lookup_where = str_replace("st.","",$lookup_where);
$query = "select * from people " .
"where school_num = $base_school_num " .
"and people_type = 'Customer' " .
$lookup_where .
"order by last_name, first_name";
break;
case 'Parent':
case 'Staff':
// Build the query
$unum = $_SESSION['UserInfo']['record_num'];
$query = "select * from people " .
"where school_num = $base_school_num " .
"and people_type = 'Customer' " .
"and user_num = $unum " .
"order by last_name, first_name";
break;
}
// Display the data
$message_width = $default_data_width;
include "form.messages.php";
$columnHeaders = array(getLanguageText('TEXT-NAME'),
getLanguageText('TEXT-ACCOUNT'),
getLanguageText('TEXT-ORDERS')
);
$columnAlign = array('left','center','center','center','center','center');
$customers = db_query($query);
$data = array();
while ($row = db_fetch_array($customers)) {
extract($row);
// Create the user account tooltip
$user_num = $user_num;
$user = "";
// If there is avalid 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)");
$user_balance = floatval($user_balance);
$otipSpans .= "" . $otipTABLE .
sprintf($otipROW2,getLanguageText('TEXT-USER-ID').": ",$urow['userid']) .
sprintf($otipROW2,getLanguageText('TEXT-USER-TYPE').": ",$urow['type']) .
sprintf($otipROW2,getLanguageText('TEXT-NAME').": ",$urow['first_name'] . ' ' . $urow['last_name']) .
sprintf($otipROW2,getLanguageText('TEXT-EMAIL').": ",$urow['email']) .
sprintf($otipROW2,getLanguageText('TEXT-PHONE').": ",$urow['home_phone']) .
sprintf($otipROW2,getLanguageText('TEXT-STATUS').": ",$urow['status']) .
sprintf($otipROW2,getLanguageText('TEXT-SYSTEM-REMINDER').": ",$urow['email_reminders']) .
sprintf($otipROW2,getLanguageText('TEXT-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");
$data[] = array("$last_name,$first_name",$user,$orders,"record_num" => $record_num);
}
echo("\n");
echo("$PageTitle
\n");
echo("\n");
$order_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";
$commands = array("$money_icon");
listData($data,$columnHeaders,$action,$commands,'Y',$columnAlign);
?>