New: NativePHP Starter-Kit

Laravel Livewire Tables Documentation
Sponsors Demo Support

Edit

🎉 Enjoying this package? Consider sponsoring me on GitHub or buying me a beer.

This is the documentation for v2 but the latest version is v3. You can switch versions in the menu at the top. Check your current version with the following command:

composer show rappasoft/laravel-livewire-tables

Relationships

Out of the box the columns support hasOne, belongsTo, and MorphOne relationships for display, sorting, and searching. The component will automatically join the necessary tables.

To call these relationships, just use the relationship dot-notation string as the field name:

 1protected $model = User::class;
 2 
 3// ...
 4 
 5public function columns(): array {
 6    return [
 7        // Looks for the address column on the address relationship of User.
 8        // $user->address->address
 9        Column::make('Address', 'address.address'),
10 
11        // Looks for $user->address->group->name
12        Column::make('Address Group', 'address.group.name'),
13 
14        // Looks for $user->address->group->city->name
15        Column::make('Group City', 'address.group.city.name'),
16    ];
17}

The above will join the necessary tables as well as alias the columns for selecting, sorting, searching, etc.:

 1SELECT `addresses`.`address`   AS `address.address`,
 2       `address_groups`.`name` AS `address.group.name`,
 3       `cities`.`name`         AS `address.group.city.name`
 4FROM   `users`
 5       LEFT JOIN `addresses`
 6                 ON `addresses`.`user_id` = `users`.`id`
 7       LEFT JOIN `address_groups`
 8                 ON `addresses`.`address_group_id` = `address_groups`.`id`
 9       LEFT JOIN `cities`
10                 ON `address_groups`.`city_id` = `cities`.`id`