Laravel Livewire Tables Demo Table Source
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
namespace App\Http\Livewire; | |
use App\Models\Tag; | |
use App\Models\User; | |
use Illuminate\Database\Eloquent\Builder; | |
use Rappasoft\LaravelLivewireTables\DataTableComponent; | |
use Rappasoft\LaravelLivewireTables\Views\Columns\BooleanColumn; | |
use Rappasoft\LaravelLivewireTables\Views\Column; | |
use Rappasoft\LaravelLivewireTables\Views\Columns\ImageColumn; | |
use Rappasoft\LaravelLivewireTables\Views\Columns\LinkColumn; | |
use Rappasoft\LaravelLivewireTables\Views\Columns\ButtonGroupColumn; | |
use Rappasoft\LaravelLivewireTables\Views\Filters\SelectFilter; | |
use Rappasoft\LaravelLivewireTables\Views\Filters\MultiSelectFilter; | |
use Rappasoft\LaravelLivewireTables\Views\Filters\DateFilter; | |
use Rappasoft\LaravelLivewireTables\Views\Filters\TextFilter; | |
use App\Exports\UsersExport; | |
use Maatwebsite\Excel\Facades\Excel; | |
class UsersTable extends DataTableComponent | |
{ | |
public $myParam = 'Default'; | |
public string $tableName = 'users1'; | |
public array $users1 = []; | |
public $columnSearch = [ | |
'name' => null, | |
'email' => null, | |
]; | |
public function configure(): void | |
{ | |
$this->setPrimaryKey('id') | |
->setDebugEnabled() | |
->setAdditionalSelects(['users.id as id']) | |
->setConfigurableAreas([ | |
'toolbar-left-start' => ['includes.areas.toolbar-left-start', ['param1' => $this->myParam]] | |
]) | |
->setReorderEnabled() | |
->setHideReorderColumnUnlessReorderingEnabled() | |
->setSecondaryHeaderTrAttributes(function($rows) { | |
return ['class' => 'bg-gray-100']; | |
}) | |
->setSecondaryHeaderTdAttributes(function(Column $column, $rows) { | |
if ($column->isField('id')) { | |
return ['class' => 'text-red-500']; | |
} | |
return ['default' => true]; | |
}) | |
->setFooterTrAttributes(function($rows) { | |
return ['class' => 'bg-gray-100']; | |
}) | |
->setFooterTdAttributes(function(Column $column, $rows) { | |
if ($column->isField('name')) { | |
return ['class' => 'text-green-500']; | |
} | |
return ['default' => true]; | |
}) | |
->setHideBulkActionsWhenEmptyEnabled() | |
->setTableRowUrl(function($row) { | |
return 'https://google-'.$row->id.'.com'; | |
}) | |
->setTableRowUrlTarget(function($row) { | |
return '_blank'; | |
}); | |
} | |
public function columns(): array | |
{ | |
return [ | |
// ImageColumn::make('Avatar') | |
// ->location(function($row) { | |
// return asset('img/logo-'.$row->id.'.png'); | |
// }) | |
// ->attributes(function($row) { | |
// return [ | |
// 'class' => 'w-8 h-8 rounded-full', | |
// ]; | |
// }), | |
Column::make('Order', 'sort') | |
->sortable() | |
->collapseOnMobile() | |
->excludeFromColumnSelect(), | |
Column::make('Name') | |
->sortable() | |
->searchable() | |
->secondaryHeader(function() { | |
return view('tables.cells.input-search', ['field' => 'name', 'columnSearch' => $this->columnSearch]); | |
}) | |
->footer(function($rows) { | |
return '<strong>Name Footer</strong>'; | |
}) | |
->html(), | |
Column::make('E-mail', 'email') | |
->sortable() | |
->searchable() | |
->secondaryHeader(function() { | |
return view('tables.cells.input-search', ['field' => 'email', 'columnSearch' => $this->columnSearch]); | |
}), | |
Column::make('Address', 'address.address') | |
->sortable() | |
->searchable() | |
->collapseOnTablet(), | |
Column::make('Address Group', 'address.group.name') | |
->sortable() | |
->searchable() | |
->collapseOnTablet(), | |
Column::make('Group City', 'address.group.city.name') | |
->sortable() | |
->searchable() | |
->collapseOnTablet(), | |
BooleanColumn::make('Active') | |
->sortable() | |
->collapseOnMobile(), | |
Column::make('Verified', 'email_verified_at') | |
->sortable() | |
->collapseOnTablet(), | |
Column::make('Tags') | |
->label(fn($row) => $row->tags->pluck('name')->implode(', ')), | |
// Column::make('Actions') | |
// ->label( | |
// fn($row, Column $column) => view('tables.cells.actions')->withUser($row) | |
// ) | |
// ->unclickable(), | |
ButtonGroupColumn::make('Actions') | |
->unclickable() | |
->attributes(function($row) { | |
return [ | |
'class' => 'space-x-2', | |
]; | |
}) | |
->buttons([ | |
LinkColumn::make('My Link 1') | |
->title(fn($row) => 'Link 1') | |
->location(fn($row) => 'https://'.$row->id.'google1.com') | |
->attributes(function($row) { | |
return [ | |
'target' => '_blank', | |
'class' => 'underline text-blue-500', | |
]; | |
}), | |
LinkColumn::make('My Link 2') | |
->title(fn($row) => 'Link 2') | |
->location(fn($row) => 'https://'.$row->id.'google2.com') | |
->attributes(function($row) { | |
return [ | |
'class' => 'underline text-blue-500', | |
]; | |
}), | |
LinkColumn::make('My Link 3') | |
->title(fn($row) => 'Link 3') | |
->location(fn($row) => 'https://'.$row->id.'google3.com') | |
->attributes(function($row) { | |
return [ | |
'class' => 'underline text-blue-500', | |
]; | |
}) | |
]), | |
]; | |
} | |
public function filters(): array | |
{ | |
return [ | |
TextFilter::make('Name') | |
->config([ | |
'maxlength' => 5, | |
'placeholder' => 'Search Name', | |
]) | |
->filter(function(Builder $builder, string $value) { | |
$builder->where('users.name', 'like', '%'.$value.'%'); | |
}), | |
MultiSelectFilter::make('Tags') | |
->options( | |
Tag::query() | |
->orderBy('name') | |
->get() | |
->keyBy('id') | |
->map(fn($tag) => $tag->name) | |
->toArray() | |
)->filter(function(Builder $builder, array $values) { | |
$builder->whereHas('tags', fn($query) => $query->whereIn('tags.id', $values)); | |
}) | |
->setFilterPillValues([ | |
'3' => 'Tag 1', | |
]), | |
SelectFilter::make('E-mail Verified', 'email_verified_at') | |
->setFilterPillTitle('Verified') | |
->options([ | |
'' => 'Any', | |
'yes' => 'Yes', | |
'no' => 'No', | |
]) | |
->filter(function(Builder $builder, string $value) { | |
if ($value === 'yes') { | |
$builder->whereNotNull('email_verified_at'); | |
} elseif ($value === 'no') { | |
$builder->whereNull('email_verified_at'); | |
} | |
}), | |
SelectFilter::make('Active') | |
->setFilterPillTitle('User Status') | |
->setFilterPillValues([ | |
'1' => 'Active', | |
'0' => 'Inactive', | |
]) | |
->options([ | |
'' => 'All', | |
'1' => 'Yes', | |
'0' => 'No', | |
]) | |
->filter(function(Builder $builder, string $value) { | |
if ($value === '1') { | |
$builder->where('active', true); | |
} elseif ($value === '0') { | |
$builder->where('active', false); | |
} | |
}), | |
DateFilter::make('Verified From') | |
->config([ | |
'min' => '2020-01-01', | |
'max' => '2021-12-31', | |
]) | |
->filter(function(Builder $builder, string $value) { | |
$builder->where('email_verified_at', '>=', $value); | |
}), | |
DateFilter::make('Verified To') | |
->filter(function(Builder $builder, string $value) { | |
$builder->where('email_verified_at', '<=', $value); | |
}), | |
]; | |
} | |
public function builder(): Builder | |
{ | |
return User::query() | |
->when($this->columnSearch['name'] ?? null, fn ($query, $name) => $query->where('users.name', 'like', '%' . $name . '%')) | |
->when($this->columnSearch['email'] ?? null, fn ($query, $email) => $query->where('users.email', 'like', '%' . $email . '%')); | |
} | |
public function bulkActions(): array | |
{ | |
return [ | |
'activate' => 'Activate', | |
'deactivate' => 'Deactivate', | |
'export' => 'Export', | |
]; | |
} | |
public function export() | |
{ | |
$users = $this->getSelected(); | |
$this->clearSelected(); | |
return Excel::download(new UsersExport($users), 'users.xlsx'); | |
} | |
public function activate() | |
{ | |
User::whereIn('id', $this->getSelected())->update(['active' => true]); | |
$this->clearSelected(); | |
} | |
public function deactivate() | |
{ | |
User::whereIn('id', $this->getSelected())->update(['active' => false]); | |
$this->clearSelected(); | |
} | |
public function reorder($items): void | |
{ | |
foreach ($items as $item) { | |
User::find((int)$item['value'])->update(['sort' => (int)$item['order']]); | |
} | |
} | |
} |
hi, how to show specific data from user id ?
hi, what is the value on tables.cells.input-search
blade?
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
->secondaryHeader(function() { return view('tables.cells.input-search', ['field' => 'name', 'columnSearch' => $this->columnSearch]); })
Hello, where can I get this view from? Thank you.