/** * Show a count of assets by status label * * @return View */ public function getAssetCountByStatuslabel() { $colors = []; $statuslabels = Statuslabel::get(); $labels = []; $points = []; foreach ($statuslabels as $statuslabel) { $labels[] = $statuslabel->name; $points[] = $statuslabel->assets()->whereNull('assigned_to')->count(); } $labels[] = 'Deployed'; $points[] = Asset::whereNotNull('assigned_to')->count(); $result = ["labels" => $labels, "datasets" => [["data" => $points, "backgroundColor" => Helper::chartColors(), "hoverBackgroundColor" => Helper::chartColors()]]]; return $result; }
/** * Show a count of assets by status label * * @return View */ public function getAssetCountByStatuslabel() { $colors = []; $statuslabels = Statuslabel::with('assets')->get(); $labels = []; $points = []; $colors = []; foreach ($statuslabels as $statuslabel) { if ($statuslabel->assets->count() > 0) { $labels[] = $statuslabel->name; $points[] = $statuslabel->assets()->whereNull('assigned_to')->count(); if ($statuslabel->color != '') { $colors[] = $statuslabel->color; } } } $labels[] = 'Deployed'; $points[] = Asset::whereNotNull('assigned_to')->count(); $colors_array = array_merge($colors, Helper::chartColors()); $result = ["labels" => $labels, "datasets" => [["data" => $points, "backgroundColor" => $colors_array, "hoverBackgroundColor" => $colors_array]]]; return $result; }