From a40507fdd34a204c774aa3038361f6000f4cfefb Mon Sep 17 00:00:00 2001
From: Andrew Dunstan <andrew@dunslane.net>
Date: Mon, 24 Jan 2011 14:52:33 -0800
Subject: [PATCH] add shading for system name on failures page to show current
 status

---
 cgi-bin/show_failures.pl | 21 +++++++++++++--------
 htdocs/inc/pgbf.css      |  8 ++++----
 templates/fstatus.tt     |  2 +-
 3 files changed, 18 insertions(+), 13 deletions(-)

diff --git a/cgi-bin/show_failures.pl b/cgi-bin/show_failures.pl
index 104bd66..ad754fa 100755
--- a/cgi-bin/show_failures.pl
+++ b/cgi-bin/show_failures.pl
@@ -32,19 +32,19 @@ my $presort_clause = "";
 my $sortby = $query->param('sortby') || 'nosort';
 if ($sortby eq 'name')
 {
-	$sort_clause = 'lower(sysname),';
+	$sort_clause = 'lower(b.sysname),';
 }
 elsif ($sortby eq 'os')
 {
-	$sort_clause = 'lower(operating_system), os_version desc,'; 
+	$sort_clause = 'lower(b.operating_system), b.os_version desc,'; 
 }
 elsif ($sortby eq 'compiler')
 {
-	$sort_clause = "lower(compiler), compiler_version,";
+	$sort_clause = "lower(b.compiler), b.compiler_version,";
 }
 elsif ($sortby eq 'namenobranch')
 {
-	$presort_clause = "lower(sysname), snapshot desc,"
+	$presort_clause = "lower(b.sysname), b.snapshot desc,"
 }
 
 my $db = DBI->connect($dsn,$dbuser,$dbpass,{pg_expand_array => 0}) 
@@ -53,13 +53,18 @@ my $db = DBI->connect($dsn,$dbuser,$dbpass,{pg_expand_array => 0})
 my $statement =<<EOS;
 
 
-  select timezone('GMT'::text, now())::timestamp(0) without time zone - b.snapshot AS when_ago, b.*
+  select timezone('GMT'::text, 
+	now())::timestamp(0) without time zone - b.snapshot AS when_ago, 
+	b.*,
+	d.stage as current_stage
   from nrecent_failures_db_data b
+	left join  dashboard_mat d
+		on (d.sysname = b.sysname and d.branch = b.branch)
   order by $presort_clause 
-        branch = 'HEAD' desc,
-        branch desc, 
+        b.branch = 'HEAD' desc,
+        b.branch desc, 
         $sort_clause 
-        snapshot desc
+        b.snapshot desc
 
 EOS
 ;
diff --git a/htdocs/inc/pgbf.css b/htdocs/inc/pgbf.css
index 5c7ef7d..b484f05 100644
--- a/htdocs/inc/pgbf.css
+++ b/htdocs/inc/pgbf.css
@@ -109,10 +109,10 @@ th.head {
 
 .status, .detail { border-bottom: 1px #fff solid; }
 tr.last td { border-bottom: 1px #aaa solid; }
-.pass td.status, .pass td.detail { background: #6f6; }
-.warn td.status, .warn td.detail { background: #fc3; }
-.warnx td.status, .warn td.detail { background: #f99; }
-.fail td.status, .fail td.detail { background: #f66; }
+.pass td.status, .pass td.detail, td.pass { background: #6f6; }
+.warn td.status, .warn td.detail, td.warn { background: #fc3; }
+.warnx td.status, .warn td.detail, td.warnx { background: #f99; }
+.fail td.status, .fail td.detail, td.fail { background: #f66; }
 body.history th { text-align: right; }
 body.application table { margin: 0 auto; }
 body.application th { text-align: right; }
diff --git a/templates/fstatus.tt b/templates/fstatus.tt
index 6412a23..e88b488 100644
--- a/templates/fstatus.tt
+++ b/templates/fstatus.tt
@@ -71,7 +71,7 @@ See accompanying License file for license details
 <tr><th colspan="2">Alias</th><th>System</th><th>Status</th><th>Flags</th></tr>
 [% END %]
 <tr [% PROCESS cl bgfor=row.stage %]>
-    <td><a 
+    <td [% PROCESS cl bgfor=row.current_stage %]><a 
     href="show_history.pl?nm=[% row.sysname %]&amp;br=[% row.branch %]"
     title="History"
   >[% row.sysname %]</a></td>
-- 
2.30.2