[csw-devel] SF.net SVN: opencsw:[326] web/wordpresscsw/wp-content/themes/opencsw

wbonnet at users.sourceforge.net wbonnet at users.sourceforge.net
Thu Feb 24 00:34:07 CET 2011


Revision: 326
          http://opencsw.svn.sourceforge.net/opencsw/?rev=326&view=rev
Author:   wbonnet
Date:     2011-02-23 23:34:07 +0000 (Wed, 23 Feb 2011)

Log Message:
-----------
Add pending packages in GAR

Modified Paths:
--------------
    web/wordpresscsw/wp-content/themes/opencsw/qa.php
    web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php

Added Paths:
-----------
    web/wordpresscsw/wp-content/themes/opencsw/qa-gar-pending.php

Added: web/wordpresscsw/wp-content/themes/opencsw/qa-gar-pending.php
===================================================================
--- web/wordpresscsw/wp-content/themes/opencsw/qa-gar-pending.php	                        (rev 0)
+++ web/wordpresscsw/wp-content/themes/opencsw/qa-gar-pending.php	2011-02-23 23:34:07 UTC (rev 326)
@@ -0,0 +1,133 @@
+<?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>Overview of packages in GAR</h2>";
+    print     "<div class=\"entry\">";
+    print     "<span>The following list contains all the packages available from GAR which have not yet been release to unstable catalog.<span>" ;
+
+    // Retrieve the statistics from the database
+    $arrayPkg = $qaDAO->getListOfGarPendingPackages();
+
+    // Disconnect from the database
+    $template      = "/wp-content/themes/opencsw";
+
+    print "<h3>Packages ( " . count($arrayPkg) . " )</h3>";
+    print "<span>The list of packages uses several icons. Here are the meanings of each icon that may be displayed below :</span>";
+    print "<br>";
+    print "<ul>";
+    print "<img src=\"$template/img/uwatch-missing.png\" title=\"Package is not in GAR.\" alt=\"-\"/> Package is not in GAR";
+    print "<br>";
+    print "<img src=\"$template/img/uwatch-deactivated.png\" title=\"uWatch is not activated. Information about upstream version not available\" alt=\"-\"/> uWatch is not activated. Information about upstream version not available";
+    print "<br>";
+    print "<img src=\"$template/img/uwatch-error.png\" title=\"uWatch reported an error while checking upstream site\" alt=\"X\"/> uWatch reported an error while checking upstream site";
+    print "<br>";
+    print "</ul>";
+    print "<table border=\"0\">";
+    print "<tbody  class=\"package-list\">";
+    print "<tr>";
+    print "<th rowspan=\"2\">Software name</th><th colspan=\"2\" class=\"package-list-cell\">Version</th><th rowspan=\"2\" class=\"package-list-cell\">Lutefisk</th><th rowspan=\"2\" class=\"package-list-cell\">uBuild</th><th rowspan=\"2\" class=\"package-list-cell\">CheckPkg</th>";
+    print "</tr>";
+    print "<tr>";
+    print "<th class=\"package-list-cell\">GAR</th><th>Upstream</th>";
+    print "</tr>";
+
+    // Initialize global counter
+    $upgradablePackages = 0;
+    $packageToRelease   = 0;
+
+    for( $i = 0 ; $i < count($arrayPkg) ; $i++) {
+        $package          = $arrayPkg[$i] ;                                                 // Get the current row
+        $versionInfoArray = $qaDAO->getPackageVersionInformation($package["software"]);     // Retrieve version information from uwatch db
+        $versionInfo      = $versionInfoArray[0];
+        print "<tr>\n" ;
+        print "<td><a title='" . $package["software"] . "' href='/qa/package/" ;
+        print $package["software"] . "'>" . $package["software"] . "</a></td>";
+
+        // Replace empty version by a -
+        $garVersion      = empty($versionInfo["garVersion"])      ? "-" : $versionInfo["garVersion"];
+        $upstreamVersion = empty($versionInfo["upstreamVersion"]) ? "-" : $versionInfo["upstreamVersion"];
+
+        if ( ( $garVersion <> $unstableVersion )  && ( ! empty($versionInfo["garVersion"]) ) ) {
+            $packageToRelease++;   
+        }
+
+        // Test if the package exists in gar
+        if ( $versionInfo["garPath"] == "") {
+            print "<td class=\"package-list-cell\" colspan=\"2\"><img src=\"$template/img/uwatch-missing.png\" title=\"Package " . $package["software"] . " is not in GAR.\" alt=\"-\"/></td>\n" ;     
+        } else {
+            // Test if uwatch is deactived
+            if ( $versionInfo["uwatchActivated"] != 1) {
+                // Yes thus display GAR info and deactivated icon
+                print "<td class=\"package-list-cell\">" . $garVersion . "</td>\n" ;               // GAR
+                print "<td class=\"package-list-cell\"><img src=\"$template/img/uwatch-deactivated.png\" title=\"uWatch is not activated. Information about upstream version not available\" alt=\"-\"/></td>\n" ;     
+            } else {
+                // Uwatch is actived, check if there is an error
+                if ( $versionInfo["lastUpstreamCheckStatus"] != 1) {
+                    // Yes thus display GAR info and deactivated icon
+                    print "<td class=\"package-list-cell\">" . $garVersion . "</td>\n" ;               // GAR
+                    print "<td class=\"package-list-cell\"><img src=\"$template/img/uwatch-error.png\" title=\"uWatch reported an error while checking upstream site\" alt=\"X\"/></td>\n" ;     
+                } else {
+                    // Display gar version information
+                    if ( ( $garVersion == $upstreamVersion ) && ( ! empty($versionInfo["garVersion"]) ) ) {
+                        print "<td colspan=\"2\" class=\"package-list-cell\">" . $upstreamVersion . "</td>\n" ;          // Same for GAR and upstream
+                    } else {
+                        print "<td class=\"package-list-cell\">" . $garVersion . "</td>\n" ;               // GAR
+                        print "<td class=\"package-list-cell\"><a title='" . $upstreamVersion . " upstream site' href='" . $package["vendorurl"] ;
+                        print "'>" . $upstreamVersion . "</a></td>\n" ;          // Upstream
+                        if ( ! empty($versionInfo["garVersion"]) ) {
+                            $upgradablePackages++;
+                        }
+                    }
+                }
+            }
+        }
+        print "<td class=\"package-list-cell\">-</td>\n" ;          // Lutefisk
+        print "<td class=\"package-list-cell\">-</td>\n" ;          // bBuild
+        print "<td class=\"package-list-cell\">-</td>\n" ;          // Checkpkg
+        print "</tr>\n" ;
+    }
+
+    // Display total bugs
+    print "<tr>\n" ;
+    print "<td>Total</td>";
+    // Display the counters in the page
+    print "<td class=\"package-list-cell\">" . $totalCritical . "</td>\n" ;       // Critical
+    print "<td class=\"package-list-cell\">" . $totalMajor . "</td>\n" ;          // Major
+    print "<td class=\"package-list-cell\">" . $totalMinor . "</td>\n" ;          // Minor
+    print "<td class=\"package-list-cell\">" . $totalTweak . "</td>\n" ;          // Tweak
+
+    // Display catalog version information
+    print "<td class=\"package-list-cell\" colspan=\"3\">To release : $packageToRelease</td>\n" ;            // Stable
+    print "<td class=\"package-list-cell\" colspan=\"2\">Upgradable : $upgradablePackages</td>\n" ;            // Stable
+    print "<td class=\"package-list-cell\" colspan=\"3\"></td>\n" ;            // Stable
+    print "</tr>\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(); ?>

