/** * Return a view with issueCount and issues collection * * @return Response */ public function index() { $issuesCount = Issue::latest()->get()->count(); $issues = DB::table('issues')->orderBy('created_at', 'desc')->paginate(15); $issues->each(function ($issue) { $issue->id = (int) $issue->id; $issue->projectName = Project::find($issue->project_id)->name; $issue->statusLabel = IssueStatus::find($issue->status_id)->label; $issue->typeLabel = IssueType::find($issue->type_id)->label; unset($issue->project_id); unset($issue->status_id); unset($issue->type_id); }); return view('issues.index')->with(['issuesCount' => $issuesCount, 'issues' => $issues]); }