<?php

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

$hloh = new Table("hotlunch_order_header");
$hloi = new Table("hotlunch_order_items");

$school_num = 19004;
$prevDB = "hotlunch_20160928";


db_query("USE $prevDB");

$ordersPrev = array();
$query = "SELECT * FROM hotlunch_order_header WHERE school_num = $school_num AND ordered_by_num NOT IN (647923,647925,647927,647928)";
$results = db_query($query);
while ($row = db_fetch_assoc($results)) {
   $onum = $row['record_num'];
   $ordersPrev[$onum] = $row;
}


db_query("USE hotlunch");
foreach ($ordersPrev as $onum => $order) {
   $query = "SELECT * FROM hotlunch_order_header WHERE school_num = $school_num AND record_num = $onum";
   $results = db_query($query);
   if (db_num_rows($results) == 0) {
      $insert = 'N';

      // Check for any current order for person
      $pnum = $order['ordered_by_num'];
      $results = db_query("SELECT * FROM hotlunch_order_header WHERE school_num = $school_num AND ordered_by_num = $pnum");
      if (db_num_rows($results) > 0) continue;

      // $insert = 'Y';

      $name = db_getVal("SELECT concat(first_name,' ',last_name) FROM people WHERE record_num = $pnum");
      echo("$onum - $pnum - $name\n");

      if ($insert == 'Y') {
         db_query("USE $prevDB");
         $items = array();
         $query = "SELECT * FROM hotlunch_order_items WHERE school_num = $school_num AND order_num = $onum";
         $results = db_query($query);
         while ($row = db_fetch_assoc($results)) {
            $items[] = $row;
         }
         db_query("USE hotlunch");

         $query = $hloh->BuildInsert($order);
         db_query($query);
         $onum = db_insert_id();

         for ($i = 0; $i < count($items); $i++) {
            $item = $items[$i];
            $item['order_num'] = $onum;
            $item['school_num'] = $school_num;
            $query = $hloi->BuildInsert($item);
            db_query($query);
         }
      }
   }
}

?>