saf/doctrine-orm-searchable-repository

Make your Doctrine's EntityRepository Searchable

doctrine-orm-searchable-repository

This library extends the EntityRepository to add search functionality with a lot of filters., _(*1)

$filters = [
    'name'        => ['neq' => 'My name'],
    'author.name' => ['in' => ['Foo', 'Bar']],
    'rating'      => ['gte' => 4],
];

$orders = [
    'author.name' => 'ASC',
    'name'        => 'DESC',
];

$entities = $repository->search($filters, $orders);

You can even perform search of a value on multiple columns:, _(*2)

$filters = [
    'name' => [
        'field'     => ['firstName', 'lastName],
        'condition' => 'like',
        'value'     => '%Lewis%',
    ],
];

$orders = [
    'author.name' => 'ASC',
    'name'        => 'DESC',
];

$entities = $repository->search($filters, $orders);

This will result in the following condition :, _(*3)

firstName like '%Lewis%' OR lastName like '%Lewis%'

How to use

Install using composer, _(*4)

composer require saf/doctrine-orm-searchable-repository

And just make your repository class extends SAF\SearchableRepository\SearchableRepository., _(*5)

use SAF\SearchableRepository\SearchableRepository;

class MyRepository extends  SearchableRepository
{
    // ...
}

Then you can access the search method on your repository., _(*6)

Filters

This library use filter types to handle how to apply filter condition and ordering. It comes with a GenericType that is the default one but you can add a new filter type., _(*7)

// add a new type handler to your search with the setType function
// the first parameter correspond to the doctrine type
// the second parameter is the filter type (that must implements \SAF\SearchableRepository\SearchableRepository\Types\TypeInterface interface)
$repository->setType('string', new MyStringFilterType());

GenericType