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

[dmichelsen at users.sourceforge.net]

Revision: 664
          http://sourceforge.net/p/opencsw/code/664
Author:   dmichelsen
Date:     2013-09-13 16:20:27 +0000 (Fri, 13 Sep 2013)
Log Message:
-----------
Add section on qa maintainer pages for active maintainers without packages

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

Modified: web/wordpresscsw/wp-content/themes/opencsw/maintainersDAO.php
===================================================================
--- web/wordpresscsw/wp-content/themes/opencsw/maintainersDAO.php	2013-05-22 14:22:49 UTC (rev 663)
+++ web/wordpresscsw/wp-content/themes/opencsw/maintainersDAO.php	2013-09-13 16:20:27 UTC (rev 664)
@@ -352,6 +352,37 @@
 
     // -----------------------------------------------------------------------------------------------------------------------
     //
+    // Get information about "active" maintainers (who signed up) but never released a package
+    //
+    // -----------------------------------------------------------------------------------------------------------------------
+    function getListOfActiveMaintainersWithoutPackages() {
+
+        // Define the query used to retrieve the packages from the database
+        $sqlQuery  = "select m.fullname, m.maintainer, m.status from maintainers as m where (select count(*) from packages as p where p.maintlogin = m.maintainer) = 0 order by m.fullname asc" ;
+    
+        // 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
+                "fullname"        => $row[0],                   // Copy the field into the array of results
+                "maintainer"      => $row[1],
+                "status"          => $row[2],
+            );
+            $idxCount++;                                        // Increase the index
+        }
+
+        // Return the array to the caller
+        return $output;                                         // Return the array to the caller
+    }
+
+    // -----------------------------------------------------------------------------------------------------------------------
+    //
     // Get the list of former maintainers
     //
     // -----------------------------------------------------------------------------------------------------------------------

Modified: web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers.php
===================================================================
--- web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers.php	2013-05-22 14:22:49 UTC (rev 663)
+++ web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers.php	2013-09-13 16:20:27 UTC (rev 664)
@@ -12,6 +12,7 @@
 
     // Retrieve the statistics from the database
     $arrayActiveMaint   = $maintDAO->getListOfActiveMaintainersWithPackageCount();
+    $arrayNopkgMaint    = $maintDAO->getListOfActiveMaintainersWithoutPackages();
     $arrayRetiredMaint  = $maintDAO->getListOfRetiredMaintainersWithPackageCount();
 
     // Disconnect from the database
@@ -51,6 +52,37 @@
                     ?>
                     </tbody>
                 </table>
+
+                <h3>QA pages active maintainers without packages</h3>
+                <span>
+                The following list provides direct access link to the QA pages of each active maintainers who s not owning any packages.
+                </span>
+                <br>
+                <br>
+                <table border="0">
+                    <tbody class="maintainer-list">
+                    <?php 
+                        print "<tr>\n" ;
+                        for( $i = 0 ; $i < count($arrayNopkgMaint) ; $i++) {
+                            $maint = $arrayNopkgMaint[$i] ;         // Get the current row
+                            print "<td width=\"20%\"><a title='" . $maint["fullname"] . "' href='/qa/maintainer/" . $maint["maintainer"] . "'>" . $maint["fullname"] . "</a></td>\n"; 
+                            if ( ( ($i +1)  % 3 == 0) && ( $i <> 0 ) )  {
+                                print "</tr>\n" ;
+                                print "<tr>\n" ;
+                            } else {
+                                if (count($arrayMaint) == 1)   {
+                                    print "</tr>\n" ;
+                                } else {
+                                    if ( $i == ( count($arrayMaint) - 1 ) )  {
+                                        print "</tr>\n" ;
+                                    }
+                                }
+                            }
+                        } 
+                    ?>
+                    </tbody>
+                </table>
+
                 <h3>QA pages of retired maintainers</h3>
                 <span>
                 The following list provides direct access link to the QA pages of each retired maintainers who are still owning at least 1 package. The package owned by retired mainainters are declared as orphaned and available for takeover.

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.