Header/footer in a table Filament 3

I want to add a header or footer to a table (widget). The header/footer I want to be a text followed by a dynamic value(float). The dynamic value I want to be the result of getParkEntrySubtotal method

Here is the code

<?php

namespace App\Filament\Widgets;

use App\Models\Facility;
use Filament\Forms\Components\DatePicker;
use Filament\Tables\Columns\TextColumn;
use Filament\Tables\Filters\Filter;
use Filament\Tables\Table;
use Filament\Widgets\TableWidget as BaseWidget;
use Illuminate\Contracts\Support\Htmlable;
use Illuminate\Database\Eloquent\Builder;

class FacilitiesWidget extends BaseWidget
{
    protected function getTableHeading(): string | Htmlable| null
    {
        return __('statistic.facilities');
    }

    protected static ?int $sort = 5;






    

    public function getParkEntrySubtotal(): float
    {
        $parkEntrySubtotal = Facility::query()
            ->join('ticket_facilities', 'facilities.id', '=', 'ticket_facilities.facility_id')
            ->join('tickets', 'tickets.id', '=', 'ticket_facilities.ticket_id')
            ->join('ticket_types as tt', 'tickets.ticket_type_id', '=', 'tt.id') // alias tt for ticket_types

            ->select(
                'facilities.id',
                'facilities.name as name',
                'facilities.price as price'
            )
            ->selectRaw('SUM(ticket_facilities.use_limit) as use_limit')
            ->selectRaw('SUM(facilities.price * ticket_facilities.use_limit) as TotalMoney')

            // Calculate park entry subtotal (tt.price * total ticket quantity)
            ->selectRaw('tt.price * COUNT(DISTINCT tickets.id) as park_entry_subtotal')

            // Group by facilities and ticket type price (not required for this method)
            ->groupBy('facilities.id', 'facilities.name', 'facilities.price', 'tt.price')

            ->first()?->park_entry_subtotal ?? 0.0; // Return park_entry_subtotal or 0.0 if not found

        return $parkEntrySubtotal;
    }









    public function table(Table $table): Table
    {
        return $table
            ->query(
                Facility::query()
                    ->join('ticket_facilities', 'facilities.id', '=', 'ticket_facilities.facility_id')
                    ->join('tickets', 'tickets.id', '=', 'ticket_facilities.ticket_id')
                    ->select(
                        'facilities.id',
                        'facilities.name as name',
                        'facilities.price as price'
                    )
                    ->selectRaw('SUM(ticket_facilities.use_limit) as use_limit')
                    ->selectRaw('SUM(facilities.price * ticket_facilities.use_limit) as TotalMoney')
                    ->groupBy('facilities.id', 'facilities.name', 'facilities.price')
            )

            ->columns([
                TextColumn::make('name')
                    ->label(__('ticket.facility_name')),

                TextColumn::make('use_limit')
                    ->alignCenter()
                    ->label(__('ticket.facility_quantity')),

                TextColumn::make('price')
                    ->alignCenter()
                    ->label(__('ticket.price')),

                TextColumn::make('TotalMoney')
                    ->alignCenter()
                    ->label(__('ticket.total_money')),

            ])
            ->filters([
                Filter::make('created_at')
                    ->form([
                        DatePicker::make('created_from'),
                        DatePicker::make('created_until'),
                    ])
                    ->query(fn (Builder $query, array $data): Builder => $query
                        ->when(
                            $data['created_from'],
                            fn (Builder $query, $date): Builder => $query->whereDate('tickets.created_at', '>=', $date),
                        )
                        ->when(
                            $data['created_until'],
                            fn (Builder $query, $date): Builder => $query->whereDate('tickets.created_at', '<=', $date),
                        ))
            ]);
    }
}

LaryAI

1 year ago

Level 58

To add a header or footer to a table widget in Filament 3, you can use the header and footer methods provided by the Filament table component. You can include dynamic values by calling methods within these sections.

Here's an example of how you can achieve this:

Define your table widget.
Use the header and footer methods to add the desired text and dynamic value.

Assuming you have a method getParkEntrySubtotal that returns a float value, you can integrate it as follows:

use Filament\Tables\Columns\TextColumn;
use Filament\Tables\Widgets\TableWidget;

class YourTableWidget extends TableWidget
{
    protected function getTableColumns(): array
    {
        return [
            TextColumn::make('column_name')
                ->label('Column Label'),
            // Add other columns as needed
        ];
    }

    protected function getTableHeader(): ?string
    {
        $subtotal = $this->getParkEntrySubtotal();
        return "Header Text: " . number_format($subtotal, 2);
    }

    protected function getTableFooter(): ?string
    {
        $subtotal = $this->getParkEntrySubtotal();
        return "Footer Text: " . number_format($subtotal, 2);
    }

    private function getParkEntrySubtotal(): float
    {
        // Your logic to calculate the subtotal
        return 123.45; // Example value
    }
}

In this example:

getTableColumns defines the columns of your table.
getTableHeader and getTableFooter methods are used to add a header and footer to the table, respectively. These methods return a string that includes the dynamic value from getParkEntrySubtotal.
getParkEntrySubtotal is a placeholder for your actual method that calculates the subtotal.

Make sure to replace column_name and Column Label with your actual column details and adjust the logic in getParkEntrySubtotal to fit your needs.

This should give you a table with a header and footer that includes dynamic values.

Please or to participate in this conversation.