From f1f679c8ad823b7ac9e9be2221a67bdeecbb7f7a Mon Sep 17 00:00:00 2001
From: Andrew Dunstan <andrew@dunslane.net>
Date: Fri, 15 Oct 2010 20:48:10 +0000
Subject: [PATCH] display sysnotes

---
 cgi-bin/show_history.pl |  3 ++-
 cgi-bin/show_members.pl |  1 +
 templates/history.tt    | 14 ++++++++++++++
 templates/members.tt    |  7 ++++++-
 4 files changed, 23 insertions(+), 2 deletions(-)

diff --git a/cgi-bin/show_history.pl b/cgi-bin/show_history.pl
index 902fdb5..b55c381 100755
--- a/cgi-bin/show_history.pl
+++ b/cgi-bin/show_history.pl
@@ -44,7 +44,8 @@ my $statement = <<EOS;
   select (now() at time zone 'GMT')::timestamp(0) - snapshot as when_ago,
       sysname, snapshot, b.status, stage,
       operating_system, os_version, compiler, compiler_version, architecture,
-      owner_email
+      owner_email,
+      sys_notes_ts::date AS sys_notes_date, sys_notes
   from buildsystems s, 
        build_status b 
   where name = ?
diff --git a/cgi-bin/show_members.pl b/cgi-bin/show_members.pl
index 5d4a0c9..3bc733c 100755
--- a/cgi-bin/show_members.pl
+++ b/cgi-bin/show_members.pl
@@ -34,6 +34,7 @@ my $db = DBI->connect($dsn,$dbuser,$dbpass);
 my $statement = q{
 
   select name, operating_system, os_version, compiler, compiler_version, owner_email, 
+    sys_notes_ts::date AS sys_notes_date, sys_notes,
     architecture as arch, ARRAY(
 				select branch || ':' || 
 				       extract(days from now() - l.snapshot)
diff --git a/templates/history.tt b/templates/history.tt
index d0510e6..dd050ed 100644
--- a/templates/history.tt
+++ b/templates/history.tt
@@ -15,6 +15,20 @@
     <tr><th>Architecture</th><td>[% statrows.0.architecture %]</td></tr>
     <tr><th>Owner</th><td>[% statrows.0.owner_email %]</td></tr>
   </table>
+[% IF statrows.0.sys_notes %]
+    <br />
+    <table>
+     <tr>
+       <th class="head" rowspan="2">System Notes</th>
+       <th>Date</th>
+       <th>Notes</th>
+     </tr>
+     <tr>
+      <td>[% statrows.0.sys_notes_date %]</td>
+      <td>[% statrows.0.sys_notes %]</td>
+     </tr>
+   </table>
+[% END %]
   <h3>Branch: [% branch %][% IF statrows.size >= hm %] (last [% hm %] entries shown)[% END %]</h3>
 [% BLOCK stdet %]
     <tr [% PROCESS cl bgfor=row.stage %]>
diff --git a/templates/members.tt b/templates/members.tt
index cb18311..68aafb4 100644
--- a/templates/members.tt
+++ b/templates/members.tt
@@ -27,7 +27,12 @@
 %]    <tr [%- IF alt %]class="alt"[% END -%]>
     [% alt = ! alt %]
     <td><input type="checkbox" name="member" value="[% row.name %]" /></td>
-    <td>[% row.name %]<br />[% row.owner_email %]</td>
+    <td>[% row.name %]<br />[% row.owner_email %]
+[% IF row.sys_notes %]
+    <br />
+      Notes: ([% row.sys_notes_date %]) [% row.sys_notes %]
+[% END %]
+    </td>
     <td>[% row.operating_system %]<br />[% row.os_version %]
 	[% FOREACH personality IN row.personalities %]
         <br / > w.e.f. [% personality.effective_date %]: [% personality.os_version %]
-- 
2.30.2