The signifly/laravel-builder-macros
package allows you to easily add a set of useful builder macros to your Laravel app.
You can install the package via composer:
composer require signifly/laravel-builder-macros
The package will automatically register itself.
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
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');
A query way to join relations.
// Params: $relationName, $operator
$query->joinRelation('contact');
A query to left join relations.
// Params: $relationName, $operator
$query->leftJoinRelation('contact');
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
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`
composer test
If you discover any security issues, please email [email protected] instead of using the issue tracker.
The MIT License (MIT). Please see License File for more information.