Concept for filtering users or other models

To achieve dynamic filtering of users in your application using Filament, you can leverage Eloquent query scopes and custom filters. While there might not be a specific package that fits your exact needs, you can build a flexible system by combining Eloquent scopes with Filament's table filters. Here's a step-by-step approach:

1. Define Eloquent Scopes:

   First, define scopes in your User model to encapsulate the filtering logic. This makes your queries reusable and clean.

   // In User.php model
   public function scopeLoggedInLastThreeMonths($query)
   {
       return $query->where('last_login_at', '>=', now()->subMonths(3));
   }
   
   public function scopeNeverBoughtProduct($query)
   {
       return $query->whereDoesntHave('orders');
   }
   
   public function scopeOlderThan($query, $age)
   {
       return $query->where('birthdate', '<=', now()->subYears($age));
   }
   

2. Create Custom Filters in Filament:

   Use Filament's table filters to apply these scopes dynamically. You can create a custom filter class or define them directly in your Filament resource.

   // In your Filament resource
   use Filament\Tables\Filters\Filter;
   
   public static function table(Table $table): Table
   {
       return $table
           ->filters([
               Filter::make('Logged In Last 3 Months')
                   ->query(fn ($query) => $query->loggedInLastThreeMonths()),
   
               Filter::make('Never Bought Product')
                   ->query(fn ($query) => $query->neverBoughtProduct()),
   
               Filter::make('Older Than 18')
                   ->query(fn ($query) => $query->olderThan(18)),
           ]);
   }
   

3. Dynamic Filter System:

   If you want to make this system more dynamic, consider creating a configuration file or database table where you define available filters and their corresponding scopes. You can then loop through these configurations to generate filters dynamically.

   // Example of dynamic filter configuration
   $filters = [
       'Logged In Last 3 Months' => 'loggedInLastThreeMonths',
       'Never Bought Product' => 'neverBoughtProduct',
       'Older Than 18' => fn($query) => $query->olderThan(18),
   ];
   
   // In your Filament resource
   public static function table(Table $table): Table
   {
       $filterDefinitions = [];
   
       foreach ($filters as $label => $scope) {
           $filterDefinitions[] = Filter::make($label)
               ->query(is_callable($scope) ? $scope : fn($query) => $query->$scope());
       }
   
       return $table->filters($filterDefinitions);
   }
   

This approach allows you to define and manage filters dynamically, making it easier to add or modify filters without changing the core logic of your application.