public function doGet(Option $q, HttpGet $get, LoggedIn $me, Option $compilations)
{
$artist = $get->get("artist")->map("urldecode");
$album = $get->get("album")->map("urldecode");
$genre = $get->get("genre")->map("urldecode");
$order_field = $get->getOrElse("sort", "auto");
$filter = $q->map("trim")->reject("");
$query = (new SelectQuery(TSongs::_NAME))->where(TSongs::USER_ID, $me->getId())->where(TSongs::FILE_ID . " IS NOT NULL");
$query->select(TSongs::defaultSelection());
if ($compilations->nonEmpty()) {
$query->where(TSongs::IS_COMP, $compilations->get());
}
Context::contextify($query);
if ($artist->nonEmpty()) {
$query->where(TSongs::A_ARTIST, $artist->get());
}
if ($album->nonEmpty()) {
$query->where(TSongs::T_ALBUM, $album->get());
}
if ($genre->nonEmpty()) {
$query->where(TSongs::T_GENRE, $genre->get());
}
if ($filter->nonEmpty()) {
if (strpos($filter->get(), ":") !== false) {
list($key, $value) = explode(":", $filter->get(), 2);
switch ($key) {
case "id":
$query->where(TSongs::ID, $value);
break;
}
} else {
$query->where(TSongs::FTS_ANY . " @@ plainto_tsquery(?)", [$filter->get()]);
}
} else {
switch ($order_field) {
case 'upload':
$query->orderBy(TSongs::C_DATE . " DESC")->orderBy(TSongs::ID);
break;
default:
$query->orderBy(TSongs::A_ARTIST)->orderBy(TSongs::T_ALBUM)->orderBy(TSongs::DISC)->orderBy(TSongs::T_NUMBER)->orderBy(TSongs::ID);
}
}
ob_start("ob_gzhandler");
$query->renderAllAsJson(function ($row) {
$artist_encoded = escape_url($row["album_artist"]);
$album_encoded = escape_url($row["track_album"]);
$genre_encoded = escape_url($row["track_genre"]);
$row["artist_url"] = "artist/{$artist_encoded}";
$row["album_url"] = "artist/{$artist_encoded}/{$album_encoded}";
$row["genre_url"] = "genre/{$genre_encoded}";
return $row;
});
}
public function doGet(Option $q, LoggedIn $me)
{
$filter = $q->map("trim")->reject("");
$query = (new SelectQuery(TSongs::_NAME))->select(TSongs::A_ARTIST)->where(TSongs::USER_ID, $me->getId())->selectAlias("MIN(" . TSongs::C_BIG_ID . ")", TSongs::C_BIG_ID)->selectAlias("MIN(" . TSongs::C_MID_ID . ")", TSongs::C_MID_ID)->selectAlias("MIN(" . TSongs::C_SMALL_ID . ")", TSongs::C_SMALL_ID);
$query->where(TSongs::IS_COMP, "0");
Context::contextify($query);
if ($filter->nonEmpty()) {
$query->where(TSongs::FTS_ARTIST . " @@ plainto_tsquery(?)", [$filter->get()]);
}
$query->addGroupBy(TSongs::A_ARTIST);
$query->orderBy(TSongs::A_ARTIST);
ob_start("ob_gzhandler");
$query->renderAllAsJson(function ($row) {
$artist_encoded = escape_url($row["album_artist"]);
$row["artist_url"] = "artist/{$artist_encoded}";
return $row;
});
}
