/**
*
*/
public function exportairports()
{
$allairports = OperationsData::getAllAirports();
header('Content-Type: text/plain');
header('Content-Disposition: attachment; filename="airports.csv"');
$fp = fopen('php://output', 'w');
# Then write out all of the airports
foreach ($allairports as $ap) {
unset($ap->id);
fputcsv($fp, (array) $ap, ',');
}
fclose($fp);
}
public function importairports()
{
if (!file_exists($_FILES['uploadedfile']['tmp_name'])) {
$this->render('airport_import_form.php');
return;
}
echo '<h3>Processing Import</h3>';
# Get the column headers
$allaircraft = OperationsData::getAllAirports(false);
$headers = array();
$dbcolumns = DB::get_cols();
foreach ($dbcolumns as $col) {
$headers[] = $col->name;
}
$temp_name = $_FILES['uploadedfile']['tmp_name'];
$new_name = CACHE_PATH . '/' . $_FILES['uploadedfile']['name'];
if (!move_uploaded_file($temp_name, $new_name)) {
$this->render('core_error.php');
$this->set('message', 'Shit the bed?');
return false;
}
$fp = fopen($new_name, 'r');
if (isset($_POST['header'])) {
$skip = true;
}
$added = 0;
$updated = 0;
$total = 0;
echo '<div style="overflow: auto; height: 400px;
border: 1px solid #666; margin-bottom: 20px;
padding: 5px; padding-top: 0px; padding-bottom: 20px;">';
if (isset($_POST['erase_airports'])) {
OperationsData::deleteAllAirports();
echo "Deleting All Airports<br />";
}
while ($fields = fgetcsv($fp, 1000, ',')) {
// Skip the first line
if ($skip == true) {
$skip = false;
continue;
}
//Check for empty lines, continue
if (empty($fields)) {
continue;
}
//Create Varibles...
$icao = $fields[0];
$name = $fields[1];
$country = $fields[2];
$lat = $fields[3];
$lng = $fields[4];
$hub = $fields[5];
$fuelprice = $fields[6];
$chartlink = $fields[7];
//Since we need the values filled in, if not, then continue
if (empty($icao) || empty($lat) || empty($lng)) {
continue;
}
# Enabled or not
if ($hub == '1') {
$hub = true;
} else {
$hub = false;
}
//Build Array, seem can't use the array merge for some reason...
$data = array('icao' => $fields[0], 'name' => $fields[1], 'country' => $fields[2], 'lat' => $fields[3], 'lng' => $fields[4], 'hub' => $hub, 'fuelprice' => $fields[6], 'chartlink' => $fields[7]);
# Does this airport exist?
$aiport_info = OperationsData::getAirportInfo($icao);
if ($aiport_info) {
echo "Editing {$icao} - {$name}<br>";
OperationsData::editAirport($data);
$updated++;
} else {
echo "Adding {$icao} - {$name}<br>";
OperationsData::addAirport($data);
$added++;
}
$total++;
}
//You should always close a file before deleting otherwise it will spit the unlink error due to permissions
fclose($fp);
unlink($new_name);
echo "The import process is complete, added {$added} airports, updated {$updated}, for a total of {$total}<br />";
}
public function index()
{
$this->set('airports', OperationsData::getAllAirports());
$this->set('aircrafts', OperationsData::getAllAircraft('true'));
$this->show('realschedulelite/realschedulelite_index.tpl');
}
/**
* PIREPS::FilePIREPForm()
*
* @param string $bidid
* @return
*/
protected function FilePIREPForm($bidid = '')
{
if (!Auth::LoggedIn()) {
$this->set('message', 'You must be logged in to access this feature!');
$this->render('core_error.tpl');
return;
}
$this->set('pilot', Auth::$pilot->firstname . ' ' . Auth::$pilot->lastname);
$this->set('pilotcode', PilotData::GetPilotCode(Auth::$pilot->code, Auth::$pilot->pilotid));
$this->set('pirepfields', PIREPData::GetAllFields());
if ($bidid != '') {
$this->set('bid', SchedulesData::GetBid($bidid));
// get the bid info
}
$airport_list = OperationsData::getAllAirports();
$this->set('allairports', $airport_list);
#deprecated
$this->set('airport_list', $airport_list);
$airline_list = OperationsData::getAllAirlines(true);
$this->set('allairlines', $airline_list);
#deprecated
$this->set('airline_list', $airline_list);
$aircraft_list = OperationsData::getAllAircraft(true);
/* Skip any aircraft which have aircraft that the pilot
is not rated to fly (according to RANK)
This means the aircraft rank level is higher than
what the pilot's ranklevel, so just do "continue"
and move onto the next route in the list
*/
if (Config::Get('RESTRICT_AIRCRAFT_RANKS') === true) {
foreach ($aircraft_list as $index => $aircraft) {
if ($aircraft->ranklevel > Auth::$pilot->ranklevel) {
unset($aircraft_list[$index]);
continue;
}
}
}
$this->set('allaircraft', $aircraft_list);
#deprecated
$this->set('aircraft_list', $aircraft_list);
$this->render('pirep_new.tpl');
}
?>
<html>
<head>
</head>
<body>
<form method="get" action="">
Enter airport: <input type ="text" name="depicao" value="<?php
echo $_GET['depicao'];
?>
" />
<input type="submit" name="submit" value="View Distances" />
</form>
<p>To verify, use <a href="http://www.gpsvisualizer.com/calculators" target="_new">gps visualizer</a>. press control+f to find a certain airport.</p>
<?php
if (!isset($_GET['submit'])) {
exit;
}
$depicao = OperationsData::getAirportInfo($_GET['depicao']);
$all_airports = OperationsData::getAllAirports();
echo "Plotting distance between {$depicao->name} ({$depicao->icao}) and...<br><br>";
echo '<ul>';
foreach ($all_airports as $airport) {
Config::Set('UNITS', 'mi');
$mi_dist = OperationsData::getAirportDistance($depicao, $airport);
Config::Set('UNITS', 'km');
$km_dist = OperationsData::getAirportDistance($depicao, $airport);
Config::Set('UNITS', 'nm');
$nm_dist = OperationsData::getAirportDistance($depicao, $airport);
echo "<li>{$airport->name} ({$airport->icao})\n\t\t\t<ul>\n\t\t\t\t<li>{$depicao->lat}, {$depicao->lng} > {$airport->lat}, {$airport->lng}</li>\n\t\t\t\t<li>{$mi_dist} m</li>\n\t\t\t\t<li>{$km_dist} km</li>\n\t\t\t\t<li>{$nm_dist} nm</li>\n\t\t\t</ul>\n\t\t </li>";
}
echo '</ul>';
