README

This library extends the EntityRepository to add search functionality with a lot of filters.

$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:

$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 :

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

How to use

Install using composer

composer require saf/doctrine-orm-searchable-repository

And just make your repository class extends SAF\SearchableRepository\SearchableRepository.

use SAF\SearchableRepository\SearchableRepository;

class MyRepository extends  SearchableRepository
{
    // ...
}

Then you can access the search method on your repository.

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.

// 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