diff options
Diffstat (limited to 'seriestreemodel.cpp')
-rw-r--r-- | seriestreemodel.cpp | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/seriestreemodel.cpp b/seriestreemodel.cpp index b521647..d5257bb 100644 --- a/seriestreemodel.cpp +++ b/seriestreemodel.cpp @@ -36,6 +36,8 @@ SeriesTreeModel::SeriesTreeModel(QStringList &headers, QObject *parent) : SmTree mSeriesPartFilesQuery->prepare("SELECT files.tfilename, files.cmd5sum FROM seriesparts, files WHERE seriesparts.iseriesparts_id = :id AND seriesparts.iseriesparts_id = files.iseriespart_id"); mSortedMovieListQuery = new QSqlQuery(mDb); mSortedMovieListQuery->prepare("SELECT files.tfilename, files.cmd5sum FROM series, seriesparts, files WHERE series.iseries_id = :id AND seriesparts.iseries_id = series.iseries_id AND seriesparts.iseriesparts_id = files.iseriespart_id AND files.sifiletype = 1 ORDER BY seriesparts.iseriespart, files.sifileno"); + mNextDvdNoQuery = new QSqlQuery(mDb); + mNextDvdNoQuery->prepare("SELECT MAX(idvd) FROM files"); populate(); } @@ -230,6 +232,15 @@ QFileInfoList SeriesTreeModel::findSortedMovies(const QModelIndex &from) const{ return retval; } +int SeriesTreeModel::findNextDvdNo() const{ + int dvdno = 0; + mNextDvdNoQuery->exec(); + while(mNextDvdNoQuery->next()){ + dvdno = mNextDvdNoQuery->value(0).toInt(); + } + return dvdno; +} + bool SeriesTreeModel::deleteFromSeries(const QModelIndex &what){ int nodeType = what.data(TypeRole).toInt(); QSqlQuery *query = 0; |