BaseRepository::paginateResults() - Code Metrics - Inspection of "[wip] - introduce new config provider" - studiomado/query-bundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#61)

by Simone

created 2017-11-24 08:12 UTC

BaseRepository::paginateResults() B

↳ Parent: BaseRepository

Complexity

Conditions	3
Paths	2

Size

Total Lines	28
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	12

Importance

Changes

Metric	Value
cc	3
eloc	15
nc	2
nop	1
dl	0
loc	28
ccs	0
cts	15
cp	0
crap	12
rs	8.8571
c	0
b	0
f	0

<?php

namespace Mado\QueryBundle\Repositories;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\QueryBuilder;
use Hateoas\Configuration\Route;
filter:
    dependency_paths: ["lib/*"]
use Hateoas\Representation\Factory\PagerfantaFactory;
filter:
    dependency_paths: ["lib/*"]
use Mado\QueryBundle\Component\ConfigProvider;
use Mado\QueryBundle\Queries\QueryBuilderFactory;
use Mado\QueryBundle\Queries\QueryBuilderOptions;
use Pagerfanta\Adapter\DoctrineORMAdapter;
filter:
    dependency_paths: ["lib/*"]
use Pagerfanta\Pagerfanta;
filter:
    dependency_paths: ["lib/*"]
use Symfony\Component\HttpFoundation\Request;

class BaseRepository extends EntityRepository
{
    protected $fields;

    protected $request;

    protected $use_result_cache = false;

    protected $entityAlias;

    protected $route_name;

    protected $currentEntityAlias;

    protected $embeddedFields;

    protected $joins = [];

    protected $queryBuilderFactory;

    protected $queryOptions;

    protected $configProvider;

    public function __construct($manager, $class)
    {
        parent::__construct($manager, $class);

        $this->fields = array_keys($this->getClassMetadata()->fieldMappings);

        $entityName = explode('\\', strtolower($this->getEntityName()) );
        $entityName = $entityName[count($entityName)-1];
        //$entityAlias = $entityName[0];
        $this->entityAlias = $entityName;

        $this->queryBuilderFactory = new QueryBuilderFactory($this->getEntityManager());
    }

    public function initFromQueryBuilderOptions(QueryBuilderOptions $options)
    {
        $this->queryBuilderFactory->createQueryBuilder($this->getEntityName(), $this->entityAlias);

        $fieldMappings = $this->getClassMetadata()->fieldMappings;
        $this->fields = array_keys($fieldMappings);

        $this->queryBuilderFactory->setFields($this->fields ?? []);
        $this->queryBuilderFactory->setFilters($options->getFilters());
        $this->queryBuilderFactory->setOrFilters($options->getOrFilters());
        $this->queryBuilderFactory->setSorting($options->getSorting());
        $this->queryBuilderFactory->setRel($options->getRel());
        $this->queryBuilderFactory->setPrinting($options->getPrinting());
        $this->queryBuilderFactory->setSelect($options->getSelect());
    }

    public function getQueryBuilderFactory()
    {
        $this->ensureQueryOptionIsDefined();

        $this->initFromQueryBuilderOptions($this->queryOptions);

        return $this->queryBuilderFactory;
    }

    public function useResultCache($bool)
    {
        $this->use_result_cache = $bool;
    }

    public function setRequest(Request $request)
    {
        return $this->setQueryOptionsFromRequest($request);
    }

    public function setRequestWithFilter(Request $request, $filter)
    {
        return $this->setQueryOptionsFromRequestWithCustomFilter($request, $filter);
    }

    public function setRequestWithOrFilter(Request $request, $orFilter)
    {
        return $this->setQueryOptionsFromRequestWithCustomOrFilter($request, $orFilter);
    }

    public function setQueryOptions(QueryBuilderOptions $options)
    {
        $this->queryOptions = $options;
    }

