Completed
Push — master ( 65be4b...73f088 )
by Yannick
07:48
created

airline-statistics-registration.php (1 issue)

Severity

Upgrade to new PHP Analysis Engine

These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more

1
<?php
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['airline'])) {
6
        header('Location: '.$globalURL.'/airline');
7
        die();
8
}
9
$airline = filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
10
$Spotter = new Spotter();
11
$spotter_array = $Spotter->getSpotterDataByAirline($airline,"0,1","");
12
13
if (!empty($spotter_array))
14
{
15
	$title = sprintf(_("Most Common Aircraft by Registration from %s (%s)"),$spotter_array[0]['airline_name'],$spotter_array[0]['airline_icao']);
16
	require_once('header.php');
17
18
	print '<div class="select-item">';
19
	print '<form action="'.$globalURL.'/airline" method="post">';
20
	print '<select name="airline" class="selectpicker" data-live-search="true">';
21
	print '<option></option>';
22
	$airline_names = $Spotter->getAllAirlineNames();
23
	foreach($airline_names as $airline_name)
24
	{
25
		if($airline == $airline_name['airline_icao'])
26
		{
27
			print '<option value="'.$airline_name['airline_icao'].'" selected="selected">'.$airline_name['airline_name'].' ('.$airline_name['airline_icao'].')</option>';
28
		} else {
29
			print '<option value="'.$airline_name['airline_icao'].'">'.$airline_name['airline_name'].' ('.$airline_name['airline_icao'].')</option>';
30
		}
31
	}
32
	print '</select>';
33
	print '<button type="submit"><i class="fa fa-angle-double-right"></i></button>';
34
	print '</form>';
35
	print '</div>';
36
37
	if ($airline != "NA")
38
	{
39
		print '<div class="info column">';
40
			print '<h1>'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')</h1>';
41
			if ($globalIVAO && @getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif'))
42
			{
43
				print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />';
44
			}
45
			elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png'))
46
			{
47
				print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />';
48
			}
49
			print '<div><span class="label">'._("Name").'</span>'.$spotter_array[0]['airline_name'].'</div>';
50
			print '<div><span class="label">'._("Country").'</span>'.$spotter_array[0]['airline_country'].'</div>';
51
			print '<div><span class="label">'._("ICAO").'</span>'.$spotter_array[0]['airline_icao'].'</div>';
52
			print '<div><span class="label">'._("IATA").'</span>'.$spotter_array[0]['airline_iata'].'</div>';
53
			print '<div><span class="label">'._("Callsign").'</span>'.$spotter_array[0]['airline_callsign'].'</div>'; 
54
			print '<div><span class="label">'._("Type").'</span>'.ucwords($spotter_array[0]['airline_type']).'</div>';        
55
		print '</div>';
56
	} else {
57
		print '<div class="alert alert-warning">'._("This special airline profile shows all flights that do <u>not</u> have a airline associated with them.").'</div>';
58
	}
59
60
	include('airline-sub-menu.php');
61
	print '<div class="column">';
62
	print '<h2>'._("Most Common Aircraft by Registration").'</h2>';
63
	print '<p>'.sprintf(_("The statistic below shows the most common aircraft by their registration of flights from <strong>%s</strong>."),$spotter_array[0]['airline_name']).'</p>';
64
65
	$aircraft_array = $Spotter->countAllAircraftRegistrationByAirline($airline);
66
	if (!empty($aircraft_array))
67
	{
68
		print '<div class="table-responsive">';
69
		print '<table class="common-type table-striped">';
70
		print '<thead>';
71
		print '<th></th>';
72
		print '<th></th>';
73
		print '<th>'._("Registration").'</th>';
74
		print '<th>'._("Aircraft Type").'</th>';
75
		print '<th>'._("# of times").'</th>';
76
		print '<th></th>';
77
		print '</thead>';
78
		print '<tbody>';
79
		$i = 1;
80
		foreach($aircraft_array as $aircraft_item)
81
		{
82
			print '<tr>';
83
			print '<td><strong>'.$i.'</strong></td>';
84
			if ($aircraft_item['image_thumbnail'] != "")
85
			{
86
				print '<td class="aircraft_thumbnail">';
87
				if (isset($aircraft_item['aircraft_type'])) {
88
					print '<a href="'.$globalURL.'/registration/'.$aircraft_item['registration'].'"><img src="'.$aircraft_item['image_thumbnail'].'" class="img-rounded" data-toggle="popover" title="'.$aircraft_item['registration'].' - '.$aircraft_item['aircraft_icao'].' - '.$aircraft_item['airline_name'].'" alt="'.$aircraft_item['registration'].' - '.$aircraft_item['aircraft_type'].' - '.$aircraft_item['airline_name'].'" data-content="'._("Registration:").' '.$aircraft_item['registration'].'<br />'._("Aircraft:").' '.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')<br />'._("Airline:").' '.$aircraft_item['airline_name'].'" data-html="true" width="100px" /></a>';
89
				} else {
90
					print '<a href="'.$globalURL.'/registration/'.$aircraft_item['registration'].'"><img src="'.$aircraft_item['image_thumbnail'].'" class="img-rounded" data-toggle="popover" title="'.$aircraft_item['registration'].' - '.$aircraft_item['aircraft_icao'].' - '.$aircraft_item['airline_name'].'" alt="'.$aircraft_item['registration'].' - '.$aircraft_item['airline_name'].'" data-content="'._("Registration:").' '.$aircraft_item['registration'].'<br />'._("Aircraft:").' '.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')<br />'._("Airline:").' '.$aircraft_item['airline_name'].'" data-html="true" width="100px" /></a>';
91
				}
92
				print '</td>';
93
			} else {
94
				print '<td class="aircraft_thumbnail">';
95
				if (isset($aircraft_item['aircraft_type'])) {
96
					print '<a href="'.$globalURL.'/registration/'.$aircraft_item['registration'].'"><img src="'.$globalURL.'/images/placeholder_thumb.png" class="img-rounded" data-toggle="popover" title="'.$aircraft_item['registration'].' - '.$aircraft_item['aircraft_icao'].' - '.$aircraft_item['airline_name'].'" alt="'.$aircraft_item['registration'].' - '.$aircraft_item['aircraft_type'].' - '.$aircraft_item['airline_name'].'" data-content="'._("Registration:").' '.$aircraft_item['registration'].'<br />'._("Aircraft:").' '.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')<br />'._("Airline:").' '.$aircraft_item['airline_name'].'" data-html="true" width="100px" /></a>';
97
				} else {
98
					print '<a href="'.$globalURL.'/registration/'.$aircraft_item['registration'].'"><img src="'.$globalURL.'/images/placeholder_thumb.png" class="img-rounded" data-toggle="popover" title="'.$aircraft_item['registration'].' - '.$aircraft_item['aircraft_icao'].' - '.$aircraft_item['airline_name'].'" alt="'.$aircraft_item['registration'].' - '.$aircraft_item['airline_name'].'" data-content="'._("Registration:").' '.$aircraft_item['registration'].'<br />'._("Aircraft:").' '.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')<br />'._("Airline:").' '.$aircraft_item['airline_name'].'" data-html="true" width="100px" /></a>';
99
				}
100
				print '</td>';
101
			}
102
			print '<td>';
103
			print '<a href="'.$globalURL.'/registration/'.$aircraft_item['registration'].'">'.$aircraft_item['registration'].'</a>';
104
			print '</td>';
105
			print '<td>';
106
			print '<a href="'.$globalURL.'/aircraft/'.$aircraft_item['aircraft_icao'].'">'.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')</a>';
107
			print '</td>';
108
			print '<td>';
109
			print $aircraft_item['registration_count'];
110
			print '</td>';
111
			print '<td><a href="'.$globalURL.'/search?registration='.$aircraft_item['registration'].'&airline='.$airline.'">'._("Search flights").'</a></td>';
112
			print '</tr>';
113
			$i++;
114
		}
115
		print '<tbody>';
116
		print '</table>';
117
		print '</div>';
118
	}
119
	print '</div>';
120
} else {
121
	$title = _("Airline Statistic");
122
	require_once('header.php');
123
	print '<h1>'._("Error").'</h1>';
124
	print '<p>'._("Sorry, the airline does not exist in this database. :(").'</p>'; 
125
}
126
127
require_once('footer.php');
128
?>
1 ignored issue
show
It is not recommended to use PHP's closing tag ?> in files other than templates.

Using a closing tag in PHP files that only contain PHP code is not recommended as you might accidentally add whitespace after the closing tag which would then be output by PHP. This can cause severe problems, for example headers cannot be sent anymore.

A simple precaution is to leave off the closing tag as it is not required, and it also has no negative effects whatsoever.

Loading history...