update.php

<?php

/*****************************************************
* Dugan Knoll
* Grinnell College '12
* Colin Tremblay
* Grinnell College '14
*
* This file creates .json files for the most recent dining hall meals.
* PROCEDURE
* 1. Remove old .json files
* 2. Pull nutrition.xml from server
* 3. Change the xml into a useful json
* 4. Pull menu.csv from server
* 5. Read the csv information from a file and create the menu objects.
* 6. Saves the menu files.
* 7. Updates the available-days file.
*
* Modified Tyler Dewey 
* Grinnell College '16
* 11/25/14
*****************************************************/

/*****************************************************
* Enable garbage collection during script. Note that this line
* requires a matching line below (at the very end of the code)
*/
gc_enable();
ini_set('display_errors', 'On');
ini_set('memory_limit', '-1');
set_time_limit(6000);
date_default_timezone_set("America/Chicago");
include_once "Menu.php";
include_once "Nutrition.php";

if( ($dates_handle2 = fopen('dates_array', 'r')) == false ){
  echo('Failed to open dates file.');
}
else{
  /****************************************************************************
* Check each of the old menus and only remove them if their date has passed.
*/
  $old_dates = unserialize(fread($dates_handle2, 5000));

  $is_old_dates = false;
  for($i = 0; $i<count($old_dates); ){
    
    $todays_date = new DateTime();
    $todays_date->setTime(0,0,0);
    
    $date = explode('-',$old_dates[$i]);
    $date = new DateTime($date[2].'-'.$date[0].'-'.$date[1]);
    $interval = $todays_date->diff($date, false);
    $diff = intval($interval->format('%r%d')); // Calculates number of days ahead
    if($diff < 0){
      if(!$is_old_dates){
        echo("Deleting old menus:</br>");
        $is_old_dates = true;
      }

      // Remove old menu file
      $menu_path = $old_dates[$i].".json \n";
      if (file_exists($menu_path)) {
        echo "$menu_path \n";
        unlink($menu_path);
      }

      // Remove old dishes file
      $dishes_path = $old_dates[$i]."_dishes.json \n";
      if (file_exists($dishes_path)) {
        echo "$dishes_path \n";
        unlink($dishes_path);
      }

      array_splice($old_dates, $i,1);
    }
    else $i++;
  }
}

echo '</br>';

/****************************************************************************
 * Check the server for a new nutrition.xml file.
 */

//if URI Exists
$lastmodified = filemtime ('./nutrition.xml');

//wget only pulls the file if the one at the location is newer than the local copy
exec('wget -N -t 3 http://wwwarchive.grinnell.edu/calendar/menu/nutrition.xml', $out, $return_val);
//save new file
if($return_val == 0) {
  if ($lastmodified == filemtime ('./nutrition.xml')){
    echo("</br>Nutrition file on server isn't new. Didn't Pull.</br>");
    $return_val = 1;
  }
  else{
    echo("</br>Pulled nutrition.xml from server.</br>");
    exec('chmod 755 ./nutrition.xml');
    if (file_exists("nutrition.json"))
      unlink("nutrition.json");
  }
}
else
  echo("</br>Failed to pull nutrition file with error ".$return_val." .</br>");


/****************************************************************************
 * Load the most recent nutrition file. Create json.
 */

// setup output file
$outfile = "nutrition.json";
// if nutrition.json already exists and we didn't pull new information, skip re-writing nutrition.json
if (file_exists($outfile) && file_exists("nutrition.xml")) {
  $xmlTime = filemtime ('./nutrition.xml');
  $jsonTime = filemtime ('./nutrition.json');
  if ($jsonTime == false || $xmlTime == false)
    echo("</br>Error reading nutrition file timestamps");
}
if((file_exists($outfile)) && ($return_val != 0) && ($xmlTime < $jsonTime))
  echo("Will not overwrite nutrition.json</br>");
else {
  if(($out_handle = fopen($outfile, 'w')) == false){
    echo('Failed to create nutrition file.');
  }
  $output = create_nutrition_json();

  // write the file
  fwrite($out_handle, $output);
  echo("</br>Wrote nutrition JSON.</br>");
  exec('chmod 755 ./nutrition.json');
  fclose($out_handle);
}

/****************************************************************************
 * Check the server for a new menu.csv file.
 */

//if URI Exists
if (file_exists('./menu.csv')) {
  $lastmodified = filemtime ('./menu.csv');
}
//wget only pulls the file if the one at the location is newer than the local copy
exec('wget -N -t 3 http://wwwarchive.grinnell.edu/calendar/menu/menu.csv', $out, $return_val);
//save new file
if($return_val == 0){
  if ($lastmodified == filemtime ('./menu.csv')){
    echo("</br>Menu file on server isn't new. Didn't Pull.</br>");
    $return_val = 1;
  }
  else{
    echo("</br>Pulled menu.csv from server.</br>");
    exec('chmod 755 ./menu.csv');
  }
}
else {
  //wget only pulls the file if the one at the location is newer than the local copy
  exec('wget -N -t 3 http://wwwarchive.grinnell.edu/calendar/menu/menus.csv', $out, $return_val);
  //save new file
  if ($return_val == 0){
    exec('chmod 755 ./menus.csv');
    exec('mv ./menus.csv ./menu.csv');
    if ($lastmodified == filemtime ('./menu.csv')){
      echo("</br>Menu file on server isn't new. Didn't Pull.</br>");
      $return_val = 1;
    }
    else
      echo("</br>Pulled menus.csv from server.</br>");
  }
  //else die("</br>Couldn't find new menu file on server.</br>");
}

