<?php
$ValidAccess = 2010;
require_once("include/globals.php");


$moduleName = "ajax.fixMenuProducts.php";
// startLog($moduleName);

if (SessionActive() != 1 || ! UserLoggedIn()) {
   logExit("Session is not active",$moduleName);
   exit();
}

// Set userType
$userType = "Parent";
if (array_key_exists('type', $_SESSION['UserInfo']) && in_array($_SESSION['UserInfo']['type'],$AllAdminUserTypes)) $userType = "Admin";
if ($userType != 'Admin') return;


// Ensure that only valid user types have access to this module
if ($userType != 'Admin') {
   $error_message = getLanguageText('ERRORMSG-ACCESS-DENIED');
   logExit($error_message);
   exit;
}


// CSRF token validation
include "include/ajax.csrfToken.php";


// Set default timezone
date_default_timezone_set("Canada/Pacific");
$now = date("Y-m-d H:i:s",time());

$return_data = array();


// Get parameters
$schedule_num = intval($_GET['schedule_num']);
$supplier_school_num = intval($_GET['supplier_school_num']);

writeLog("schedule_num: $schedule_num");
writeLog("supplier_school_num: $supplier_school_num");


// Get supplier products from supplier school
$query = "SELECT * FROM supplier_products WHERE school_num = $supplier_school_num";
$results = db_query($query);

if (db_num_rows($results) == 0) {
   $return_data['ajax_return_msg'] = 'No Supplier Products';
   echo(json_encode($return_data));
   exit();
}

$Products = array();
$ProductNames = array();
while ($row = db_fetch_assoc($results)) {
   $rnum = $row['record_num'];
   $pname = $row['product_name'];

   $pname = preg_replace("/ -.*/","",$pname);
   $pname = preg_replace("/ =.*/","",$pname);

   $Products[$rnum] = $row;
   $ProductNames[$pname] = $rnum;
   writeLog("Product: $pname");
}


// Get menu items
$query = "SELECT hlmi.* FROM hotlunch_menu_items AS hlmi, hotlunch_menu_dates AS hlmd " .
         "WHERE hlmi.school_num = $school_num " .
         "AND hlmd.record_num = hlmi.menu_num " .
         "AND schedule_num IN ($schedule_num) " .
         "AND item_type = 'Item' " .
         "ORDER BY hlmd.sequence,hlmi.sequence";
$items = db_query($query);
$num = db_num_rows($items);
db_query("DELETE FROM hotlunch_menu_products WHERE school_num = $school_num AND menu_item_num = 0");

$table = new Table("hotlunch_menu_products");

$count = 0;
while ($row = db_fetch_array($items)) {
   extract($row);
   writeLog("record_num: $record_num");

   $title = preg_replace("/ -.*/","",$item_title);
   $title = preg_replace("/ =.*/","",$title);

   $found = 'No';
   $rnum = 0;
   if (array_key_exists($title, $ProductNames)) {
      $found = "Found";
      $rnum = $ProductNames[$title];
      db_query("DELETE FROM hotlunch_menu_products WHERE school_num = $school_num AND menu_item_num = $record_num");

      $entry = array();
      $entry['school_num'] = $school_num;
      $entry['menu_item_num'] = $record_num;
      $entry['product_sequence'] = 1;
      $entry['supplier_product_num'] = $rnum;
      $entry['supplier_product_qty'] = 1;

      $query = $table->BuildInsert($entry);
      writeLog($query);
      db_query($query);

      $count++;
   }
   writeLog("Item: $title - $found");

}

$return_data['ajax_return_msg'] = "Menu Items: $num -- Updated: $count";
echo(json_encode($return_data));

?>