Revision: 298 http://opencsw.svn.sourceforge.net/opencsw/?rev=298&view=rev Author: wbonnet Date: 2011-02-19 18:40:53 +0000 (Sat, 19 Feb 2011)
Log Message: ----------- Add last activity to maintainer page Modified Paths: -------------- web/wordpresscsw/wp-content/themes/opencsw/maintainer.php web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php Modified: web/wordpresscsw/wp-content/themes/opencsw/maintainer.php =================================================================== --- web/wordpresscsw/wp-content/themes/opencsw/maintainer.php 2011-02-19 15:59:19 UTC (rev 297) +++ web/wordpresscsw/wp-content/themes/opencsw/maintainer.php 2011-02-19 18:40:53 UTC (rev 298) @@ -8,13 +8,16 @@ <?php // Create the DAO object $maintDAO = new maintainersDAO(); + $qaDAO = new qaDAO(); // Connect to database $maintDAO->connect(); + $qaDAO->connect(); // Retrieve the information from the database $maintainerLogin = $wp_query->get('maintainerName'); $arrayInfo = $maintDAO->getMaintainerInformation($maintainerLogin); + $lastActivityInfo = $qaDAO->getMaintainerLastUnstableSubmitDate($maintainerLogin); $maintainerFullName = $arrayInfo[1] ; $maintainerStatus = $arrayInfo[2] ; @@ -50,6 +53,9 @@ print "<tr>\n" ; print "<th>Bug tracking</th><td><a href=/buglist/maintainer.cgi?maintainer='" . $maintainerLogin . "'>List of open/relevant bugs for " . $maintainerFullName . "</a>\n" ; print "</tr>\n" ; + print "<tr>\n" ; + print "<th>Last activity date</th><td><a href=/package/" . $lastActivityInfo[0]["software"] . ">" . $lastActivityInfo[0]["software"] . "</a> has been added to unstable on " . $lastActivityInfo[0]["date"] . "</td>\n" ; + print "</tr>\n" ; print "</tbody>"; print "</table>"; Modified: web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php =================================================================== --- web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php 2011-02-19 15:59:19 UTC (rev 297) +++ web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php 2011-02-19 18:40:53 UTC (rev 298) @@ -463,5 +463,35 @@ // Return the array to the caller return $output; // Return the array to the caller } + + // ----------------------------------------------------------------------------------------------------------------------- + // + // Get the last submission date of a maintainer. This is the date he last submitted to unstable + // + // ----------------------------------------------------------------------------------------------------------------------- + function getMaintainerLastUnstableSubmitDate($maintName) { + + // Define the query used to retrieve the packages from the database + $sqlQuery = "select p.software , h.HIST_VERSION_DATE from UWATCH_VERSION_HISTORY as h , UWATCH_PKG_VERSION as v , packages as p where p.maintlogin = '" . $maintName . "' and p.software = v.PKG_CATALOGNAME and v.ID_PKG = h.ID_PKG and h.HIST_VERSION_TYPE = 'unstable' order by h.HIST_VERSION_DATE desc limit 1 ; "; + + // Execute the query to retrieve the row to update + $this->execQuery($sqlQuery); + + // Return value + $output = array(); // Array used to store the output + $idxCount = 0; // Index on the current line in the array + + // Check if there is a result + while ($row = mysql_fetch_row($this->result)) { + $output[$idxCount] = array( // Copy the current row into the array of results + "software" => $row[0], // Copy the field into the array of results + "date" => $row[1] // Copy the field into the array of results + ); + $idxCount++; // Increase the index + } + + // Return the array to the caller + return $output; // Return the array to the caller + } } ?> 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