Laravel Eloquent: Query Scopes

Global Scopes

Allow you to add constraints to all queries for a given model.

Local Scopes

Allow you to define common sets of constraints that you may easily re-use throughout your application.

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
    /**
     * Scope a query to only include popular users.
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopePopular($query)
    {
        return $query->where('votes', '>', 100);
    }

    /**
     * Scope a query to only include active users.
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeActive($query)
    {
        return $query->where('active', 1);
    }
}

Laravel Eloquent: Query Scopes — Structure map

Clickable & Draggable!

Laravel Eloquent: Query Scopes — Related pages: