forked from Ysurac/FlightAirMap
/
date-detailed.php
93 lines (70 loc) · 2.72 KB
/
date-detailed.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
93
<?php
require('require/class.Connection.php');
require('require/class.Spotter.php');
if (!isset($_GET['date'])){
header('Location: '.$globalURL.'');
} else {
$Spotter = new Spotter();
//calculuation 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];
}
$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;
$page_url = $globalURL.'/date/'.$_GET['date'];
if (isset($_GET['sort']))
{
$spotter_array = $Spotter->getSpotterDataByDate($_GET['date'],$limit_start.",".$absolute_difference, $_GET['sort']);
} else {
$spotter_array = $Spotter->getSpotterDataByDate($_GET['date'],$limit_start.",".$absolute_difference);
}
if (!empty($spotter_array))
{
date_default_timezone_set($globalTimezone);
$title = 'Detailed View for flights from '.date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601']));
require('header.php');
print '<div class="select-item">';
print '<form action="'.$globalURL.'/date" method="post">';
print '<label for="date">Select a Date</label>';
print '<input type="text" id="date" name="date" value="'.$_GET['date'].'" size="8" readonly="readonly" class="custom" />';
print '<button type="submit"><i class="fa fa-angle-double-right"></i></button>';
print '</form>';
print '</div>';
print '<div class="info column">';
print '<h1>Flights from '.date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601'])).'</h1>';
print '</div>';
include('date-sub-menu.php');
print '<div class="table column">';
print '<p>The table below shows the detailed information of all flights on <strong>'.date("l M j, Y", strtotime($spotter_array[0]['date_iso_8601'])).'</strong>.</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.'/'.$_GET['sort'].'">«Previous Page</a>';
}
if ($spotter_array[0]['query_number_rows'] == $absolute_difference)
{
print '<a href="'.$page_url.'/'.$limit_end.','.$limit_next.'/'.$_GET['sort'].'">Next Page»</a>';
}
print '</div>';
print '</div>';
} else {
$title = "Unknown Date";
require('header.php');
print '<h1>Error</h1>';
print '<p>Sorry, this date does not exist in this database. :(</p>';
}
}
?>
<?php
require('footer.php');
?>