/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function show(Request $request, $id) { // Only Allow Ajax requests //if ($request->ajax()) { $actions = SiteIssueAction::select(['site_issues_actions.id', 'site_issues_actions.created_by', 'site_issues_actions.action', DB::raw('DATE_FORMAT(site_issues_actions.created_at,\'%d/%m/%y\') AS niceDate '), DB::raw('CONCAT(users.firstname, " ", users.lastname) AS fullname')])->join('users', 'site_issues_actions.created_by', '=', 'users.id')->where('issue_id', '=', $id)->orderBy('site_issues_actions.created_at')->get(); return $actions; //} return view('errors.404'); }