airport-detailed.php

<?php
require_once('require/class.Connection.php');
require_once('require/class.Spotter.php');
require_once('require/class.Language.php');
require_once('require/class.Stats.php');
require_once('require/class.METAR.php');

if (!isset($_GET['airport'])){
	header('Location: '.$globalURL.'/airport');
} else {
	$Spotter = new Spotter();
	//calculation for the pagination
	if(!isset($_GET['limit']))
	{
		$limit_start = 0;
		$limit_end = 25;
		$absolute_difference = 25;
	}  else {
		$limit_explode = explode(",", $_GET['limit']);
		$limit_start = $limit_explode[0];
		$limit_end = $limit_explode[1];
		if (!ctype_digit(strval($limit_start)) || !ctype_digit(strval($limit_end))) {
			$limit_start = 0;
			$limit_end = 25;
		}
	}
	$absolute_difference = abs($limit_start - $limit_end);
	$limit_next = $limit_end + $absolute_difference;
	$limit_previous_1 = $limit_start - $absolute_difference;
	$limit_previous_2 = $limit_end - $absolute_difference;
	$airport_icao = filter_input(INPUT_GET,'airport',FILTER_SANITIZE_STRING);
	$airport = $airport_icao;
	$page_url = $globalURL.'/airport/'.$airport_icao;
	
	$sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING);
	$airport_array = $Spotter->getAllAirportInfo($airport_icao);
	if (!empty($airport_array))
	{
		if ($sort != '') {
			$spotter_array = $Spotter->getSpotterDataByAirport($airport_icao,$limit_start.",".$absolute_difference, $sort);
		} else {
			$spotter_array = $Spotter->getSpotterDataByAirport($airport_icao,$limit_start.",".$absolute_difference, '');
		}
		
		if (isset($globalMETAR) && $globalMETAR) {
			$METAR = new METAR();
			$metar_info = $METAR->getMETAR($airport_icao);
			//print_r($metar_info);
			if (isset($metar_info[0]['metar'])) $metar_parse = $METAR->parse($metar_info[0]['metar']);
            		//print_r($metar_parse);
		}
		
		$title = sprintf(_("Detailed View for %s, %s (%s)"),$airport_array[0]['city'],$airport_array[0]['name'],$airport_array[0]['icao']);

		require_once('header.php');
		
		print '<div class="select-item">';
		print '<form action="'.$globalURL.'/airport" method="post">';
		print '<select name="airport" class="selectpicker" data-live-search="true">';
		print '<option></option>';
		$Stats = new Stats();
		$airport_names = $Stats->getAllAirportNames();
		if (empty($airport_names)) $airport_names = $Spotter->getAllAirportNames();
		ksort($airport_names);
		foreach($airport_names as $airport_name)
		{
			if($airport_icao == $airport_name['airport_icao'])
			{
				print '<option value="'.$airport_name['airport_icao'].'" selected="selected">'.$airport_name['airport_city'].', '.$airport_name['airport_name'].', '.$airport_name['airport_country'].' ('.$airport_name['airport_icao'].')</option>';
			} else {
				print '<option value="'.$airport_name['airport_icao'].'">'.$airport_name['airport_city'].', '.$airport_name['airport_name'].', '.$airport_name['airport_country'].' ('.$airport_name['airport_icao'].')</option>';
			}
		}
		print '</select>';
		print '<button type="submit"><i class="fa fa-angle-double-right"></i></button>';
		print '</form>';
		print '</div>';
		print '<br />';
		
		if ($airport_icao != "NA")
		{
			print '<div class="info column">';
			print '<h1>'.$airport_array[0]['city'].', '.$airport_array[0]['name'].' ('.$airport_array[0]['icao'].')</h1>';
			print '<div><span class="label">'._("Name").'</span>'.$airport_array[0]['name'].'</div>';
			print '<div><span class="label">'._("City").'</span>'.$airport_array[0]['city'].'</div>';
			print '<div><span class="label">'._("Country").'</span>'.$airport_array[0]['country'].'</div>';
			print '<div><span class="label">'._("ICAO").'</span>'.$airport_array[0]['icao'].'</div>';
			print '<div><span class="label">'._("IATA").'</span>'.$airport_array[0]['iata'].'</div>';
			print '<div><span class="label">'._("Altitude").'</span>';
			if ((!isset($_COOKIE['unitaltitude']) && isset($globalUnitAltitude) && $globalUnitAltitude == 'feet') || (isset($_COOKIE['unitaltitude']) && $_COOKIE['unitaltitude'] == 'feet')) {
				print $airport_array[0]['altitude'].' feet';
			} else {
				print round($airport_array[0]['altitude']*0.3048).' m';
			}
			print '</div>';
			print '<div><span class="label">'._("Coordinates").'</span><a href="http://maps.google.com/maps?z=10&t=k&q='.$airport_array[0]['latitude'].','.$airport_array[0]['longitude'].'" target="_blank">Google Map<i class="fa fa-angle-double-right"></i></a></div>';
			print '<div><span class="label">'._("Live Air Traffic").'</span><a href="http://www.liveatc.net/search/?icao='.$airport_array[0]['icao'].'" target="_blank">LiveATC.net<i class="fa fa-angle-double-right"></i></a></div>';
			if (isset($airport_array[0]['home_link']) && $airport_array[0]['home_link'] != '') print '<div><a href="'.$airport_array[0]['home_link'].'"><i class="fa fa-home"></i></a></div>';
			if (isset($airport_array[0]['wikipedia_link']) && $airport_array[0]['wikipedia_link'] != '') print '<div><a href="'.$airport_array[0]['wikipedia_link'].'"><i class="fa fa-wikipedia-w"></i></a></div>';
			if (isset($airport_array[0]['diagram_pdf']) && $airport_array[0]['diagram_pdf'] != '') print '<div><span class="label">'._("Diagram").'</span><a href="'.$airport_array[0]['diagram_pdf'].'" target="_blank">'.$airport_array[0]['icao'].'<i class="fa fa-angle-double-right"></i></a></div>';
			print '</div>';
			
			$Stats = new Stats();
			$all_data = $Stats->getLast7DaysAirports($airport_icao);
			// Use spotter also
			if (isset($globalTimezone)) {
				date_default_timezone_set($globalTimezone);
			} else date_default_timezone_set('UTC');
			if (count($all_data) > 0) {
				print '<link href="'.$globalURL.'/css/c3.min.css" rel="stylesheet" type="text/css">';
				print '<script type="text/javascript" src="'.$globalURL.'/js/d3.min.js"></script>';
				print '<script type="text/javascript" src="'.$globalURL.'/js/c3.min.js"></script>';
				print '<div id="chart" class="chart" width="100%"></div><script>';
				$date_data = '';
				$departure_data = '';
				$arrival_data = '';
				foreach($all_data as $data)
				{
					$date_data .= '"'.$data['date'].'",';
					$departure_data .= $data['departure'].',';
					$arrival_data .= $data['arrival'].',';
				}
				$date_data = "['x',".substr($date_data,0,-1)."]";
				$departure_data = "['departure',".substr($departure_data,0,-1)."]";
				$arrival_data = "['arrival',".substr($arrival_data,0,-1)."]";
				print 'c3.generate({
				    bindto: "#chart",
				    data: {
					x: "x",
					axes: {
					    departure: "y",
					    speed: "y2"
					},
					xFormat: "%Y-%m-%d",
					columns: ['.$date_data.','.$departure_data.','.$arrival_data.'],
					colors: { 
					    departure: "#1a3151",
					    arrival: "#aa0000"
					}
				    },
				    axis: { 
					x: { 
					    type: "timeseries", tick: { format: "%Y-%m-%d"}
					},
					y: {
					    label: "# of Flights",tick: { format: d3.format("d") }
					}
				    },
				    legend: { show: false }});';
				print '</script>';
			}
			print '<div class="info column">';
			if (isset($metar_parse)) {
				print '<div><span class="label">METAR</span>';
				print $metar_info[0]['metar'].'<br />';
				print '<b>'.$metar_info[0]['metar_date'].'</b> ';
				if (isset($metar_parse['wind'])) {
					print _("Wind:").' ';
					if (isset($metar_parse['wind']['direction'])) {
						$direction = $Spotter->parseDirection($metar_parse['wind']['direction']);
						print $direction[0]['direction_fullname'];
						print ' ('.$metar_parse['wind']['direction'].'°) ';
					}
					if (isset($metar_parse['wind']['speed'])) {
						print $metar_parse['wind']['speed'].' m/s';
					}
					print ' - ';
				}
				if (isset($metar_parse['visibility'])) {
					print _("Visibility:").' '.$metar_parse['visibility'].' m'." - ";
				}
				if (isset($metar_parse['weather'])) {
					print _("Weather:").' '.$metar_parse['weather']." - ";
				}
				if (isset($metar_parse['temperature'])) {
					print _("Temperature:").' '.$metar_parse['temperature'].' °C'." - ";
				}
				if (isset($metar_parse['dew'])) {
					print _("Dew point:").' '.$metar_parse['dew'].' °C'." - ";
				}
				if (isset($metar_parse['temperature']) && isset($metar_parse['dew'])) {
					$humidity = round(100 * pow((112 - (0.1 * $metar_parse['temperature']) + $metar_parse['dew']) / (112 + (0.9 * $metar_parse['temperature'])), 8),1);
					print _("Humidity:").' '.$humidity.'%'." - ";
				}
				if (isset($metar_parse['QNH'])) {
					print _("Pressure:").' '.$metar_parse['QNH'].' hPa';
				}
				print '</div>';
			}
			print '</div>';
		} else {
			print '<div class="alert alert-warning">'._("This special airport profile shows all flights that do <u>not</u> have a departure and/or arrival airport associated with them.").'</div>';
		}
		if (!empty($spotter_array)) {
			include('airport-sub-menu.php');
			print '<div class="table column">';
			if ($airport_array[0]['iata'] != "NA")
			{
				print '<p>'.sprintf(_("The table below shows the detailed information of all flights to/from <strong>%s, %s (%s)</strong>."),$airport_array[0]['city'],$airport_array[0]['name'],$airport_array[0]['icao']).'</p>';
			}
			include('table-output.php');  
			print '<div class="pagination">';
			if ($limit_previous_1 >= 0)
			{
				print '<a href="'.$page_url.'/'.$limit_previous_1.','.$limit_previous_2.'/'.$sort.'">&laquo;'._("Previous Page").'</a>';
			}
			if (isset($spotter_array[0]['query_number_rows']) && $spotter_array[0]['query_number_rows'] == $absolute_difference)
			{
				print '<a href="'.$page_url.'/'.$limit_end.','.$limit_next.'/'.$sort.'">'._("Next Page").'&raquo;</a>';
			}
			print '</div>';
			print '</div>';
		} else {
			if (isset($airport_array[0]['image']) && $airport_array[0]['image'] != '') print '<center><img src="'.$airport_array[0]['image'].'" /></center>';
			print '<p>'._("Sorry, no flights used the airport in this database.").'</p>'; 
		}
	} else {
		$title = "Airport";
		require_once('header.php');
		print '<h1>'._("Error").'</h1>';
		print '<p>'._("Sorry, the airport does not exist in this database. :(").'</p>'; 
	}
}
require_once('footer.php');
?>