/** * Get Docs current user is authorised to manage + Process datatables ajax request. */ public function getToolbox(Request $request) { $company_list = [Auth::user()->company->id, Auth::user()->company->reportsToCompany()->id]; //$company_list = [3, 27]; $records = SafetyDoc::select(['id', 'type', 'site_id', 'reportfile', 'name'])->where('type', 'TOOL')->whereIn('company_id', $company_list)->where('status', '1'); $dt = Datatables::of($records)->editColumn('id', '<div class="text-center"><a href="/filebank/whs/toolbox/{{$reportfile}}"><i class="fa fa-file-text-o"></i></a></div>')->make(true); return $dt; }
/** * Get Docs current user is authorised to manage + Process datatables ajax request. */ public function getSDS(Request $request) { if ($request->get('category_id') && $request->get('category_id') != ' ') { $category_list = [$request->get('category_id')]; } else { $category_list = SafetyDocCategory::lists('id')->toArray(); } $company_list = [Auth::user()->company->id, Auth::user()->company->reportsToCompany()->id]; $records = SafetyDoc::select(['id', 'type', 'site_id', 'reportfile', 'name'])->where('type', 'SDS')->whereIn('category_id', $category_list)->whereIn('company_id', $company_list)->where('status', '1'); $dt = Datatables::of($records)->editColumn('id', '<div class="text-center"><a href="/filebank/whs/sds/{{$reportfile}}"><i class="fa fa-file-text-o"></i></a></div>')->make(true); return $dt; }