@@ -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 | } |