Input Select
This example demonstrates how to use a Custom Field to render a select input in a table cell.
You can find the Blade Component source code in SelectCategory.php and in select-category.blade.php.
ID
|
Dish Name
|
Category
|
Price
|
In Stock
|
Created At
|
---|---|---|---|---|---|
1
|
Arkansas Possum Pie
|
|
279,94 €
|
No
|
03/04/2024
|
2
|
Albacore Tuna Melt
|
|
97,76 €
|
Yes
|
18/05/2024
|
3
|
борщ
|
|
100,19 €
|
Yes
|
30/04/2024
|
4
|
Bacalhau com natas
|
|
257,80 €
|
No
|
21/04/2024
|
5
|
Baba Ghanoush
|
|
234,59 €
|
No
|
01/05/2024
|
6
|
Bacon Cheeseburger
|
|
118,06 €
|
No
|
17/05/2024
|
7
|
Baked potato
|
|
156,36 €
|
No
|
13/04/2024
|
8
|
Baklava
|
|
174,31 €
|
Yes
|
21/04/2024
|
9
|
Bangers and mash
|
|
193,81 €
|
No
|
03/04/2024
|
10
|
Black Pudding
|
|
108,28 €
|
Yes
|
18/05/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.
<?php namespace App\Livewire\Examples\InputSelectTable; use App\Models\Category;use App\Models\Dish;use Illuminate\Database\Query\Builder;use Illuminate\Support\Carbon;use Illuminate\Support\Collection;use Illuminate\Support\Facades\Blade;use Illuminate\Support\Number;use Livewire\Attributes\On;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 InputSelectTable extends PowerGridComponent{ public function setUp(): array { return [ Header::make() ->showSearchInput(), Footer::make() ->showPerPage() ->showRecordCount(), ]; } 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 { $options = $this->categorySelectOptions(); return PowerGrid::fields() ->add('id') ->add('name') ->add('category_id', fn ($dish) => intval($dish->category_id)) ->add('price_in_eur', fn ($dish) => Number::currency($dish->price, in: 'EUR', locale: 'pt_PT')) ->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')) ->add('category_name', function ($dish) use ($options) { if (is_null($dish->category_id)) { dd($dish); } return Blade::render('<x-select-category type="occurrence" :options=$options :dishId=$dishId :selected=$selected/>', ['options' => $options, 'dishId' => intval($dish->id), 'selected' => intval($dish->category_id)]); }); } public function columns(): array { return [ Column::make('ID', 'id'), Column::make('Dish Name', 'name') ->bodyAttribute('!text-wrap') ->searchable() ->sortable(), Column::make('Category', 'category_name'), Column::make('Price', 'price_in_eur', 'price'), Column::make('In Stock', 'in_stock'), Column::make('Created At', 'created_at_formatted'), ]; } public function categorySelectOptions(): Collection { return Category::all(['id', 'name'])->mapWithKeys(function ($item) { return [ $item->id => match (strtolower($item->name)) { 'meat' => '🍖 ', 'fish' => '🐟 ', 'pie' => '🍰 ', 'garnish' => '🥗 ', 'pasta' => '🍝 ', 'dessert' => '🍧 ', 'soup' => '🍲 ', } . $item->name, ]; }); } #[On('categoryChanged')] public function categoryChanged($categoryId, $dishId): void { dd("category Id: {$categoryId} for Dish id: {$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.0
|
A front-end framework for Laravel.
|
openspout/openspout
|
v4.24.1
|
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.
|