<?php

require 'require/class.Connection.php';
require 'require/class.Spotter.php';
$Spotter = new Spotter();
$sort = filter_input(INPUT_GET, 'sort', FILTER_SANITIZE_STRING);
$spotter_array = $Spotter->getSpotterDataByDate($_GET['date'], "0,1", $sort);
if (!empty($spotter_array)) {
    $title = 'Most Common Aircraft Manufacturer on ' . 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="column">';
    print '<h2>Most Common Aircraft Manufacturer</h2>';
    print '<p>The statistic below shows the most common Aircraft Manufacturer of flights on <strong>' . date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601'])) . '</strong>.</p>';
    $manufacturers_array = $Spotter->countAllAircraftManufacturerByDate($_GET['date']);
    if (!empty($manufacturers_array)) {
        print '<div class="table-responsive">';
        print '<table class="common-manufacturer table-striped">';
        print '<thead>';
        print '<th></th>';
        print '<th>Aircraft Manufacturer</th>';
     $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>';
<?php

require 'require/class.Connection.php';
require 'require/class.Spotter.php';
$spotter_array = Spotter::getSpotterDataByDate($_GET['date'], "0,1", $_GET['sort']);
if (!empty($spotter_array)) {
    $title = 'Most Common Aircraft by Registration on ' . 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="column">';
    print '<h2>Most Common Aircraft by Registration</h2>';
    print '<p>The statistic below shows the most common aircraft by registration of flights on <strong>' . date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601'])) . '</strong>.</p>';
    $aircraft_array = Spotter::countAllAircraftRegistrationByDate($_GET['date']);
    if (!empty($aircraft_array)) {
        print '<div class="table-responsive">';
        print '<table class="common-type table-striped">';
        print '<thead>';
        print '<th></th>';
        print '<th></th>';
        print '<th>Registration</th>';
        print '<th>Aircraft Type</th>';
 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">';