Edit subject

Forgot that on implementing MoviePropertiesDialog...

2 files changed, 9 insertions, 2 deletions

diff --git a/moviepropertiesdialog.cpp b/moviepropertiesdialog.cpp
index 2fa68c2..d1f90c0 100644
--- a/moviepropertiesdialog.cpp
+++ b/moviepropertiesdialog.cpp
@@ -38,6 +38,10 @@ void MoviePropertiesDialog::setupDialog(){
     mCommentLE = new QLineEdit;
     seriesGrid->addWidget(commentL, 2, 0);
     seriesGrid->addWidget(mCommentLE, 2, 1);
+    QLabel *subjectL = new QLabel(tr("Subject"));
+    mSubjectLE = new QLineEdit;
+    seriesGrid->addWidget(subjectL, 3, 0);
+    seriesGrid->addWidget(mSubjectLE, 3, 1);
     QGroupBox *seriesGB = new QGroupBox(tr("Series"));
     seriesGB->setLayout(seriesGrid);
     QIntValidator *validator = new QIntValidator(this);
@@ -115,12 +119,13 @@ void MoviePropertiesDialog::init(int seriesPartsId){
     mSeriesPartsId = seriesPartsId;
     QSqlDatabase db = QSqlDatabase::database("treedb");
     QSqlQuery genQ(db);
-    genQ.prepare("SELECT series.tseries_name, seriesparts.tsubtitle, seriesparts.iseriespart, metadata.tcomment, metadata.sireleaseyear, metadata.tsourcemedium FROM series, seriesparts, metadata WHERE seriesparts.iseriesparts_id = :id AND seriesparts.iseries_id = series.iseries_id AND metadata.iseriespart_id = seriesparts.iseriesparts_id");
+    genQ.prepare("SELECT series.tseries_name, seriesparts.tsubtitle, seriesparts.iseriespart, metadata.tcomment, metadata.sireleaseyear, metadata.tsourcemedium, metadata.tsubject FROM series, seriesparts, metadata WHERE seriesparts.iseriesparts_id = :id AND seriesparts.iseries_id = series.iseries_id AND metadata.iseriespart_id = seriesparts.iseriesparts_id");
     genQ.bindValue(":id", seriesPartsId);
     genQ.exec();
     while(genQ.next()){
         mSeriesNameLE->setText(genQ.value(0).toString());
         mSubtitleLE->setText(genQ.value(1).toString());
+        mSubjectLE->setText(genQ.value(6).toString());
         mSeriesPartLE->setText(genQ.value(2).toString());
         mCommentLE->setText(genQ.value(3).toString());
         mReleaseYearLE->setText(genQ.value(4).toString());
@@ -252,10 +257,11 @@ void MoviePropertiesDialog::accept(){
         sourceMedium = "Usenet"; //for historical reasons it's not lowercased
     }
     QSqlQuery updateMdQ(db);
-    updateMdQ.prepare("UPDATE metadata SET sireleaseyear = :ry, tcomment = :c, tsourcemedium = :src WHERE iseriespart_id = :spid");
+    updateMdQ.prepare("UPDATE metadata SET sireleaseyear = :ry, tcomment = :c, tsourcemedium = :src, tsubject = :subj WHERE iseriespart_id = :spid");
     updateMdQ.bindValue(":ry", mReleaseYearLE->text().toInt());
     updateMdQ.bindValue(":c", mCommentLE->text());
     updateMdQ.bindValue(":src", sourceMedium);
+    updateMdQ.bindValue(":subj", mSubjectLE->text());
     updateMdQ.bindValue(":spid", mSeriesPartsId);
     updateMdQ.exec();
     QSqlQuery clearActorMapQ(db);
diff --git a/moviepropertiesdialog.h b/moviepropertiesdialog.h
index f44c35a..29abec0 100644
--- a/moviepropertiesdialog.h
+++ b/moviepropertiesdialog.h
@@ -25,6 +25,7 @@ class MoviePropertiesDialog : public QDialog {
         QLineEdit *mSeriesNameLE;
         QLineEdit *mSubtitleLE;
         QLineEdit *mCommentLE;
+        QLineEdit *mSubjectLE;
         QLineEdit *mReleaseYearLE;
         QLineEdit *mSeriesPartLE;
         QRadioButton *mTorrentRB;