-
Notifications
You must be signed in to change notification settings - Fork 161
/
Copy pathregistration-statistics-time.php
92 lines (87 loc) · 3.49 KB
/
registration-statistics-time.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
<?php
require_once('require/class.Connection.php');
require_once('require/class.Spotter.php');
require_once('require/class.Language.php');
$Spotter = new Spotter();
$sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING);
$registration = filter_input(INPUT_GET,'registration',FILTER_SANITIZE_STRING);
$spotter_array = $Spotter->getSpotterDataByRegistration($registration, "0,1", $sort);
$aircraft_array = $Spotter->getAircraftInfoByRegistration($registration);
if (!empty($spotter_array))
{
$title = sprintf(_("Most Common Time of Day of aircraft with registration %s"),$registration);
require_once('header.php');
print '<div class="info column">';
print '<h1>'.$registration.' - '.$aircraft_array[0]['aircraft_name'].' ('.$aircraft_array[0]['aircraft_icao'].')</h1>';
print '<div><span class="label">'._("Name").'</span><a href="'.$globalURL.'/aircraft/'.$aircraft_array[0]['aircraft_icao'].'">'.$aircraft_array[0]['aircraft_name'].'</a></div>';
print '<div><span class="label">'._("ICAO").'</span><a href="'.$globalURL.'/aircraft/'.$aircraft_array[0]['aircraft_icao'].'">'.$aircraft_array[0]['aircraft_icao'].'</a></div>';
print '<div><span class="label">'._("Manufacturer").'</span><a href="'.$globalURL.'/manufacturer/'.strtolower(str_replace(" ", "-", $aircraft_array[0]['aircraft_manufacturer'])).'">'.$aircraft_array[0]['aircraft_manufacturer'].'</a></div>';
print '</div>';
include('registration-sub-menu.php');
print '<div class="column">';
print '<h2>'._("Most Common Time of Day").'</h2>';
print '<p>'.sprintf(_("The statistic below shows the most common time of day from aircraft with registration <strong>%s</strong>."),$registration).'</p>';
$hour_array = $Spotter->countAllHoursByRegistration($registration);
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="chartHour" class="chart" width="100%"></div><script>';
$hour_data = '';
$hour_cnt = '';
$last = 0;
foreach($hour_array as $hour_item)
{
while($last != $hour_item['hour_name']) {
$hour_data .= '"'.$last.':00",';
$hour_cnt .= '0,';
$last++;
}
$last++;
$hour_data .= '"'.$hour_item['hour_name'].':00",';
$hour_cnt .= $hour_item['hour_count'].',';
}
$hour_data = "[".substr($hour_data, 0, -1)."]";
$hour_cnt = "['flights',".substr($hour_cnt,0,-1)."]";
print 'c3.generate({
bindto: "#chartHour",
data: {
columns: ['.$hour_cnt.'], types: { flights: "area"}, colors: { flights: "#1a3151"}
},
axis: {
x: { type: "category", categories: '.$hour_data.'},
y: { label: "# of Flights"}
},
legend: { show: false }
});';
print '</script>';
if (!empty($hour_array))
{
print '<div class="table-responsive">';
print '<table class="common-hour table-striped">';
print '<thead>';
print '<th>'._("Hour").'</th>';
print '<th>'._("Number").'</th>';
print '</thead>';
print '<tbody>';
$i = 1;
foreach($hour_array as $hour_item)
{
print '<tr>';
print '<td>'.$hour_item['hour_name'].':00</td>';
print '<td>'.$hour_item['hour_count'].'</td>';
print '</tr>';
$i++;
}
print '<tbody>';
print '</table>';
print '</div>';
}
print '</div>';
} else {
$title = _("Registration");
require_once('header.php');
print '<h1>'._("Error").'</h1>';
print '<p>'._("Sorry, this registration does not exist in this database. :(").'</p>';
}
require_once('footer.php');
?>