<?php

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

$school_num = 19232;


$DataSets = array("users","people","hotlunch_order_header","hotlunch_order_items","user_account","user_account_detail","user_online_payments");


for ($n = 0; $n < count($DataSets); $n++) {
   $TableName = $DataSets[$n];

   switch ($TableName) {
      case 'users':
         $query = "SELECT * FROM users WHERE school_num = $school_num AND type = 'Parent'";
         break;

      case 'people':
         $query = "SELECT * FROM users WHERE school_num = $school_num AND user_type IN ('Student','Customer')";
         break;

      default:
         $query = "SELECT * FROM $TableName WHERE school_num = $school_num";
         break;
   }

   db_query("USE hotlunch_20210207");

   $DataArray = array();

   $results = db_query($query);
   while ($row = db_fetch_assoc($results)) {
      $DataArray[] = $row;
   }

   echo("$TableName " . count($DataArray) . "\n");


   db_query("USE hotlunch");

   $Table = new Table($TableName);

   for ($i = 0; $i < count($DataArray); $i++) {
      $row = $DataArray[$i];
      $query = $Table->BuildInsert($row,'Yes');
      db_query($query);
   }
}


?>