Join
↓
Id
|
↕
Dish
|
↕
Category
|
---|---|---|
1
|
Arkansas Possum Pie
|
Garnish
|
2
|
Albacore Tuna Melt
|
Garnish
|
3
|
борщ
|
Soup
|
4
|
Bacalhau com natas
|
Dessert
|
5
|
Baba Ghanoush
|
Fish
|
6
|
Bacon Cheeseburger
|
Garnish
|
7
|
Baked potato
|
Meat
|
8
|
Baklava
|
Fish
|
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 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.
|