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