kirschbaum-development/eloquent-power-joins
Open on GitHub →
The Laravel magic you know, now applied to joins
Eloquent is very powerful, but it lacks a bit of the "Laravel way" when using joins. This package lets you write joins the Laravel way: more readable, with less code, and without leaking implementation details where they don't belong.
Instead of writing joins by hand:
User::select('users.*')
->join('posts', 'posts.user_id', '=', 'users.id')
->join('comments', 'comments.post_id', '=', 'posts.id');
You can use the relationships you've already defined:
User::joinRelationship('posts.comments');
Polymorphic relationships, soft deletes, model scopes, aliases and extra relationship conditions are all handled for you. You can also query relationship existence using joins and sort results by columns or aggregations from related tables:
// Query relationship existence using joins instead of where exists
User::powerJoinHas('posts');
// Order by a related column
User::orderByPowerJoins('profile.city');
// Order by an aggregation on a related table
Post::orderByPowerJoinsCount('comments.id', 'desc');
Documentation
You'll find the full documentation on our documentation site.
You can also read a more detailed explanation of the problems this package solves in this blog post.
Installation
You can install the package via composer:
composer require kirschbaum-development/eloquent-power-joins
Testing
composer test
Changelog
Please see CHANGELOG for more information on what has changed recently.
Contributing
Please see CONTRIBUTING for details.
Security
If you discover any security related issues, please email security@kirschbaumdevelopment.com instead of using the issue tracker.
Credits
Sponsorship
Development of this package is sponsored by Kirschbaum Development Group, a developer driven company focused on problem solving, team building, and community. Learn more about us or join us!
License
The MIT License (MIT). Please see License File for more information.
