Datasource Collection
This example uses a Collection as Datasource.
Index
ID
Name
Balance
Online
Created At
Index
|
ID
|
Name
|
Balance
|
Online
|
Created At
|
---|---|---|---|---|---|
|
|
|
|
|
|
1
|
29
|
Luan
|
R$ 241,86
|
✅
|
01/01/2023
|
2
|
57
|
Daniel
|
R$ 166,51
|
✅
|
02/02/2023
|
3
|
93
|
Claudio
|
R$ 219,01
|
❌
|
03/03/2023
|
4
|
104
|
Vitor
|
R$ 44,28
|
✅
|
04/04/2023
|
Disclaimer: Table data is randomly generated for
illustrative purposes only. The information here is not a reflection of the actual market and does
not constitute business, financial, or medical advice.
<?php
namespace App\Livewire\Examples\DatasourceCollectionTable;
use Illuminate\Support\Carbon;
use Illuminate\Support\Collection;
use Illuminate\Support\Number;
use PowerComponents\LivewirePowerGrid\Column;
use PowerComponents\LivewirePowerGrid\Facades\Filter;
use PowerComponents\LivewirePowerGrid\Facades\PowerGrid;
use PowerComponents\LivewirePowerGrid\PowerGridComponent;
use PowerComponents\LivewirePowerGrid\PowerGridFields;
use PowerComponents\LivewirePowerGrid\Traits\WithExport;
final class DatasourceCollectionTable extends PowerGridComponent
{
public string $tableName = 'datasource-collection-table';
use WithExport;
public function setUp(): array
{
return [
PowerGrid::header()
->showToggleColumns()
->showSearchInput(),
PowerGrid::footer()
->showPerPage()
->showRecordCount(),
];
}
public function datasource(): Collection
{
return collect([
[
'id' => 29,
'name' => 'Luan',
'balance' => 241.86,
'is_online' => true,
'created_at' => '2023-01-01 00:00:00',
],
[
'id' => 57,
'name' => 'Daniel',
'balance' => 166.51,
'is_online' => true,
'created_at' => '2023-02-02 00:00:00',
],
[
'id' => 93,
'name' => 'Claudio',
'balance' => 219.01,
'is_online' => false,
'created_at' => '2023-03-03 00:00:00',
],
[
'id' => 104,
'name' => 'Vitor',
'balance' => 44.28,
'is_online' => true,
'created_at' => '2023-04-04 00:00:00',
],
]);
}
public function fields(): PowerGridFields
{
return PowerGrid::fields()
->add('id')
->add('name')
->add('balance', fn ($item) => Number::currency($item->balance, in: 'BRL', locale: 'pt-BR'))
->add('is_online', fn ($item) => $item->is_online ? '✅' : '❌')
->add('created_at', fn ($item) => Carbon::parse($item->created_at))
->add('created_at_formatted', fn ($item) => Carbon::parse($item->created_at)->format('d/m/Y'));
}
public function columns(): array
{
return [
Column::make('Index', 'id')->index(),
Column::make('ID', 'id'),
Column::add()
->title('Name')
->field('name')
->searchable()
->sortable(),
Column::add()
->title('Balance')
->field('balance')
->sortable(),
Column::add()
->title('Online')
->field('is_online'),
Column::add()
->title('Created At')
->field('created_at_formatted'),
];
}
public function filters(): array
{
return [
Filter::inputText('name'),
Filter::number('balance')
->thousands('.')
->decimal(',')
->placeholder('lowest', 'highest'),
Filter::boolean('is_online')
->label('✅', '❌'),
];
}
}