[Dehs-devel] r101 - trunk/www
atomo64-guest at alioth.debian.org
atomo64-guest at alioth.debian.org
Tue Jan 29 01:26:15 UTC 2008
Author: atomo64-guest
Date: 2008-01-29 01:26:15 +0000 (Tue, 29 Jan 2008)
New Revision: 101
Modified:
trunk/www/maintainer.php
Log:
Make it display the lastcheck information (also changed the text for lastupvsdebsync)
Use standard English decimal and thousands separators
Modified: trunk/www/maintainer.php
===================================================================
--- trunk/www/maintainer.php 2008-01-27 17:09:58 UTC (rev 100)
+++ trunk/www/maintainer.php 2008-01-29 01:26:15 UTC (rev 101)
@@ -55,15 +55,15 @@
$maint = pg_escape_string($maint);
$name = pg_escape_string($name);
-$sql=ARRAY(no_watch=>"SELECT id,mpop_inst,name,pkgs.version,pkgs.dist,tot_up_error, tot_avg_error_date,wwiz,wwiz_type,wwiz_version,maint,section,up_changes,up_url,dversionmangled,lastupvsdebsync FROM pkgs INNER JOIN
+$sql=ARRAY(no_watch=>"SELECT id,mpop_inst,name,pkgs.version,pkgs.dist,tot_up_error, tot_avg_error_date,wwiz,wwiz_type,wwiz_version,maint,section,up_changes,up_url,dversionmangled,lastupvsdebsync,lastcheck FROM pkgs INNER JOIN
(Select max(pop_inst) as mpop_inst,SUM(up_error) as tot_up_error,AVG(avg_error_date) as tot_avg_error_date,name,dist FROM binpkgs GROUP BY name,dist HAVING max(pop_inst) IS NOT NULL) as binpkgs using(name,dist)
WHERE (watch IS NULL OR watch='') AND (maint LIKE '$maint' OR uploaders LIKE '%$maint%') AND name LIKE '$name' ORDER BY mpop_inst DESC;",
-no_upstream=>"select id,mpop_inst,name,section,version, tot_up_error, tot_avg_error_date, pkgs.dist,watch_warn,up_changes, up_version,up_url,dversionmangled,lastupvsdebsync from pkgs INNER JOIN (Select max(pop_inst) as mpop_inst,SUM(up_error) as tot_up_error,AVG(avg_error_date) as tot_avg_error_date,name,dist FROM binpkgs GROUP BY name,dist)
+no_upstream=>"select id,mpop_inst,name,section,version, tot_up_error, tot_avg_error_date, pkgs.dist,watch_warn,up_changes, up_version,up_url,dversionmangled,lastupvsdebsync,lastcheck from pkgs INNER JOIN (Select max(pop_inst) as mpop_inst,SUM(up_error) as tot_up_error,AVG(avg_error_date) as tot_avg_error_date,name,dist FROM binpkgs GROUP BY name,dist)
as binpkgs using(name,dist) where up_version='' AND watch!='' AND (maint LIKE '$maint' OR uploaders LIKE '%$maint%') AND name LIKE '$name' order by mpop_inst desc;",
-no_updated=>"Select id,mpop_inst,name,section,version,tot_up_error,tot_avg_error_date,pkgs.dist,up_version,watch_warn, up_changes,up_url,dversionmangled,lastupvsdebsync from pkgs
+no_updated=>"Select id,mpop_inst,name,section,version,tot_up_error,tot_avg_error_date,pkgs.dist,up_version,watch_warn, up_changes,up_url,dversionmangled,lastupvsdebsync,lastcheck from pkgs
INNER join (Select max(pop_inst) as mpop_inst,SUM(up_error) as tot_up_error,AVG(avg_error_date) as tot_avg_error_date,name,dist FROM binpkgs GROUP BY name,dist) as binpkgs using(name,dist)
where updated='0' AND up_version!='' AND (maint LIKE '$maint' OR uploaders LIKE '%$maint%') AND name LIKE '$name'
-order by mpop_inst desc;",ok=>"Select id,mpop_inst,name,section,version,tot_up_error,tot_avg_error_date,pkgs.dist,up_version,watch_warn, up_changes,up_url,dversionmangled,lastupvsdebsync from pkgs
+order by mpop_inst desc;",ok=>"Select id,mpop_inst,name,section,version,tot_up_error,tot_avg_error_date,pkgs.dist,up_version,watch_warn, up_changes,up_url,dversionmangled,lastupvsdebsync,lastcheck from pkgs
INNER join (Select max(pop_inst) as mpop_inst,SUM(up_error) as tot_up_error,AVG(avg_error_date) as tot_avg_error_date,name,dist FROM binpkgs GROUP BY name,dist) as binpkgs using(name,dist)
where updated='1' AND (maint LIKE '$maint' OR uploaders LIKE '%$maint%') AND name LIKE '$name' AND (up_version != '' AND up_version IS NOT NULL)
order by mpop_inst desc;");
@@ -86,16 +86,16 @@
<p><big> <?php
switch ($key) {
case "no_watch":
- print "$totrs <b>packages without a watch file</b>, <b>share: </b> " . number_format ( $totrs/$totpkgs[0] * 100, 2, ",",".") . "%<br>" ;
+ print "$totrs <b>packages without a watch file</b>, <b>share: </b> " . number_format ( $totrs/$totpkgs[0] * 100, 2) . "%<br>" ;
break;
case "no_upstream":
- print "$totrs <b>packages without a checkable upstream</b>, <b>share: </b> " . number_format ( $totrs/$totpkgs[0] * 100, 2, ",",".") . "%<br>" ;
+ print "$totrs <b>packages without a checkable upstream</b>, <b>share: </b> " . number_format ( $totrs/$totpkgs[0] * 100, 2) . "%<br>" ;
break;
case "no_updated":
- print "$totrs <b>packages with newer upstream release</b>, <b>share: </b> " . number_format ( $totrs/$totpkgs[0] * 100, 2, ",",".") . "%<br>" ;
+ print "$totrs <b>packages with newer upstream release</b>, <b>share: </b> " . number_format ( $totrs/$totpkgs[0] * 100, 2) . "%<br>" ;
break;
case "ok":
- print "$totrs <b>packages up-to-date</b>, <b>share: </b> " . number_format ( $totrs/$totpkgs[0] * 100, 2, ",",".") . "%<br>" ;
+ print "$totrs <b>packages up-to-date</b>, <b>share: </b> " . number_format ( $totrs/$totpkgs[0] * 100, 2) . "%<br>" ;
break;
} ?>
</big></td>
@@ -149,7 +149,8 @@
echo ' (mangled: <i>' . htmlentities($res_array["dversionmangled"]) . '</i>)';
}
?></li>
-<li><b>Last time package was found as updated: </b><? echo htmlentities($res_array['lastupvsdebsync']); ?></li>
+<li><b>Last time checked: </b><? echo htmlentities($res_array['lastcheck']); ?></li>
+<li><b>Last time found as updated: </b><? echo htmlentities($res_array['lastupvsdebsync']); ?></li>
<li><b>Tot Upstream Bugs: </b><? if ($res_array["tot_up_error"]) echo "<a href='http://bugs.debian.org/cgi-bin/pkgreport.cgi?pkg=".urlencode($res_array["name"]).";dist=".urlencode($res_array["dist"]).";tag=upstream'>"; print number_format($res_array["tot_up_error"] ,0); if ($res_array["tot_up_error"]) echo '</a>'; ?></li>
<li><b>Avg days opened: </b><? print number_format($res_array["tot_avg_error_date"],0); ?></li>
<li><b>Distrib: </b><? printf('<a href="http://packages.debian.org/%1$s/%2$s">%1$s</a>',$res_array["dist"],$res_array["name"]); ?></li>
More information about the Dehs-devel
mailing list