/** * Display Lavachart graph for CUCM devices * * @return \Illuminate\View\View */ public function deviceCounts() { $data = executeQuery('SELECT t.name, count(*) AS num FROM device d INNER JOIN typemodel t ON d.tkmodel = t.enum GROUP BY t.name ORDER BY num DESC'); $phoneCounts = \Lava::DataTable(); $phoneCounts->addStringColumn('Phone Model')->addNumberColumn('Count'); foreach ($data as $key => $val) { $phoneCounts->addRow([$val->name, (int) $val->num]); } $piechart = \Lava::DonutChart('Cisco IP Phones')->setOptions(['datatable' => $phoneCounts, 'title' => 'Cluster A IP Phones Stats', 'height' => 1000, 'width' => 2000]); return view('reports.device.counts', compact('piechart')); }
public function getStepsTodayChart() { $TodaySteps = (new Step())->where('date', Carbon::now()->toDateString())->first(); if ($TodaySteps === null) { $TodaySteps = new Step(); } $steps = \Lava::DataTable(); $steps->addStringColumn('Steps')->addNumberColumn('Count')->addRow(['Steps', $TodaySteps->steps])->addRow(['Target', $TodaySteps->stepsLeftToTarget]); $chart = \Lava::DonutChart('stepToday', $steps, ['title' => 'Steps today', 'legend' => ['position' => 'none'], 'pieSliceTextStyle' => ['color' => 'none'], 'pieHole' => 0.7]); return $chart; }
public function getChart(Request $request) { $reasons = \Lava::DataTable(); $reasons->addStringColumn('Reasons')->addNumberColumn('Percent')->addRow(array('Passed', 50))->addRow(array('Failed', 30))->addRow(array('Skipped', 20)); $piechart = \Lava::PieChart('myPieChart')->setOptions(array('datatable' => $reasons, 'legend' => \Lava::Legend(array('position' => 'none')), 'chartArea' => \Lava::ChartArea(['width' => 250, 'height' => 250]), 'colors' => array('078B3E', 'CD1E35', 'FCDC27'))); $threedpiechart = \Lava::PieChart('myThreeDPieChart')->setOptions(array('datatable' => $reasons, 'legend' => \Lava::Legend(array('position' => 'none')), 'chartArea' => \Lava::ChartArea(['width' => 250, 'height' => 250]), 'colors' => array('368DB9', 'A41034', 'FCDC27'), 'is3D' => true)); $donutchart = \Lava::DonutChart('myDonut')->setOptions(array('datatable' => $reasons, 'legend' => \Lava::Legend(array('position' => 'none')), 'chartArea' => \Lava::ChartArea(['width' => 250, 'height' => 250]), 'colors' => array('368DB9', 'A41034', 'FCDC27'))); }