File: /var/www/html/dashboard.orbiwheels.com/app/DataTables/Admin/UsersDataTable.php
<?php
namespace App\DataTables\Admin;
use App\Models\User;
use Illuminate\Database\Eloquent\Builder as QueryBuilder;
use Yajra\DataTables\EloquentDataTable;
use Yajra\DataTables\Html\Builder as HtmlBuilder;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Html\Column;
use Yajra\DataTables\Html\Editor\Editor;
use Yajra\DataTables\Html\Editor\Fields;
use Yajra\DataTables\Services\DataTable;
class UsersDataTable extends DataTable
{
/**
* Build the DataTable class.
*
* @param QueryBuilder<User> $query Results from query() method.
*/
public function dataTable(QueryBuilder $query): EloquentDataTable
{
return (new EloquentDataTable($query))
->addColumn('role', function ($user) {
return $user->roles->pluck('name')->implode(', ');
})
->addColumn('action', function ($user) {
$buttons = '<div class="table-actions d-flex">';
if (auth()->user()->can('staff.edit')) {
$buttons .= '
<a href="' . route('admin.staff.edit', $user->id) . '" class="btn btn-primary btn-sm" title="Edit">
<i class="fa fa-edit"></i>
</a>';
}
if (auth()->user()->can('staff.delete')) {
$buttons .= '
<button type="button" data-url="' . route('admin.staff.delete', $user->id) . '" class="btn btn-danger btn-sm delete" data-id="' . $user->id . '" title="Delete">
<i class="fa fa-trash"></i>
</button>';
}
$buttons .= '</div>';
return $buttons;
})
->addIndexColumn()
->setRowId('id')
->rawColumns(['action']);
}
/**
* Get the query source of dataTable.
*
* @return QueryBuilder<User>
*/
public function query(User $model): QueryBuilder
{
return $model->newQuery();
}
/**
* Optional method if you want to use the html builder.
*/
public function html(): HtmlBuilder
{
return $this->builder()
->setTableId('users-table')
->setTableAttribute('class', 'table table-striped table-bordered dt-responsive nowrap jambo_table bulk_action')
->columns($this->getColumns())
->minifiedAjax()
->orderBy(1)
->selectStyleSingle()
->responsive(true)
->autoWidth(false)
->buttons([
// Button::make('excel'),
// Button::make('csv'),
// Button::make('pdf'),
// Button::make('print'),
// Button::make('reset'),
// Button::make('reload')
]);
}
/**
* Get the dataTable columns definition.
*/
public function getColumns(): array
{
return [
Column::make('id'),
Column::make('first_name'),
Column::make('last_name'),
Column::make('email'),
Column::make('phone'),
Column::make('role'),
Column::computed('action')
->exportable(false)
->printable(false)
->width(60)
->addClass('text-center'),
];
}
/**
* Get the filename for export.
*/
protected function filename(): string
{
return 'Users_' . date('YmdHis');
}
}