eloquent($query)
->addColumn('action', function ($query){
return '';
})
->addColumn('access', function ($query){
$access = AdminAccessRight::query()->where('user_id',$query->id)->first();
if(empty($access))
return 'N/A';
elseif($access->value == '2')
return 'Reviewer';
elseif ($access->value == '3' )
return 'Approver';
else
return 'Super Admin';
})->rawColumns(['action','access']);
}
/**
* Get the query object to be processed by dataTables.
*
* @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection
*/
public function query()
{
$query = User::query()->where('role_id',1);
return $this->applyScopes($query);
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\Datatables\Html\Builder
*/
public function html()
{
return $this->builder()
->columns($this->getColumns())
->ajax('')
->addAction(['width' => '120px'])
->dom('Bfrtip')
->buttons(
Button::make('export'),
Button::make('print'),
Button::make('reset'),
Button::make('reload')
);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'id',
'username',
'access',
'created_at',
'updated_at',
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'admin.adminusersdatatables_' . time();
}
}