/*
  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;
		}
	}
}