|
@@ -41,47 +41,47 @@ |
|
|
block discarded – undo |
|
41
|
41
|
} |
|
42
|
42
|
|
|
43
|
43
|
public function md5($input) { |
|
44
|
|
- return new QueryFunction('MD5(' . $this->helper->quoteColumnName($input) . ')'); |
|
|
44
|
+ return new QueryFunction('MD5('.$this->helper->quoteColumnName($input).')'); |
|
45
|
45
|
} |
|
46
|
46
|
|
|
47
|
47
|
public function concat($x, $y) { |
|
48
|
|
- return new QueryFunction('CONCAT(' . $this->helper->quoteColumnName($x) . ', ' . $this->helper->quoteColumnName($y) . ')'); |
|
|
48
|
+ return new QueryFunction('CONCAT('.$this->helper->quoteColumnName($x).', '.$this->helper->quoteColumnName($y).')'); |
|
49
|
49
|
} |
|
50
|
50
|
|
|
51
|
51
|
public function substring($input, $start, $length = null) { |
|
52
|
52
|
if ($length) { |
|
53
|
|
- return new QueryFunction('SUBSTR(' . $this->helper->quoteColumnName($input) . ', ' . $this->helper->quoteColumnName($start) . ', ' . $this->helper->quoteColumnName($length) . ')'); |
|
|
53
|
+ return new QueryFunction('SUBSTR('.$this->helper->quoteColumnName($input).', '.$this->helper->quoteColumnName($start).', '.$this->helper->quoteColumnName($length).')'); |
|
54
|
54
|
} else { |
|
55
|
|
- return new QueryFunction('SUBSTR(' . $this->helper->quoteColumnName($input) . ', ' . $this->helper->quoteColumnName($start) . ')'); |
|
|
55
|
+ return new QueryFunction('SUBSTR('.$this->helper->quoteColumnName($input).', '.$this->helper->quoteColumnName($start).')'); |
|
56
|
56
|
} |
|
57
|
57
|
} |
|
58
|
58
|
|
|
59
|
59
|
public function sum($field) { |
|
60
|
|
- return new QueryFunction('SUM(' . $this->helper->quoteColumnName($field) . ')'); |
|
|
60
|
+ return new QueryFunction('SUM('.$this->helper->quoteColumnName($field).')'); |
|
61
|
61
|
} |
|
62
|
62
|
|
|
63
|
63
|
public function lower($field) { |
|
64
|
|
- return new QueryFunction('LOWER(' . $this->helper->quoteColumnName($field) . ')'); |
|
|
64
|
+ return new QueryFunction('LOWER('.$this->helper->quoteColumnName($field).')'); |
|
65
|
65
|
} |
|
66
|
66
|
|
|
67
|
67
|
public function add($x, $y) { |
|
68
|
|
- return new QueryFunction($this->helper->quoteColumnName($x) . ' + ' . $this->helper->quoteColumnName($y)); |
|
|
68
|
+ return new QueryFunction($this->helper->quoteColumnName($x).' + '.$this->helper->quoteColumnName($y)); |
|
69
|
69
|
} |
|
70
|
70
|
|
|
71
|
71
|
public function subtract($x, $y) { |
|
72
|
|
- return new QueryFunction($this->helper->quoteColumnName($x) . ' - ' . $this->helper->quoteColumnName($y)); |
|
|
72
|
+ return new QueryFunction($this->helper->quoteColumnName($x).' - '.$this->helper->quoteColumnName($y)); |
|
73
|
73
|
} |
|
74
|
74
|
|
|
75
|
75
|
public function count($count, $alias = '') { |
|
76
|
|
- $alias = $alias ? (' AS ' . $this->helper->quoteColumnName($alias)) : ''; |
|
77
|
|
- return new QueryFunction('COUNT(' . $this->helper->quoteColumnName($count) . ')' . $alias); |
|
|
76
|
+ $alias = $alias ? (' AS '.$this->helper->quoteColumnName($alias)) : ''; |
|
|
77
|
+ return new QueryFunction('COUNT('.$this->helper->quoteColumnName($count).')'.$alias); |
|
78
|
78
|
} |
|
79
|
79
|
|
|
80
|
80
|
public function max($field) { |
|
81
|
|
- return new QueryFunction('MAX(' . $this->helper->quoteColumnName($field) . ')'); |
|
|
81
|
+ return new QueryFunction('MAX('.$this->helper->quoteColumnName($field).')'); |
|
82
|
82
|
} |
|
83
|
83
|
|
|
84
|
84
|
public function min($field) { |
|
85
|
|
- return new QueryFunction('MIN(' . $this->helper->quoteColumnName($field) . ')'); |
|
|
85
|
+ return new QueryFunction('MIN('.$this->helper->quoteColumnName($field).')'); |
|
86
|
86
|
} |
|
87
|
87
|
} |