void CGUIDialogMusicInfo::SetDiscography()
{
m_albumSongs->Clear();
CMusicDatabase database;
database.Open();
std::vector<int> albumsByArtist;
database.GetAlbumsByArtist(m_artist.idArtist, albumsByArtist);
for (unsigned int i=0;i<m_artist.discography.size();++i)
{
CFileItemPtr item(new CFileItem(m_artist.discography[i].first));
item->SetLabel2(m_artist.discography[i].second);
int idAlbum = -1;
for (std::vector<int>::const_iterator album = albumsByArtist.begin(); album != albumsByArtist.end(); ++album)
{
if (StringUtils::EqualsNoCase(database.GetAlbumById(*album), item->GetLabel()))
{
idAlbum = *album;
item->GetMusicInfoTag()->SetDatabaseId(idAlbum, "album");
break;
}
}
if (idAlbum != -1) // we need this slight stupidity to get correct case for the album name
item->SetArt("thumb", database.GetArtForItem(idAlbum, MediaTypeAlbum, "thumb"));
else
item->SetArt("thumb", "DefaultAlbumCover.png");
m_albumSongs->Add(item);
}
}
CStdString CDirectoryNodeAlbumTop100::GetLocalizedName() const
{
CMusicDatabase db;
if (db.Open())
return db.GetAlbumById(GetID());
return "";
}
std::string CDirectoryNodeAlbumRecentlyPlayed::GetLocalizedName() const
{
if (GetID() == -1)
return g_localizeStrings.Get(15102); // All Albums
CMusicDatabase db;
if (db.Open())
return db.GetAlbumById(GetID());
return "";
}
CStdString CDirectoryNodeAlbumCompilations::GetLocalizedName() const
{
if (GetID() == -1)
return g_localizeStrings.Get(15102); // All Albums
CMusicDatabase db;
if (db.Open())
return db.GetAlbumById(GetID());
return "";
}
bool CMusicDatabaseDirectory::GetLabel(const CStdString& strDirectory, CStdString& strLabel)
{
strLabel = "";
CStdString path = CLegacyPathTranslation::TranslateMusicDbPath(strDirectory);
auto_ptr<CDirectoryNode> pNode(CDirectoryNode::ParseURL(path));
if (!pNode.get())
return false;
// first see if there's any filter criteria
CQueryParams params;
CDirectoryNode::GetDatabaseInfo(path, params);
CMusicDatabase musicdatabase;
if (!musicdatabase.Open())
return false;
// get genre
if (params.GetGenreId() >= 0)
strLabel += musicdatabase.GetGenreById(params.GetGenreId());
// get artist
if (params.GetArtistId() >= 0)
{
if (!strLabel.empty())
strLabel += " / ";
strLabel += musicdatabase.GetArtistById(params.GetArtistId());
}
// get album
if (params.GetAlbumId() >= 0)
{
if (!strLabel.empty())
strLabel += " / ";
strLabel += musicdatabase.GetAlbumById(params.GetAlbumId());
}
if (strLabel.empty())
{
switch (pNode->GetChildType())
{
case NODE_TYPE_TOP100:
strLabel = g_localizeStrings.Get(271); // Top 100
break;
case NODE_TYPE_GENRE:
strLabel = g_localizeStrings.Get(135); // Genres
break;
case NODE_TYPE_ARTIST:
strLabel = g_localizeStrings.Get(133); // Artists
break;
case NODE_TYPE_ALBUM:
strLabel = g_localizeStrings.Get(132); // Albums
break;
case NODE_TYPE_ALBUM_RECENTLY_ADDED:
case NODE_TYPE_ALBUM_RECENTLY_ADDED_SONGS:
strLabel = g_localizeStrings.Get(359); // Recently Added Albums
break;
case NODE_TYPE_ALBUM_RECENTLY_PLAYED:
case NODE_TYPE_ALBUM_RECENTLY_PLAYED_SONGS:
strLabel = g_localizeStrings.Get(517); // Recently Played Albums
break;
case NODE_TYPE_ALBUM_TOP100:
case NODE_TYPE_ALBUM_TOP100_SONGS:
strLabel = g_localizeStrings.Get(10505); // Top 100 Albums
break;
case NODE_TYPE_SINGLES:
strLabel = g_localizeStrings.Get(1050); // Singles
break;
case NODE_TYPE_SONG:
strLabel = g_localizeStrings.Get(134); // Songs
break;
case NODE_TYPE_SONG_TOP100:
strLabel = g_localizeStrings.Get(10504); // Top 100 Songs
break;
case NODE_TYPE_YEAR:
case NODE_TYPE_YEAR_ALBUM:
case NODE_TYPE_YEAR_SONG:
strLabel = g_localizeStrings.Get(652); // Years
break;
case NODE_TYPE_ALBUM_COMPILATIONS:
case NODE_TYPE_ALBUM_COMPILATIONS_SONGS:
strLabel = g_localizeStrings.Get(521);
break;
case NODE_TYPE_OVERVIEW:
strLabel = "";
break;
default:
CLog::Log(LOGWARNING, "%s - Unknown nodetype requested %d", __FUNCTION__, pNode->GetChildType());
return false;
}
}
return true;
}
bool CRecentlyAddedJob::UpdateMusic()
{
CGUIWindow* home = g_windowManager.GetWindow(WINDOW_HOME);
if ( home == NULL )
return false;
CLog::Log(LOGDEBUG, "CRecentlyAddedJob::UpdateMusic() - Running RecentlyAdded home screen update");
int i = 0;
CFileItemList musicItems;
CMusicDatabase musicdatabase;
musicdatabase.Open();
if (musicdatabase.GetRecentlyAddedAlbumSongs("musicdb://", musicItems, NUM_ITEMS))
{
for (; i < musicItems.Size(); ++i)
{
CFileItemPtr item = musicItems.Get(i);
CStdString value;
value.Format("%i", i + 1);
CStdString strThumb;
CStdString strRating;
CStdString strAlbum = item->GetMusicInfoTag()->GetAlbum();
CStdString strArtist = item->GetMusicInfoTag()->GetArtist();
long idAlbum = musicdatabase.GetAlbumByName(strAlbum,strArtist);
if (idAlbum != -1)
musicdatabase.GetAlbumThumb(idAlbum,strThumb);
strRating.Format("%c", item->GetMusicInfoTag()->GetRating());
home->SetProperty("LatestSong." + value + ".Title" , item->GetMusicInfoTag()->GetTitle());
home->SetProperty("LatestSong." + value + ".Year" , item->GetMusicInfoTag()->GetYear());
home->SetProperty("LatestSong." + value + ".Artist" , strArtist);
home->SetProperty("LatestSong." + value + ".Album" , strAlbum);
home->SetProperty("LatestSong." + value + ".Rating" , strRating);
home->SetProperty("LatestSong." + value + ".Path" , item->GetMusicInfoTag()->GetURL());
home->SetProperty("LatestSong." + value + ".Thumb" , strThumb);
home->SetProperty("LatestSong." + value + ".Fanart" , item->GetCachedFanart());
}
}
for (; i < NUM_ITEMS; ++i)
{
CStdString value;
value.Format("%i", i + 1);
home->SetProperty("LatestSong." + value + ".Title" , "");
home->SetProperty("LatestSong." + value + ".Year" , "");
home->SetProperty("LatestSong." + value + ".Artist" , "");
home->SetProperty("LatestSong." + value + ".Album" , "");
home->SetProperty("LatestSong." + value + ".Rating" , "");
home->SetProperty("LatestSong." + value + ".Path" , "");
home->SetProperty("LatestSong." + value + ".Thumb" , "");
home->SetProperty("LatestSong." + value + ".Fanart" , "");
}
i = 0;
VECALBUMS albums;
if (musicdatabase.GetRecentlyAddedAlbums(albums, NUM_ITEMS))
{
for (; i < (int)albums.size(); ++i)
{
CStdString value;
CStdString strPath;
CStdString strThumb;
CStdString strDBpath;
CStdString strSQLAlbum;
CAlbum& album=albums[i];
value.Format("%i", i + 1);
musicdatabase.GetAlbumThumb(album.idAlbum,strThumb);
strDBpath.Format("musicdb://3/%i/", album.idAlbum);
strSQLAlbum.Format("idAlbum=%i", album.idAlbum);
CStdString strArtist = musicdatabase.GetSingleValue("albumview", "strArtist", strSQLAlbum);
home->SetProperty("LatestAlbum." + value + ".Title" , musicdatabase.GetAlbumById(album.idAlbum));
home->SetProperty("LatestAlbum." + value + ".Year" , atoi(musicdatabase.GetSingleValue("album", "iYear", strSQLAlbum)));
home->SetProperty("LatestAlbum." + value + ".Artist" , strArtist);
home->SetProperty("LatestAlbum." + value + ".Rating" , musicdatabase.GetSingleValue("albumview", "iRating", strSQLAlbum));
home->SetProperty("LatestAlbum." + value + ".Path" , strDBpath);
home->SetProperty("LatestAlbum." + value + ".Thumb" , strThumb);
home->SetProperty("LatestAlbum." + value + ".Fanart" , CFileItem::GetCachedThumb(strArtist,g_settings.GetMusicFanartFolder()));
}
}
for (; i < NUM_ITEMS; ++i)
{
CStdString value;
value.Format("%i", i + 1);
home->SetProperty("LatestAlbum." + value + ".Title" , "");
home->SetProperty("LatestAlbum." + value + ".Year" , "");
home->SetProperty("LatestAlbum." + value + ".Artist" , "");
home->SetProperty("LatestAlbum." + value + ".Rating" , "");
home->SetProperty("LatestAlbum." + value + ".Path" , "");
home->SetProperty("LatestAlbum." + value + ".Thumb" , "");
home->SetProperty("LatestAlbum." + value + ".Fanart" , "");
}
musicdatabase.Close();
return true;
}