    public function setQueryOptionsFromRequest(Request $request = null)
    {
        $requestAttributes = [];
        foreach ($request->attributes->all() as $attributeName => $attributeValue) {
            $requestAttributes[$attributeName] = $request->attributes->get(
                $attributeName,
                $attributeValue
            );
        }

        $filters     = $request->query->get('filtering', []);
        $orFilters   = $request->query->get('filtering_or', []);
        $sorting     = $request->query->get('sorting', []);
        $printing    = $request->query->get('printing', []);
        $rel         = $request->query->get('rel', '');
        $page        = $request->query->get('page', '');
        $select      = $request->query->get('select', $this->entityAlias);
        $pageLength  = $request->query->get('limit', 666);

        $filtering   = $request->query->get('filtering', '');
        $limit       = $request->query->get('limit', '');

        $filterOrCorrected = [];

        $count = 0;
        foreach ($orFilters as $key => $filter) {
            if (is_array($filter)) {
                foreach ($filter as $keyInternal => $internal) {
                    $filterOrCorrected[$keyInternal .'|' . $count] = $internal;
                    $count = $count + 1;
                }
            } else {
                $filterOrCorrected[$key] = $filter;
            }
        }

        $requestProperties = [
            'filtering'   => $filtering,
            'orFiltering' => $filterOrCorrected,
            'limit'       => $limit,
            'page'        => $page,
            'filters'     => $filters,
            'orFilters'   => $filterOrCorrected,
            'sorting'     => $sorting,
            'rel'         => $rel,
            'printing'    => $printing,
            'select'      => $select,
        ];

        $options = array_merge(
            $requestAttributes,
            $requestProperties
        );

        $this->queryOptions = QueryBuilderOptions::fromArray($options);

        return $this;
    }

    public function setQueryOptionsFromRequestWithCustomFilter(Request $request = null, $filter)

    {
        $filters = $request->query->get('filtering', []);
        $orFilters = $request->query->get('filtering_or', []);
        $sorting = $request->query->get('sorting', []);
        $printing = $request->query->get('printing', []);
        $rel = $request->query->get('rel', '');
        $page = $request->query->get('page', '');
        $select = $request->query->get('select', $this->entityAlias);
        $pageLength = $request->query->get('limit', 666);

        $filtering = $request->query->get('filtering', '');
        $limit = $request->query->get('limit', '');

        $filters = array_merge($filters, $filter);

        $filterOrCorrected = [];

        $count = 0;
        foreach ($orFilters as $key => $filter) {
            if (is_array($filter)) {
                foreach ($filter as $keyInternal => $internal) {
                    $filterOrCorrected[$keyInternal .'|' . $count] = $internal;
                    $count = $count + 1;
                }
            } else {
                $filterOrCorrected[$key] = $filter;
            }
        }

        $this->queryOptions = QueryBuilderOptions::fromArray([
            '_route' => $request->attributes->get('_route'),
            'customer_id' => $request->attributes->get('customer_id'),
            'id' => $request->attributes->get('id'),
            'filtering' => $filtering,
            'limit' => $limit,
            'page' => $page,
            'filters' => $filters,
            'orFilters' => $filterOrCorrected,
            'sorting' => $sorting,
            'rel' => $rel,
            'printing' => $printing,
            'select' => $select,
        ]);

        return $this;
    }

    public function setQueryOptionsFromRequestWithCustomOrFilter(Request $request = null, $orFilter)

