<?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 = '';
   }
}

?>