function import($cachable = false, $urlparams = false)
{
require_once JPATH_COMPONENT . '/helpers/import.php';
date_default_timezone_set('UTC');
echo "<h1>Executing importation</h1>";
// set the default timezone to use. Available since PHP 5.1
$date = date("ym") . date("d") - 1;
//$date= 140930;
switch ($_GET["view"]) {
case 'additions':
$URL = 'http://www.myairlease.com/efu_media/MSNs_additions_' . $date . '-01.xls';
break;
case 'removals':
$URL = 'http://www.myairlease.com/efu_media/MSNs_removals_' . $date . '-01.xls';
break;
case 'updates':
$URL = 'http://www.myairlease.com/efu_media/MSNs_updates_' . $date . '-01.xls';
break;
}
$dest = '/Applications/XAMPP/xamppfiles/temp/file.xls';
echo $URL;
$file_headers = @get_headers($URL);
echo $file_headers[0];
if ($file_headers[0] != 'HTTP/1.1 200 OK') {
echo "<p>File NOT found! Today no new " . $_GET["view"] . " from " . $_POST["source"] . '</p>';
} else {
echo "<p>New update found, ready to import.<br />Source: " . $_POST["source"] . '</p>';
if (copy('http://www.myairlease.com/efu_media/MSNs_updates_' . $date . '-01.xls', $dest)) {
echo "<p>file found and copied to our server successfully</p>";
$myObject = new ImportHelper($_GET["view"], $_POST["source"], $dest);
$myObject->PrepareValues();
} else {
echo "Server could not download and copied succesfully the excel file from " . $_POST["source"];
}
}
echo '<a href="' . JURI::root() . 'administrator/index.php?option=com_available_assets&view=aircraftlist" class="btn btn-success">Return to Aircarf List</a>';
}
