git://git.exim.org / buildfarm-server.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
remove redundant file
[buildfarm-server.git] / cgi-bin / show_members.pl
diff --git a/cgi-bin/show_members.pl b/cgi-bin/show_members.pl
index 341103eba10701a1a1f1a7d84f0b742729fc4d74..2b6e0be40d7cac8e04c305d7a3f6e0c16e9f4544 100755 (executable)
--- a/cgi-bin/show_members.pl
+++ b/cgi-bin/show_members.pl
@@ -7,7 +7,7 @@ use Template;
 
 
 
-use vars qw($dbhost $dbname $dbuser $dbpass $dbport $sort_by);
+use vars qw($dbhost $dbname $dbuser $dbpass $dbport $template_dir $sort_by);
 
 
 require "$ENV{BFConfDir}/BuildFarmWeb.pl";
@@ -35,15 +35,13 @@ my $statement = <<EOS;
 
   select name, operating_system, os_version, compiler, compiler_version, owner_email, 
     architecture as arch, ARRAY(
-                               select distinct on (branch <> 'HEAD', branch) 
-                                      branch || ':' || 
-                                      extract(days from now() - snapshot)
-                               from build_status 
-                               where name = sysname
-                               order by branch <> 'HEAD', branch desc, 
-                                        snapshot desc
+                               select branch || ':' || 
+                                      extract(days from now() - latest_snapshot)
+                               from build_status_latest l 
+                               where l.sysname = s.name
+                               order by branch <> 'HEAD', branch desc 
                                ) as branches 
-  from buildsystems 
+  from buildsystems s
   where status = 'approved'
   order by $sort_by
 
@@ -67,97 +65,13 @@ $db->disconnect;
 # use Data::Dumper; print "Content-Type: text/plain\n\n",Dumper($statrows),"VERSION: ",$DBD::Pg::VERSION,"\n"; exit;
 
 
-my $template = new Template({});
+my $template_opts = { INCLUDE_PATH => $template_dir};
+my $template = new Template($template_opts);
 
 print "Content-Type: text/html\n\n";
 
-$template->process(\*DATA,{statrows=>$statrows});
+$template->process('members.tt',
+               {statrows=>$statrows});
 
 exit;
 
-
-__DATA__
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
-        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
-<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
-<head>
-       <meta http-equiv="content-type" content="text/html; charset=utf-8" />
-       <title>PostgreSQL BuildFarm Members</title>
-       <link rel="icon" type="image/png" href="/elephant-icon.png" />
-       <link rel="stylesheet" rev="stylesheet" href="/inc/pgbf.css" charset="utf-8" />
-       <style type="text/css"><!--
-       li#members a { color:rgb(17,45,137); background: url(/inc/b/r.png) no-repeat 100% -20px; } 
-       li#members { background: url(/inc/b/l.png) no-repeat 0% -20px; }
-       --></style>
-   </style>
-</head>
-<body class="members">
-<div id="wrapper">
-<div id="banner">
-<a href="/index.html"><img src="/inc/pgbuildfarm-banner.png" alt="PostgreSQL BuildFarm" width="800" height="73" /></a>
-<div id="nav">
-<ul>
-    <li id="home"><a href="/index.html" title="PostgreSQL BuildFarm Home">Home</a></li>
-    <li id="status"><a href="/cgi-bin/show_status.pl" title="Current results">Status</a></li>
-    <li id="members"><a href="/cgi-bin/show_members.pl" title="Platforms tested">Members</a></li>
-    <li id="register"><a href="/register.html" title="Join PostgreSQL BuildFarm">Register</a></li>
-    <li id="pgfoundry"><a href="http://pgfoundry.org/projects/pgbuildfarm/">PGFoundry</a></li>
-</ul>
-</div><!-- nav -->
-</div><!-- banner -->
-<div id="main">
-<h1>PostgreSQL BuildFarm Members</h1>
-    <p>Click branch links to see build history. Click the heading links to resort the list. Select members by checkbox and hit the button at the bottom to create a status custom filter.</p>
-    <form name="filter" method="GET" action="/cgi-bin/show_status.pl">
-    <table cellspacing="0">
-    <tr>
-    <td>&nbsp;</td>
-    <th><a href="/cgi-bin/show_members.pl?sort_by=name">Name</a><br /><a href="/cgi-bin/show_members.pl?sort_by=owner">Owner</a></th>
-    <th><a href="/cgi-bin/show_members.pl?sort_by=os">OS / Version</a></th>
-    <th><a href="/cgi-bin/show_members.pl?sort_by=compiler">Compiler / Version</a></th>
-    <th><a href="/cgi-bin/show_members.pl?sort_by=arch">Arch</a></th>
-    <th>Branches reported on<br />(most recent report)</th>
-    </tr>
-[% alt = true %]
-[% FOREACH row IN statrows %]    <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.operating_system %]<br />[% row.os_version %]</td>
-    <td>[% row.compiler %]<br />[% row.compiler_version %]</td>
-    <td>[% row.arch %]</td>
-    <td class="branch">[% IF ! row.branches ; '&nbsp;' ; END -%]
-    <ul>
-    [%- 
-       FOREACH branch_days IN row.branches.split(',') ;
-       branch_fields = branch_days.split(':');
-       branch = branch_fields.0;
-       branch_day = branch_fields.1;
-    %]<li><a 
-    href="show_history.pl?nm=[% row.name %]&amp;br=[% branch %]"
-    title="History"
-    >[% branch %]</a>&nbsp;([% branch_day %]&nbsp;days&nbsp;ago)</li>[% END %]</ul></td>
-    </tr>
-[% END %]
-    </table>
-    <input type="submit" value="Make Filter" />
-    </form>
-    </div><!-- main -->
-<hr />
-<p style="text-align: center;">
-Hosting for the PostgreSQL Buildfarm is generously 
-provided by: 
-<a href="http://www.commandprompt.com">CommandPrompt, 
-The PostgreSQL Company</a>
-</p>
-    </div><!-- wrapper -->
-  </body>
-</html>
-
-
-
-
-
-
-
-
Server side for Exim Build Farm