2 require_once('require/class.Connection.php');
3 require_once('require/class.Spotter.php');
4 require_once('require/class.Language.php');
5 if (!isset($_GET['country'])) {
6 header('Location: '.$globalURL.'/country');
9 $Spotter = new Spotter();
11 $country = ucwords(str_replace("-", " ", urldecode(filter_input(INPUT_GET
,'country',FILTER_SANITIZE_STRING
))));
12 $sort = filter_input(INPUT_GET
,'sort',FILTER_SANITIZE_STRING
);
13 $spotter_array = $Spotter->getSpotterDataByCountry($country, "0,1", $sort);
15 if (!empty($spotter_array))
17 $title = sprintf(_("Most Common Aircraft from %s"),$country);
19 require_once('header.php');
20 print '<div class="select-item">';
21 print '<form action="'.$globalURL.'/country" method="post">';
22 print '<select name="country" class="selectpicker" data-live-search="true">';
23 print '<option></option>';
24 $all_countries = $Spotter->getAllCountries();
25 foreach($all_countries as $all_country)
27 if($country == $all_country['country'])
29 print '<option value="'.strtolower(str_replace(" ", "-", $all_country['country'])).'" selected="selected">'.$all_country['country'].'</option>';
31 print '<option value="'.strtolower(str_replace(" ", "-", $all_country['country'])).'">'.$all_country['country'].'</option>';
35 print '<button type="submit"><i class="fa fa-angle-double-right"></i></button>';
39 if ($_GET['country'] != "NA")
41 print '<div class="info column">';
42 print '<h1>'.sprintf(_("Airports & Airlines from %s"),$country).'</h1>';
45 print '<div class="alert alert-warning">'._("This special country profile shows all flights that do <u>not</u> have a country of a airline or departure/arrival airport associated with them.").'</div>';
48 include('country-sub-menu.php');
49 print '<div class="column">';
50 print '<h2>'._("Most Common Aircraft").'</h2>';
51 print '<p>'.sprintf(_("The statistic below shows the most common aircraft of flights from <strong>%s</strong>."),$country).'</p>';
53 $aircraft_array = $Spotter->countAllAircraftTypesByCountry($country);
54 if (!empty($aircraft_array))
56 print '<div class="table-responsive">';
57 print '<table class="common-type table-striped">';
60 print '<th>'._("Aircraft Type").'</th>';
61 print '<th>'._("# of times").'</th>';
65 foreach($aircraft_array as $aircraft_item)
68 print '<td><strong>'.$i.'</strong></td>';
70 print '<a href="'.$globalURL.'/aircraft/'.$aircraft_item['aircraft_icao'].'">'.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')</a>';
73 print $aircraft_item['aircraft_icao_count'];
84 $title = _("Country");
85 require_once('header.php');
86 print '<h1>'._("Error").'</h1>';
87 print '<p>'._("Sorry, the country does not exist in this database. :(").'</p>';
90 require_once('footer.php');