Modified: web/wordpresscsw/wp-content/themes/opencsw/qa.php
===================================================================
--- web/wordpresscsw/wp-content/themes/opencsw/qa.php	2011-02-23 23:11:00 UTC (rev 325)
+++ web/wordpresscsw/wp-content/themes/opencsw/qa.php	2011-02-23 23:34:07 UTC (rev 326)
@@ -66,6 +66,12 @@
                         <a title='Packages missing from GAR repository' href='/qa/packages/gar/missing'>Packages missing from GAR repository</a>
                     </li>
                 </ul>
+                <span>The following link displays the complete list of packages pending in the GAR repository. These packages have not yet been published to unstable catalog.</span>
+                <ul>
+                    <li>
+                        <a title='Packages pending in the GAR repository' href='/qa/packages/gar/pending'>Packages pending in the GAR repository</a>
+                    </li>
+                </ul>
                 <span>The following links displays the complete list of packages with uWatch issues. The build descriptions of these packages should be fixed to solves errors reported.</span>
                 <ul>
                     <li>

Modified: web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php
===================================================================
--- web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php	2011-02-23 23:11:00 UTC (rev 325)
+++ web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php	2011-02-23 23:34:07 UTC (rev 326)
@@ -493,5 +493,36 @@
         // Return the array to the caller
         return $output;                                      // Return the array to the caller
     }
+
+    // -----------------------------------------------------------------------------------------------------------------------
+    //
+    // Get information about a maintainer
+    //
+    // -----------------------------------------------------------------------------------------------------------------------
+    function getListOfGarPendingPackages() {
+
+        // Define the query used to retrieve the packages from the database
+        $sqlQuery  = "select PKG_CATALOGNAME, PKG_GAR_VERSION from UWATCH_PKG_VERSION where PKG_GAR_PATH is not null and PKG_UNSTABLE_VERSION is null and PKG_TESTING_VERSION is null and PKG_STABLE_VERSION is null order by PKG_CATALOGNAME" ;
+    
+        // 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
+                "stream_version"        => $row[1]
+            );
+            $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.


More information about the devel mailing list