Skip to content

Instantly share code, notes, and snippets.

@HelgeSverre
Created September 23, 2023 10:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save HelgeSverre/22ad09bf5cac9f0f646df85a12e82459 to your computer and use it in GitHub Desktop.
Save HelgeSverre/22ad09bf5cac9f0f646df85a12e82459 to your computer and use it in GitHub Desktop.
How to group table rows in filamentphp by month and year
<?php
use Filament\Resources\Resource;
use Filament\Tables;
use Filament\Tables\Grouping\Group;
use Filament\Tables\Table;
use Illuminate\Database\Eloquent\Builder;
class ReceiptResource extends Resource
{
protected static ?string $model = Purchase::class;
protected static ?string $label = 'Purchases';
public static function table(Table $table): Table
{
return $table
->recordTitleAttribute('vendor_name')
->columns([
// Ex: "Friday 23. September 2023"
Tables\Columns\TextColumn::make('date')->label('Purchase Date')->date('l j. F Y'),
Tables\Columns\TextColumn::make('vendor_name')->label('Vendor'),
Tables\Columns\TextColumn::make('total_amount')->label('Total Amount'),
])
->defaultGroup(
// Group the rows by Year and Month (2023-09, 2023-11 etc) instead of "date"
Group::make('date')
// Ex: "2023-10-0",
// Note: You need the "-0" at the end, so Carbon can parse the date.
->getKeyFromRecordUsing(
fn(Purchase $record): string => $record->date->format('Y-m-0')
)
// Ex: "September 2023"
->getTitleFromRecordUsing(
fn(Purchase $record): string => $record->date->format('F Y')
)
// Set the default ordering
->orderQueryUsing(
fn(Builder $query, string $direction) => $query->orderBy('date', 'desc')
)
// Hide "date: " in the Group title
->titlePrefixedWithLabel(false),
);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment