Workflow
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.