DevMakerLab/Laravel-Filters
Need some filters? This package is based on the Repository Design Pattern to let you create specific queries easily.
Installation
composer require devmakerlab/laravel-filters
Usage
This package offers an abstract class AbstractFilterableRepository which needs to be extended to implement the features of this package.
PeopleRepository.php
<?php
declare(strict_types=1);
use DevMakerLab\LaravelFilters\AbstractFilterableRepository;
class PeopleRepository extends AbstractFilterableRepository
{
private DatabaseManager $databaseManager;
public function __construct(DatabaseManager $databaseManager)
{
$this->databaseManager = $databaseManager;
}
public function get(array $args): array
{
$queryBuilder = $this->databaseManager->table('people')
->select(['firstname', 'lastname', 'age', 'gender']);
$this->applyFilters($queryBuilder, $args);
$people = $queryBuilder->get();
return $this->transform($people);
}
public function transform(Collection $people): array
{
$people->transform(function ($person) {
return [
'name' => sprintf('%s %s', $person->lastname, $person->firstname),
'age' => $person->age,
'gender' => $person->gender,
];
});
return $people->toArray();
}
}
PeopleService.php
<?php
...
$peopleRepository = new PeopleRepository($databaseManager);
$people = $peopleRepository
->addFilter(OldPeopleFilter::class)
->get(['age' => 60]);
OldPeopleFilter.php
<?php
declare(strict_types=1);
use Illuminate\Database\Query\Builder;
use DevMakerLab\LaravelFilters\AbstractFilter;
class OldPeopleFilter extends AbstractFilter
{
public int $age;
public function apply(Builder $queryBuilder): void
{
$queryBuilder->where('age', '>=', $this->age);
}
}
Example
Usage Example of DevMakerLab/Laravel-Filters package.
3 Jan 1, 2022
175 Nov 22, 2022
45 Jan 2, 2023
4 Jun 11, 2022
2 Dec 4, 2022
40 Jan 3, 2023
59 Sep 25, 2022
15 Nov 20, 2022
4 Mar 29, 2022
423 Dec 20, 2022
11 Aug 15, 2022
2 Sep 25, 2022
6 Dec 30, 2022
6 Dec 21, 2022
26 Dec 21, 2022
10 Nov 20, 2022
2 Jan 25, 2022
1 Nov 22, 2021
9 Jul 26, 2022