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