eloquent($query)
->filterColumn('role', function ($query, $keyword) {})
->addColumn('action', function ($item) {
$buttons = '';
if (auth()->user()->can('Edit User')) {
$buttons .= '' . __('custom.edit') . '';
}
if (auth()->user()->can('Delete User') && auth()->id() != $item->id) {
$buttons .= '
';
}
return '';
})->editColumn('role', function ($item) {
return implode(", ", $item->roles->pluck('name')->toArray()) ?? '';
})->editColumn('avatar', function ($item) {
return ' . ')
';
})->editColumn('status', function ($item) {
$badge = $item->status == User::STATUS_ACTIVE ? "badge-success" : "badge-danger";
return '' . Str::upper($item->status) . '';
})->rawColumns(['avatar', 'status', 'action'])->addIndexColumn();
}
/**
* Get query source of dataTable.
*
* @param User $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(User $model)
{
$user = Auth::user();
$orgId = $user->organisation_id;
return $model->newQuery()
->where('organisation_id', $orgId);
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
$params = $this->getBuilderParameters();
$params['order'] = [[1, 'asc']];
return $this->builder()
->columns($this->getColumns())
->minifiedAjax()
->addAction(['width' => '55px', 'class' => 'text-center', 'printable' => false, 'exportable' => false, 'title' => 'ACTION'])
->parameters($params);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::computed('DT_RowIndex', __('custom.sl')),
Column::make('avatar', 'avatar')->title(__('custom.avatar')),
Column::make('name', 'name')->title(__('custom.name')),
Column::make('email', 'email')->title(__('custom.email')),
Column::make('phone', 'phone')->title(__('custom.phone')),
Column::make('role', 'role')->title(__('custom.role')),
Column::make('status', 'status')->title(__('custom.status')),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'User_' . date('YmdHis');
}
/**
* pdf
*
* @return void
*/
public function pdf()
{
$data = $this->getDataForExport();
$pdf = PDF::loadView('vendor.datatables.print', [
'data' => $data
]);
return $pdf->download($this->getFilename() . '.pdf');
}