Change font to courier

...again

1 files changed, 6 insertions, 3 deletions

diff --git a/playerwidget.cpp b/playerwidget.cpp
index 36910cc..e46990e 100644
--- a/playerwidget.cpp
+++ b/playerwidget.cpp
@@ -129,7 +129,7 @@ void PlayerWidget::populateByArtist(){
     QSqlQuery artistsQ(db);
     artistsQ.prepare("SELECT iartists_id, tartists_name FROM artists ORDER BY tartists_name ASC");
     QSqlQuery albumQ(db);
-    albumQ.prepare("SELECT DISTINCT(songs.ialbums_id), talbum_name, siyear FROM songs, albums WHERE songs.iartists_id = :artistid AND songs.ialbums_id = albums.ialbums_id");
+    albumQ.prepare("SELECT DISTINCT(songs.ialbums_id), talbum_name, siyear FROM songs, albums WHERE songs.iartists_id = :artistid AND songs.ialbums_id = albums.ialbums_id ORDER BY siyear ASC");
     QSqlQuery songQ(db);
     songQ.prepare("SELECT sipos, ttitle, tfullpath FROM songs WHERE ialbums_id = :alid AND iartists_id = :arid ORDER BY sipos ASC");
 
@@ -143,7 +143,8 @@ void PlayerWidget::populateByArtist(){
     artistsQ.exec();
     while(artistsQ.next()){
         QStandardItem *curArtist = new QStandardItem;
-        QString artistText = QString(tr("%1 - %2")).arg(QString("🅐")).arg(artistsQ.value(1).toString()); //I guess this will bite me!
+        curArtist->setFont(QFont("courier"));
+        QString artistText = QString(tr("%1 %2")).arg(QString("🅐")).arg(artistsQ.value(1).toString()); //I guess this will bite me!
         curArtist->setText(artistText);
         curArtist->setData(Artist, TypeRole);
         curArtist->setData(artistsQ.value(0).toInt(), IdRole);
@@ -152,7 +153,8 @@ void PlayerWidget::populateByArtist(){
         albumQ.exec();
         while(albumQ.next()){
             QStandardItem *curAlbum = new QStandardItem;
-            QString albumText = QString(tr("%1 - %2 (%3)")).arg(QChar(0x29BE)).arg(albumQ.value(1).toString()).arg(QString::number(albumQ.value(2).toInt()));
+            curAlbum->setFont(QFont("courier"));
+            QString albumText = QString(tr("%1 %2 - %3")).arg(QChar(0x29BE)).arg(QString::number(albumQ.value(2).toInt())).arg(albumQ.value(1).toString());
             curAlbum->setText(albumText);
             curAlbum->setData(Album, TypeRole);
             curAlbum->setData(albumQ.value(0), IdRole);
@@ -162,6 +164,7 @@ void PlayerWidget::populateByArtist(){
             songQ.exec();
             while(songQ.next()){
                 QStandardItem *curSong = new QStandardItem;
+                curSong->setFont(QFont("courier"));
                 QString songText = QString(tr("%1 %2 - %3")).arg(QChar(0x266C)).arg(songQ.value(0).toInt(), 3, 10, QChar('0')).arg(songQ.value(1).toString());
                 curSong->setText(songText);
                 curSong->setData(Song, TypeRole);