@@ -40,7 +40,7 @@ |
||
40 | 40 | |
41 | 41 | |
42 | 42 | /** |
43 | - * @param DibiFluent $data_source |
|
43 | + * @param Dibi\Fluent $data_source |
|
44 | 44 | * @param string $primary_key |
45 | 45 | */ |
46 | 46 | public function __construct(\Dibi\Fluent $data_source, $primary_key) |
@@ -171,7 +171,7 @@ discard block |
||
171 | 171 | \dibi::IDENTIFIER |
172 | 172 | ); |
173 | 173 | |
174 | - if ($filter->isExactSearch()){ |
|
174 | + if ($filter->isExactSearch()) { |
|
175 | 175 | $this->data_source->where("$column = %s", $value); |
176 | 176 | continue; |
177 | 177 | } |
@@ -303,7 +303,7 @@ discard block |
||
303 | 303 | |
304 | 304 | public function addAggregationColumn($aggregation_type, $column) |
305 | 305 | { |
306 | - $this->aggregation_data_source = $this->aggregation_data_source->select($aggregation_type .'(%n)', $column)->as($column); |
|
306 | + $this->aggregation_data_source = $this->aggregation_data_source->select($aggregation_type.'(%n)', $column)->as($column); |
|
307 | 307 | } |
308 | 308 | |
309 | 309 | public function getAggregationData() |
@@ -177,7 +177,7 @@ discard block |
||
177 | 177 | $exprs = []; |
178 | 178 | |
179 | 179 | foreach ($filter->getCondition() as $column => $value) { |
180 | - if($filter->isExactSearch()) { |
|
180 | + if ($filter->isExactSearch()) { |
|
181 | 181 | $exprs[] = Criteria::expr()->eq($column, $value); |
182 | 182 | continue; |
183 | 183 | } |
@@ -310,7 +310,7 @@ discard block |
||
310 | 310 | |
311 | 311 | foreach ($this->aggregations as $column => $aggregation_type) { |
312 | 312 | if ($aggregation_type == ColumnAggregationFunction::$aggregation_type_avg) { |
313 | - $result[$column] = $result[$column] / $this->data_source->count(); |
|
313 | + $result[$column] = $result[$column] / $this->data_source->count(); |
|
314 | 314 | } |
315 | 315 | } |
316 | 316 | return $result; |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | /** |
24 | 24 | * @var array |
25 | 25 | */ |
26 | - protected $aggregations =[]; |
|
26 | + protected $aggregations = []; |
|
27 | 27 | |
28 | 28 | /** |
29 | 29 | * @var array |
@@ -66,7 +66,7 @@ discard block |
||
66 | 66 | } |
67 | 67 | |
68 | 68 | return $this->data_source->count( |
69 | - $this->data_source->getName() . '.' . (is_array($primary) ? reset($primary) : $primary) |
|
69 | + $this->data_source->getName().'.'.(is_array($primary) ? reset($primary) : $primary) |
|
70 | 70 | ); |
71 | 71 | } |
72 | 72 | |
@@ -177,8 +177,8 @@ discard block |
||
177 | 177 | $like = '('; |
178 | 178 | $args = []; |
179 | 179 | |
180 | - if($filter->isExactSearch()){ |
|
181 | - $like .= "$column = ? OR "; |
|
180 | + if ($filter->isExactSearch()) { |
|
181 | + $like .= "$column = ? OR "; |
|
182 | 182 | $args[] = "$value"; |
183 | 183 | } else { |
184 | 184 | if ($filter->hasSplitWordsSearch() === FALSE) { |
@@ -191,7 +191,7 @@ discard block |
||
191 | 191 | $args[] = "%$word%"; |
192 | 192 | } |
193 | 193 | } |
194 | - $like = substr($like, 0, strlen($like) - 4) . ')'; |
|
194 | + $like = substr($like, 0, strlen($like) - 4).')'; |
|
195 | 195 | |
196 | 196 | $or[] = $like; |
197 | 197 | $big_or .= "$like OR "; |
@@ -229,9 +229,9 @@ discard block |
||
229 | 229 | |
230 | 230 | foreach ($values as $value) { |
231 | 231 | if ($i == $length) { |
232 | - $or .= $filter->getColumn() . ' = ?)'; |
|
232 | + $or .= $filter->getColumn().' = ?)'; |
|
233 | 233 | } else { |
234 | - $or .= $filter->getColumn() . ' = ? OR '; |
|
234 | + $or .= $filter->getColumn().' = ? OR '; |
|
235 | 235 | } |
236 | 236 | |
237 | 237 | $i++; |
@@ -241,7 +241,7 @@ discard block |
||
241 | 241 | |
242 | 242 | call_user_func_array([$this->data_source, 'where'], $values); |
243 | 243 | } else { |
244 | - $this->data_source->where($filter->getColumn() . ' = ?', reset($values)); |
|
244 | + $this->data_source->where($filter->getColumn().' = ?', reset($values)); |
|
245 | 245 | } |
246 | 246 | } |
247 | 247 | |
@@ -327,7 +327,7 @@ discard block |
||
327 | 327 | $result = []; |
328 | 328 | //there should really be some better way to do this and get all results in one query, this could be big performance issue on bigger tables |
329 | 329 | foreach ($this->aggregations as $column => $aggregation_type) { |
330 | - $result[$column] = $this->data_source->aggregation($aggregation_type . '(' . $column . ')'); |
|
330 | + $result[$column] = $this->data_source->aggregation($aggregation_type.'('.$column.')'); |
|
331 | 331 | } |
332 | 332 | |
333 | 333 | return $result; |
@@ -107,8 +107,8 @@ discard block |
||
107 | 107 | $date_end = clone $date; |
108 | 108 | |
109 | 109 | $this->data_source = $this->data_source->findBy([ |
110 | - $this->prepareColumn($column) . '>=' => $date->setTime(0, 0, 0), |
|
111 | - $this->prepareColumn($column) . '<=' => $date_end->setTime(23, 59, 59) |
|
110 | + $this->prepareColumn($column).'>=' => $date->setTime(0, 0, 0), |
|
111 | + $this->prepareColumn($column).'<=' => $date_end->setTime(23, 59, 59) |
|
112 | 112 | ]); |
113 | 113 | } |
114 | 114 | |
@@ -131,12 +131,12 @@ discard block |
||
131 | 131 | $dataCondition = []; |
132 | 132 | if ($value_from) { |
133 | 133 | $date_from = \DateTime::createFromFormat($filter->getPhpFormat(), $value_from); |
134 | - $dataCondition[$this->prepareColumn($filter->getColumn()) . '>='] = $date_from->setTime(0, 0, 0); |
|
134 | + $dataCondition[$this->prepareColumn($filter->getColumn()).'>='] = $date_from->setTime(0, 0, 0); |
|
135 | 135 | } |
136 | 136 | |
137 | 137 | if ($value_to) { |
138 | 138 | $date_to = \DateTime::createFromFormat($filter->getPhpFormat(), $value_to); |
139 | - $dataCondition[$this->prepareColumn($filter->getColumn()) . '<='] = $date_to->setTime(23, 59, 59); |
|
139 | + $dataCondition[$this->prepareColumn($filter->getColumn()).'<='] = $date_to->setTime(23, 59, 59); |
|
140 | 140 | } |
141 | 141 | |
142 | 142 | if (!empty($dataCondition)) { |
@@ -160,11 +160,11 @@ discard block |
||
160 | 160 | $dataCondition = []; |
161 | 161 | |
162 | 162 | if ($value_from) { |
163 | - $dataCondition[$this->prepareColumn($filter->getColumn()) . '>='] = $value_from; |
|
163 | + $dataCondition[$this->prepareColumn($filter->getColumn()).'>='] = $value_from; |
|
164 | 164 | } |
165 | 165 | |
166 | 166 | if ($value_to) { |
167 | - $dataCondition[$this->prepareColumn($filter->getColumn()) . '<='] = $value_to; |
|
167 | + $dataCondition[$this->prepareColumn($filter->getColumn()).'<='] = $value_to; |
|
168 | 168 | } |
169 | 169 | |
170 | 170 | if (!empty($dataCondition)) { |
@@ -308,7 +308,7 @@ discard block |
||
308 | 308 | private function prepareColumn($column) |
309 | 309 | { |
310 | 310 | if (Strings::contains($column, '.')) { |
311 | - return 'this->' . str_replace('.', '->', $column); |
|
311 | + return 'this->'.str_replace('.', '->', $column); |
|
312 | 312 | } |
313 | 313 | return $column; |
314 | 314 | } |
@@ -334,10 +334,10 @@ discard block |
||
334 | 334 | } |
335 | 335 | $sql = 'SELECT '; |
336 | 336 | foreach ($this->aggregations as $column => $aggregation_type) { |
337 | - $sql .= $aggregation_type . '(' . $column . ') as ' . $column . ','; |
|
337 | + $sql .= $aggregation_type.'('.$column.') as '.$column.','; |
|
338 | 338 | } |
339 | 339 | |
340 | - $sql = rtrim($sql, ',') . ' FROM ( ' . $this->data_source->getQueryBuilder()->getQuerySql() . ' ) as data'; |
|
340 | + $sql = rtrim($sql, ',').' FROM ( '.$this->data_source->getQueryBuilder()->getQuerySql().' ) as data'; |
|
341 | 341 | |
342 | 342 | $params = $this->data_source->getQueryBuilder()->getQueryParameters(); |
343 | 343 | array_unshift($params, $sql); |
@@ -93,7 +93,7 @@ discard block |
||
93 | 93 | [$this->data, $filter->getValue()] |
94 | 94 | ); |
95 | 95 | } else { |
96 | - $this->data = array_filter($this->data, function ($row) use ($filter) { |
|
96 | + $this->data = array_filter($this->data, function($row) use ($filter) { |
|
97 | 97 | return $this->applyFilter($row, $filter); |
98 | 98 | }); |
99 | 99 | } |
@@ -421,7 +421,7 @@ discard block |
||
421 | 421 | |
422 | 422 | foreach ($this->aggregations as $column => $aggregation_type) { |
423 | 423 | if ($aggregation_type == ColumnAggregationFunction::$aggregation_type_avg) { |
424 | - $result[$column] = $result[$column] / count($this->data); |
|
424 | + $result[$column] = $result[$column] / count($this->data); |
|
425 | 425 | } |
426 | 426 | } |
427 | 427 | return $result; |
@@ -146,7 +146,7 @@ |
||
146 | 146 | |
147 | 147 | |
148 | 148 | /** |
149 | - * @param array $columns |
|
149 | + * @param Column\IColumn[] $columns |
|
150 | 150 | * @return array|bool |
151 | 151 | */ |
152 | 152 | public function aggregationRow(array $columns) |