From 91750c1a4247ab436ffff5a518efd7004c01b98d Mon Sep 17 00:00:00 2001 From: Arno Date: Thu, 7 Feb 2013 14:46:43 +0100 Subject: Change sort order Change sort order when selecting files for burning... Alphabetically is not very useful here... --- filestreemodel.cpp | 2 +- filestreewidget.cpp | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/filestreemodel.cpp b/filestreemodel.cpp index 96f1ba4..729a4fc 100644 --- a/filestreemodel.cpp +++ b/filestreemodel.cpp @@ -95,7 +95,7 @@ void FilesTreeModel::setIds(const QList &seriesPartIds){ void FilesTreeModel::setForBurn(){ mDisplayMode = Burn; - QString query = QString("SELECT iseriespart_id, tfilename, cmd5sum, bisize, idvd, sifiletype, sifileno, siquality, ifiles_id, series.tseries_name, seriesparts.iseriespart, seriesparts.bfavorite FROM files, seriesparts, series WHERE iseriespart_id IN (SELECT iseriesparts_id from seriesparts where bfavorite = false) AND files.iseriespart_id = seriesparts.iseriesparts_id AND seriesparts.iseries_id = series.iseries_id AND sifiletype = 1 AND idvd < 0 ORDER BY tfilename, sifileno ASC"); + QString query = QString("SELECT iseriespart_id, tfilename, cmd5sum, bisize, idvd, sifiletype, sifileno, siquality, ifiles_id, series.tseries_name, seriesparts.iseriespart, seriesparts.bfavorite FROM files, seriesparts, series WHERE iseriespart_id IN (SELECT iseriesparts_id from seriesparts where bfavorite = false) AND files.iseriespart_id = seriesparts.iseriesparts_id AND seriesparts.iseries_id = series.iseries_id AND sifiletype = 1 AND idvd < 0 ORDER BY iseriespart_id"); QSqlQuery filesQuery(mDb); filesQuery.prepare(query); populate(filesQuery); diff --git a/filestreewidget.cpp b/filestreewidget.cpp index c2a5d5f..cb253b3 100644 --- a/filestreewidget.cpp +++ b/filestreewidget.cpp @@ -523,8 +523,8 @@ const QString FilesTreeView::fileNameText(const QModelIndex &idx) const{ return QString(); } FilesTreeModel *filesModel = qobject_cast(SmGlobals::instance()->model("FilesModel")); - QHash files = filesModel->filesBySeriesPartId(idx.data(FilesTreeModel::SeriesPartIdRole).toInt()); - QModelIndex seriesPartIdx = seriesModel->findValue(idx.data(FilesTreeModel::SeriesPartIdRole), seriesIdx, SeriesTreeModel::SeriesPartId); + QHash files = filesModel->filesBySeriesPartId(idx.data(FilesTreeModel::SeriesPartIdRole).toInt()); + QModelIndex seriesPartIdx = seriesModel->findValue(idx.data(FilesTreeModel::SeriesPartIdRole), seriesIdx, SeriesTreeModel::SeriesPartId); QString retval = QString(tr("

%1 %2

")).arg(seriesPartIdx.data(SeriesTreeModel::NameRole).toString()).arg(QString::number(seriesPartIdx.data(SeriesTreeModel::SeriesPartRole).toInt())); retval.append(QString(tr("

Files:

"))); retval.append(tr("
    ")); -- cgit v1.2.3-70-g09d2