33 lines
980 B
PHP
33 lines
980 B
PHP
<?php
|
|
|
|
include "db.php";
|
|
|
|
$school_num = 279;
|
|
$user_num = 1705672;
|
|
|
|
$query = "SELECT * FROM user_account WHERE school_num = $school_num AND user_num = $user_num AND deleted != 'Y' ORDER BY transaction_datetime";
|
|
$results = db_query($query);
|
|
|
|
$orders = "";
|
|
$balance = 0;
|
|
while ($row = db_fetch_assoc($results)) {
|
|
extract($row);
|
|
$balance = $balance + $transaction_amount;
|
|
$ostatus = '';
|
|
if ($order_num > 0) {
|
|
$ostatus = db_getVal("SELECT status FROM hotlunch_order_header WHERE school_num = $school_num AND record_num = $order_num");
|
|
if (strlen($orders)) $orders .= ",";
|
|
$orders .= $order_num;
|
|
}
|
|
|
|
printf("%s %10s %10s %10.2f %10.2f\n",$transaction_datetime,$order_num,$ostatus,$transaction_amount,$balance);
|
|
if ($balance <= 0.00) {
|
|
$query = "UPDATE hotlunch_order_header SET status = 'Paid' WHERE school_num = $school_num AND record_num IN ($orders)";
|
|
echo("$query\n");
|
|
db_query($query);
|
|
$orders = '';
|
|
}
|
|
}
|
|
|
|
?>
|