@@ -29,7 +29,7 @@ |
||
29 | 29 | * @inheritdoc |
30 | 30 | */ |
31 | 31 | public function like($x, $y, $type = null) { |
32 | - return parent::like($x, $y, $type) . " ESCAPE '\\'"; |
|
32 | + return parent::like($x, $y, $type)." ESCAPE '\\'"; |
|
33 | 33 | } |
34 | 34 | |
35 | 35 | public function iLike($x, $y, $type = null) { |
@@ -41,26 +41,26 @@ |
||
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 | } |
@@ -208,9 +208,9 @@ discard block |
||
208 | 208 | $query->expr()->eq('configkey', new Literal('email')) |
209 | 209 | ) |
210 | 210 | // sqlite doesn't like re-using a single named parameter here |
211 | - ->where($query->expr()->iLike('uid', $query->createPositionalParameter('%' . $connection->escapeLikeParameter($search) . '%'))) |
|
212 | - ->orWhere($query->expr()->iLike('displayname', $query->createPositionalParameter('%' . $connection->escapeLikeParameter($search) . '%'))) |
|
213 | - ->orWhere($query->expr()->iLike('configvalue', $query->createPositionalParameter('%' . $connection->escapeLikeParameter($search) . '%'))) |
|
211 | + ->where($query->expr()->iLike('uid', $query->createPositionalParameter('%'.$connection->escapeLikeParameter($search).'%'))) |
|
212 | + ->orWhere($query->expr()->iLike('displayname', $query->createPositionalParameter('%'.$connection->escapeLikeParameter($search).'%'))) |
|
213 | + ->orWhere($query->expr()->iLike('configvalue', $query->createPositionalParameter('%'.$connection->escapeLikeParameter($search).'%'))) |
|
214 | 214 | ->orderBy($query->func()->lower('displayname'), 'ASC') |
215 | 215 | ->orderBy($query->func()->lower('uid'), 'ASC') |
216 | 216 | ->setMaxResults($limit) |
@@ -262,7 +262,7 @@ discard block |
||
262 | 262 | * @return boolean true if user was found, false otherwise |
263 | 263 | */ |
264 | 264 | private function loadUser($uid) { |
265 | - $uid = (string)$uid; |
|
265 | + $uid = (string) $uid; |
|
266 | 266 | if (!isset($this->cache[$uid])) { |
267 | 267 | //guests $uid could be NULL or '' |
268 | 268 | if ($uid === '') { |
@@ -328,7 +328,7 @@ discard block |
||
328 | 328 | */ |
329 | 329 | public function getHome($uid) { |
330 | 330 | if ($this->userExists($uid)) { |
331 | - return \OC::$server->getConfig()->getSystemValue("datadirectory", \OC::$SERVERROOT . "/data") . '/' . $uid; |
|
331 | + return \OC::$server->getConfig()->getSystemValue("datadirectory", \OC::$SERVERROOT."/data").'/'.$uid; |
|
332 | 332 | } |
333 | 333 | |
334 | 334 | return false; |