DoctrineCollectionDataSource::limit() - Code Metrics - ublaboo/datagrid - Measure and Improve Code Quality continuously with Scrutinizer

DoctrineCollectionDataSource::limit() A
last analyzed 2018-05-01 21:27 UTC

↳ Parent: DoctrineCollectionDataSource

Complexity

Conditions	1
Paths	1

Size

Total Lines	6
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	6
rs	9.4285
c	0
b	0
f	0
cc	1
eloc	3
nc	1
nop	2

<?php

/**
 * @copyright   Copyright (c) 2015 ublaboo <[email protected]>
 * @author      Martin Procházka <[email protected]>
 * @package     Ublaboo
 */

namespace Ublaboo\DataGrid\DataSource;

use Doctrine\Common\Collections\Collection;
use Doctrine\Common\Collections\Criteria;
use Ublaboo\DataGrid\AggregationFunction\IAggregatable;
use Ublaboo\DataGrid\Filter;
use Ublaboo\DataGrid\Utils\DateTimeHelper;
use Ublaboo\DataGrid\Utils\Sorting;

final class DoctrineCollectionDataSource extends FilterableDataSource implements IDataSource, IAggregatable
{

	/**
	 * @var Collection
	 */
	private $data_source;

	/**
	 * @var string
	 */
	private $primary_key;

	/**
	 * @var Criteria
	 */
	private $criteria;


	/**
	 * @param Collection  $collection
	 * @param string      $primary_key
	 */
	public function __construct(Collection $collection, $primary_key)
	{
		$this->criteria = Criteria::create();
		$this->data_source = $collection;
		$this->primary_key = $primary_key;
	}


	/**
	 * @return Collection
	 */
	private function getFilteredCollection()
	{
		return $this->data_source->matching($this->criteria);
	}


	/********************************************************************************
	 *                          IDataSource implementation                          *
	 ********************************************************************************/


	/**
	 * Get count of data
	 * @return int
	 */
	public function getCount()
	{
		return $this->getFilteredCollection()->count();
	}


	/**
	 * Get the data
	 * @return array
	 */
	public function getData()
	{
		return $this->getFilteredCollection()->toArray();
	}


	/**
	 * Filter data - get one row
	 * @param array $condition
	 * @return static
	 */
	public function filterOne(array $condition)
	{
		foreach ($condition as $column => $value) {
			$expr = Criteria::expr()->eq($column, $value);
			$this->criteria->andWhere($expr);
		}

		return $this;
	}


	/**
	 * Filter by date
	 * @param  Filter\FilterDate $filter
	 * @return void
	 */
	public function applyFilterDate(Filter\FilterDate $filter)
	{
		foreach ($filter->getCondition() as $column => $value) {
			$date = DateTimeHelper::tryConvertToDateTime($value, [$filter->getPhpFormat()]);

			$from = Criteria::expr()->gte($filter->getColumn(), $date->format('Y-m-d 00:00:00'));
			$to = Criteria::expr()->lte($filter->getColumn(), $date->format('Y-m-d 23:59:59'));

			$this->criteria->andWhere($from)->andWhere($to);
		}
	}


	/**
	 * Filter by date range
	 * @param  Filter\FilterDateRange $filter
	 * @return void
	 */
	public function applyFilterDateRange(Filter\FilterDateRange $filter)
	{
		$conditions = $filter->getCondition();
		$values = $conditions[$filter->getColumn()];

		if ($value_from = $values['from']) {

			$date_from = DateTimeHelper::tryConvertToDateTime($value_from, [$filter->getPhpFormat()]);
			$date_from->setTime(0, 0, 0);

			$expr = Criteria::expr()->gte($filter->getColumn(), $date_from->format('Y-m-d H:i:s'));
			$this->criteria->andWhere($expr);
		}

		if ($value_to = $values['to']) {

			$date_to = DateTimeHelper::tryConvertToDateTime($value_to, [$filter->getPhpFormat()]);
			$date_to->setTime(23, 59, 59);

			$expr = Criteria::expr()->lte($filter->getColumn(), $date_to->format('Y-m-d H:i:s'));
			$this->criteria->andWhere($expr);
		}
	}


