Workflow
Join
Id
Dish
Category
1
Arkansas Possum Pie
Meat
2
Albacore Tuna Melt
Fish
3
борщ
Soup
4
Bacalhau com natas
Fish
5
Baba Ghanoush
Soup
6
Bacon Cheeseburger
Pie
7
Baked potato
Meat
8
Baklava
Meat
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 App\Models\Dish;
use Illuminate\Database\Eloquent\Builder;
use PowerComponents\LivewirePowerGrid\Column;
use PowerComponents\LivewirePowerGrid\Footer;
use PowerComponents\LivewirePowerGrid\Header;
use PowerComponents\LivewirePowerGrid\PowerGrid;
use PowerComponents\LivewirePowerGrid\PowerGridComponent;
use PowerComponents\LivewirePowerGrid\PowerGridFields;
 
class JoinTable extends PowerGridComponent
{
public function setUp(): array
{
return [
Header::make()
->showSearchInput(),
 
Footer::make()
->showPerPage(8, [8, 15, 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');
}
 
public function fields(): PowerGridFields
{
return PowerGrid::fields()
->add('id')
->add('dish_name', fn (Dish $dish) => $dish->name)
->add('category_name', fn (Dish $dish) => $dish->category->name);
}
 
public function columns(): array
{
return [
Column::make('Id', 'id')
->searchable()
->sortable(),
 
Column::make('Dish', 'dish_name', 'dishes.name')
->searchable()
->sortable(),
 
Column::make('Category', 'category_name', 'newCategories.name')
->searchable()
->sortable(),
];
}
}

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

Name
Version
Description
laravel/framework
v10
The Laravel Framework.
openspout/openspout
v4.23.0
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.