/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { // Check authorisation and throw 404 if not if (!(Auth::user()->company->subscription && Auth::user()->is('full.access|full.read.acccess|whs.admin'))) { return view('errors/404'); } if ($request->ajax()) { $tips = SafetyTip::select(['safety_tips.id', 'safety_tips.title', 'safety_tips.body', 'safety_tips.status', DB::raw('DATE_FORMAT(last_published,\'%d/%m/%y\') AS niceDate '), DB::raw('CONCAT(users.firstname, " ", users.lastname) AS fullname')])->join('users', 'safety_tips.created_by', '=', 'users.id')->where('safety_tips.company_id', Auth::user()->company->reportsToCompany()->id)->orderBy('last_published', 'DESC')->get(); return $tips; } return view('safety.tip.list'); }