    {
        $filters = $request->query->get('filtering', []);
        $orFilters = $request->query->get('filtering_or', []);
        $sorting = $request->query->get('sorting', []);
        $printing = $request->query->get('printing', []);
        $rel = $request->query->get('rel', '');
        $page = $request->query->get('page', '');
        $select = $request->query->get('select', $this->entityAlias);
        $pageLength = $request->query->get('limit', 666);

        $filtering = $request->query->get('filtering', '');
        $limit = $request->query->get('limit', '');

        $orFilters = array_merge($orFilters, $orFilter);

        $filterOrCorrected = [];

        $count = 0;
        foreach ($orFilters as $key => $filter) {
            if (is_array($filter)) {
                foreach ($filter as $keyInternal => $internal) {
                    $filterOrCorrected[$keyInternal .'|' . $count] = $internal;
                    $count = $count + 1;
                }
            } else {
                $filterOrCorrected[$key] = $filter;
            }
        }

        $this->queryOptions = QueryBuilderOptions::fromArray([
            '_route' => $request->attributes->get('_route'),
            'customer_id' => $request->attributes->get('customer_id'),
            'id' => $request->attributes->get('id'),
            'filtering' => $filtering,
            'limit' => $limit,
            'page' => $page,
            'filters' => $filters,
            'orFilters' => $filterOrCorrected,
            'sorting' => $sorting,
            'rel' => $rel,
            'printing' => $printing,
            'select' => $select,
        ]);

        return $this;
    }

    public function getRequest()
    {
        return $this->request;
    }

    public function setRouteName($route_name = '')
    {
        $this->route_name = $route_name;
        return $this;
    }

    public function findAllPaginated()
    {
        if ($this->configProvider) {
            $this->setRequest($this->configProvider->getRequest());
            $this->queryBuilderFactory->setConfigProvider($this->configProvider);
        }

        $this->ensureQueryOptionIsDefined();

        $this->initFromQueryBuilderOptions($this->queryOptions);

        $this->queryBuilderFactory->filter();
        $this->queryBuilderFactory->sort();

        $qb = $this->queryBuilderFactory->getQueryBuilder();

        if ($this->configProvider) {
            $qb = $this->configProvider->filterRelation($qb);
        }

        return $this->paginateResults($qb);
    }

    protected function paginateResults(
        \Doctrine\ORM\QueryBuilder $queryBuilder
    ) {
        $this->ensureQueryOptionIsDefined();

        $limit = $this->queryOptions->get('limit', 10);
        $page = $this->queryOptions->get('page', 1);


        $pagerAdapter = new DoctrineORMAdapter($queryBuilder);

        $query = $pagerAdapter->getQuery();
        if(isset($this->use_result_cache) and $this->use_result_cache){
            $query->useResultCache(true, 600);
        }

        $pager = new Pagerfanta($pagerAdapter);
        $pager->setNormalizeOutOfRangePages(true);
        $pager->setMaxPerPage($limit);
        $pager->setCurrentPage($page);

        $pagerFactory = new PagerfantaFactory();

        $router = $this->createRouter();

        $results = $pagerFactory->createRepresentation($pager, $router);

        return $results;
    }

    protected function customQueryStringValues()
    {
        return [];
    }

    protected function createRouter()
    {
        $request = $this->getRequest();

        $params = [];

        $list = array_merge([
            'filtering',
            'limit',
            'page',
            'sorting',
        ], $this->customQueryStringValues());

        $this->ensureQueryOptionIsDefined();

        foreach ($list as $itemKey => $itemValue) {
            $params[$itemValue] = $this->queryOptions->get($itemValue);
        }

        if(!isset($this->route_name)){
            $this->route_name = $this->queryOptions->get('_route');
        }

        return new Route($this->route_name, $params);
    }

    protected function getCurrentEntityAlias() : string
    {
        return $this->currentEntityAlias;
    }

    protected function setCurrentEntityAlias(string $currentEntityAlias) 
    {
        $this->currentEntityAlias = $currentEntityAlias;
    }

    protected function getEmbeddedFields() : array
    {
        return $this->embeddedFields;
    }

    protected function setEmbeddedFields(array $embeddedFields) 
    {
        $this->embeddedFields = $embeddedFields;
    }

    public function getEntityAlias(string $entityName) : string
    {
        $arrayEntityName = explode('\\', strtolower($entityName) );
        return $arrayEntityName[count($arrayEntityName)-1];
    }

