ChartsController

<?php namespace App\Http\Controllers;

use App\Http\Requests;
use App\Http\Controllers\Controller;

use App\Siswa;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Khill\Lavacharts\Lavacharts;
use Lava;

class ChartsController extends Controller {

    public function index()
    {
        $siswa = Siswa::orderBy('NIS','ASC')->get();
        return view('pages.index',compact('siswa'));
    }

    function bar(){
        $votes  =  \Lava::DataTable();
        $dataSiswa = DB::table('siswas')->groupBy('Nilai')->get();

        $votes->addStringColumn('Jumlah')
            ->addNumberColumn('Jumlah');
        foreach($dataSiswa as $siswa){
            $votes->addRow(array($siswa->Nilai,
                DB::table('siswas')->where('Nilai','=',$siswa->Nilai)->count()));
        }

        \Lava::BarChart('Jumlah')
            ->setOptions(array(
                'datatable' => $votes,
                'orientation' => 'horizontal',

            ));
        return view('pages.bar');
    }

    function pie(){
        $nilai = \Lava::DataTable();
        $dataNilai = DB::Table('siswas')->groupBy('Nilai')->get();

        $nilai->addColumn('string','Reasons')
            ->addColumn('number','Percent');
        foreach($dataNilai as $n){
            $nilai->addRow(
                array(
                    $n->Nilai,DB::Table('siswas')->where('Nilai','=',$n->Nilai)->count()
                )
            );
        }

        \Lava::PieChart('Nilai')->setOptions(
            array(
                'datatable'=>$nilai,
                'is3D'=>true,
                'slices'=>array(
                    \Lava::Slice(array(
                        'offset' => 0.1
                    )),
                    \Lava::Slice(array(
                        'offset' => 0.1
                    )),
                    \Lava::Slice(array(
                        'offset' => 0.1
                    ))
                )
            )
        );
        return view('pages.pie');
    }
}