X-Git-Url: https://jasonwoof.com/gitweb/?p=wfpl-cms.git;a=blobdiff_plain;f=admin_images.php;h=2a5ae51511500ea1f05b8099b48d6c4111c999b2;hp=73d16c64c0d21e5af5d8dcb1fa96e13fe993daa0;hb=a2eea0ebfb5a15b80fc0d76be90f4ab453539be0;hpb=e7424acd48ed670f1b8bd8d7c1ff69b37ce6334b

diff --git a/admin_images.php b/admin_images.php
index 73d16c6..2a5ae51 100644
--- a/admin_images.php
+++ b/admin_images.php
@@ -127,7 +127,22 @@ function admin_images_main_delete($id) {
 }
 
 function admin_images_main_listing() {
-	$listing_rows = db_get_assocs('cms_images', 'id,image,name,caption', 'order by name, caption');
+	$sort_by = 'name';
+	$sorts = array(
+		'age' => 'created_at desc',
+		'name' => "coalesce(nullif(name, ''), caption), created_at",
+		'caption' => "coalesce(nullif(caption, ''), name), created_at"
+	);
+	if (isset($_REQUEST['sort'])) {
+		foreach ($sorts as $s => $sql) {
+			if ($_REQUEST['sort'] == $s) {
+				$sort_by = $s;
+				break;
+			}
+		}
+	}
+	tem_set("sort_by_$sort_by");
+	$listing_rows = db_get_assocs('cms_images', 'id,image,name,caption', 'order by ' . $sorts[$sort_by]);
 	tem_set('listings', $listing_rows);
 }