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

[wbonnet at users.sourceforge.net]

Revision: 307
          http://opencsw.svn.sourceforge.net/opencsw/?rev=307&view=rev
Author:   wbonnet
Date:     2011-02-21 10:58:07 +0000 (Mon, 21 Feb 2011)

Log Message:
-----------
Fix the default no information message

Modified Paths:
--------------
    web/wordpresscsw/wp-content/themes/opencsw/maintainer.php
    web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.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-21 10:40:40 UTC (rev 306)
+++ web/wordpresscsw/wp-content/themes/opencsw/maintainer.php	2011-02-21 10:58:07 UTC (rev 307)
@@ -58,9 +58,13 @@
         print         "</tr>\n" ;
         print         "<tr>\n" ;
 	if ($lastActivityInfo[0]["date"] != "")  {
-       		print             "<th>Last packaging activity</th><td><a href=/package/" . $lastActivityInfo[0]["software"] . ">" . $lastActivityInfo[0]["software"] . "</a> has been added to unstable on " .  $lastActivityInfo[0]["date"] . "</td>\n" ;
+                if ( $lastActivityInfo[0]["date"] == "2009-10-14") {
+                     print "<th>Last packaging activity</th><td>No information available</td>";
+ 		} else {
+       			print             "<th>Last packaging activity</th><td><a href=/package/" . $lastActivityInfo[0]["software"] . ">" . $lastActivityInfo[0]["software"] . "</a> has been added to unstable on " .  $lastActivityInfo[0]["date"] . "</td>\n" ;
+                } 
  	} else {
-        	print             "<th>Last packaging activity</th><td>No information available</td>\n" ;
+        	print             "<th>Last packaging activity</th><td>The maintainer has no package</td>\n" ;
 	 }
         print         "</tr>\n" ;
         print         "<tr>\n" ;

Modified: web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.php
===================================================================
--- web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.php	2011-02-21 10:40:40 UTC (rev 306)
+++ web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.php	2011-02-21 10:58:07 UTC (rev 307)
@@ -34,7 +34,7 @@
     print "<table border=\"0\">";
     print "<tbody  class=\"package-list\">";
     print "<tr>";
-    print "<th>Name</th><th>Last packaging activity</th><th>Most recently updated package</th><th>Last bug tracker activity</th>\n" ;
+    print "<th>Name</th><th>Last packaging activity</th><th>Last bug tracker activity</th>\n" ;
     print "</tr>";
     $totalPkg = 0;
     for( $i = 0 ; $i < count($arrayMaint) ; $i++) {
@@ -42,11 +42,16 @@
         $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";
+            print "<td><a title='" . $maint["fullname"] . "' href='/maintainers/" . $maint["maintainer"] . "'>" . $maint["fullname"] . "</a></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";
+	        if ( $lastActivityInfo[0]["date"] == "2009-10-14") {
+       		     print "<td><a title='" . $maint["fullname"] . "' href='/maintainers/" . $maint["maintainer"] . "'>" . $maint["fullname"] . "</a></td><td>No activity information</td>\n";
+       	 	} else  {
+            		print "<td><a title='" . $maint["fullname"] . "' href='/maintainers/" . $maint["maintainer"] . "'>" . $maint["fullname"] . "</a></td><td>" . $lastActivityInfo[0]["date"] . " (<a href=/package/" . $lastActivityInfo[0]["software"] . ">" . $lastActivityInfo[0]["software"] . "</a>)</td>\n";
+        	}
         }
-        print "<td></td>";
+        print "<td>No bug tracker activity information</td>";
+        print "</tr>";
     }
 
     // Close table

Modified: web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php
===================================================================
--- web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php	2011-02-21 10:40:40 UTC (rev 306)
+++ web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php	2011-02-21 10:58:07 UTC (rev 307)
@@ -472,7 +472,7 @@
     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 ; ";
+        $sqlQuery  = "select p.software , date(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);


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