1 files changed, 14 insertions, 1 deletions
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;