Filament•13mo ago

Display value of Pivot Table

Hello, I'm currently looking for a better and more performant solution to display a pivot table attribute in my relationManager. It is working right now and using formatStateUsing() but it is doing a lot of DB queries as you might see i use the SponsorType::find() function. SponsorsRelationManager.php

public static function table(Table $table): Table
    {
        return $table
            ->columns([
                ImageColumn::make('logo_url')
                    ->label('Logo')
                    ->circular()
                ,
                TextColumn::make('name')
                    ->searchable()
                    ->sortable(),
                TextColumn::make('country')
                    ->searchable()
                    ->sortable(),
                TextColumn::make('sponsor_type_id')
                    ->label('Type')
                    // Show the name of the sponsor type instead of the ID
                    ->formatStateUsing(function (string $state) {
                        return SponsorType::find($state)->name;
                    })
                    ->searchable()
                    ->sortable(),
            ])
            ->filters([
                //
            ])
            ->headerActions([
                Tables\Actions\CreateAction::make(),
            ])
            ->actions([
                Tables\Actions\EditAction::make(),
                Tables\Actions\DeleteAction::make(),
            ])
            ->bulkActions([
                Tables\Actions\DeleteBulkAction::make(),
            ]);
    }

public static function table(Table $table): Table
    {
        return $table
            ->columns([
                ImageColumn::make('logo_url')
                    ->label('Logo')
                    ->circular()
                ,
                TextColumn::make('name')
                    ->searchable()
                    ->sortable(),
                TextColumn::make('country')
                    ->searchable()
                    ->sortable(),
                TextColumn::make('sponsor_type_id')
                    ->label('Type')
                    // Show the name of the sponsor type instead of the ID
                    ->formatStateUsing(function (string $state) {
                        return SponsorType::find($state)->name;
                    })
                    ->searchable()
                    ->sortable(),
            ])
            ->filters([
                //
            ])
            ->headerActions([
                Tables\Actions\CreateAction::make(),
            ])
            ->actions([
                Tables\Actions\EditAction::make(),
                Tables\Actions\DeleteAction::make(),
            ])
            ->bulkActions([
                Tables\Actions\DeleteBulkAction::make(),
            ]);
    }

10 Replies

BuggerSee•13mo ago

Pivot Class: ConferenceSponsor.php

class ConferenceSponsor extends Pivot
{
    protected $table = 'conference_sponsor';

    protected $fillable = [
        'conference_id',
        'sponsor_id',
        'sponsor_type_id',
    ];

    public function conference()
    {
        return $this->belongsTo(Conference::class);
    }

    public function sponsor()
    {
        return $this->belongsTo(Sponsor::class);
    }

    public function sponsorType()
    {
        return $this->belongsTo(SponsorType::class);
    }
}

class ConferenceSponsor extends Pivot
{
    protected $table = 'conference_sponsor';

    protected $fillable = [
        'conference_id',
        'sponsor_id',
        'sponsor_type_id',
    ];

    public function conference()
    {
        return $this->belongsTo(Conference::class);
    }

    public function sponsor()
    {
        return $this->belongsTo(Sponsor::class);
    }

    public function sponsorType()
    {
        return $this->belongsTo(SponsorType::class);
    }
}

Sponsor model class:

class Sponsor extends Model
{
    protected $table = 'sponsors';

    protected $fillable = [
        'name',
        'country',
        'logo_url',
    ];

    public function conferences()
    {
        return $this->belongsToMany(Conference::class, 'conference_sponsor')
            ->using(ConferenceSponsor::class)
            ->withPivot('sponsor_type_id');
    }
}

class Sponsor extends Model
{
    protected $table = 'sponsors';

    protected $fillable = [
        'name',
        'country',
        'logo_url',
    ];

    public function conferences()
    {
        return $this->belongsToMany(Conference::class, 'conference_sponsor')
            ->using(ConferenceSponsor::class)
            ->withPivot('sponsor_type_id');
    }
}

BuggerSee•13mo ago

awcodes•13mo ago

can you not just eager load the relationship in the eloquent query for the table?

BuggerSee•13mo ago

Where exactly would i need to do that? Sorry im quite new to this

awcodes•13mo ago

In your relation manage class I think it’s getTableQuery.

awcodes•13mo ago

Works the same as the list resource class. https://filamentphp.com/docs/2.x/admin/resources/listing-records#customizing-the-eloquent-query

Filament

Listing records - Resources - Admin Panel - Filament

The elegant TALL stack admin panel for Laravel artisans.

BuggerSee•13mo ago

    protected function getTableQuery(): Builder
    {
        return parent::getTableQuery()->with('sponsorType');
    }

    protected function getTableQuery(): Builder
    {
        return parent::getTableQuery()->with('sponsorType');
    }

BuggerSee•13mo ago

Added this code now and i don't get n+1 warning anymore. This should mean the eager loading is working correct?

awcodes•13mo ago

correct then you should be able to just use 'sponsorType.name' for your text column

BuggerSee•13mo ago

Thanks it worked 🙂

Gaming

Programming

Display value of Pivot Table