-started properties dialog, does nothing atm, but compiles :)

git-svn-id: file:///var/svn/repos2/shemov/trunk@396 f440f766-f032-0410-8965-dc7d17de2ca0

1 files changed, 65 insertions, 0 deletions

diff --git a/moviepropertiesdialog.cpp b/moviepropertiesdialog.cpp
new file mode 100644
index 0000000..26bec8f
--- /dev/null
+++ b/moviepropertiesdialog.cpp
@@ -0,0 +1,65 @@
+/*
+  This program is free software; you can redistribute it and/or
+  modify it under the terms of the GNU General Public License
+  as published by the Free Software Foundation; either version
+  2 of the License, or (at your option) any later version.
+*/
+
+#include <QHBoxLayout>
+#include <QVBoxLayout>
+#include <QGraphicsView>
+#include <QGraphicsScene>
+#include <QPushButton>
+#include <QTextEdit>
+#include <QLabel>
+#include <QSqlQuery>
+#include <QFileInfo>
+
+#include "moviepropertiesdialog.h"
+#include "helper.h"
+
+MoviePropertiesDialog::MoviePropertiesDialog(int movid, QWidget *parent, Qt::WindowFlags f) : QDialog(parent, f), mId(movid), mIndex(-1){
+	//gather data
+	covers();
+	QSqlQuery q1;
+	q1.prepare("SELECT ttitle, tfilename, cmd5sum, bisize, genre.tgenrename, iquality, idvd FROM movies, genre WHERE movies.igenreid = genre.igenreid AND movies.imovid = :id");
+	q1.bindValue(":id", mId);
+	q1.exec();
+	QString title, filename, md5, genre;
+	quint64 size(0);
+	qint32 quality, dvd;
+	quality = dvd = 0;
+	q1.exec();
+	while(q1.next()){
+		title = q1.value(0).toString();
+		filename = q1.value(1).toString();
+		md5 = q1.value(2).toString();
+		genre = q1.value(4).toString();
+		size = q1.value(3).toLongLong();
+		quality = q1.value(5).toInt();
+		dvd = q1.value(6).toInt();
+	}
+	QStringList actors;
+	QSqlQuery q2;
+	q2.prepare("SELECT tactorname FROM actor, movieactormap WHERE movieactormap.iactorid = actor.iactorid AND movieactormap.imovid = :id");
+	q2.bindValue(":id", mId);
+	while(q2.next()){
+		actors << q2.value(0).toString();
+	}
+	//layout
+	
+}
+
+void MoviePropertiesDialog::covers(){
+	QSqlQuery q;
+	q.prepare("SELECT tfilename, cmd5sum FROM covers WHERE imovid = :id");
+	q.bindValue(":id", mId);
+	q.exec();
+	while(q.next()){
+		QString path = Helper::createArchivePath(q.value(0).toString(), q.value(1).toString());
+		QFileInfo fi(path);
+		if(fi.exists()){
+			mCovers << path;
+		}
+	}
+}