Make Origin MD5sums searchable

First, add a QAction to copy the MD5sum from FSWidget to Clipboard. Then
enhance the SearchDialog to support MD5sums from files_origin *only*.

1 files changed, 17 insertions, 0 deletions

diff --git a/searchdialog.cpp b/searchdialog.cpp
index 5c155b9..788c468 100644
--- a/searchdialog.cpp
+++ b/searchdialog.cpp
@@ -122,6 +122,23 @@ void FilenamesAndMetadata::search(){
     if(ctr == 0){
         appendEmpty(filenameItem);
     }
+
+    //search md5sums
+    QSqlQuery md5sumQ(db);
+    md5sumQ.prepare("SELECT tfilename, iseriespart_id, series.tseries_name, seriesparts.tsubtitle FROM files, files_origin, seriesparts, series WHERE files_origin.cmd5sum = :md5 AND files_origin.ifiles_id = files.ifiles_id AND files.iseriespart_id =  seriesparts.iseriesparts_id AND seriesparts.iseries_id = series.iseries_id");
+    md5sumQ.bindValue(":md5", mSearch->text());
+    SmTreeItem *md5Item = new SmTreeItem(QVariantList() << tr("MD5 Sums") << QVariant() << QVariant(), root);
+    root->appendChild(md5Item);
+    ctr = 0;
+    md5sumQ.exec();
+    while(md5sumQ.next()){
+        ++ctr;
+        appendChild(md5sumQ.value(1), md5sumQ.value(0), md5sumQ.value(2), md5sumQ.value(3), md5Item);
+    }
+    if(ctr == 0){
+        appendEmpty(md5Item);
+    }
+
     mModel->setRoot(root);
     mResult->expandAll();
 }