Relationship Model Cant Connect Another Table

[kahfieidn]

What happened?

How to call relationship in $row rappasoft
I try to make dynamic array which is

Here is my code:

            Column::make("Status", "status")
                ->sortable()
                ->searchable(),
                ButtonGroupColumn::make('Actions')
                ->attributes(function($row) {
                    return [
                        'class' => 'space-x-2',
                    ];
                })
                ->buttons([
                    LinkColumn::make('View') // make() has no effect in this case but needs to be set anyway
                    ->title(fn($row) => 'View' . $row->name)
                    ->location(fn($row) => route('dashboard.tracking.show', [$row->perizinans->id, $row->id] ))
                        ->attributes(function($row) {
                            return [
                                'class' => 'underline text-blue-500 hover:no-underline',
                            ];
                        }),
                ]),       

$row->perizinans->id above not working to call relationship table, please help us to get another id table in relationship model in laravel

Before i make column using relationship .perizinans.name, all working fine, and then when i call relation ship using row like $row->perizinans->id, not working

Please help me, thanks

How to reproduce the bug

No response

Package Version

2

PHP Version

8.1.x

Laravel Version

10

Alpine Version

3

Theme

Bootstrap 4.x

Notes

No response

Error Message

No response

[lrljoe]

Use setAdditionalSelects() in your configure method. Or use the builder() to add a with() to reference the model.

The package only loads the columns that are used or specified to optimize performance.

[kahfieidn]

when i definition with in query, how to call that in $row ??
Can you give me example?

[lrljoe]

Can you share your builder() code and I'll let you know. It'll be the same style however

[kahfieidn]

public function query(): Builder
 {
     return Permohonan::query()
         ->with('perizinans');
 }

perizinans is my table relationship,

and i try call id perizinans using $row like $row->perizinans->id

the error is : Attempt to read property "id" on null

Here is my full code :

    public function query(): Builder
    {
        return Permohonan::query()
            ->with('perizinans');
    }

    public function columns(): array
    {
        return [
            Column::make("Id", "id")
                ->sortable(),
            Column::make("Nama Pemohon", "users.name")
                ->sortable()
                ->searchable(),
            Column::make("Nama Perizinan", "perizinans.nama_perizinan")
                ->sortable(),
            Column::make("Sektor", "sektors.nama_sektor")
                ->sortable(),
            LinkColumn::make('Action')
                ->title(fn($row) => 'View')
                ->location(fn($row) => route('dashboard.tracking.show', [$row->perizinans->id, $row->id])),    
        ];
    }

[lrljoe]

Can you share the whole component, including configure() etc please

[kahfieidn]

Here is:

<?php

namespace App\Http\Livewire;

use App\Models\User;
use App\Models\Perizinan;
use App\Models\Permohonan;
use Rappasoft\LaravelLivewireTables\Views\Column;
use Rappasoft\LaravelLivewireTables\DataTableComponent;
use Rappasoft\LaravelLivewireTables\Views\Columns\LinkColumn;
use Rappasoft\LaravelLivewireTables\Views\Columns\ButtonGroupColumn;

class TrackingTable extends DataTableComponent
{
    protected $model = Permohonan::class;
    protected $perizinans = Perizinan::class;

    public function configure(): void
    {
        $this->setPrimaryKey('id');
    }

    public function query(): Builder
    {
        return Permohonan::query()
            ->with('perizinans');
    }

    public function columns(): array
    {
        return [
            Column::make("Id", "id")
                ->sortable(),
            Column::make("Nama Pemohon", "users.name")
                ->sortable()
                ->searchable(),
            Column::make("Nama Perizinan", "perizinans.nama_perizinan")
                ->sortable(),
            Column::make("Sektor", "sektors.nama_sektor")
                ->sortable(),
            LinkColumn::make('Action')
                ->title(fn($row) => 'View')
                ->location(fn($row) => route('dashboard.tracking.show', [$row->perizinans->id, $row->id])),    
        ];
    }
}

[lrljoe]

Get rid of the $model reference as that is the alternative approach, and it is

public function builder(): Builder

not

public function query(): Builder

Then add the id for your relationship in setAdditionalSelects in your configure() method. You'll need to prefix it with the table name in your database.

[kahfieidn]

I got error when change public function builder(): Builder

Log is:
Could not check compatibility between App\Http\Livewire\TrackingTable::builder(): App\Http\Livewire\Builder and Rappasoft\LaravelLivewireTables\DataTableComponent::builder(): Illuminate\Database\Eloquent\Builder, because class App\Http\Livewire\Builder is not available

Here is my full code :

<?php

namespace App\Http\Livewire;

use App\Models\User;
use App\Models\Perizinan;
use App\Models\Permohonan;
use Rappasoft\LaravelLivewireTables\Views\Column;
use Rappasoft\LaravelLivewireTables\DataTableComponent;
use Rappasoft\LaravelLivewireTables\Views\Columns\LinkColumn;
use Rappasoft\LaravelLivewireTables\Views\Columns\ButtonGroupColumn;

class TrackingTable extends DataTableComponent
{
    protected $model = Permohonan::class;
    protected $perizinans = Perizinan::class;

    public function configure(): void
    {
        $this->setPrimaryKey('id');
        $this->setAdditionalSelects(['perizinans.id as id']);

    }

    public function builder(): Builder
    {
        return Permohonan::query()
            ->with('perizinans');
    }

    public function columns(): array
    {
        return [
            Column::make("Id", "id")
                ->sortable(),
            Column::make("Nama Pemohon", "users.name")
                ->sortable()
                ->searchable(),
            Column::make("Nama Perizinan", "perizinans.nama_perizinan")
                ->sortable(),
            Column::make("Sektor", "sektors.nama_sektor")
                ->sortable(),
            LinkColumn::make('Action')
                ->title(fn($row) => 'View')
                ->location(fn($row) => route('dashboard.tracking.show', [$row->perizinans->id, $row->id])),    
        ];
    }
}

[lrljoe]

Add

use Illuminate\Database\Eloquent\Builder;

to the top of your component

[kahfieidn]

Ok now error solve,
but i cannot call $row->perizinans->id

Attempt to read property "id" on null

[kahfieidn]

Solved thanks