    protected function relationship($queryBuilder)
    {
        return $queryBuilder;
    }

    public function getQueryBuilderFactoryWithoutInitialization()
    {
        return $this->queryBuilderFactory;
    }

    public function setConfigProvider(ConfigProvider $provider, array $domainConfiguration = [])
    {
        $this->configProvider = $provider;
        $this->configProvider->setDomainConfiguration($domainConfiguration);

        return $this;
    }

    public function ensureQueryOptionIsDefined()
    {
        if (!$this->queryOptions) {
            throw new \RuntimeException(
                'Oops! QueryBuilderOptions was never defined.'
            );
        }
    }
}


1			<?php
2
3			namespace Mado\QueryBundle\Repositories;
4
5			use Doctrine\ORM\EntityRepository;
6			use Doctrine\ORM\QueryBuilder;
7			use Hateoas\Configuration\Route;
			0 ignored issues – show Bug introduced 2017-08-29 10:25 UTC by Report Bug Copy Issue Report The type `Hateoas\Configuration\Route` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
8			use Hateoas\Representation\Factory\PagerfantaFactory;
			0 ignored issues – show Bug introduced 2017-08-29 10:25 UTC by Report Bug Copy Issue Report The type `Hateoas\Representation\Factory\PagerfantaFactory` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
9			use Mado\QueryBundle\Component\ConfigProvider;
10			use Mado\QueryBundle\Queries\QueryBuilderFactory;
11			use Mado\QueryBundle\Queries\QueryBuilderOptions;
12			use Pagerfanta\Adapter\DoctrineORMAdapter;
			0 ignored issues – show Bug introduced 2017-08-29 10:25 UTC by Report Bug Copy Issue Report The type `Pagerfanta\Adapter\DoctrineORMAdapter` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
13			use Pagerfanta\Pagerfanta;
			0 ignored issues – show Bug introduced 2017-11-22 22:57 UTC by Report Bug Copy Issue Report The type `Pagerfanta\Pagerfanta` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