/****************************************************************************
 * Load the most recent CSV file.
 */
$menu_file = fopen("menu.csv", "r") or die("Couldn't read menu file!");
$menus = array();
$todaysMeals = new Menu;
echo("</br>Loaded menu.csv...</br></br>");

$count = 0;

/****************************************************************************
 * Check each menu item from the csv and add it to the appropriate day's menu.
 */
 //MY VERSION OF PHP MADE ME TAKE OUT THE backslash (but that should be the default anyway)
 //while(($menu_item_arr = fgetcsv($menu_file,0,',','"','\\')) !== FALSE
   
  // get the nutrition json so it can be passed down
  $string = file_get_contents("nutrition.json");
  $json_a = json_decode($string, true);

if($json_a == null)
  echo("Error parsing nutrition.json");
while(($menu_item_arr = fgetcsv($menu_file,0,',','"')) !== FALSE
      && (count($menu_item_arr) >2))
{  str_replace("\0","",$menu_item_arr);
  //$menu_item_arr = str_getcsv($menu_item_csv,',','"','\\');
  
  //  echo $menu_item_arr[1];
  //  echo "</br></br>";

  // Check the Date.
  $date = str_replace("\0","",$menu_item_arr[21]);
  $date = explode('/', $date);
  
  // If the date cannot be read, forget the item.
  if(count($date) == 3) {
  //Make sure the item is intended for outtakes or marketplace
  // IF AT SOME POINT WE WANT TO ADD SPENCER GRILL MENU ITEMS,
  // THIS WILL NEED TO BE CHANGED
  $location = str_replace("\9", "", $menu_item_arr[1]);
  $meal = str_replace("\0","",$menu_item_arr[3]);
  $market = strpos($location, 'MARKETPLACE');
  $outtake = strpos($meal, 'OUT TAKES');
  if (($market !== false) || ($outtake !== false)) {
    $date[2] = substr($date[2],0,4);
    $curr_date = remove_leading_zero($date[0]).
      '-'.remove_leading_zero($date[1]).
      '-'.remove_leading_zero($date[2]); // Ex. 2-28-2012
    if(array_key_exists($curr_date, $menus)){
            $menus[$curr_date]->addDish($meal,
                          str_replace("\0","",$menu_item_arr[7]),
                          str_replace("\0","",$menu_item_arr[8]),
              str_replace("\0","",$menu_item_arr[12]),
              $json_a);
    }
    else{
      $menus[$curr_date] = new Menu;
      $menus[$curr_date]->addDish($meal,
                          str_replace("\0","",$menu_item_arr[7]),
                          str_replace("\0","",$menu_item_arr[8]),
              str_replace("\0","",$menu_item_arr[12]),
              $json_a);
    }
   }
  }
  else {
    echo('Failed to read menu item in row '.$count.'.</br>');
  }
  $count++;
 }
echo "</br>";

$keys = array_keys($menus);

/****************************************************************************
 * Output jsons and save each new day's menu.
 */

 $lastDate = "null";
 
$written = false; // We print 'Menu created for:' only one time.
for($i=0; $i<count($keys); $i++){
  $outfile = $keys[$i].'.json'; // e.g. 1-30-2012.json
  if( ($out_handle = fopen($outfile, 'w'))  ==  false ){
    echo('Failed to create menu file.');
  }
 
  $output = $menus[$keys[$i]]->printMeals();
  fwrite($out_handle, $output);
  fclose($out_handle);
  //  unlink($outfile);

  //Sanity check to make sure we have saved actual text.
  if(strlen($output)>0){
    if($written == false){
      echo('Menu created for:</br>');
      $written = true;
    }
    echo $keys[$i]."</br>";
  
  $lastDate = $keys[$i];
  }
}

echo "</br>";

// Add any future dates whose menus we do not yet want to delete.
for($i=0; $i< count($old_dates); $i++){
  if(!array_key_exists($old_dates[$i],$menus)){
    array_unshift($keys, $old_dates[$i]);
    echo("Kept the menu for ".$old_dates[$i].".</br>");
  }
}


/****************************************************************************
 * Save the dates that we have .json files for for future removal.
 */

$dates_info = serialize($keys);
if( ($dates_handle = fopen('dates_array', 'w'))  ==  false ){
  echo('Failed to create dates file. Please report this to the Grinnell app-dev team.');
}
fwrite($dates_handle, $dates_info);
fclose($dates_handle);

// Save the last day for setting the date picker

$last_date_info = "{\"Last_Day\":\"".$lastDate."\"}";

if( ($last_date_handle = fopen('last_date.json', 'w'))  ==  false ){
  echo('Failed to create last date json. Please report this to the Grinnell app-dev team.');
}
fwrite($last_date_handle, $last_date_info);
fclose($last_date_handle);


//The matching line to enable/disable garbage collection
gc_disable();
?>