From b05eae96a4be8990a1de81795013587ded7ed3aa Mon Sep 17 00:00:00 2001
From: Dan McGee <dan@archlinux.org>
Date: Wed, 30 Nov 2011 12:28:11 -0600
Subject: Add more precise sort for last update signoff column

This allows sorting by the exact time recorded in the database, even if
we don't show it directly to the user, which makes finding the most
recent updates a lot easier.

Signed-off-by: Dan McGee <dan@archlinux.org>
---
 media/archweb.js                 | 13 +++++++++++++
 templates/packages/signoffs.html |  4 ++--
 2 files changed, 15 insertions(+), 2 deletions(-)

diff --git a/media/archweb.js b/media/archweb.js
index 4f098c7d..151d0f81 100644
--- a/media/archweb.js
+++ b/media/archweb.js
@@ -54,6 +54,19 @@ if (typeof $.tablesorter !== 'undefined') {
         },
         type: 'numeric'
     });
+    $.tablesorter.addParser({
+        id: 'epochdate',
+        is: function(s) { return false; },
+        format: function(s, t, c) {
+            /* TODO: this assumes our magic class is the only one */
+            var epoch = $(c).attr('class');
+            if (!epoch.indexOf('epoch-') == 0) {
+                return 0;
+            }
+            return epoch.slice(6);
+        },
+        type: 'numeric'
+    });
     $.tablesorter.addParser({
         id: 'longDateTime',
         re: /^(\d{4})-(\d{2})-(\d{2}) ([012]\d):([0-5]\d)(:([0-5]\d))?( (\w+))?$/,
diff --git a/templates/packages/signoffs.html b/templates/packages/signoffs.html
index bd84289c..b032e656 100644
--- a/templates/packages/signoffs.html
+++ b/templates/packages/signoffs.html
@@ -56,7 +56,7 @@
                 <td>{{ group.target_repo }}</td>
                 <td>{{ group.packager|default:"Unknown" }}</td>
                 <td>{{ group.packages|length }}</td>
-                <td>{{ group.last_update|date }}</td>
+                <td class="epoch-{{ group.last_update|date:'U' }}">{{ group.last_update|date }}</td>
                 {% if group.specification.known_bad %}
                 <td class="approval signoff-bad">Bad</td>
                 {% else %}
@@ -85,7 +85,7 @@
 $(document).ready(function() {
     $('a.signoff-link').click(signoff_package);
     $(".results").tablesorter({widgets: ['zebra'], sortList: [[0,0]],
-        headers: { 7: { sorter: false }, 8: {sorter: false } } });
+        headers: { 5: { sorter: 'epochdate' }, 7: { sorter: false }, 8: {sorter: false } } });
     $('#signoffs_filter input').change(filter_signoffs);
     $('#criteria_reset').click(filter_signoffs_reset);
     // fire function on page load to ensure the current form selections take effect
-- 
cgit v1.2.3-55-g3dc8