/**
* @return mixed
*/
public function reportIniciativaInstituicao(Request $request = null)
{
if ($request != null) {
switch ($request['type']) {
case 'geral':
return $this->reportIniciativaInstituicaoGeral()->toJson();
break;
case 'regiao':
switch ($request['regiao']) {
case 1:
return $this->reportIniciativaInstituicaoByUf([50, 51, 52, 53])->toJson();
break;
case 2:
return $this->reportIniciativaInstituicaoByUf([11, 12, 13, 14, 15, 16, 17])->toJson();
break;
case 3:
return $this->reportIniciativaInstituicaoByUf([21, 22, 23, 24, 25, 26, 27, 28, 29])->toJson();
break;
case 4:
return $this->reportIniciativaInstituicaoByUf([41, 42, 43])->toJson();
break;
case 5:
return $this->reportIniciativaInstituicaoByUf([31, 32, 33, 35])->toJson();
break;
}
break;
case 'estado':
if ($request['cidade'] != '') {
return $this->reportIniciativaInstituicaoByCidade($request['cidade'])->toJson();
} else {
return $this->reportIniciativaInstituicaoByUf([$request['uf']])->toJson();
}
break;
}
} else {
$dados = $this->reportIniciativaInstituicaoGeral();
$graph = \Lava::ColumnChart('IniciativaInstituicao')->setOptions(['datatable' => $dados, 'legend' => \Lava::Legend(['position' => 'top'])]);
return $graph;
}
}
private function getTeamsChart()
{
$teamHoursDataTable = \Lava::DataTable();
foreach (Team::all()->sortBy('name') as $team) {
$teamHoursDataTable->addNumberColumn($team->name);
}
foreach (Team::all() as $team) {
$teamHoursDataTable->addRow([$team->workActivities()->sum('hours')]);
}
\Lava::LineChart('Overview')->dataTable($clubOverviewChart)->title('Stundenübersicht nach Team, Zeitraum 1 Jahr, Intervall 2 Wochen')->setOptions(array('legend' => \Lava::Legend(array('position' => 'in'))));
}
public function getChart($title, $chartType, $height, $width, $arrayColors, $datatTable)
{
if ($chartType = 'PieChart') {
\Lava::PieChart($title)->setOptions(array('datatable' => $datatTable, 'legend' => \Lava::Legend(array('position' => 'none')), 'chartArea' => \Lava::ChartArea(['width' => $width, 'height' => $height]), 'colors' => $arrayColors, 'is3D' => true));
} elseif ($chartType = 'DonutChart') {
}
}
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')));
}
