cvs: pearweb /public_html/bugs stats.php
| From: | Helgi �ormar �orbj�rnsson | Date: | Tue, 29 Jun 2004 23:06:03 +0000 |
| Subject: | cvs: pearweb /public_html/bugs stats.php | ||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-21280@lists.php.net to get a copy of this message | ||
dufuz Tue Jun 29 19:06:03 2004 EDT
Modified files:
/pearweb/public_html/bugs stats.php
Log:
New color schema and now you can choose the bug type also.
http://cvs.php.net/diff.php/pearweb/public_html/bugs/stats.php?r1=1.17&r2=1.18&ty=u
Index: pearweb/public_html/bugs/stats.php
diff -u pearweb/public_html/bugs/stats.php:1.17 pearweb/public_html/bugs/stats.php:1.18
--- pearweb/public_html/bugs/stats.php:1.17 Tue Jun 29 17:09:49 2004
+++ pearweb/public_html/bugs/stats.php Tue Jun 29 19:06:03 2004
@@ -15,7 +15,7 @@
* @package Bugs
* @copyright Copyright (c) 1997-2004 The PHP Group
* @license http://www.php.net/license/3_0.txt
PHP License
- * @version $Id: stats.php,v 1.17 2004/06/29 21:09:49 dufuz Exp $
+ * @version $Id: stats.php,v 1.18 2004/06/29 23:06:03 dufuz Exp $
*/
/**
@@ -56,6 +56,13 @@
}
+if (empty($_GET['bug_type']) || $_GET['bug_type'] == 'All') {
+ $bug_type = '';
+} else {
+ $bug_type = $_GET['bug_type'];
+ $where_clause .= " AND bug_type = '" . escapeSQL($bug_type) .
"'";
+}
+
$query = 'SELECT p.name FROM packages p '.$sql.$type.$where.' GROUP BY p.name';
$result = $dbh->getAll($query);
@@ -68,10 +75,10 @@
}
}
foreach ($result as $package) {
- $query = 'SELECT bugdb.status, bugdb.package_name
+ $query = 'SELECT status, package_name
FROM bugdb
- WHERE bugdb.package_name =
'.$dbh->quoteSmart($package['name']).'
- GROUP BY bugdb.id';
+ WHERE package_name =
'.$dbh->quoteSmart($package['name']).$where_clause.'
+ GROUP BY id';
$result1 = $dbh->query($query);
$package_name['all'][$package['name']]['total'] = 0;
@@ -155,7 +162,7 @@
if ($grandtotal) {
$entries =& $dbh->getOne('SELECT count(id) AS total FROM bugdb');
$stat_head = '<tr id="bug_header"><td><strong
style="text-align: right;">Total bug entries in system:</strong></td>
- <td style="font-size: 130%;">'.$entries.'</td>';
+ <td style="font-size: 120%;">'.$entries.'</td>';
} else {
$stat_head = '<tr
id="bug_header"><td> </td><td> </td>';
}
@@ -177,14 +184,14 @@
/**
* Fetch list of all categories
*/
-echo "<table>\n";
+echo '<table>'."\n";
$res = category::listAll();
$_SERVER['QUERY_STRING'] ? $query_string = '?' .
$_SERVER['QUERY_STRING'] : '';
-echo '<tr><td colspan="10">
+echo '<tr><td colspan="13">
<form method="get" action="/bugs/stats.php' . $query_string .
'">
<div>
<strong>Category:</strong>
- <select name="category" id="category"
onchange="this.form.submit();">';
+ <select name="category" id="category"
onchange="this.form.submit(); return false;">';
$_GET['category'] == '' ? $selected = '
selected="selected"' : $selected = '';
echo '<option value=""' . $selected .
'>All</option>'."\n";
foreach ($res as $row) {
@@ -193,7 +200,7 @@
}
echo '</select>
<strong>Developer:</strong>
- <select name="developer" id="developers"
onchange="this.form.submit();">'."\n";
+ <select name="developer" id="developers"
onchange="this.form.submit(); return false;">'."\n";
/**
* Fetch list of users/maintainers
@@ -201,15 +208,17 @@
$users = $dbh->query('SELECT u.handle AS handle, u.name AS name FROM users u, maintains m
WHERE u.handle = m.handle
GROUP BY handle ORDER BY u.name');
$_GET['developer'] == '' ? $selected = '
selected="selected"' : $selected = '';
- echo '<option value=""' . $selected . '>Select
user...</option>'."\n";
+ echo '<option value=""' . $selected .
'>All</option>'."\n";
while ($u = $users->fetchRow(DB_FETCHMODE_ASSOC)) {
$_GET['developer'] == $u['handle'] ? $selected = '
selected="selected"' : $selected = '';
echo '<option value="' . $u['handle'] . '"' .
$selected . '>' . $u['name'] . '</option>'."\n";
}
-echo ' </select></div>
- </form>
- </td></tr>' . "\n";
-
+ echo '</select> <strong>Bug Type:</strong><select
id="bug_type" name="bug_type" onchange="this.form.submit(); return
false;">';
+ show_type_options($_GET['bug_type'], true);
+ echo '</select>
+ </div>
+ </form></td></tr></table>' . "\n";
+ echo '<table style="width: 100%;">'."\n";
// Exit if there are no bugs for this version
if ($total == 0) {
@@ -220,16 +229,16 @@
echo display_stat_header($total, true);
-echo '<tr><td
class="bug_head"><strong>All:</strong></td>
+echo '<tr><td
class="bug_head"><strong>All</strong></td>
<td class="bug_bg1">' . $total . '</td>
<td class="bug_bg2">'. bugstats('closed', 'all')
.' </td>
<td class="bug_bg1">'. bugstats('open', 'all')
.' </td>
<td class="bug_bg2">'. bugstats('critical', 'all')
.' </td>
<td class="bug_bg1">'. bugstats('verified', 'all')
.' </td>
- <td class="bug_bg1">'. bugstats('analyzed', 'all')
.' </td>
- <td class="bug_bg2">'. bugstats('assigned', 'all')
.' </td>
- <td class="bug_bg2">'. bugstats('suspended', 'all')
.' </td>
- <td class="bug_bg1">'. bugstats('duplicate', 'all')
.' </td>
+ <td class="bug_bg2">'. bugstats('analyzed', 'all')
.' </td>
+ <td class="bug_bg1">'. bugstats('assigned', 'all')
.' </td>
+ <td class="bug_bg1">'. bugstats('suspended', 'all')
.' </td>
+ <td class="bug_bg2">'. bugstats('duplicate', 'all')
.' </td>
<td class="bug_bg1">'. bugstats('feedback', 'all')
.' </td>
<td class="bug_bg2">'. bugstats('no feedback', 'all')
.' </td>
<td class="bug_bg1">'. bugstats('bogus', 'all')
.' </td>
@@ -243,16 +252,16 @@
echo display_stat_header($total, false);
}
echo '<tr><td class="bug_head">
- <strong>' . package_link($name) . ':</strong></td>
+ <strong>' . package_link($name) . '</strong></td>
<td class="bug_bg1">'.
$package_name['all'][$name]['total'] .'</td>
<td class="bug_bg2">'. bugstats('closed', $name)
.' </td>
<td class="bug_bg1">'. bugstats('open', $name)
.' </td>
<td class="bug_bg2">'. bugstats('critical', $name)
.' </td>
<td class="bug_bg1">'. bugstats('verified', $name)
.' </td>
- <td class="bug_bg1">'. bugstats('analyzed', $name)
.' </td>
- <td class="bug_bg2">'. bugstats('assigned', $name)
.' </td>
- <td class="bug_bg2">'. bugstats('suspended', $name)
.' </td>
- <td class="bug_bg1">'. bugstats('duplicate', $name)
.' </td>
+ <td class="bug_bg2">'. bugstats('analyzed', $name)
.' </td>
+ <td class="bug_bg1">'. bugstats('assigned', $name)
.' </td>
+ <td class="bug_bg1">'. bugstats('suspended', $name)
.' </td>
+ <td class="bug_bg2">'. bugstats('duplicate', $name)
.' </td>
<td class="bug_bg1">'. bugstats('feedback', $name)
.' </td>
<td class="bug_bg2">'. bugstats('no feedback', $name)
.' </td>
<td class="bug_bg1">'. bugstats('bogus', $name)
.' </td>