	/**
	 * Filter by range
	 * @param  Filter\FilterRange $filter
	 * @return void
	 */
	public function applyFilterRange(Filter\FilterRange $filter)
	{
		$conditions = $filter->getCondition();
		$values = $conditions[$filter->getColumn()];

		if ($value_from = $values['from']) {
			$expr = Criteria::expr()->gte($filter->getColumn(), $value_from);
			$this->criteria->andWhere($expr);
		}

		if ($value_to = $values['to']) {
			$expr = Criteria::expr()->lte($filter->getColumn(), $value_to);
			$this->criteria->andWhere($expr);
		}
	}


	/**
	 * Filter by keyword
	 * @param  Filter\FilterText $filter
	 * @return void
	 */
	public function applyFilterText(Filter\FilterText $filter)
	{
		$exprs = [];

		foreach ($filter->getCondition() as $column => $value) {
			if ($filter->isExactSearch()) {
				$exprs[] = Criteria::expr()->eq($column, $value);
				continue;
			}

			if ($filter->hasSplitWordsSearch() === false) {

				$words = [$value];
			} else {
				$words = explode(' ', $value);
			}

			foreach ($words as $word) {
				$exprs[] = Criteria::expr()->contains($column, $word);
			}
		}

		$expr = call_user_func_array([Criteria::expr(), 'orX'], $exprs);
		$this->criteria->andWhere($expr);
	}


	/**
	 * Filter by multi select value
	 * @param  Filter\FilterMultiSelect $filter
	 * @return void
	 */
	public function applyFilterMultiSelect(Filter\FilterMultiSelect $filter)
	{
		$values = $filter->getCondition()[$filter->getColumn()];

		$expr = Criteria::expr()->in($filter->getColumn(), $values);
		$this->criteria->andWhere($expr);
	}


	/**
	 * Filter by select value
	 * @param  Filter\FilterSelect $filter
	 * @return void
	 */
	public function applyFilterSelect(Filter\FilterSelect $filter)
	{
		foreach ($filter->getCondition() as $column => $value) {
			$expr = Criteria::expr()->eq($column, $value);
			$this->criteria->andWhere($expr);
		}
	}


	/**
	 * Apply limit and offset on data
	 * @param int $offset
	 * @param int $limit
	 * @return static
	 */
	public function limit($offset, $limit)
	{
		$this->criteria->setFirstResult($offset)->setMaxResults($limit);

		return $this;
	}


	/**
	 * Sort data
	 * @param Sorting $sorting
	 * @return static
	 */
	public function sort(Sorting $sorting)
	{
		if (is_callable($sorting->getSortCallback())) {
			call_user_func(
				$sorting->getSortCallback(),
				$this->criteria,
				$sorting->getSort()
			);

			return $this;
		}

		if ($sort = $sorting->getSort()) {
			$this->criteria->orderBy($sort);
			return $this;
		}

		$this->criteria->orderBy([$this->primary_key => 'ASC']);

		return $this;
	}


	/**
	 * @param  callable  $aggregationCallback
	 * @return void
	 */
	public function processAggregation(callable $aggregationCallback)
	{
		call_user_func($aggregationCallback, clone $this->data_source);
	}
}


