<?php

require 'require/class.Connection.php';
require 'require/class.Spotter.php';
if (!isset($_GET['aircraft_manufacturer'])) {
    header('Location: ' . $globalURL . '/manufacturer');
    die;
}
$Spotter = new Spotter();
$manufacturer = ucwords(str_replace("-", " ", $_GET['aircraft_manufacturer']));
$spotter_array = $Spotter->getSpotterDataByManufacturer($manufacturer, "0,1", $_GET['sort']);
if (!empty($spotter_array)) {
    $title = 'Most Common Time of Day from ' . $manufacturer;
    require 'header.php';
    print '<div class="select-item">';
    print '<form action="' . $globalURL . '/manufacturer" method="post">';
    print '<select name="aircraft_manufacturer" class="selectpicker" data-live-search="true">';
    print '<option></option>';
    $all_manufacturers = $Spotter->getAllManufacturers();
    foreach ($all_manufacturers as $all_manufacturer) {
        if ($_GET['aircraft_manufacturer'] == strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer']))) {
            print '<option value="' . strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])) . '" selected="selected">' . $all_manufacturer['aircraft_manufacturer'] . '</option>';
        } else {
            print '<option value="' . strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])) . '">' . $all_manufacturer['aircraft_manufacturer'] . '</option>';
        }
    }
    print '</select>';
    print '<button type="submit"><i class="fa fa-angle-double-right"></i></button>';
    print '</form>';
    print '</div>';
    print '<div class="info column">';
<?php

require 'require/class.Connection.php';
require 'require/class.Spotter.php';
if (!isset($_GET['aircraft_manufacturer'])) {
    header('Location: ' . $globalURL . '/manufacturer');
    die;
}
$Spotter = new Spotter();
$manufacturer = ucwords(str_replace("-", " ", $_GET['aircraft_manufacturer']));
$sort = filter_input(INPUT_GET, 'sort', FILTER_SANITIZE_STRING);
$spotter_array = $Spotter->getSpotterDataByManufacturer($manufacturer, "0,1", $sort);
if (!empty($spotter_array)) {
    $title = 'Most Common Aircraft from ' . $manufacturer;
    require 'header.php';
    print '<div class="select-item">';
    print '<form action="' . $globalURL . '/manufacturer" method="post">';
    print '<select name="aircraft_manufacturer" class="selectpicker" data-live-search="true">';
    print '<option></option>';
    $all_manufacturers = $Spotter->getAllManufacturers();
    foreach ($all_manufacturers as $all_manufacturer) {
        if ($_GET['aircraft_manufacturer'] == strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer']))) {
            print '<option value="' . strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])) . '" selected="selected">' . $all_manufacturer['aircraft_manufacturer'] . '</option>';
        } else {
            print '<option value="' . strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])) . '">' . $all_manufacturer['aircraft_manufacturer'] . '</option>';
        }
    }
    print '</select>';
    print '<button type="submit"><i class="fa fa-angle-double-right"></i></button>';
    print '</form>';
    print '</div>';
     $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;
 $manufacturer = ucwords(str_replace("-", " ", $_GET['aircraft_manufacturer']));
 $page_url = $globalURL . '/manufacturer/' . $_GET['aircraft_manufacturer'];
 if (isset($_GET['sort'])) {
     $spotter_array = Spotter::getSpotterDataByManufacturer($manufacturer, $limit_start . "," . $absolute_difference, $_GET['sort']);
 } else {
     $spotter_array = Spotter::getSpotterDataByManufacturer($manufacturer, $limit_start . "," . $absolute_difference, '');
 }
 if (!empty($spotter_array)) {
     $title = 'Detailed View for ' . $manufacturer;
     require 'header.php';
     print '<div class="select-item">';
     print '<form action="' . $globalURL . '/manufacturer" method="post">';
     print '<select name="aircraft_manufacturer" class="selectpicker" data-live-search="true">';
     print '<option></option>';
     $all_manufacturers = Spotter::getAllManufacturers();
     foreach ($all_manufacturers as $all_manufacturer) {
         if ($_GET['aircraft_manufacturer'] == strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer']))) {
             print '<option value="' . strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])) . '" selected="selected">' . $all_manufacturer['aircraft_manufacturer'] . '</option>';
         } else {
             print '<option value="' . strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])) . '">' . $all_manufacturer['aircraft_manufacturer'] . '</option>';
         }
     $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;
 $manufacturer = ucwords(str_replace("-", " ", $_GET['aircraft_manufacturer']));
 $page_url = $globalURL . '/manufacturer/' . $_GET['aircraft_manufacturer'];
 if (isset($_GET['sort'])) {
     $spotter_array = $Spotter->getSpotterDataByManufacturer($manufacturer, $limit_start . "," . $absolute_difference, $_GET['sort']);
 } else {
     $spotter_array = $Spotter->getSpotterDataByManufacturer($manufacturer, $limit_start . "," . $absolute_difference, '');
 }
 if (!empty($spotter_array)) {
     $title = 'Detailed View for ' . $manufacturer;
     require 'header.php';
     print '<div class="select-item">';
     print '<form action="' . $globalURL . '/manufacturer" method="post">';
     print '<select name="aircraft_manufacturer" class="selectpicker" data-live-search="true">';
     print '<option></option>';
     $all_manufacturers = $Spotter->getAllManufacturers();
     foreach ($all_manufacturers as $all_manufacturer) {
         if ($_GET['aircraft_manufacturer'] == strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer']))) {
             print '<option value="' . strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])) . '" selected="selected">' . $all_manufacturer['aircraft_manufacturer'] . '</option>';
         } else {