62 lines
1.8 KiB
PHP
62 lines
1.8 KiB
PHP
<?php
|
|
require_once("include/globals.php");
|
|
|
|
if (SessionActive() != 1 || ! UserLoggedIn()) {
|
|
header("Location: /");
|
|
exit();
|
|
}
|
|
|
|
|
|
// Ensure that only valid user types have access to this module
|
|
$AllowedUserTypes = array('SuperUser','System Administrator','Application Administrator','Administration Team','Schedule Team');
|
|
if (checkPermission($AllowedUserTypes) != 1) {
|
|
echo("<br>\n");
|
|
$error_message = getLanguageText('ERRORMSG-ACCESS-DENIED');
|
|
include "form.messages.php";
|
|
return;
|
|
}
|
|
|
|
|
|
$query = "SELECT * " .
|
|
"FROM user_balance_save " .
|
|
"WHERE school_num = $school_num " .
|
|
"ORDER BY last_name, first_name";
|
|
$results = db_query($query);
|
|
|
|
$data = array();
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$entry = array();
|
|
|
|
$balance = '$'.number_format($row['balance'],2);
|
|
$posted_datetime = '';
|
|
if (intval($row['posted_time']) > 0) $posted_datetime = date("Y-m-d H:i:s",$row['posted_time']);
|
|
|
|
$entry[] = $row['original_userid'];
|
|
$entry[] = $row['original_type'];
|
|
$entry[] = $row['first_name'].' '.$row['last_name'];
|
|
$entry[] = $row['email'];
|
|
$entry[] = $row['balance_year'];
|
|
$entry[] = $balance;
|
|
$entry[] = $row['posted'];
|
|
$entry[] = $posted_datetime;
|
|
|
|
$data[] = $entry;
|
|
}
|
|
|
|
|
|
$column_headers = array(
|
|
getLanguageText('TEXT-USER-ID'),
|
|
getLanguageText('TEXT-TYPE'),
|
|
getLanguageText('TEXT-NAME'),
|
|
getLanguageText('TEXT-EMAIL'),
|
|
getLanguageText('TEXT-YEAR'),
|
|
getLanguageText('TEXT-BALANCE'),
|
|
getLanguageText('TEXT-POSTED'),
|
|
getLanguageText('TEXT-POSTED-TIME'),
|
|
);
|
|
$fname = genFileName("user-balances.csv");
|
|
xlsData($data,$column_headers,$fname);
|
|
|
|
exit();
|
|
?>
|