owncloud /
music
| @@ 305-315 (lines=11) @@ | ||
| 302 | * @param bool $fuzzy |
|
| 303 | * @return Album[] |
|
| 304 | */ |
|
| 305 | public function findAllByName($name, $userId, $fuzzy = false){ |
|
| 306 | if ($fuzzy) { |
|
| 307 | $condition = 'AND LOWER(`album`.`name`) LIKE LOWER(?) '; |
|
| 308 | $name = '%' . $name . '%'; |
|
| 309 | } else { |
|
| 310 | $condition = 'AND `album`.`name` = ? '; |
|
| 311 | } |
|
| 312 | $sql = $this->makeSelectQuery($condition . 'ORDER BY LOWER(`album`.`name`)'); |
|
| 313 | $params = array($userId, $name); |
|
| 314 | return $this->findEntities($sql, $params); |
|
| 315 | } |
|
| 316 | } |
|
| 317 | ||
| @@ 160-170 (lines=11) @@ | ||
| 157 | * @param bool $fuzzy |
|
| 158 | * @return Track[] |
|
| 159 | */ |
|
| 160 | public function findAllByName($name, $userId, $fuzzy = false){ |
|
| 161 | if ($fuzzy) { |
|
| 162 | $condition = 'AND LOWER(`track`.`title`) LIKE LOWER(?) '; |
|
| 163 | $name = '%' . $name . '%'; |
|
| 164 | } else { |
|
| 165 | $condition = 'AND `track`.`title` = ? '; |
|
| 166 | } |
|
| 167 | $sql = $this->makeSelectQuery($condition . 'ORDER BY LOWER(`track`.`title`)'); |
|
| 168 | $params = array($userId, $name); |
|
| 169 | return $this->findEntities($sql, $params); |
|
| 170 | } |
|
| 171 | ||
| 172 | /** |
|
| 173 | * @param string $name |
|
