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 & 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 & 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 ']);