owncloud /
music
| @@ 334-344 (lines=11) @@ | ||
| 331 | * @param bool $fuzzy |
|
| 332 | * @return Album[] |
|
| 333 | */ |
|
| 334 | public function findAllByName($name, $userId, $fuzzy = false){ |
|
| 335 | if ($fuzzy) { |
|
| 336 | $condition = 'AND LOWER(`album`.`name`) LIKE LOWER(?) '; |
|
| 337 | $name = '%' . $name . '%'; |
|
| 338 | } else { |
|
| 339 | $condition = 'AND `album`.`name` = ? '; |
|
| 340 | } |
|
| 341 | $sql = $this->makeSelectQuery($condition . 'ORDER BY LOWER(`album`.`name`)'); |
|
| 342 | $params = array($userId, $name); |
|
| 343 | return $this->findEntities($sql, $params); |
|
| 344 | } |
|
| 345 | } |
|
| 346 | ||
| @@ 164-174 (lines=11) @@ | ||
| 161 | * @param bool $fuzzy |
|
| 162 | * @return Track[] |
|
| 163 | */ |
|
| 164 | public function findAllByName($name, $userId, $fuzzy = false){ |
|
| 165 | if ($fuzzy) { |
|
| 166 | $condition = 'AND LOWER(`track`.`title`) LIKE LOWER(?) '; |
|
| 167 | $name = '%' . $name . '%'; |
|
| 168 | } else { |
|
| 169 | $condition = 'AND `track`.`title` = ? '; |
|
| 170 | } |
|
| 171 | $sql = $this->makeSelectQuery($condition . 'ORDER BY LOWER(`track`.`title`)'); |
|
| 172 | $params = array($userId, $name); |
|
| 173 | return $this->findEntities($sql, $params); |
|
| 174 | } |
|
| 175 | ||
| 176 | /** |
|
| 177 | * @param string $name |
|
