display sysnotes

diff --git a/cgi-bin/show_history.pl b/cgi-bin/show_history.pl
index 902fdb5b58a46821ab4feee3d441ff6b6a86361e..b55c381b6cb364a418138bf9c5b3345515738bd5 100755 (executable)
--- 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 5d4a0c97623a417043b7e0bfc3c63827ee1a806f..3bc733c5a2127300094dffa4970b25679125b2f8 100755 (executable)
--- 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 d0510e699b0e76d4ca921b5360f661d1e82cc88a..dd050edfc1d3f6a465f9cefa9b2aaeefd4c3a32f 100644 (file)
--- 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 cb183114a3b64a31caa0c73109e8df7003e7023a..68aafb4733a29d83b50e80af49d0022667f6d636 100644 (file)
--- 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 %]