Workflow
Lazy Load

This example enables Lazy Loading.

ID
Name
Category
Price
In Stock
Created At
1
Arkansas Possum Pie
Garnish
€243.39
No
06/07/2024
2
Albacore Tuna Melt
Pie
€63.11
Yes
03/07/2024
3
Π±ΠΎΡ€Ρ‰
Soup
€100.19
Yes
26/06/2024
4
Bacalhau com natas
Garnish
€238.11
Yes
02/06/2024
5
Baba Ghanoush
Pasta
€143.09
Yes
30/05/2024
6
Bacon Cheeseburger
Fish
€257.39
Yes
13/06/2024
7
Baked potato
Garnish
€171.89
Yes
05/07/2024
8
Baklava
Dessert
€143.46
Yes
14/07/2024
9
Bangers and mash
Dessert
€253.72
Yes
26/05/2024
10
Black Pudding
Pasta
€248.73
Yes
10/07/2024
11
Blue cheese dressing
Pasta
€130.90
No
25/05/2024
12
Boulliabaise
Soup
€104.68
No
21/06/2024
13
Bread
Garnish
€60.60
Yes
18/06/2024
14
Breaded shrimp
Pie
€186.47
No
31/05/2024
15
Breakfast burrito
Pasta
€199.36
Yes
18/05/2024
16
Brisket
Soup
€138.11
Yes
25/06/2024
17
Brunswick stew
Meat
€165.15
No
01/07/2024
18
Bruschetta
Pasta
€165.87
No
28/05/2024
19
Buffalo Wings
Garnish
€86.31
No
16/07/2024
20
Buffalo burger
Pie
€278.57
No
23/06/2024
21
Buffalo wing
Soup
€82.90
No
08/07/2024
22
Calamari
Fish
€252.14
Yes
28/05/2024
23
Carne pizzaiola
Garnish
€170.92
No
04/06/2024
24
Caviar
Meat
€164.59
No
25/05/2024
25
Ceviche
Pie
€99.14
Yes
09/07/2024
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.
πŸ”Ž View on GitHub
<?php
 
namespace App\Livewire\Examples\LazyLoadTable;
 
use App\Models\Dish;
use Illuminate\Database\Query\Builder;
use Illuminate\Support\Carbon;
use Illuminate\Support\Number;
use Livewire\Attributes\On;
use PowerComponents\LivewirePowerGrid\Column;
use PowerComponents\LivewirePowerGrid\Footer;
use PowerComponents\LivewirePowerGrid\Header;
use PowerComponents\LivewirePowerGrid\Lazy;
use PowerComponents\LivewirePowerGrid\PowerGrid;
use PowerComponents\LivewirePowerGrid\PowerGridComponent;
use PowerComponents\LivewirePowerGrid\PowerGridFields;
 
class LazyLoadTable extends PowerGridComponent
{
public function setUp(): array
{
return [
Header::make()
->showSearchInput(),
 
Footer::make()
->showPerPage(200)
->showRecordCount(),
 
Lazy::make()
->rowsPerChildren(25),
];
}
 
public function datasource(): ?Builder
{
return Dish::query()
->join('categories as newCategories', function ($categories) {
$categories->on('dishes.category_id', '=', 'newCategories.id');
})
->select('dishes.*', 'newCategories.name as category_name')
->toBase();
}
 
public function fields(): PowerGridFields
{
return PowerGrid::fields()
->add('id')
->add('name')
->add('category_id', fn ($dish) => intval($dish->category_id))
->add('category_name', fn ($dish) => e($dish->category_name))
->add('price_in_eur', fn ($dish) => Number::currency($dish->price, in: 'EUR'))
->add('in_stock', fn ($dish) => $dish->in_stock ? 'Yes' : 'No')
->add('created_at_formatted', fn ($dish) => Carbon::parse($dish->created_at)->format('d/m/Y'));
}
 
public function columns(): array
{
return [
 
Column::make('ID', 'id')
->searchable()
->sortable(),
 
Column::make('Name', 'name')
->bodyAttribute('!text-wrap')
->searchable()
->sortable(),
 
Column::make('Category', 'category_name'),
 
Column::make('Price', 'price_in_eur', 'price')
->searchable()
->sortable(),
 
Column::make('In Stock', 'in_stock'),
 
Column::make('Created At', 'created_at_formatted'),
];
}
 
#[On('edit')]
public function edit(int $dishId): void
{
$this->js('alert(' . $dishId . ')');
}
}
Code highlighting provided by Torchlight.dev

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

Name
Version
Description
laravel/framework
v11
The Laravel Framework.
livewire/livewire
v3.5.4
A front-end framework for Laravel.
openspout/openspout
v4.24.3
PHP Library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way
power-components/livewire-powergrid
5.x-dev
PowerGrid generates Advanced Datatables using Laravel Livewire.