tools/pmc.php

<?php
/*******************************************************************************
 * Copyright (c) 2018 Eclipse Foundation and others.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *******************************************************************************/

/**

 */
require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/nav.class.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/menu.class.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/projects/classes/Project.class.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/projects/classes/common.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/projects/classes/database.inc");

$App = new App();
$Nav = new Nav();
$Menu = new Menu();
include($App->getProjectCommon());

$pageTitle = "Eclipse Foundation PMC Tasks";
$pageKeywords = "";
$pageAuthor = "Wayne Beaton";

$root = Project::getProject($_GET['id']);
if ($root->isTopLevel()) {

}

function withCqsAwaitingPMC($id, $callable) {
	$sql = "
		select
			b.bug_id as id,
			c.name as project,
			b.short_desc as description,
			b.cf_type as type,
			date(b.creation_ts) as created,
			b.bug_status as status,
			b.resolution as resolution,
			b.bug_severity as state
		from bugs as b
			join components as c on b.component_id = c.id
			join products as p on b.product_id = p.id
		where p.name='{$id}'
			and bug_status='NEW'
			and bug_severity='awaiting_pmc'
		order by c.name
	";
	query('ipzilla', $sql, array(), $callable);
}


ob_start();
?>
<div id="maincontent">
<div id="midcolumn">
<h1><?= $pageTitle ?></h1>

<p><strong>Experimental</strong> Provide a list of links to tasks that require the PMC's attention.</p>

<h3>Intellectual Property</h3>

<?php
$cqs = array();
withCqsAwaitingPMC($root->getId(), function($cq) use (&$cqs) {
	$cqs[$cq['project']][] = $cq;
});

if ($cqs) {
	print "<p>The following CQs require some attention from the PMC.</p>";

	foreach ($cqs as $id => $list) {
		$project = Project::getProject($id);
		$name = $project ? $project->getFormalName() : $id;
		print "<h4>{$name}</h4>";
		print "<ul>";
		foreach($list as $cq) {
			print "<li><a href=\"https://dev.eclipse.org/ipzilla/show_bug.cgi?id={$cq['id']}\">{$cq['id']}</a> {$cq['description']}</li>";
		}
		print "</ul>";
	}
}
?>

</div>
</div>

<?php
$html = ob_get_contents();
ob_end_clean();
$App->generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html);
?>