public function getPinned()
{
$query = Playlist::userDetails()->with('tracks', 'tracks.cover', 'tracks.user', 'user')->join('pinned_playlists', function ($join) {
$join->on('playlist_id', '=', 'playlists.id');
})->where('pinned_playlists.user_id', '=', Auth::user()->id)->orderBy('title', 'asc')->select('playlists.*')->get();
$playlists = [];
foreach ($query as $playlist) {
$mapped = Playlist::mapPublicPlaylistSummary($playlist);
$mapped['description'] = $playlist->description;
$mapped['is_pinned'] = true;
$playlists[] = $mapped;
}
return Response::json($playlists, 200);
}
