From b83c75451c08569d90aedf7a54b5fa868ec6608e Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.spb.ru>
Date: Wed, 23 Nov 2005 11:47:30 +0100
Subject: sortable feed editor

---
 backend.php | 38 +++++++++++++++++++++++++++++++-------
 prefs.js    |  6 +++---
 2 files changed, 34 insertions(+), 10 deletions(-)

diff --git a/backend.php b/backend.php
index 69559a69d..87b4708b2 100644
--- a/backend.php
+++ b/backend.php
@@ -1116,28 +1116,52 @@
 				type=\"submit\" class=\"button\" 
 				onclick=\"javascript:addFeed()\" value=\"Add feed\"></div>";
 
+		$feeds_sort = db_escape_string($_GET["sort"]);
+
+		if (!$feeds_sort || $feeds_sort == "undefined") {
+			$feeds_sort = $_SESSION["pref_sort_feeds"];			
+			if (!$feeds_sort) $feeds_sort = "title";
+		}
+
+		$_SESSION["pref_sort_feeds"] = $feeds_sort;
+
 		$result = db_query($link, "SELECT 
 				id,title,feed_url,substring(last_updated,1,16) as last_updated,
 				update_interval,purge_interval,
 				(SELECT title FROM ttrss_feed_categories 
 					WHERE id = cat_id) AS category
 			FROM 
-				ttrss_feeds WHERE owner_uid = '".$_SESSION["uid"]."' ORDER by title");
+				ttrss_feeds WHERE owner_uid = '".$_SESSION["uid"]."' 
+			ORDER by $feeds_sort,title");
 
 		print "<div id=\"infoBoxShadow\"><div id=\"infoBox\">PLACEHOLDER</div></div>";
 
 		print "<p><table width=\"100%\" class=\"prefFeedList\" id=\"prefFeedList\">";
 		print "<tr class=\"title\">
-					<td>&nbsp;</td><td>Select</td><td width=\"20%\">Title</td>
-					<td width=\"20%\">Link</td>";
+					<td>&nbsp;</td>
+					<td>Select</td>
+					<td width=\"20%\">
+						<a href=\"javascript:updateFeedList('title')\">Title</a></td>
+					<td width=\"20%\">
+						<a href=\"javascript:updateFeedList('feed_url')\">Link</a>
+					</td>";
 
 		if (get_pref($link, 'ENABLE_FEED_CATS')) {
-			print "<td width=\"10%\">Category</td>";
+			print "<td width=\"10%\">
+				<a href=\"javascript:updateFeedList('category')\">Category</a></td>";
 		}
 		
-		print "<td width=\"10%\">Update Interval</td>
-					<td width=\"10%\">Purge Days</td>
-					<td>Last updated</td></tr>";
+		print "
+			<td width=\"10%\">
+				<a href=\"javascript:updateFeedList('update_interval')\">Update Interval</a>
+			</td>
+			<td width=\"10%\">
+				<a href=\"javascript:updateFeedList('purge_interval')\">Purge Days</a>
+			</td>
+			<td>
+				<a href=\"javascript:updateFeedList('last_updated')\">Last updated</a>
+			</td>				
+		</tr>";
 		
 		$lnum = 0;
 		
diff --git a/prefs.js b/prefs.js
index 846f6825f..04b313836 100644
--- a/prefs.js
+++ b/prefs.js
@@ -165,8 +165,7 @@ function notify_callback() {
 	}
 }
 
-
-function updateFeedList() {
+function updateFeedList(sort_key) {
 
 	if (!xmlhttp_ready(xmlhttp)) {
 		printLockingError();
@@ -177,7 +176,8 @@ function updateFeedList() {
 
 	p_notify("Loading, please wait...");
 
-	xmlhttp.open("GET", "backend.php?op=pref-feeds", true);
+	xmlhttp.open("GET", "backend.php?op=pref-feeds" +
+		"&sort=" + param_escape(sort_key), true);
 	xmlhttp.onreadystatechange=feedlist_callback;
 	xmlhttp.send(null);
 
-- 
cgit v1.2.3