Controller
$data = DB::table('buses')
->join('bustypes', 'bustypes.id', '=', 'buses.bustype_id')
->select(DB::raw('bustypes.name as bustype'), DB::raw('COUNT(buses.id) as count'))
->groupBy('bustypes.id')
->get();
$array[] = ['Bustype', 'Number'];
foreach ($data as $key => $value) {
$array[++$key] = [$value->bustype, $value->count];
}
Blade
<div class="panel-body" align="center">
<div id="pie_chart" style="width:450px; height:450px;">
</div>
</div>
<script type="text/javascript">
var analytics = <?php echo $company; ?>
google.charts.load('current', {'packages': ['corechart']});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable(analytics);
var view = new google.visualization.DataView(data);
var options = {
title: "Car Own List"
};
view.setColumns([0, {
calc: "stringify",
sourceColumn: 1,
type: "string",
role: "annotation"
}, 1]);
var chart = new google.visualization.PieChart(
document.getElementById('pie_chart')
);
chart.draw(data, options);
}
</script>
