From 991ef5c1bfb73d17f67eb9024871cefbce969dca Mon Sep 17 00:00:00 2001
From: cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f>
Date: Sat, 16 Jan 2010 10:20:45 +0000
Subject: Part of request #2928950: Add config option to allow sorting by
 bookmark creation date instead of modification date

git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@594 b3834d28-1941-0410-a4f8-b48e95affb8f
---
 data/config.default.php                  | 10 ++++++++++
 doc/ChangeLog                            |  2 ++
 src/SemanticScuttle/Service/Bookmark.php |  4 ++--
 3 files changed, 14 insertions(+), 2 deletions(-)

diff --git a/data/config.default.php b/data/config.default.php
index 8dd61a5..c3c3b58 100644
--- a/data/config.default.php
+++ b/data/config.default.php
@@ -378,6 +378,16 @@ $defaultRecentDays = 14;
  */
 $defaultOrderBy = 'date_desc';
 
+/**
+ * Database field to use when sorting by date.
+ * Options here are 'bModified' to sort after
+ * modification date, and 'bDatetime' to sort
+ * after creation date
+ *
+ * @var string
+ */
+$dateOrderField = 'bModified';
+
 /**
  * Number of entries that are shown in
  * the RSS feed by default.
diff --git a/doc/ChangeLog b/doc/ChangeLog
index 7b58030..4b1c30b 100644
--- a/doc/ChangeLog
+++ b/doc/ChangeLog
@@ -7,6 +7,8 @@ ChangeLog for SemantiScuttle
 - Implement part of request #2928950:
   - User adjustable entry count: rss.php?count=20
   - Fix HTTP content type header for RSS
+  - Add config option to allow sorting by bookmark creation date
+    instead of modification date
 
 0.95.1 - 2009-11-16
 -------------------
diff --git a/src/SemanticScuttle/Service/Bookmark.php b/src/SemanticScuttle/Service/Bookmark.php
index d0aba0b..cb53cb1 100644
--- a/src/SemanticScuttle/Service/Bookmark.php
+++ b/src/SemanticScuttle/Service/Bookmark.php
@@ -693,7 +693,7 @@ class SemanticScuttle_Service_Bookmark extends SemanticScuttle_DbService
 
         switch($sortOrder) {
         case 'date_asc':
-            $query_5 .= ' ORDER BY B.bModified ASC ';
+            $query_5 .= ' ORDER BY B.' . $GLOBALS['dateOrderField'] . ' ASC ';
             break;
         case 'title_desc':
             $query_5 .= ' ORDER BY B.bTitle DESC ';
@@ -714,7 +714,7 @@ class SemanticScuttle_Service_Bookmark extends SemanticScuttle_DbService
             $query_5 .= ' ORDER BY B.bAddress ASC ';
             break;
         default:
-            $query_5 .= ' ORDER BY B.bModified DESC ';
+            $query_5 .= ' ORDER BY B.' . $GLOBALS['dateOrderField'] . ' DESC ';
         }
 
         // Handle the parts of the query that depend on any tags that are present.
-- 
cgit v1.2.3