/** * 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; }