[Dehs-devel] r160 - trunk/www
atomo64-guest at alioth.debian.org
atomo64-guest at alioth.debian.org
Sun Oct 19 22:17:02 UTC 2008
Author: atomo64-guest
Date: 2008-10-19 22:17:02 +0000 (Sun, 19 Oct 2008)
New Revision: 160
Modified:
trunk/www/no_updated.php
trunk/www/no_upstream.php
trunk/www/no_watch.php
Log:
Use width: auto, reduce clutter, drop .diff.gz size, add link to per-package report
Modified: trunk/www/no_updated.php
===================================================================
--- trunk/www/no_updated.php 2008-09-25 01:24:54 UTC (rev 159)
+++ trunk/www/no_updated.php 2008-10-19 22:17:02 UTC (rev 160)
@@ -33,7 +33,7 @@
<?
require("config_www.inc");
$rsql=pg_exec($db,
-"Select id,pkgs.pop_inst,name,version,bytes, tot_up_error,tot_avg_error_date,pkgs.dist,up_version,watch_warn, up_changes,dversionmangled from pkgs
+"Select id,pkgs.pop_inst,name,version, tot_up_error,tot_avg_error_date,pkgs.dist,up_version,watch_warn, up_changes,dversionmangled from pkgs
INNER join (Select 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!=''
order by pop_inst desc;") OR Die("Error on query");;
@@ -44,7 +44,7 @@
<b>Total with upstream found:</b> $totpkgs[0] <b>Percentage: </b> " . number_format ( $totnowatch/$totpkgs[0] * 100, 2, ",",".") . "%" ;
?>
<table
- style="width: 50%; text-align: left; margin-left: auto; margin-right: auto;"
+ style="width: auto; text-align: left; margin-left: auto; margin-right: auto;"
border="1" cellspacing="2" cellpadding="2">
<tbody>
<tr>
@@ -53,11 +53,10 @@
<td style="vertical-align: top;text-align: center; font-weight: bold;">Name</td>
<td style="vertical-align: top; text-align: center; font-weight: bold;">Upstream Version</td>
<td style="vertical-align: top; text-align: center; font-weight: bold;">Debian Version</td>
- <td style="vertical-align: top; text-align: left; font-weight: bold;">Source Size (KB)</td>
<td style="vertical-align: top; text-align: center; font-weight: bold;">Tot Upstream Bugs</td>
- <td style="vertical-align: top; text-align: center; font-weight: bold;">Avg days opened</td>
+ <td style="vertical-align: top; text-align: center; font-weight: bold;">Avg days open</td>
<td style="vertical-align: top; text-align: center; font-weight: bold;">Distrib</td>
- <td style="vertical-align: top;text-align: center; font-weight: bold;">Uscan Errors processing Watch File</td>
+ <td style="vertical-align: top;text-align: center; font-weight: bold;">Uscan warnings</td>
</tr>
<?
while ($res_array=pg_fetch_array($rsql)) {
@@ -65,20 +64,19 @@
<tr>
<td style="vertical-align: top;"><? print $res_array["pop_inst"]; ?><br>
</td>
- <td style="vertical-align: top;"><? print $res_array["name"]; ?><br>
+ <td style="vertical-align: top;"><a href="/report.php?package=<? print urlencode($res_array["name"]); ?>"><? print htmlentities($res_array["name"]); ?></a><br>
</td>
<td style="vertical-align: top;">
<? if ($res_array[up_changes]!='') { ?>
- <a href="<? print "wwiz_detail.php?id=$res_array[id]&type=up_changes";?>">
+ <a href="<? print "wwiz_detail.php?id=$res_array[id]&type=up_changes";?>">
<? print htmlentities($res_array["up_version"]); ?></a><br>
<?}
else print $res_array["up_version"].'<br>';?>
</td>
<td style="vertical-align: top;"><? print $res_array["version"]; if ($res_array["dversionmangled"] != $res_array["version"]) {
- echo ' (mangled: <i>' . htmlentities($res_array["dversionmangled"]) . '</i>)';
+ echo ' (mangled: <i>' . htmlentities($res_array["dversionmangled"]) . '</i>)';
} ?><br>
</td>
- <td style="vertical-align: top;"><? print number_format ($res_array[bytes]/1024, 0); ?><br></td>
<td style="vertical-align: top;"><? print number_format($res_array["tot_up_error"] ,0); ?><br>
</td>
<td style="vertical-align: top;"><? print number_format($res_array["tot_avg_error_date"],0); ?><br>
Modified: trunk/www/no_upstream.php
===================================================================
--- trunk/www/no_upstream.php 2008-09-25 01:24:54 UTC (rev 159)
+++ trunk/www/no_upstream.php 2008-10-19 22:17:02 UTC (rev 160)
@@ -14,7 +14,7 @@
<?include("menu.inc");?>
<?
require "config_www.inc";
-$rsql=pg_exec($db, "select pkgs.pop_inst,name,tot_up_error, tot_avg_error_date, pkgs.dist,watch_warn from pkgs INNER JOIN (Select 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 watch_warn !='' order by pop_inst desc;");
+$rsql=pg_exec($db, "select pkgs.pop_inst,name,tot_up_error, tot_avg_error_date, pkgs.dist,watch_warn,failures_count from pkgs INNER JOIN (Select 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 watch_warn !='' order by pop_inst desc;");
$rsql2=pg_exec($db, "SELECT count(name) from pkgs WHERE watch is not null");
$totnowatch=pg_numrows($rsql);
$totpkgs=pg_fetch_array($rsql2);
@@ -23,7 +23,7 @@
?>
<table
- style="width: 50%; text-align: left; margin-left: auto; margin-right: auto;"
+ style="width: auto; text-align: left; margin-left: auto; margin-right: auto;"
border="1" cellspacing="2" cellpadding="2">
<tbody>
<tr>
@@ -31,12 +31,14 @@
style="vertical-align: top; text-align: left; font-weight: bold;">Pop Inst</td>
<td style="vertical-align: top;"><span style="font-weight: bold;">Name</span>
<td
- style="vertical-align: top; text-align: left; font-weight: bold;">Opened upstream bugs</td>
+ style="vertical-align: top; text-align: left; font-weight: bold;">Open upstream bugs</td>
<td
- style="vertical-align: top; text-align: left; font-weight: bold;">Avg days opened</td>
+ style="vertical-align: top; text-align: left; font-weight: bold;">Avg days open</td>
+ <td
+ style="vertical-align: top; text-align: left; font-weight: bold;">Continuous failures</td>
<td
style="vertical-align: top; text-align: left; font-weight: bold;">Distrib</td>
- <td style="vertical-align: top;"><span style="font-weight: bold;">Uscan Errors processing Watch File</span>
+ <td style="vertical-align: top;"><span style="font-weight: bold;">Uscan warnings</span>
<br>
</td>
</tr>
@@ -46,14 +48,16 @@
<tr>
<td style="vertical-align: top;"><? print $res_array["pop_inst"]; ?><br>
</td>
- <td style="vertical-align: top;"><? print $res_array["name"]; ?><br>
+ <td style="vertical-align: top;"><a href="/report.php?package=<? print urlencode($res_array["name"]); ?>"><? print htmlentities($res_array["name"]); ?></a><br>
</td>
<td style="vertical-align: top;"><? print number_format($res_array["tot_up_error"],0); ?><br>
</td>
<td style="vertical-align: top;"><? print number_format($res_array["tot_avg_error_date"],0); ?><br>
</td>
- <td style="vertical-align: top;"><? print $res_array["dist"]; ?><br>
+ <td style="vertical-align: top;"><? print number_format($res_array["failures_count"],0); ?><br>
</td>
+ <td style="vertical-align: top;"><? print htmlentities($res_array["dist"]); ?><br>
+ </td>
<td style="vertical-align: top;"><? print htmlentities($res_array["watch_warn"]); ?><br>
</td>
</tr>
Modified: trunk/www/no_watch.php
===================================================================
--- trunk/www/no_watch.php 2008-09-25 01:24:54 UTC (rev 159)
+++ trunk/www/no_watch.php 2008-10-19 22:17:02 UTC (rev 160)
@@ -31,7 +31,7 @@
Source packages that need watch files - Sorted by popularity<br><br>
<?include("menu.inc");?>
<?
- $sqlstring="SELECT id,pkgs.pop_inst,name,pkgs.version,pkgs.dist,tot_up_error, bytes, tot_avg_error_date,wwiz,wwiz_type,wwiz_version,up_changes FROM pkgs INNER JOIN
+ $sqlstring="SELECT id,pkgs.pop_inst,name,pkgs.version,pkgs.dist,tot_up_error, tot_avg_error_date,wwiz,wwiz_type,wwiz_version,up_changes FROM pkgs INNER JOIN
(Select 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 watch IS NULL OR watch='' ORDER BY pop_inst DESC";
require "config_www.inc";
@@ -71,9 +71,8 @@
<td style="text-align: left; font-weight: bold;">Name</td>
<td style="text-align: left; font-weight: bold;">WWizard Version</td>
<td style="text-align: left; font-weight: bold;">Debian Version</td>
-<td style="text-align: left; font-weight: bold;">Source Size (KB)</td>
<td style="text-align: center; font-weight: bold;">Tot Upstream Bugs</td>
-<td style="text-align: center; font-weight: bold;">Avg days opened</td>
+<td style="text-align: center; font-weight: bold;">Avg days open</td>
<td style="text-align: left; font-weight: bold;">Dist</td>
<td style="text-align: left; font-weight: bold;">Watch Wizard</td>
</tr>
@@ -82,7 +81,7 @@
?>
<tr>
<td><? print $res_array["pop_inst"]; ?><br></td>
-<td><? print $res_array["name"]; ?><br></td>
+<td><a href="/report.php?package=<? print urlencode($res_array["name"]); ?>"><? print htmlentities($res_array["name"]); ?></a><br></td>
<td>
<? if ($res_array[up_changes]!='' AND is_updated($res_array["wwiz_version"],$res_array["version"])) { ?>
<a href="<? print "wwiz_detail.php?id=$res_array[id]&type=up_changes";?>"><? print htmlentities($res_array["wwiz_version"]); ?></a><br>
@@ -90,7 +89,6 @@
else print htmlentities($res_array["wwiz_version"]).'<br>';?>
</td>
<td><? print htmlentities($res_array["version"]); ?><br></td>
-<td><? print number_format ($res_array[bytes]/1024, 0, ",","."); ?><br></td>
<td><? print number_format($res_array["tot_up_error"],0); ?><br>
</td>
<td><? print number_format($res_array["tot_avg_error_date"],0); ?><br>
More information about the Dehs-devel
mailing list