Stop duplicating your Eloquent query scopes and constraints in PHP. This package lets you re-use your query scopes and constraints by adding them as a subquery.
📺 Want to see this package in action? Join the live stream on December 3 at 14:00 CET: https://youtu.be/0vR8IQSFsfQ
- PHP 8.1+
- Laravel 10.0
This package is tested with GitHub Actions using MySQL 8.0, PostgreSQL 10.8 and SQLite.
- Add a subquery based on a query scope.
- Add a subquery using a Closure.
- Shortcuts for calling scopes by using a string or array.
- Support for more than one subquery.
- Support for flipping the result.
- Zero third-party dependencies.
Related package: Laravel Eloquent Where Not
❤️ We proudly support the community by developing Laravel packages and giving them away for free. If this package saves you time or if you're relying on it professionally, please consider sponsoring the maintenance and development and check out our latest premium package: Inertia Table. Keeping track of issues and pull requests takes time, but we're happy to help!
If you want to know more about the background of this package, please read the blogpost: Stop duplicating your Eloquent query scopes and constraints. Re-use them as select statements with a new Laravel package.
You can install the package via composer:
composer require protonemedia/laravel-eloquent-scope-as-selectAdd the macro to the query builder, for example, in your AppServiceProvider. By default, the name of the macro is addScopeAsSelect, but you can customize it with the first parameter of the addMacro method.
use ProtoneMedia\LaravelEloquentScopeAsSelect\ScopeAsSelect;
public function boot()
{
ScopeAsSelect::addMacro();
// or use a custom method name:
ScopeAsSelect::addMacro('withScopeAsSubQuery');
}For a more practical explanation, check out the usage section below.
Add a select using a Closure. Each Post model, published or not, will have an is_published attribute.
Post::addScopeAsSelect('is_published', function ($query) {
$query->published();
})->get();The example above can be shortened by using a string, where the second argument is the name of the scope:
Post::addScopeAsSelect('is_published', 'published')->get();You can use an array to call multiple scopes:
Post::addScopeAsSelect('is_popular_and_published', ['popular', 'published'])->get();Use an associative array to call dynamic scopes:
Post::addScopeAsSelect('is_announcement', ['ofType' => 'announcement'])->get();If your dynamic scopes require multiple arguments, you can use an associative array:
Post::addScopeAsSelect('is_announcement', ['publishedBetween' => [2010, 2020]])->get();You can also mix dynamic and non-dynmaic scopes:
Post::addScopeAsSelect('is_published_announcement', [
'published',
'ofType' => 'announcement'
])->get();The method has an optional third argument that flips the result.
Post::addScopeAsSelect('is_not_announcement', ['ofType' => 'announcement'], false)->get();Imagine you have a Post Eloquent model with a query scope.
class Post extends Model
{
public function scopePublished($query)
{
return $query->whereNotNull('published_at');
}
}Now you can fetch all published posts by calling the scope method on the query:
$allPublishedPosts = Post::published()->get();But what if you want to fetch all posts and then check if the post is published? This scope is quite simple, so you can easily mimic the scope's outcome by checking the published_at attribute:
Post::get()->each(function (Post $post) {
$isPublished = !is_null($post->published_at);
});This is harder to achieve when scopes get more complicated or when you chain various scopes. Let's add a relationship and another scope to the Post model:
class Post extends Model
{
public function comments()
{
return $this->hasMany(Comment::class);
}
public function scopePublished($query)
{
return $query->whereNotNull('published_at');
}
public function scopePublishedInCurrentYear($query)
{
return $query->whereYear('published_at', date('Y'));
}
}Using Eloquent, we can fetch all posts from this year with at least ten comments.
$recentPopularPosts = Post::query()
->publishedInCurrentYear()
->has('comments', '>=', 10)
->get();Great! Now we want to fetch all posts again, and then check if the post was published this year and has at least ten comments.
Post::get()->each(function (Post $post) {
$isRecentAndPopular = $post->comments()->count() >= 10
&& optional($post->published_at)->isCurrentYear();
});Well, you get the idea. This is bound to get messy and you're duplicating logic as well.
Using the power of this package, you can re-use your scopes when fetching data. The first example (published scope) can be narrowed down to:
$posts = Post::addScopeAsSelect('is_published', function ($query) {
$query->published();
})->get();With short closures, a feature which was introduced in PHP 7.4, this can be even shorter:
$posts = Post::addScopeAsSelect('is_published', fn ($query) => $query->published())->get();Now every Post model will have an is_published boolean attribute.
$posts->each(function (Post $post) {
$isPublished = $post->is_published;
});You can add multiple selects as well, for example, to combine both scenarios:
Post::query()
->addScopeAsSelect('is_published', function ($query) {
$query->published();
})
->addScopeAsSelect('is_recent_and_popular', function ($query) {
$query->publishedInCurrentYear()->has('comments', '>=', 10);
})
->get()
->each(function (Post $post) {
$isPublished = $post->is_published;
$isRecentAndPopular = $post->is_recent_and_popular;
});Instead of using a Closure, there are some shortcuts you could use (see also: Short API description):
Using a string instead of a Closure:
Post::addScopeAsSelect('is_published', function ($query) {
$query->published();
});
// is the same as:
Post::addScopeAsSelect('is_published', 'published');Using an array instead of Closure, to support multiple scopes and dynamic scopes:
Post::addScopeAsSelect('is_announcement', function ($query) {
$query->ofType('announcement');
});
// is the same as:
Post::addScopeAsSelect('is_announcement', ['ofType' => 'announcement']);You can also flip the result with the optional third parameter (it defaults to true):
$postA = Post::addScopeAsSelect('is_announcement', ['ofType' => 'announcement'])->first();
$postB = Post::addScopeAsSelect('is_not_announcement', ['ofType' => 'announcement'], false)->first();
$this->assertTrue($postA->is_announcement)
$this->assertFalse($postB->is_not_announcement);composer testPlease see CHANGELOG for more information about what has changed recently.
Please see CONTRIBUTING for details.
Inertia Table: The Ultimate Table for Inertia.js with built-in Query Builder.Laravel Blade On Demand: Laravel package to compile Blade templates in memory.Laravel Cross Eloquent Search: Laravel package to search through multiple Eloquent models.Laravel FFMpeg: This package provides an integration with FFmpeg for Laravel. The storage of the files is handled by Laravel's Filesystem.Laravel MinIO Testing Tools: Run your tests against a MinIO S3 server.Laravel Mixins: A collection of Laravel goodies.Laravel Paddle: Paddle.com API integration for Laravel with support for webhooks/events.Laravel Task Runner: Write Shell scripts like Blade Components and run them locally or on a remote server.Laravel Verify New Email: This package adds support for verifying new email addresses: when a user updates its email address, it won't replace the old one until the new one is verified.Laravel XSS Protection: Laravel Middleware to protect your app against Cross-site scripting (XSS). It sanitizes request input, and it can sanatize Blade echo statements.
If you discover any security related issues, please email pascal@protone.media instead of using the issue tracker.
The MIT License (MIT). Please see License File for more information.
This package is Treeware. If you use it in production, then we ask that you buy the world a tree to thank us for our work. By contributing to the Treeware forest you’ll be creating employment for local families and restoring wildlife habitats.