svn: /web/qa/trunk/reports/ index.php reportsfunctions.php
| From: | Philip Olson | Date: | Fri, 17 Jun 2011 06:05:07 +0000 |
| Subject: | svn: /web/qa/trunk/reports/ index.php reportsfunctions.php | ||
| Groups: | php.qa | ||
| Request: | Send a blank email to php-qa+get-65824@lists.php.net to get a copy of this message | ||
philip Fri, 17 Jun 2011 06:05:07 +0000
Revision: http://svn.php.net/viewvc?view=revision&revision=312229
Log:
Renamed column descriptions, removed DB size column, and added 'date last reported'
column.
Changed paths:
U web/qa/trunk/reports/index.php
U web/qa/trunk/reports/reportsfunctions.php
Modified: web/qa/trunk/reports/index.php
===================================================================
--- web/qa/trunk/reports/index.php 2011-06-17 05:25:11 UTC (rev 312228)
+++ web/qa/trunk/reports/index.php 2011-06-17 06:05:07 UTC (rev 312229)
@@ -47,9 +47,8 @@
die("Error opening DB file: ".$database->lastErrorMsg());
}
$failedTestsArray = array();
-
- $query = 'SELECT test_name,COUNT(id) as cpt,COUNT(DISTINCT diff) as variations FROM failed
- GROUP BY test_name ORDER BY COUNT(id) DESC LIMIT 50';
+ $query = 'SELECT test_name,COUNT(failed.id) as cpt,COUNT(DISTINCT diff) as variations,
date(date) as date FROM failed,reports WHERE failed.id_report = reports.id
+ GROUP BY test_name ORDER BY cpt DESC LIMIT 50';
$q = @$database->query($query);
if (!$q) die("Error querying DB: ".$database->lastErrorMsg());
while ($tab = $q->fetchArray(SQLITE3_ASSOC)) {
@@ -68,15 +67,14 @@
<h1><a href="/reports/"><img title="Go back home"
src="home.png" border="0" style="vertical-align:middle;"
/></a>Reports per version</h1>
-<table class="sortable" style="border: 1px solid black;padding:5px;
width:700px">
+<table class="sortable" style="border: 1px solid black;padding:5px;
width:800px">
<thead>
<tr>
<th>PHP Version</th>
<th>Reports</th>
- <th>Failing tests</th>
- <th>Failures</th>
- <th>Last record</th>
- <th class="sorttable_nosort">DB Size</th>
+ <th>Unique failed tests</th>
+ <th>Total failed tests</th>
+ <th>Last report date</th>
</tr>
</thead>
<tbody>
@@ -112,7 +110,6 @@
}
echo " ago";
echo '</td>';
- echo '<td nowrap
align="right"><small>'.round($line['dbsize']/1024/1024).'
MB</small></td>';
echo '</tr>'."\n";
}
?>
@@ -126,12 +123,13 @@
padding: 3px;
}
</style>
-<table id="testList" class="sortable" style="width: 700px;
border-collapse: collapse">
+<table id="testList" class="sortable" style="width: 800px;
border-collapse: collapse">
<thead>
<tr>
<th>Test name</th>
<th>Count</th>
<th>Variations</th>
+ <th>Last reported date</th>
<th> </th>
</tr>
</thead>
@@ -144,6 +142,7 @@
echo '><td>'.$line['test_name'].'</td>';
echo '<td
align="right">'.$line['cpt'].'</td>';
echo '<td
align="right">'.$line['variations'].'</td>';
+ echo '<td
align="right">'.$line['date'].'</td>';
echo '<td><a
href="viewreports.php?version='.$VERSION.'&test='.urlencode($line['test_name']).'">
<img src="report.png" title="View reports" border="0"
/></a></td>';
echo '</tr>'."\n";
Modified: web/qa/trunk/reports/reportsfunctions.php
===================================================================
--- web/qa/trunk/reports/reportsfunctions.php 2011-06-17 05:25:11 UTC (rev 312228)
+++ web/qa/trunk/reports/reportsfunctions.php 2011-06-17 06:05:07 UTC (rev 312229)
@@ -48,9 +48,6 @@
$data[$version]['nbFailures'] = $row['nbFailures'];
$database->close();
-
- // we will use dbsize elsewhere. Record it now somewhere
- $data[$version]['dbsize'] =
filesize(dirname(__FILE__).'/db/'.$entry);
}
}
return $data;