@@ -13,11 +13,11 @@ discard block |
||
13 | 13 | * @return $this |
14 | 14 | */ |
15 | 15 | public function orderBy($expression, $direction = 'asc') { |
16 | - if(strtolower($direction) != 'desc') { |
|
16 | + if (strtolower($direction) != 'desc') { |
|
17 | 17 | $direction = 'ASC'; |
18 | 18 | } |
19 | - if(is_array($expression)) { |
|
20 | - if(!count($expression)) { |
|
19 | + if (is_array($expression)) { |
|
20 | + if (!count($expression)) { |
|
21 | 21 | return $this; |
22 | 22 | } |
23 | 23 | $arguments = array( |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | */ |
35 | 35 | public function orderByValues($fieldName, array $values) { |
36 | 36 | $expr = []; |
37 | - foreach(array_values($values) as $idx => $value) { |
|
37 | + foreach (array_values($values) as $idx => $value) { |
|
38 | 38 | $expr[] = $this->db()->quoteExpression("WHEN ? THEN ?", array($value, $idx)); |
39 | 39 | } |
40 | 40 | $this->orderBy[] = array(sprintf("CASE %s\n\t\t%s\n\tEND", $this->db()->quoteField($fieldName), join("\n\t\t", $expr)), 'ASC'); |
@@ -46,12 +46,12 @@ discard block |
||
46 | 46 | * @return string |
47 | 47 | */ |
48 | 48 | protected function buildOrder($query) { |
49 | - if(!count($this->orderBy)) { |
|
49 | + if (!count($this->orderBy)) { |
|
50 | 50 | return $query; |
51 | 51 | } |
52 | 52 | $query .= "ORDER BY\n"; |
53 | 53 | $arr = array(); |
54 | - foreach($this->orderBy as $order) { |
|
54 | + foreach ($this->orderBy as $order) { |
|
55 | 55 | list($expression, $direction) = $order; |
56 | 56 | $arr[] = sprintf("\t%s %s", $expression, strtoupper($direction)); |
57 | 57 | } |