require 'require/class.Spotter.php';
$Spotter = new Spotter();
$title = "Statistic - Most common Route by Airport";
require 'header.php';
include 'statistics-sub-menu.php';
?>

<script type="text/javascript" src="https://www.google.com/jsapi"></script>
		<div class="info">
	  	<h1>Most common Route by Airport</h1>
	  </div>
    
    	<p>Below are the <strong>Top 10</strong> most common Departure &amp; Arrival airport combinations.</p>
     
<?php 
$route_array = $Spotter->countAllRoutes();
print '<div id="chart" class="chart" width="100%"></div>
      	<script> 
      		google.load("visualization", "1", {packages:["corechart"]});
          google.setOnLoadCallback(drawChart);
          function drawChart() {
            var data = google.visualization.arrayToDataTable([
            	["Aircraft", "# of Times"], ';
$route_data = '';
foreach ($route_array as $route_item) {
    $route_data .= '[ "' . $route_item['airport_departure_icao'] . ' - ' . $route_item['airport_arrival_icao'] . '",' . $route_item['route_count'] . '],';
}
$route_data = substr($route_data, 0, -1);
print $route_data;
print ']);
    
require 'require/class.Connection.php';
require 'require/class.Spotter.php';
$title = "Statistic - Most common Route by Airport";
require 'header.php';
include 'statistics-sub-menu.php';
?>

<script type="text/javascript" src="https://www.google.com/jsapi"></script>
		<div class="info">
	  	<h1>Most common Route by Airport</h1>
	  </div>
    
    	<p>Below are the <strong>Top 10</strong> most common Departure &amp; Arrival airport combinations.</p>
     
<?php 
$route_array = Spotter::countAllRoutes();
print '<div id="chart" class="chart" width="100%"></div>
      	<script> 
      		google.load("visualization", "1", {packages:["corechart"]});
          google.setOnLoadCallback(drawChart);
          function drawChart() {
            var data = google.visualization.arrayToDataTable([
            	["Aircraft", "# of Times"], ';
$route_data = '';
foreach ($route_array as $route_item) {
    $route_data .= '[ "' . $route_item['airport_departure_icao'] . ' - ' . $route_item['airport_arrival_icao'] . '",' . $route_item['route_count'] . '],';
}
$route_data = substr($route_data, 0, -1);
print $route_data;
print ']);