Workflow
Collection
XLSX
Csv
ID
Name
Chef
Price
In Stock
Created At
ID
Name
Chef
Price
In Stock
Created At
1
Name 1
1.58
Yes
01/01/2023
2
Name 2
1.68
Yes
02/02/2023
3
Name 3
Luan
1.78
No
03/03/2023
4
Name 4
Luan
1.88
Yes
04/04/2023
5
Name 5
Luan
1.98
No
05/05/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.
open in GitHub
<?php
 
use Illuminate\Support\Carbon;
use Illuminate\Support\Collection;
use PowerComponents\LivewirePowerGrid\Column;
use PowerComponents\LivewirePowerGrid\Exportable;
use PowerComponents\LivewirePowerGrid\Facades\Filter;
use PowerComponents\LivewirePowerGrid\Footer;
use PowerComponents\LivewirePowerGrid\Header;
use PowerComponents\LivewirePowerGrid\PowerGrid;
use PowerComponents\LivewirePowerGrid\PowerGridComponent;
use PowerComponents\LivewirePowerGrid\PowerGridFields;
use PowerComponents\LivewirePowerGrid\Traits\WithExport;
 
final class CollectionTable extends PowerGridComponent
{
use WithExport;
 
public function setUp(): array
{
$this->showCheckBox();
 
return [
Exportable::make('export')
->striped()
->type(Exportable::TYPE_XLS, Exportable::TYPE_CSV),
 
Header::make()
->showToggleColumns()
->showSearchInput(),
 
Footer::make()
->showPerPage()
->showRecordCount(),
];
}
 
public function datasource(): Collection
{
return collect([
[
'id' => 1,
'name' => 'Name 1',
'price' => 1.58,
'in_stock' => true,
'created_at' => '2023-01-01 00:00:00',
'chef_name' => '',
],
[
'id' => 2,
'name' => 'Name 2',
'price' => 1.68,
'in_stock' => true,
'created_at' => '2023-02-02 00:00:00',
'chef_name' => null,
],
[
'id' => 3,
'name' => 'Name 3',
'price' => 1.78,
'in_stock' => false,
'created_at' => '2023-03-03 00:00:00',
'chef_name' => 'Luan',
],
[
'id' => 4,
'name' => 'Name 4',
'price' => 1.88,
'in_stock' => true,
'created_at' => '2023-04-04 00:00:00',
'chef_name' => 'Luan',
],
[
'id' => 5,
'name' => 'Name 5',
'price' => 1.98,
'in_stock' => false,
'created_at' => '2023-05-05 00:00:00',
'chef_name' => 'Luan',
],
]);
}
 
public function fields(): PowerGridFields
{
return PowerGrid::fields()
->add('id')
->add('name')
->add('chef_name')
->add('price')
->add('in_stock', function ($entry) {
return $entry->in_stock ? 'Yes' : 'No';
})
->add('created_at', function ($entry) {
return Carbon::parse($entry->created_at);
})
->add('created_at_formatted', function ($entry) {
return Carbon::parse($entry->created_at)->format('d/m/Y');
});
}
 
public function columns(): array
{
return [
Column::add()
->title(__('ID'))
->field('id')
->searchable()
->sortable(),
 
Column::add()
->title(__('Name'))
->field('name')
->searchable()
->sortable(),
 
Column::add()
->title(__('Chef'))
->field('chef_name')
->searchable()
->sortable(),
 
Column::add()
->title(__('Price'))
->field('price')
->sortable(),
 
Column::add()
->title(__('In Stock'))
->field('in_stock'),
 
Column::add()
->title(__('Created At'))
->field('created_at_formatted'),
];
}
 
public function filters(): array
{
return [
Filter::inputText('name'),
];
}
}

Here you can find all relevant packages installed on this demo.

Name
Version
Description
laravel/framework
10
The Laravel Framework.
openspout/openspout
4.x-dev
PHP Library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way
power-components/livewire-powergrid
dev-livewire-main
PowerGrid generates Advanced Datatables using Laravel Livewire.