Revision: 301
http://opencsw.svn.sourceforge.net/opencsw/?rev=301&view=rev
Author: wbonnet
Date: 2011-02-20 09:32:16 +0000 (Sun, 20 Feb 2011)
Log Message:
-----------
Push maintainer activity QA page
Added Paths:
-----------
web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.php
Added: web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.php
===================================================================
--- web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.php
(rev 0)
+++ web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.php
2011-02-20 09:32:16 UTC (rev 301)
@@ -0,0 +1,63 @@
+<?php
+/*
+Template Name: Maintainer detail
+*/
+?>
+
+<?php get_header(); ?>
+<?php
+ // Create the DAO object
+ $maintDAO = new maintainersDAO();
+ $qaDAO = new qaDAO();
+
+ // Connect to database
+ $maintDAO->connect();
+ $qaDAO->connect();
+
+ print "<div id=\"container\">";
+ print "<div id=\"content\">";
+ print "<div class=\"post hentry\">";
+ print "<h2>Last maintainer activity overview</h2>";
+ print "<div class=\"entry\">";
+ print "<span>The following list displays the last activity overview of
each maintainer. The purpose of this QA page is to detected maintainers who
potentially retired. The date display for each maintainer is the last time a
package from this maintainer has been added to unstable catalog. Maintainers
may have submited package in the meantime. Activity date is updated only when
pacakge is available in the unstable catalog, and not when a package is
submited.</span>";
+ print "<br>";
+ print "<br>";
+ print "<span>Please note that since this page does not take in account
all the possible form of activity of a maintainer, it is only informative.
Meanwhile, publishing date in unstable catalog is a fairly good indicator if it
is considered over a few months. Maintainers with no package release over
several months are being contacted by the board for status update.</span>" ;
+
+ // Retrieve the statistics from the database
+ $arrayMaint = $maintDAO->getListOfActiveMaintainers();
+
+ // Disconnect from the database
+ $maintDAO->disconnect();
+
+ print "<h3>Maintainers ( " . count($arrayMaint) . " )</h3>";
+ print "<table border=\"0\">";
+ print "<tbody class=\"package-list\">";
+ print "<tr>";
+ print "<th>Name</th><th>Last activity date</th><th>Package</th>\n" ;
+ print "</tr>";
+ $totalPkg = 0;
+ for( $i = 0 ; $i < count($arrayMaint) ; $i++) {
+ $maint = $arrayMaint[$i] ; // Get the current row
+ $lastActivityInfo =
$qaDAO->getMaintainerLastUnstableSubmitDate($maint["maintainer"]);
+ print "<tr>";
+ if ( $lastActivityInfo[0]["date"] == "") {
+ print "<td><a title='" . $maint["fullname"] . "'
href='/maintainers/" . $maint["maintainer"] . "'>" . $maint["fullname"] .
"</a></td><td>-</td><td>The maintainer has no package</td>\n";
+ } else {
+ print "<td><a title='" . $maint["fullname"] . "'
href='/maintainers/" . $maint["maintainer"] . "'>" . $maint["fullname"] .
"</a></td><td>" . $lastActivityInfo[0]["date"] . "</td><td><a href=/package/" .
$lastActivityInfo[0]["software"] . ">" . $lastActivityInfo[0]["software"] .
"</a></td>\n";
+ }
+ }
+
+ // Close table
+ print "</tbody>";
+ print "</table>";
+ print "<br>";
+ print "<br>";
+ print "</div>";
+ print "</div>";
+ print "</div><!-- #content -->";
+ print "</div><!-- #container -->";
+?>
+
+<?php get_sidebar(); ?>
+<?php get_footer(); ?>
This was sent by the SourceForge.net collaborative development platform, the
world's largest Open Source development site.
_______________________________________________
devel mailing list
devel@lists.opencsw.org
https://lists.opencsw.org/mailman/listinfo/devel
