Implement gotoArchive

New context menu item for Filesystemwidget: select the seriespart when
goto archive is triggered... Selecting the partId from ArchiveModel was
deceptibly simple. Doom impending?

1 files changed, 12 insertions, 0 deletions

diff --git a/archivemodel.cpp b/archivemodel.cpp
index 1d6c8d0..695dd09 100644
--- a/archivemodel.cpp
+++ b/archivemodel.cpp
@@ -580,6 +580,18 @@ bool ArchiveModel::addSeriesPart(int partno, QString subtitle, const QModelIndex
     return false;
 }
 
+int ArchiveModel::seriesPartIdFromMd5(const QString &md5){
+    QSqlQuery partsIdQ(mDb);
+    partsIdQ.prepare("SELECT iseriespart_id FROM files WHERE cmd5sum = :md5");
+    partsIdQ.bindValue(":md5", md5);
+    int retval = -1;
+    partsIdQ.exec();
+    while(partsIdQ.next()){
+        retval = partsIdQ.value(0).toInt();
+    }
+    return retval;
+}
+
 void ArchiveModel::setOrder(int order) {
     mOrder = order;
     SmTreeItem *rootItem = readCache(mOrder);