81 lines
2.7 KiB
PHP
81 lines
2.7 KiB
PHP
<?php
|
|
include "db.php";
|
|
|
|
|
|
$query = "SELECT * FROM user_balance_save ORDER BY school_num";
|
|
$query = "SELECT * FROM user_balance_save WHERE school_num = 374 ORDER BY school_num";
|
|
$balances = db_query($query);
|
|
|
|
$snum = 0;
|
|
|
|
while ($row = db_fetch_assoc($balances)) {
|
|
extract($row);
|
|
$userBalanceNum = $record_num;
|
|
$userNum = $user_num;
|
|
|
|
if ($school_num != $snum) {
|
|
$sname = db_getVal("SELECT school_name FROM schools WHERE record_num = $school_num");
|
|
echo("\n");
|
|
echo("=============================================================\n");
|
|
echo("==== $sname\n");
|
|
$snum = $school_num;
|
|
}
|
|
|
|
db_query("USE hotlunch_2015");
|
|
|
|
$query = "SELECT * FROM user_account " .
|
|
"WHERE school_num = $school_num " .
|
|
"AND user_num = $original_user_num " .
|
|
"AND transaction_status = 'Open' " .
|
|
"AND transaction_amount > 0 " .
|
|
"AND abs(amount_paid) < transaction_amount";
|
|
$query = "SELECT * FROM user_account " .
|
|
"WHERE school_num = $school_num " .
|
|
"AND user_num = $original_user_num";
|
|
$trx = db_query($query);
|
|
|
|
$trx_history = "";
|
|
while ($row = db_fetch_assoc($trx)) {
|
|
extract($row);
|
|
|
|
$sname = "";
|
|
if ($schedule_num > 0) {
|
|
$sname = "(" . db_getVal("SELECT schedule_name FROM hotlunch_schedules WHERE school_num = $school_num AND record_num = $schedule_num") . ") ";
|
|
}
|
|
$transaction_amount = '$' . number_format($transaction_amount,2);
|
|
$trx_history .= "$transaction_type|$transaction_amount|$sname|$note\n";
|
|
}
|
|
|
|
echo("$original_userid: $balance\n$trx_history\n");
|
|
|
|
db_query("USE hotlunch");
|
|
$trx_history = db_escape_string($trx_history);
|
|
|
|
db_query("UPDATE user_balance_save SET trx_history = '$trx_history' WHERE record_num = $userBalanceNum");
|
|
$results = db_query("SELECT * FROM user_balance_save WHERE record_num = $userBalanceNum");
|
|
$row = db_fetch_assoc($results);
|
|
if ($row['posted'] == 'Y') {
|
|
|
|
$userNum = $row['user_num'];
|
|
if (intval($userNum) > 0) {
|
|
$query = "SELECT * FROM user_account WHERE school_num = $school_num AND user_num = $userNum AND transaction_type = 'Charge Adjustment'";
|
|
echo("$query\n");
|
|
$results = db_query($query);
|
|
if (db_num_rows($results)) {
|
|
$trx = db_fetch_assoc($results);
|
|
$record_num = $trx['record_num'];
|
|
// echo("NEW:: $transaction_type: $transaction_amount - $note\n");
|
|
|
|
$query = "UPDATE user_account SET trx_history = '$trx_history' WHERE school_num = $school_num AND record_num = $record_num";
|
|
echo("$query\n");
|
|
db_query($query);
|
|
echo("user_account updated...\n");
|
|
}
|
|
}
|
|
}
|
|
|
|
echo("\n");
|
|
}
|
|
|
|
?>
|