Source for file packages_closed_reports_no_release.php
Documentation is available at packages_closed_reports_no_release.php
+----------------------------------------------------------------------+
| PEAR Web site version 1.0 |
+----------------------------------------------------------------------+
| Copyright (c) 2001-2008 The PHP Group |
+----------------------------------------------------------------------+
| This source file is subject to version 3.01 of the PHP license, |
| that is bundled with this package in the file LICENSE, and is |
| available at through the world-wide-web at |
| http://www.php.net/license/3_01.txt. |
| If you did not receive a copy of the PHP license and are unable to |
| obtain it through the world-wide-web, please send a note to |
| license@php.net so we can mail you a copy immediately. |
+----------------------------------------------------------------------+
+----------------------------------------------------------------------+
* This page give you a list of all packages with closed bug report
* but hasn't had a release in X amount of time
include_once 'HTML/Table.php';
// Sortable tables http://www.kryogenix.org/code/browser/sorttable/
$extra_header = '<script type="text/javascript" src="/javascript/sorttable.js"></script>';
response_header ('Quality Assurance Initiative - Packages with closed reports but no release in the last 6 months',
// Just so we don't fetch bugs for packages that recently had a releases
UNIX_TIMESTAMP(r.releasedate) as releasedate,
JOIN bugdb ON packages.name = bugdb.package_name AND bugdb.status = 'Closed'
SELECT package, MAX(releasedate) as releasedate FROM releases GROUP BY package
) as r ON packages.id = r.package
// In case we want to show all packages, including the superseeded ones.
if (!isset ($_GET['showall'])) {
(packages.newchannel IS NULL OR packages.newchannel = '')
(packages.newpackagename IS NULL OR packages.newpackagename = '')
UNIX_TIMESTAMP(r.releasedate) < UNIX_TIMESTAMP(bugdb.ts2)
UNIX_TIMESTAMP(r.releasedate) < $min_release_date
packages.id, packages.name, bugdb.package_name, bugdb.id, r.package
unmaintained DESC, r.releasedate";
$res = $dbh->getAll ($sql, null , DB_FETCHMODE_ASSOC );
$total_rows = $dbh->getOne ('SELECT FOUND_ROWS()');
echo 'Checks <a href="#pear">PEAR</a> and <a href="#pecl">PECL</a><br />';
echo 'Found ' . $total_rows . ' reports that have been closed but their package has not had a release in 6 months<br /><br />';
$bugs = array ('pear' => array (), 'pecl' => array ());
foreach ($res as $data) {
$bugs[$data['package_type']][$data['name']]['bug_id'][] = $data['bug_id'];
$bugs[$data['package_type']][$data['name']]['last_release'] = $data['releasedate'];
$bugs[$data['package_type']][$data['name']]['unmaintained'] = $data['unmaintained'];
$table = new HTML_Table (array ('class' => 'sortable'));
$table->setHeaderContents (0 , 0 , 'Package');
$table->setHeaderContents (0 , 1 , '# bugs');
$table->setHeaderContents (0 , 2 , 'Last Release Date');
$table->setHeaderContents (0 , 3 , "Unmaintained?");
foreach ($bugs['pear'] as $name => $qa) {
make_link ('/package/' . $name . '/', $name),
make_link ('/bugs/search.php?cmd=display&package_name[]=' . $name . '&status=CRSLR', count($qa['bug_id'])),
format_date ($qa['last_release']),
$qa['unmaintained'] ? 'Yes' : ''
$table->setCellAttributes ($row, 1 , 'style="text-align: center;"');
$table->setCellAttributes ($row, 3 , 'style="text-align: center;"');
echo '<h2 id="pear">PEAR (' . count($bugs['pear']) . ')</h2>';
Documentation generated on Mon, 11 Mar 2019 15:46:40 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.
|