This Symfony bundle aims to provide structurized filtering and sorting with usage of the specification pattern (see doctrine-specification). It was design to use in the api applications but it could be also used with standard web apps.
FilterQueryManager
- it collects allfilter services
and gives you queryBuilder with applied specifications.FilterParamConverter
- providefilter object
by the data in query stringSortParamConverter
- providesort object
by the data in query string
composer require bartlomiejbeta/filter-sorter-bundle
public function registerBundles()
{
$bundles = array(
// ...
new BartB\FilterSorterBundle\FilterSorterBundle(),
);
}
I assume that you already have entities, and so one.
example:
class CarRepository extends AbstractEntitySpecificationAwareRepository
{
}
2. Add specifications (example)
3. Add Collection filter (example)
4. Add Sort Enum (example)
5. Build and register your first service adapter (adapter example, register adapter example)
5. Run (standard, api with paramConverters)
$carCollectionFilter = (new CarCollectionFilter())->setGearboxType('automatic');
$carSorter = new CarSort(CarSort::FUEL_TYPE);
$sortDirection = new SortDirectionType(SortDirectionType::DESC);
/** @var FilterQueryManager $filterQueryManager */
$filterQueryManager = $this->filterQueryManager;
$carRepository = $this->repostioryCar;
$sort = new Sort($sortDirection, $carSorter);
$limit = new Limit(1);
$basicRepositoryDTO = new BasicRepositoryDTO($carRepository);
$queryAttributesDTO = new QueryAttributesDTO($carCollectionFilter, $sort, $limit);
$queryBuilder = $filterQueryManager->getQueryBuilder($basicRepositoryDTO, $queryAttributesDTO);
$query = $queryBuilder->getQuery();
$result = $query->execute();
TODO: Upgrade example to symfony 3.4 Also I prepared full stand alone example