datalogix / laravel-builder-macros
A set of useful Laravel builder macros.
v3.1.0
2024-04-26 13:32 UTC
Requires
- php: ^7.4|^8.0
- illuminate/database: ^8.0|^9.0|^10.0|^11.0
- illuminate/support: ^8.0|^9.0|^10.0|^11.0
Requires (Dev)
- graham-campbell/testbench: ^6.1
- mockery/mockery: ^1.6
- phpunit/phpunit: ^9.5|^10.5
README
A set of useful Laravel builder macros.
Installation
You can install the package via composer:
composer require datalogix/laravel-builder-macros
The package will automatically register itself.
Macros
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');
filter
Filter in your models.
$query->filter(['name' => 'john'])->get(); // Returns all results where name includes `john`
You can also supply an array of columns to filter in:
$query->filter(['name' => 'john', 'contact.email' => '@'])->get(); // Returns all results where name includes `john` or contact.email includes `@`
You can use $request->all()
:
$query->filter($request->all())->get();
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`
$query->whereLike('title', 'john', false)->get(); // Returns all results where title ends with `john`
$query->whereLike('title', 'john', true, false)->get(); // Returns all results where title starts with `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`