From b8c44e336b596aa45f4fd4054353912b73b71e66 Mon Sep 17 00:00:00 2001
From: Arno <arno@disconnect.de>
Date: Sat, 29 Aug 2015 11:41:40 +0200
Subject: Slide through recent in PictureViewer2

For now, recent is hardcoded to pictures added in the last 6 months.
Maybe it should be configurable...
---
 picfilesmodel.cpp | 15 ++++++++++++++-
 1 file changed, 14 insertions(+), 1 deletion(-)

(limited to 'picfilesmodel.cpp')

diff --git a/picfilesmodel.cpp b/picfilesmodel.cpp
index 3eff4cb..ec1b82d 100644
--- a/picfilesmodel.cpp
+++ b/picfilesmodel.cpp
@@ -305,6 +305,19 @@ void PicFilesModel::allPicIds(){
         cur << q.value(0) << q.value(1) << q.value(2);
         mAllPics << cur;
     }
+    mCurrentPics = &mAllPics;
+}
+
+void PicFilesModel::recentPicIds(){
+    mRecentPics.clear();
+    mCurrentBatch = 0;
+    QSqlQuery q("SELECT tfilename, cmd5sum, ipicsid FROM pics WHERE dtadded > now() - interval '6 months' ORDER BY random()", mDb);
+    while(q.next()){
+        QList<QVariant> cur;
+        cur << q.value(0) << q.value(1) << q.value(2);
+        mRecentPics << cur;
+    }
+    mCurrentPics = &mRecentPics;
 }
 
 QList<QList<QVariant> > PicFilesModel::getNextBatch(){
@@ -312,7 +325,7 @@ QList<QList<QVariant> > PicFilesModel::getNextBatch(){
         mCurrentBatch = 0;
     }
     int start = mCurrentBatch * 100;
-    QList<QList<QVariant> > res = mAllPics.mid(start, 100);
+    QList<QList<QVariant> > res = mCurrentPics->mid(start, 100);
     QList<QList<QVariant> > retval;
     for(QList<QList<QVariant> >::const_iterator it = res.constBegin(); it != res.constEnd(); ++it){
         QList<QVariant> c = *it;
-- 
cgit v1.2.3-70-g09d2