laravel-builder-macros
laravel-builder-macros copied to clipboard
A set of useful macros for your Eloquent Builder.
A set of useful Laravel builder macros
The signifly/laravel-builder-macros
package allows you to easily add a set of useful builder macros to your Laravel app.
Installation
You can install the package via composer:
composer require signifly/laravel-builder-macros
The package will automatically register itself.
Macros
-
addSubSelect
-
defaultSelectAll
-
joinRelation
-
leftJoinRelation
-
map
-
whereLike
addSubSelect
Add a select sub query.
// Params: $column, $query
$query->addSubSelect('primary_address_id',
Address::select('id')
->where('user_id', $user->id)
->primary()
);
// It adds primary_address_id to the result set
defaultSelectAll
It selects all columns from the query. Useful for queries with joins and additional selects.
$query->defaultSelectAll()
->join('contacts', 'users.id', '=', 'contacts.user_id')
->addSelect('contacts.name as contact_name');
joinRelation
A query way to join relations.
// Params: $relationName, $operator
$query->joinRelation('contact');
leftJoinRelation
A query to left join relations.
// Params: $relationName, $operator
$query->leftJoinRelation('contact');
map
A direct method to retrieve the results and map it.
$userIds = $query->where('user_id', 10)->map(function ($user) {
return $user->id;
});
// Returns a collection
whereLike
Search in your models with the LIKE
operator.
$query->whereLike('title', 'john')->get();
// Returns all results where title includes `john`
You can also supply an array of columns to search in:
$query->whereLike(['title', 'contact.name'], 'john')->get();
// Returns all results where title or contact.name includes `john`
Testing
composer test
Security
If you discover any security issues, please email [email protected] instead of using the issue tracker.
Credits
- Morten Poul Jensen
- All contributors
License
The MIT License (MIT). Please see License File for more information.