<?php

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

db_query("USE hotlunch_20220927");

$OrderHeaders = array();

$query = "SELECT * FROM hotlunch_order_header WHERE ordered_by_type = 'Concession'";
$orders = db_query($query);

while ($row = db_fetch_assoc($orders)) {
   if ($row['added_date'] == '0000-00-00') $row['added_date'] = '2020-01-01';
   $OrderHeaders[] = $row;
}


db_query("USE hotlunch");
$hlohTable = new Table("hotlunch_order_header");

for ($i = 0; $i < count($OrderHeaders); $i++) {
   $row = $OrderHeaders[$i];

   $snum = $row['school_num'];
   $onum = $row['record_num'];

   $query = "SELECT count(*) FROM hotlunch_order_header WHERE school_num = $snum AND record_num = $onum";
   $numOrders = db_getVal($query);

   if ($numOrders == 0) {
      $query = "SELECT count(*) FROM hotlunch_order_items WHERE school_num = $snum AND order_num = $onum AND ordered_by_type = 'Concession'";
      $nItems = db_getVal($query);

      if ($nItems > 0) {
         $query = $hlohTable->BuildInsert($row,'Yes');
         echo("$query\n");
         db_query($query);
      }
   }
}

?>