<?php

include "db.php";
include "table.php";

$hlohTable = new Table("hotlunch_order_header");
$hloiTable = new Table("hotlunch_order_items");

$cutoff = '2026-09-01';
$school_num = 18402;
$ordered_by_num = 2299767;


$query = "SELECT * FROM hotlunch_order_change_log WHERE updated_time > '$cutoff 00:00:00' AND module = 'hotlunch_reports.php' ORDER BY school_num";
$query = "SELECT * FROM hotlunch_order_change_log WHERE school_num = $school_num AND ordered_by_num = $ordered_by_num";
$query = "SELECT * FROM hotlunch_order_change_log WHERE school_num = $school_num AND updated_time > '$cutoff 00:00:00' ORDER BY ordered_by_num";
$orders = db_query($query);

$num = db_num_rows($orders);
echo("Num Orders: $num\n");

$count = 0;
while ($row = db_fetch_assoc($orders)) {
   extract($row);
   $oUserNum = $user_num;
   if ($oUserNum == 0) continue;

   $query = "SELECT * FROM hotlunch_order_header WHERE school_num = $school_num AND schedule_num = $schedule_num AND ordered_by_num = $ordered_by_num";
   $results = db_query($query);
   if (db_num_rows($results) == 0) {

      $student = 'unknown';
      $username = 'unknown';
      $person = db_getVal("SELECT * FROM people WHERE record_num = $ordered_by_num");
      if (is_array($person)) {
         $student = $person['first_name'].' '.$person['last_name'];
         $user_num = $person['user_num'];

         $user = db_getVal("SELECT * FROM users WHERE record_num = $user_num");
         $username = $user['first_name'].' '.$user['last_name'];
      }
      $count++;

      if ($student != 'unknown') echo("$school_num - $student :: $username $oUserNum\n");
      echo("Schedule Num: $schedule_num    Order Num: $order_num ($status)    Person Num: $ordered_by_num\n");

      if ($schedule_num > 0) {
         $schedule_name = db_getVal("SELECT schedule_name FROM hotlunch_schedules WHERE $school_num = $school_num AND record_num = $schedule_num");
         echo("--- $schedule_name\n");
      }

      $order_items = explode("|||9",$order_detail);
      $prev_menu = 0;
      for ($i = 0; $i < count($order_items); $i++) {
         $entry = $order_items[$i];
         if ($i > 0) $entry = '9'.$entry;
         $item = explode("|",$entry);
         $menu_num = $item[0];
         $qty = $item[3];
         $price = '$'.$item[4];
         $mitem = $item[5];

         if ($prev_menu != $menu_num) {
            $mtitle = db_getVal("SELECT menu_title FROM hotlunch_menu_dates WHERE school_num = $school_num AND record_num = $menu_num");
            echo("  --- $mtitle $menu_num\n");
            $prev_menu = $menu_num;
         }

         printf("     %2d  %5s  %s\n",$qty,$price,$mitem);
      }
      echo("--------------------------------\n");
   }
}

echo("Not Replaced: $count\n");

?>