Add genres to actor in enhanced search dialog

Get all genres for the current actor and add them as child.

1 files changed, 23 insertions, 0 deletions

diff --git a/searchdialog.cpp b/searchdialog.cpp
index d14a61a..8266622 100644
--- a/searchdialog.cpp
+++ b/searchdialog.cpp
@@ -199,12 +199,35 @@ void ActorsAndMore::searchActor(const QString &actor){
         cur->setIcon(icon);
         cur->setData(actorQ.value(1), IdRole);
         cur->setEditable(false);
+        getGenresForActor(cur);
         root->appendRow(cur);
     }
     mResultView->setSortingEnabled(true);
     mResultView->sortByColumn(0, Qt::AscendingOrder);
 }
 
+void ActorsAndMore::getGenresForActor(QStandardItem *actorItem){
+    QStringList res;
+    QIcon icon = SmGlobals::instance()->iconFor("genre");
+    QSqlDatabase db = QSqlDatabase::database("treedb");
+    QSqlQuery genreQ(db);
+    genreQ.prepare("SELECT DISTINCT(genres.tgenrename) FROM genres, seriesparts, seriesparts_actormap, seriesparts_genremap WHERE seriesparts_actormap.iseriesparts_id = seriesparts.iseriesparts_id AND seriesparts.iseriesparts_id = seriesparts_genremap.iseriesparts_id AND seriesparts_genremap.igenres_id = genres.igenres_id AND seriesparts_actormap.iactors_id = :id ORDER BY genres.tgenrename");
+    genreQ.bindValue(":id", actorItem->data(IdRole));
+    genreQ.exec();
+    while(genreQ.next()){
+        res << genreQ.value(0).toString();
+    }
+    if(!res.isEmpty()){
+        for(QString g : res){
+            QStandardItem *cur = new QStandardItem(g);
+            cur->setIcon(icon);
+            cur->setEditable(false);
+            cur->setData(actorItem->data(IdRole), IdRole);
+            actorItem->appendRow(cur);
+        }
+    }
+}
+
 SearchDialog::SearchDialog(QWidget *parent, Qt::WindowFlags flags) : QDialog(parent, flags) {
     QHBoxLayout *gbLayout = new QHBoxLayout;
     QGroupBox *metaFnGb = new QGroupBox(tr("Metadata and Filenames"));