1		<?php
2
3		/**
4		* @copyright Copyright (c) 2015 ublaboo <[email protected]>
5		* @author Martin Procházka <[email protected]>
6		* @package Ublaboo
7		*/
8
9		namespace Ublaboo\DataGrid\DataSource;
10
11		use Doctrine\Common\Collections\Collection;
12		use Doctrine\Common\Collections\Criteria;
13		use Ublaboo\DataGrid\AggregationFunction\IAggregatable;
14		use Ublaboo\DataGrid\Filter;
15		use Ublaboo\DataGrid\Utils\DateTimeHelper;
16		use Ublaboo\DataGrid\Utils\Sorting;
17
18		final class DoctrineCollectionDataSource extends FilterableDataSource implements IDataSource, IAggregatable
19		{
20
21		/**
22		* @var Collection
23		*/
24		private $data_source;
25
26		/**
27		* @var string
28		*/
29		private $primary_key;
30
31		/**
32		* @var Criteria
33		*/
34		private $criteria;
35
36
37		/**
38		* @param Collection $collection
39		* @param string $primary_key
40		*/
41		public function __construct(Collection $collection, $primary_key)
42		{
43		$this->criteria = Criteria::create();
44		$this->data_source = $collection;
45		$this->primary_key = $primary_key;
46		}
47
48
49		/**
50		* @return Collection
51		*/
52		private function getFilteredCollection()
53		{
54		return $this->data_source->matching($this->criteria);
55		}
56
57
58		/********************************************************************************
59		* IDataSource implementation *
60		********************************************************************************/
61
62
63		/**
64		* Get count of data
65		* @return int
66		*/
67		public function getCount()
68		{
69		return $this->getFilteredCollection()->count();
70		}
71
72
73		/**
74		* Get the data
75		* @return array
76		*/
77		public function getData()
78		{
79		return $this->getFilteredCollection()->toArray();
80		}
81
82
83		/**
84		* Filter data - get one row
85		* @param array $condition
86		* @return static
87		*/
88		public function filterOne(array $condition)
89		{
90		foreach ($condition as $column => $value) {
91		$expr = Criteria::expr()->eq($column, $value);
92		$this->criteria->andWhere($expr);
93		}
94
95		return $this;
96		}
97
98
99		/**
100		* Filter by date
101		* @param Filter\FilterDate $filter
102		* @return void
103		*/
104		public function applyFilterDate(Filter\FilterDate $filter)
105		{
106		foreach ($filter->getCondition() as $column => $value) {
107		$date = DateTimeHelper::tryConvertToDateTime($value, [$filter->getPhpFormat()]);
108
109		$from = Criteria::expr()->gte($filter->getColumn(), $date->format('Y-m-d 00:00:00'));
110		$to = Criteria::expr()->lte($filter->getColumn(), $date->format('Y-m-d 23:59:59'));
111
112		$this->criteria->andWhere($from)->andWhere($to);
113		}
114		}
115
116
117		/**
118		* Filter by date range
119		* @param Filter\FilterDateRange $filter
120		* @return void
121		*/
122		public function applyFilterDateRange(Filter\FilterDateRange $filter)
123		{
124		$conditions = $filter->getCondition();
125		$values = $conditions[$filter->getColumn()];
126
127	View Code Duplication	if ($value_from = $values['from']) {
		0 ignored issues – show Duplication introduced 2017-04-19 07:50 UTC by Report Bug Copy Issue Report This code seems to be duplicated across 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...
128		$date_from = DateTimeHelper::tryConvertToDateTime($value_from, [$filter->getPhpFormat()]);
129		$date_from->setTime(0, 0, 0);
130
131		$expr = Criteria::expr()->gte($filter->getColumn(), $date_from->format('Y-m-d H:i:s'));
132		$this->criteria->andWhere($expr);
133		}
134
135	View Code Duplication	if ($value_to = $values['to']) {
		0 ignored issues – show Duplication introduced 2016-07-27 14:13 UTC by Report Bug Copy Issue Report This code seems to be duplicated across 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...
136		$date_to = DateTimeHelper::tryConvertToDateTime($value_to, [$filter->getPhpFormat()]);
137		$date_to->setTime(23, 59, 59);
138
139		$expr = Criteria::expr()->lte($filter->getColumn(), $date_to->format('Y-m-d H:i:s'));
140		$this->criteria->andWhere($expr);
141		}
142		}
143
144
145		/**
146		* Filter by range
147		* @param Filter\FilterRange $filter
148		* @return void
149		*/
150		public function applyFilterRange(Filter\FilterRange $filter)
151		{
152		$conditions = $filter->getCondition();
153		$values = $conditions[$filter->getColumn()];
154
155		if ($value_from = $values['from']) {
156		$expr = Criteria::expr()->gte($filter->getColumn(), $value_from);
157		$this->criteria->andWhere($expr);
158		}
159
160		if ($value_to = $values['to']) {
161		$expr = Criteria::expr()->lte($filter->getColumn(), $value_to);
162		$this->criteria->andWhere($expr);
163		}
164		}
165
166
167		/**
168		* Filter by keyword
169		* @param Filter\FilterText $filter
170		* @return void
171		*/
172		public function applyFilterText(Filter\FilterText $filter)
173		{
174		$exprs = [];
175
176		foreach ($filter->getCondition() as $column => $value) {
177		if ($filter->isExactSearch()) {
178		$exprs[] = Criteria::expr()->eq($column, $value);
179		continue;
180		}
181
182	View Code Duplication	if ($filter->hasSplitWordsSearch() === false) {
		0 ignored issues – show Duplication introduced 2016-07-27 14:13 UTC by Report Bug Copy Issue Report This code seems to be duplicated across 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...
183		$words = [$value];
184		} else {
185		$words = explode(' ', $value);
186		}
187
188		foreach ($words as $word) {
189		$exprs[] = Criteria::expr()->contains($column, $word);
190		}
191		}
192
193		$expr = call_user_func_array([Criteria::expr(), 'orX'], $exprs);
194		$this->criteria->andWhere($expr);
195		}
196
197
198		/**
199		* Filter by multi select value
200		* @param Filter\FilterMultiSelect $filter
201		* @return void
202		*/
203		public function applyFilterMultiSelect(Filter\FilterMultiSelect $filter)
204		{
205		$values = $filter->getCondition()[$filter->getColumn()];
206
207		$expr = Criteria::expr()->in($filter->getColumn(), $values);
208		$this->criteria->andWhere($expr);
209		}
210
211
212		/**
213		* Filter by select value
214		* @param Filter\FilterSelect $filter
215		* @return void
216		*/
217		public function applyFilterSelect(Filter\FilterSelect $filter)
218		{
219		foreach ($filter->getCondition() as $column => $value) {
220		$expr = Criteria::expr()->eq($column, $value);
221		$this->criteria->andWhere($expr);
222		}
223		}
224
225
226		/**
227		* Apply limit and offset on data
228		* @param int $offset
229		* @param int $limit
230		* @return static
231		*/
232		public function limit($offset, $limit)
233		{
234		$this->criteria->setFirstResult($offset)->setMaxResults($limit);
235
236		return $this;
237		}
238
239
240		/**
241		* Sort data
242		* @param Sorting $sorting
243		* @return static
244		*/
245		public function sort(Sorting $sorting)
246		{
247		if (is_callable($sorting->getSortCallback())) {
248		call_user_func(
249		$sorting->getSortCallback(),
250		$this->criteria,
251		$sorting->getSort()
252		);
253
254		return $this;
255		}
256
257		if ($sort = $sorting->getSort()) {
258		$this->criteria->orderBy($sort);
259		return $this;
260		}
261
262		$this->criteria->orderBy([$this->primary_key => 'ASC']);
263
264		return $this;
265		}
266
267
268		/**
269		* @param callable $aggregationCallback
270		* @return void
271		*/
272		public function processAggregation(callable $aggregationCallback)
273		{
274		call_user_func($aggregationCallback, clone $this->data_source);
275		}
276		}
277

ublaboo / datagrid

DoctrineCollectionDataSource::limit() A last analyzed 2018-05-01 21:27 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

DoctrineCollectionDataSource::limit() A
last analyzed 2018-05-01 21:27 UTC