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>

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
@@ -55,6 +55,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+))?$/,
         is: function(s) {
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