require 'require/class.Connection.php';
require 'require/class.Spotter.php';
$title = "Statistic - Most common Aircraft Manufacturer";
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 Aircraft Manufacturer</h1>
		 </div>
    
    	<p>Below are the <strong>Top 10</strong> most common aircraft manufacturers.</p>
      
<?php 
$manufacturers_array = Spotter::countAllAircraftManufacturers();
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 Manufacturer", "# of Times"], ';
$manufacturer_data = '';
foreach ($manufacturers_array as $manufacturer_item) {
    $manufacturer_data .= '[ "' . $manufacturer_item['aircraft_manufacturer'] . '",' . $manufacturer_item['aircraft_manufacturer_count'] . '],';
}
$aircraft_data = substr($manufacturer_data, 0, -1);
print $manufacturer_data;
print ']);
    
require 'require/class.Connection.php';
require 'require/class.Spotter.php';
$Spotter = new Spotter();
$title = "Statistic - Most common Aircraft Manufacturer";
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 Aircraft Manufacturer</h1>
		 </div>
    
    	<p>Below are the <strong>Top 10</strong> most common aircraft manufacturers.</p>
      
<?php 
$manufacturers_array = $Spotter->countAllAircraftManufacturers();
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 Manufacturer", "# of Times"], ';
$manufacturer_data = '';
foreach ($manufacturers_array as $manufacturer_item) {
    $manufacturer_data .= '[ "' . $manufacturer_item['aircraft_manufacturer'] . '",' . $manufacturer_item['aircraft_manufacturer_count'] . '],';
}
$aircraft_data = substr($manufacturer_data, 0, -1);
print $manufacturer_data;
print ']);