14			use Symfony\Component\HttpFoundation\Request;
15
16			class BaseRepository extends EntityRepository
17			{
18			protected $fields;
19
20			protected $request;
21
22			protected $use_result_cache = false;
23
24			protected $entityAlias;
25
26			protected $route_name;
27
28			protected $currentEntityAlias;
29
30			protected $embeddedFields;
31
32			protected $joins = [];
33
34			protected $queryBuilderFactory;
35
36	5		protected $queryOptions;
37
38	5		protected $configProvider;
39
40	5		public function __construct($manager, $class)
41			{
42	5		parent::__construct($manager, $class);
43	5
44	5		$this->fields = array_keys($this->getClassMetadata()->fieldMappings);
45	5
46			$entityName = explode('\\', strtolower($this->getEntityName()) );
47	5		$entityName = $entityName[count($entityName)-1];
48	5		//$entityAlias = $entityName[0];
49			$this->entityAlias = $entityName;
50
51			$this->queryBuilderFactory = new QueryBuilderFactory($this->getEntityManager());
52			}
53
54			public function initFromQueryBuilderOptions(QueryBuilderOptions $options)
55			{
56			$this->queryBuilderFactory->createQueryBuilder($this->getEntityName(), $this->entityAlias);
57
58			$fieldMappings = $this->getClassMetadata()->fieldMappings;
59			$this->fields = array_keys($fieldMappings);
60
61			$this->queryBuilderFactory->setFields($this->fields ?? []);
62			$this->queryBuilderFactory->setFilters($options->getFilters());
63			$this->queryBuilderFactory->setOrFilters($options->getOrFilters());
64			$this->queryBuilderFactory->setSorting($options->getSorting());
65			$this->queryBuilderFactory->setRel($options->getRel());
66			$this->queryBuilderFactory->setPrinting($options->getPrinting());
67			$this->queryBuilderFactory->setSelect($options->getSelect());
68			}
69
70			public function getQueryBuilderFactory()
71			{
72			$this->ensureQueryOptionIsDefined();
73
74			$this->initFromQueryBuilderOptions($this->queryOptions);
75
76			return $this->queryBuilderFactory;
77			}
78	1
79			public function useResultCache($bool)
80	1		{
81			$this->use_result_cache = $bool;
82			}
83
84			public function setRequest(Request $request)
85			{
86			return $this->setQueryOptionsFromRequest($request);
87			}
88
89			public function setRequestWithFilter(Request $request, $filter)
90			{
91			return $this->setQueryOptionsFromRequestWithCustomFilter($request, $filter);
92			}
93
94			public function setRequestWithOrFilter(Request $request, $orFilter)
95			{
96			return $this->setQueryOptionsFromRequestWithCustomOrFilter($request, $orFilter);
97			}
98	3
99			public function setQueryOptions(QueryBuilderOptions $options)
100	3		{
101			$this->queryOptions = $options;
102	3		}
103	3
104	3		public function setQueryOptionsFromRequest(Request $request = null)
105	3		{
106	3		$requestAttributes = [];
107	3		foreach ($request->attributes->all() as $attributeName => $attributeValue) {
108	3		$requestAttributes[$attributeName] = $request->attributes->get(
109	3		$attributeName,
110	3		$attributeValue
111			);
112	3		}
113
114	3		$filters = $request->query->get('filtering', []);
115	3		$orFilters = $request->query->get('filtering_or', []);
116			$sorting = $request->query->get('sorting', []);
117			$printing = $request->query->get('printing', []);
118			$rel = $request->query->get('rel', '');
119			$page = $request->query->get('page', '');
120			$select = $request->query->get('select', $this->entityAlias);
121			$pageLength = $request->query->get('limit', 666);
			0 ignored issues – show Unused Code introduced 2017-08-29 10:25 UTC by Report Bug Copy Issue Report The assignment to `$pageLength` is dead and can be removed. Loading history...
122			$filtering = $request->query->get('filtering', '');
123			$limit = $request->query->get('limit', '');
124
125			$filterOrCorrected = [];
126
127	3		$count = 0;
128	3		foreach ($orFilters as $key => $filter) {
129	3		if (is_array($filter)) {
130	3		foreach ($filter as $keyInternal => $internal) {
131	3		$filterOrCorrected[$keyInternal .'\|' . $count] = $internal;
132	3		$count = $count + 1;
133	3		}
134	3		} else {
135	3		$filterOrCorrected[$key] = $filter;
136	3		}
137			}
138
139	3		$requestProperties = [
140	3		'filtering' => $filtering,
141	3		'orFiltering' => $filterOrCorrected,
142			'limit' => $limit,
143			'page' => $page,
144	3		'filters' => $filters,
145			'orFilters' => $filterOrCorrected,
146	3		'sorting' => $sorting,
147			'rel' => $rel,
148			'printing' => $printing,
149	4		'select' => $select,
150			];
151	4
152			$options = array_merge(
153	4		$requestAttributes,
154			$requestProperties
155			);
156
157			$this->queryOptions = QueryBuilderOptions::fromArray($options);
158
159			return $this;
160	4		}
161
162		View Code Duplication	public function setQueryOptionsFromRequestWithCustomFilter(Request $request = null, $filter)
			0 ignored issues – show Duplication introduced 2017-08-29 10:25 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
163			{
164			$filters = $request->query->get('filtering', []);
165			$orFilters = $request->query->get('filtering_or', []);
166			$sorting = $request->query->get('sorting', []);
167			$printing = $request->query->get('printing', []);
168			$rel = $request->query->get('rel', '');
169			$page = $request->query->get('page', '');
170			$select = $request->query->get('select', $this->entityAlias);
171			$pageLength = $request->query->get('limit', 666);
			0 ignored issues – show Unused Code introduced 2017-08-29 10:25 UTC by Report Bug Copy Issue Report The assignment to `$pageLength` is dead and can be removed. Loading history...
172			$filtering = $request->query->get('filtering', '');
173			$limit = $request->query->get('limit', '');
174
175			$filters = array_merge($filters, $filter);
176
177			$filterOrCorrected = [];
178
179			$count = 0;
180			foreach ($orFilters as $key => $filter) {
181			if (is_array($filter)) {
182			foreach ($filter as $keyInternal => $internal) {
183			$filterOrCorrected[$keyInternal .'\|' . $count] = $internal;
184			$count = $count + 1;
185			}
186			} else {
187			$filterOrCorrected[$key] = $filter;
188			}
189			}
190
191			$this->queryOptions = QueryBuilderOptions::fromArray([
192			'_route' => $request->attributes->get('_route'),
193			'customer_id' => $request->attributes->get('customer_id'),
194			'id' => $request->attributes->get('id'),
195			'filtering' => $filtering,
196			'limit' => $limit,
197			'page' => $page,
198			'filters' => $filters,
199			'orFilters' => $filterOrCorrected,
200			'sorting' => $sorting,
201			'rel' => $rel,
202			'printing' => $printing,
203			'select' => $select,
204			]);
205
206			return $this;
207			}
208
209		View Code Duplication	public function setQueryOptionsFromRequestWithCustomOrFilter(Request $request = null, $orFilter)
			0 ignored issues – show Duplication introduced 2017-08-29 10:25 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
210			{
211			$filters = $request->query->get('filtering', []);
212			$orFilters = $request->query->get('filtering_or', []);
213			$sorting = $request->query->get('sorting', []);
214			$printing = $request->query->get('printing', []);
215			$rel = $request->query->get('rel', '');
216			$page = $request->query->get('page', '');
217			$select = $request->query->get('select', $this->entityAlias);
218	1		$pageLength = $request->query->get('limit', 666);
			0 ignored issues – show Unused Code introduced 2017-08-29 10:25 UTC by Report Bug Copy Issue Report The assignment to `$pageLength` is dead and can be removed. Loading history...
219			$filtering = $request->query->get('filtering', '');
220	1		$limit = $request->query->get('limit', '');
221
222	1		$orFilters = array_merge($orFilters, $orFilter);
223	1
224	1		$filterOrCorrected = [];
225	1
226	1		$count = 0;
227	1		foreach ($orFilters as $key => $filter) {
228	1		if (is_array($filter)) {
229	1		foreach ($filter as $keyInternal => $internal) {
230	1		$filterOrCorrected[$keyInternal .'\|' . $count] = $internal;
231			$count = $count + 1;
232	1		}
233			} else {
234	1		$filterOrCorrected[$key] = $filter;
235			}
236	1		}
237	1
238			$this->queryOptions = QueryBuilderOptions::fromArray([
239			'_route' => $request->attributes->get('_route'),
240			'customer_id' => $request->attributes->get('customer_id'),
241			'id' => $request->attributes->get('id'),
242			'filtering' => $filtering,
243			'limit' => $limit,
244			'page' => $page,
245			'filters' => $filters,
246			'orFilters' => $filterOrCorrected,
247			'sorting' => $sorting,
248			'rel' => $rel,
249	1		'printing' => $printing,
250	1		'select' => $select,
251	1		]);
252	1
253	1		return $this;
254	1		}
255	1
256	1		public function getRequest()
257	1		{
258	1		return $this->request;
259	1		}
260	1
261			public function setRouteName($route_name = '')
262			{
263	1		$this->route_name = $route_name;
264	1		return $this;
265	1		}
266
267			public function findAllPaginated()
268	1		{
269			if ($this->configProvider) {
270	1		$this->setRequest($this->configProvider->getRequest());
271			$this->queryBuilderFactory->setConfigProvider($this->configProvider);
272			}
273	4
274			$this->ensureQueryOptionIsDefined();
275	4
276			$this->initFromQueryBuilderOptions($this->queryOptions);
277
278			$this->queryBuilderFactory->filter();
279			$this->queryBuilderFactory->sort();
280
281			$qb = $this->queryBuilderFactory->getQueryBuilder();
282
283			if ($this->configProvider) {
284			$qb = $this->configProvider->filterRelation($qb);
285			}
286
287			return $this->paginateResults($qb);
288			}
289
290			protected function paginateResults(
291			\Doctrine\ORM\QueryBuilder $queryBuilder
292			) {
293			$this->ensureQueryOptionIsDefined();
294
295			$limit = $this->queryOptions->get('limit', 10);
296			$page = $this->queryOptions->get('page', 1);
297
298
299			$pagerAdapter = new DoctrineORMAdapter($queryBuilder);
300
301			$query = $pagerAdapter->getQuery();
302			if(isset($this->use_result_cache) and $this->use_result_cache){
303			$query->useResultCache(true, 600);
304			}
305
306			$pager = new Pagerfanta($pagerAdapter);
307			$pager->setNormalizeOutOfRangePages(true);
308			$pager->setMaxPerPage($limit);
309			$pager->setCurrentPage($page);
310
311			$pagerFactory = new PagerfantaFactory();
312
313			$router = $this->createRouter();
314
315			$results = $pagerFactory->createRepresentation($pager, $router);
316
317			return $results;
318			}
319
320			protected function customQueryStringValues()
321			{
322			return [];
323			}
324
325			protected function createRouter()
326			{
327			$request = $this->getRequest();
			0 ignored issues – show Unused Code introduced 2017-08-29 10:25 UTC by Report Bug Copy Issue Report The assignment to `$request` is dead and can be removed. Loading history...
328			$params = [];
329
330			$list = array_merge([
331			'filtering',
332			'limit',
333			'page',
334			'sorting',
335			], $this->customQueryStringValues());
336
337			$this->ensureQueryOptionIsDefined();
338
339			foreach ($list as $itemKey => $itemValue) {
340			$params[$itemValue] = $this->queryOptions->get($itemValue);
341			}
342
343			if(!isset($this->route_name)){
344			$this->route_name = $this->queryOptions->get('_route');
345			}
346
347			return new Route($this->route_name, $params);
348			}
349
350			protected function getCurrentEntityAlias() : string
351			{
352			return $this->currentEntityAlias;
353			}
354
355			protected function setCurrentEntityAlias(string $currentEntityAlias)
356			{
357			$this->currentEntityAlias = $currentEntityAlias;
358			}
359
360			protected function getEmbeddedFields() : array
361			{
362			return $this->embeddedFields;
363			}
364
365			protected function setEmbeddedFields(array $embeddedFields)
366			{
367			$this->embeddedFields = $embeddedFields;
368			}
369
370			public function getEntityAlias(string $entityName) : string
371			{
372			$arrayEntityName = explode('\\', strtolower($entityName) );
373			return $arrayEntityName[count($arrayEntityName)-1];
374			}
375
376			protected function relationship($queryBuilder)
377			{
378			return $queryBuilder;
379			}
380
381			public function getQueryBuilderFactoryWithoutInitialization()
382			{
383			return $this->queryBuilderFactory;
384			}
385
386			public function setConfigProvider(ConfigProvider $provider, array $domainConfiguration = [])
387			{
388			$this->configProvider = $provider;
389			$this->configProvider->setDomainConfiguration($domainConfiguration);
390
391			return $this;
392			}
393
394			public function ensureQueryOptionIsDefined()
395			{
396			if (!$this->queryOptions) {
397			throw new \RuntimeException(
398			'Oops! QueryBuilderOptions was never defined.'
399			);
400			}
401			}
402			}
403

studiomado / query-bundle

GitHub Access Token became invalid

Pull Request — master (#61)

BaseRepository::paginateResults() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like