Filament PHP v3 Architecture & TALL Stack Engineering

namespace App\Filament\Resources;

use App\Models\Invoice;
use Filament\Resources\Resource;
use Filament\Tables\Table;
use Filament\Tables;
use Illuminate\Database\Eloquent\Builder;
use Filament\Notifications\Notification;

class InvoiceResource extends Resource
{
    protected static ?string $model = Invoice::class;
    protected static ?string $navigationIcon = 'heroicon-o-document-text';
    protected static ?string $tenantOwnershipRelationshipName = 'team';

    public static function getEloquentQuery(): Builder
    {
        // Enforce strict eager-loading and column selection to eliminate N+1 queries
        return parent::getEloquentQuery()
            ->select(['id', 'team_id', 'customer_id', 'invoice_number', 'total_amount', 'status', 'due_date'])
            ->with([
                'customer:id,name,company_email',
                'team:id,name,currency'
            ])
            ->withCount('items');
    }

    public static function table(Table $table): Table
    {
        return $table
            ->columns([
                Tables\Columns\TextColumn::make('invoice_number')
                    ->searchable(isIndividual: true)
                    ->sortable(),
                Tables\Columns\TextColumn::make('customer.name')
                    ->searchable()
                    ->sortable(),
                Tables\Columns\TextColumn::make('total_amount')
                    ->money(fn ($record) => $record->team->currency ?? 'USD')
                    ->sortable(),
                Tables\Columns\BadgeColumn::make('status')
                    ->colors([
                        'warning' => 'pending',
                        'success' => 'paid',
                        'danger'  => 'overdue',
                    ]),
            ])
            ->bulkActions([
                Tables\Actions\BulkAction::make('batchExport')
                    ->label('Export Selected to CSV (Async)')
                    ->icon('heroicon-o-arrow-down-tray')
                    ->action(function ($records) {
                        dispatch(new \App\Jobs\ExportInvoicesJob($records->pluck('id')->toArray(), auth()->id()));
                        Notification::make()
                            ->title('Export queued in background. You will receive a link when ready.')
                            ->success()
                            ->send();
                    }),
            ]);
    }
}