Laravel Tutorials

Enhancing Laravel Queries with Reusable Scope Patterns

Published
Enhancing Laravel Queries with Reusable Scope Patterns image

Laravel's query scope functionality transforms repetitive database query logic into elegant, reusable components. These powerful abstractions enable developers to encapsulate common filtering patterns while maintaining code clarity and promoting consistent query behavior across applications.

Local scopes define reusable query constraints through specially marked methods within Eloquent models:

use Illuminate\Database\Eloquent\Attributes\Scope;
use Illuminate\Database\Eloquent\Builder;

class Order extends Model
{
    #[Scope]
    protected function completed(Builder $query): void
    {
        $query->where('status', 'completed');
    }
    
    #[Scope]
    protected function recent(Builder $query): void
    {
        $query->where('created_at', '>=', now()->subDays(30));
    }
}

Dynamic scope parameters enable flexible filtering based on runtime values:

#[Scope]
protected function byPriority(Builder $query, string $level): void
{
    $query->where('priority_level', $level);
}

$urgentOrders = Order::byPriority('urgent')->get();

Building a comprehensive inventory management system demonstrates scope composition and chaining capabilities across different operational contexts:

class Inventory extends Model
{
    #[Scope]
    protected function available(Builder $query): void
    {
        $query->where('quantity', '>', 0)
              ->where('is_active', true);
    }
    
    #[Scope]
    protected function lowStock(Builder $query): void
    {
        $query->whereColumn('quantity', '<=', 'minimum_threshold');
    }
    
    #[Scope]
    protected function inWarehouse(Builder $query, string $location): void
    {
        $query->where('warehouse_location', $location);
    }
}

$criticalItems = Inventory::available()
                         ->lowStock()
                         ->inWarehouse('main')
                         ->orderBy('quantity', 'asc')
                         ->get();

Global scopes automatically apply constraints to all model queries, ensuring consistent data filtering without manual intervention. Anonymous global scopes provide convenient query modification for simple filtering requirements while maintaining clean model definitions.

The scope architecture facilitates complex query building through method chaining, enabling developers to construct sophisticated database interactions using readable, self-documenting code patterns that promote maintainability and reduce query duplication across applications.

Harris Raftopoulos photo

Senior Software Engineer • Staff & Educator @ Laravel News • Co-organizer @ Laravel Greece Meetup

Sponsored

laravelcloud logo
Laravel Cloud

Easily create and manage your servers and deploy your Laravel applications in seconds.

Visit Laravel Cloud

The latest

View all →
Slow Job Alerts and Replica Commit IDs in Laravel 13.40 image

Slow Job Alerts and Replica Commit IDs in Laravel 13.40

Read article
Flock: A Free, Native Herd Alternative for Laravel image

Flock: A Free, Native Herd Alternative for Laravel

Read article
Live Props for Real-Time Updates in Inertia.js v3.11 image

Live Props for Real-Time Updates in Inertia.js v3.11

Read article
Cooldown Dependency Policy now in Composer 2.11 image

Cooldown Dependency Policy now in Composer 2.11

Read article
Email Sending and Testing for Laravel in One Account image

Email Sending and Testing for Laravel in One Account

Read article
Decide with Jev: Tie Every AI Check to the Exact Draft image

Decide with Jev: Tie Every AI Check to the Exact Draft

Read article