lists.php - gerrit/www.eclipse.org/projects - Git at Google


            
            <?php

            
            /* 221934 - this page to remain on eclipse.org */


            // -----------------------------------------------------------------------------------------------

            
            // lists.php - Lists of Committers, Project Leads, Projects for a Committer, etc.

            
            //	Bjorn's 'list of lists'

            
            //

            
            // AUTHOR:	Karl Matthias

            
            // DATE:	2007-07-10

            
            // HISTORY: 2007-10-19 Added components to committers lists

            
            //			2007-11-07 Phoenixized default page and fixed blocker on badly formed component names

            
            //			2007-11-26 Migrated components to Projects table

            
            //			2008-01-10 Updated to better intermingle with project_summary.php

            
            // -----------------------------------------------------------------------------------------------


            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("common/shared_functions.php");


            $App 	= new App();

            
            $Nav	= new Nav();

            
            $Menu 	= new Menu();

            
            include($App->getProjectCommon());


            $pageTitle 		= "Lists";

            
            $pageKeywords	= "committers projects leads project";

            
            $pageAuthor		= "Karl Matthias - July 10, 2007";


            $extraHtmlHeaders = '

            
            	<link rel="stylesheet" type="text/css" href="common/project_summary.css">

            
            	';

            
            $App->AddExtraHtmlHeader($extraHtmlHeaders);


            $iconDir		= "http://dev.eclipse.org/large_icons";


            ob_start();

            
            include( '_commonLeftNav.php' );

            
            ?>

            
            <div id="maincontent">

            
            <div id="midcolumn" style="width:680px;">

            
            <?php


            $list = $_REQUEST['list'];

            
            $param = $_REQUEST['param'];

            
            $param2 = $_REQUEST['param2'];


            // validate param

            
            if(!preg_match('/^[a-z.0-9\-_]*$/', $param)) {

            
            	nice_die('invalid format for parameter');

            
            }

            
            if(!preg_match('/^[a-z.0-9\-_ ]*$/i', $param2)) {

            
            	nice_die('invalid format for parameter2');

            
            }


            // validate request

            
            switch($list) {

            
            	case 'leads':

            
            	case 'allcommitters':

            
            	case 'allbyproject':

            
            	case 'projectsforcommitter':

            
            	case 'byproject':

            
            	case 'bycomponent':

            
            	break;

            
            	default:

            
            		?>

            
            		<h1>Project Lists Page</h1>

            
            		<p>Many inter-linked lists are accessible via this engine.  Clicking on a link will

            
            		take you to a page that displays more specific information.</p>

            
            		<p>General lists can be accessed using one of the following queries:</p>

            
            		<ul>

            
            		<li><a href="?list=allbyproject">All Committers Sorted by Project</a></li>

            
            		<li><a href="?list=allcommitters">All Committers Sorted by Committer Name</a></li>

            
            		</ul>

            
            		<p>Detailed queries are possible and are linked from those two queries.</p>

            
            		</div></div>

            
            		<?php

            
            		$html = ob_get_contents();

            
            		ob_end_clean();

            
            		$App->generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html);

            
            		exit();

            
            }


            if($list == 'leads') {

            
            	box_header('blueonwhite', "", '', false, true);

            
            	echo "<div style='padding: 1em; width: 100%'>";

            
            	echo "<span class='pageheader'>$param Project</span>";

            
            	box_header('whiteonblue', 'Project Leads', "$iconDir/apps/preferences-desktop-theme.png");

            
            	leads_for_project($param);

            
            	box_footer('whiteonblue');

            
            	echo "</div>";

            
            	echo "<br clear='all'/>";

            
            	box_footer('blueonwhite');

            
            	echo "<br clear='all'/>";


            } elseif($list == 'allcommitters') {

            
            	echo "<h1>All Committers with Project</h1>";

            
            	echo "<table>";

            
            	$result = $App->foundation_sql("SELECT People.PersonID, FName, LName, ProjectID FROM People, PeopleProjects " .

            
            			"WHERE Relation = 'CM' " .

            
            			"AND InactiveDate is NULL " .

            
            			"AND People.PersonID = PeopleProjects.PersonID " .

            
            			"ORDER BY LName", $fdbh);

            
            	while($row = mysql_fetch_assoc($result)) {

            
            		echo "<tr><td></a> </td><td> <a href='?list=projectsforcommitter&param=" . $row['PersonID'] ."'>" . $row['FName'] .  " " . $row['LName'] . "</a> </td><td> <a href=\"?list=byproject&param=" . $row['ProjectID'] . "\">"  . $row['ProjectID'] . "</a></td></tr>";

            
            	}

            
            	echo "</table>";


            } elseif($list == 'allbyproject') {

            
            	echo "<h1>All Committers by Project</h1>";

            
            	echo "<table>";

            
            	$result = $App->foundation_sql("SELECT People.PersonID, FName, LName, Projects.ProjectID FROM People, PeopleProjects, Projects " .

            
            			"WHERE Relation = 'CM' " .

            
            			"AND InactiveDate is NULL " .

            
            			"AND People.PersonID = PeopleProjects.PersonID " .

            
            			"AND Projects.ProjectID = PeopleProjects.ProjectID " .

            
            			"ORDER BY ProjectID", $fdbh);

            
            	while($row = mysql_fetch_assoc($result)) {

            
            		echo "<tr><td><a href=\"?list=byproject&param=" . $row['ProjectID'] . "\">"  . $row['ProjectID'] . "</a> </td><td> <a href='?list=projectsforcommitter&param=" . $row['PersonID'] ."'>" . $row['FName'] .  " " . $row['LName'] . "</a></td></tr>";

            
            	}

            
            	echo "</table>";


            } elseif($list == 'projectsforcommitter') {

            
            	// Get full name from People table

            
            	$result = $App->foundation_sql("SELECT FName, LName FROM People WHERE PersonID = '$param'");

            
            	$row = mysql_fetch_assoc($result);

            
            	$name = $row['FName'] . ' ' . $row['LName'];


            	// Get employer name if we know it

            
            	$result = $App->foundation_sql("SELECT Name1 FROM Organizations, OrganizationContacts " .

            
            			"WHERE PersonID = '$param' " .

            
            			"AND Relation = 'EMPLY' " .

            
            			"AND OrganizationContacts.Comments = 'PRIMARY'" .

            
            			"AND Organizations.OrganizationID = OrganizationContacts.OrganizationID");

            
            	$row = mysql_fetch_assoc($result);

            
            	$company = $row['Name1'];


            	box_header('blueonwhite', "", '', false, true);

            
            	echo "<div style='padding: 1em;'>";

            
            	$name .= isset($company) ? " ($company)" : "";

            
            	echo "<div><span class='pageheader'>Projects for $name</span>";

            
            	echo isset($top) ? "<span style=\"font-size: small; color: white; margin-left: 2px;\">(<a href=\"http://dash.eclipse.org/dash/commits/web-app/summary.cgi?company=y&year=x&top=$top&project=$param\">dash</a>)</span>" : '';

            
            	echo "</div>";

            
            	box_header('whiteonblue', 'Committer on', "$iconDir/apps/system-users.png");


            	echo "<table>";

            
            	$result = $App->foundation_sql("SELECT People.PersonID, FName, LName, Projects.ProjectID " .

            
            		"FROM People, PeopleProjects, Projects " .

            
            			"WHERE Relation = 'CM' " .

            
            			"AND InactiveDate is NULL " .

            
            			"AND People.PersonID = PeopleProjects.PersonID " .

            
            			"AND PeopleProjects.ProjectID = Projects.ProjectID " .

            
            			"AND People.PersonID = '$param' " .

            
            			"ORDER BY ProjectID", $fdbh);

            
            	if(mysql_num_rows($result) < 1) {

            
            		die("That is not a committer");

            
            	}

            
            	while($row = mysql_fetch_assoc($result)) {

            
            		$top = substr($row['ProjectID'], 0, strpos($row['ProjectID'], '.'));

            
            		$components = component_for_committer($param, $row['ProjectID']);

            
            		if(strlen($components) > 0) {

            
            			$components = "<span style='color: gray'>$components</span> ";

            
            		}

            
            		$url = "http://dash.eclipse.org/dash/commits/web-app/summary.cgi?type=y&year=x&top=$top&project=" . $row['ProjectID'] . "&login=$param";

            
            		echo "<tr><td></a> </td><td> <a href=\"?list=byproject&param=" . $row['ProjectID'] . "\">"  . $row['ProjectID'] . "</a> $components<span style='font-size: x-small;'>(<a href='$url'>dash</a>)</span></td></tr>";

            
            	}

            
            	echo "</table>";

            
            	echo "<br clear='all'/>";

            
            	box_footer('whiteonblue');

            
            	echo "<br clear='all'/></div>";

            
            	box_footer('blueonwhite');


            } elseif($list == 'byproject') {

            
            	$top = substr($param, 0, strpos($param, '.'));

            
            	box_header('blueonwhite', "", '', false, true);

            
            	echo "<div style='padding: 1em;'>";

            
            	echo "<div><span class='pageheader'>$param</span>";

            
            	echo isset($top) ? "<span style=\"font-size: small; color: white; margin-left: 2px;\">(<a href=\"http://dash.eclipse.org/dash/commits/web-app/summary.cgi?company=y&year=x&top=$top&project=$param\">dash</a>)</span>" : '';

            
            	echo "</div>";

            
            	box_header('whiteonblue', 'Committers', "$iconDir/apps/system-users.png");

            
            	committers_for_project($param);

            
            	box_footer('whiteonblue');


            	box_header('whiteonblue', 'Project Leads', "$iconDir/apps/preferences-desktop-theme.png", true);

            
            	leads_for_project($param);

            
            	box_footer('whiteonblue');

            
            	echo "<br clear='all'/>";


            	echo "</div>";

            
            	box_footer('blueonwhite');


            	echo "<br clear='all'/>";


            } elseif($list == 'bycomponent') {

            
            	$name = substr(strrchr($param2, '.'), 1);

            
            	echo "<h1 style='margin: 0px; padding-left: 0px'>Committers for $param ";

            
            	echo "</h1>";

            
            	echo "<b style='color: gray; padding-left: 1em;'>component: $name </b><br/><br/>\n";

            
            	echo "<table>\n";

            
            	$result = $App->foundation_sql("SELECT FName, LName, People.PersonID

            
            			FROM PeopleProjects, People, Projects

            
            			WHERE ParentProjectID = '$param'

            
            				AND Projects.ProjectID = '$param2'

            
            				AND People.PersonID = PeopleProjects.PersonID

            
            				AND Projects.ProjectID = PeopleProjects.ProjectID

            
            			ORDER BY LName", $fdbh);

            
            	if(mysql_num_rows($result) < 1) {

            
            		die("That is not a project/component or there are no committers on the project/component");

            
            	}

            
            	while($row = mysql_fetch_assoc($result)) {

            
            		echo "<tr><td> <a href='?list=projectsforcommitter&param=" . $row['PersonID'] ."'>" . $row['FName'] .  " " . $row['LName'] . "</a></td></tr>";

            
            	}

            
            	echo "</table>";


            }


            echo "<br/><hr/>

            
            <div style='font-size: small;'>

            
            <b>How to read this:</b> Project and Committer names link to detail pages for their respective subject.  (dash) links connect to

            
            the commits explorer dashboard at <a href='http://dash.eclipse.org/'>dash.eclipse.org</a>.  On detail

            
            pages components are in comma-separated, gray lists after the name of each committer if the

            
            particular project is organizedby component.

            
            </div>

            
            </div></div>";


            $html = ob_get_contents();

            
            ob_end_clean();


            # Generate the web page

            
            $App->generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html);

            
            ?>
	<?php
	/* 221934 - this page to remain on eclipse.org */

	// -----------------------------------------------------------------------------------------------
	// lists.php - Lists of Committers, Project Leads, Projects for a Committer, etc.
	// Bjorn's 'list of lists'
	//
	// AUTHOR: Karl Matthias
	// DATE: 2007-07-10
	// HISTORY: 2007-10-19 Added components to committers lists
	// 2007-11-07 Phoenixized default page and fixed blocker on badly formed component names
	// 2007-11-26 Migrated components to Projects table
	// 2008-01-10 Updated to better intermingle with project_summary.php
	// -----------------------------------------------------------------------------------------------

	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("common/shared_functions.php");

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

	$pageTitle = "Lists";
	$pageKeywords = "committers projects leads project";
	$pageAuthor = "Karl Matthias - July 10, 2007";

	$extraHtmlHeaders = '
	<link rel="stylesheet" type="text/css" href="common/project_summary.css">
	';
	$App->AddExtraHtmlHeader($extraHtmlHeaders);

	$iconDir = "http://dev.eclipse.org/large_icons";

	ob_start();
	include( '_commonLeftNav.php' );
	?>
	<div id="maincontent">
	<div id="midcolumn" style="width:680px;">
	<?php

	$list = $_REQUEST['list'];
	$param = $_REQUEST['param'];
	$param2 = $_REQUEST['param2'];

	// validate param
	if(!preg_match('/^[a-z.0-9\-_]*$/', $param)) {
	nice_die('invalid format for parameter');
	}
	if(!preg_match('/^[a-z.0-9\-_ ]*$/i', $param2)) {
	nice_die('invalid format for parameter2');
	}

	// validate request
	switch($list) {
	case 'leads':
	case 'allcommitters':
	case 'allbyproject':
	case 'projectsforcommitter':
	case 'byproject':
	case 'bycomponent':
	break;
	default:
	?>
	<h1>Project Lists Page</h1>
	<p>Many inter-linked lists are accessible via this engine. Clicking on a link will
	take you to a page that displays more specific information.</p>
	<p>General lists can be accessed using one of the following queries:</p>
	<ul>
	<li><a href="?list=allbyproject">All Committers Sorted by Project</a></li>
	<li><a href="?list=allcommitters">All Committers Sorted by Committer Name</a></li>
	</ul>
	<p>Detailed queries are possible and are linked from those two queries.</p>
	</div></div>
	<?php
	$html = ob_get_contents();
	ob_end_clean();
	$App->generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html);
	exit();
	}

	if($list == 'leads') {
	box_header('blueonwhite', "", '', false, true);
	echo "<div style='padding: 1em; width: 100%'>";
	echo "<span class='pageheader'>$param Project</span>";
	box_header('whiteonblue', 'Project Leads', "$iconDir/apps/preferences-desktop-theme.png");
	leads_for_project($param);
	box_footer('whiteonblue');
	echo "</div>";
	echo "<br clear='all'/>";
	box_footer('blueonwhite');
	echo "<br clear='all'/>";

	} elseif($list == 'allcommitters') {
	echo "<h1>All Committers with Project</h1>";
	echo "<table>";
	$result = $App->foundation_sql("SELECT People.PersonID, FName, LName, ProjectID FROM People, PeopleProjects " .
	"WHERE Relation = 'CM' " .
	"AND InactiveDate is NULL " .
	"AND People.PersonID = PeopleProjects.PersonID " .
	"ORDER BY LName", $fdbh);
	while($row = mysql_fetch_assoc($result)) {
	echo "<tr><td></a> </td><td> <a href='?list=projectsforcommitter&param=" . $row['PersonID'] ."'>" . $row['FName'] . " " . $row['LName'] . "</a> </td><td> <a href=\"?list=byproject&param=" . $row['ProjectID'] . "\">" . $row['ProjectID'] . "</a></td></tr>";
	}
	echo "</table>";

	} elseif($list == 'allbyproject') {
	echo "<h1>All Committers by Project</h1>";
	echo "<table>";
	$result = $App->foundation_sql("SELECT People.PersonID, FName, LName, Projects.ProjectID FROM People, PeopleProjects, Projects " .
	"WHERE Relation = 'CM' " .
	"AND InactiveDate is NULL " .
	"AND People.PersonID = PeopleProjects.PersonID " .
	"AND Projects.ProjectID = PeopleProjects.ProjectID " .
	"ORDER BY ProjectID", $fdbh);
	while($row = mysql_fetch_assoc($result)) {
	echo "<tr><td><a href=\"?list=byproject&param=" . $row['ProjectID'] . "\">" . $row['ProjectID'] . "</a> </td><td> <a href='?list=projectsforcommitter&param=" . $row['PersonID'] ."'>" . $row['FName'] . " " . $row['LName'] . "</a></td></tr>";
	}
	echo "</table>";

	} elseif($list == 'projectsforcommitter') {
	// Get full name from People table
	$result = $App->foundation_sql("SELECT FName, LName FROM People WHERE PersonID = '$param'");
	$row = mysql_fetch_assoc($result);
	$name = $row['FName'] . ' ' . $row['LName'];

	// Get employer name if we know it
	$result = $App->foundation_sql("SELECT Name1 FROM Organizations, OrganizationContacts " .
	"WHERE PersonID = '$param' " .
	"AND Relation = 'EMPLY' " .
	"AND OrganizationContacts.Comments = 'PRIMARY'" .
	"AND Organizations.OrganizationID = OrganizationContacts.OrganizationID");
	$row = mysql_fetch_assoc($result);
	$company = $row['Name1'];

	box_header('blueonwhite', "", '', false, true);
	echo "<div style='padding: 1em;'>";
	$name .= isset($company) ? " ($company)" : "";
	echo "<div><span class='pageheader'>Projects for $name</span>";
	echo isset($top) ? "<span style=\"font-size: small; color: white; margin-left: 2px;\">(<a href=\"http://dash.eclipse.org/dash/commits/web-app/summary.cgi?company=y&year=x&top=$top&project=$param\">dash</a>)</span>" : '';
	echo "</div>";
	box_header('whiteonblue', 'Committer on', "$iconDir/apps/system-users.png");

	echo "<table>";
	$result = $App->foundation_sql("SELECT People.PersonID, FName, LName, Projects.ProjectID " .
	"FROM People, PeopleProjects, Projects " .
	"WHERE Relation = 'CM' " .
	"AND InactiveDate is NULL " .
	"AND People.PersonID = PeopleProjects.PersonID " .
	"AND PeopleProjects.ProjectID = Projects.ProjectID " .
	"AND People.PersonID = '$param' " .
	"ORDER BY ProjectID", $fdbh);
	if(mysql_num_rows($result) < 1) {
	die("That is not a committer");
	}
	while($row = mysql_fetch_assoc($result)) {
	$top = substr($row['ProjectID'], 0, strpos($row['ProjectID'], '.'));
	$components = component_for_committer($param, $row['ProjectID']);
	if(strlen($components) > 0) {
	$components = "<span style='color: gray'>$components</span> ";
	}
	$url = "http://dash.eclipse.org/dash/commits/web-app/summary.cgi?type=y&year=x&top=$top&project=" . $row['ProjectID'] . "&login=$param";
	echo "<tr><td></a> </td><td> <a href=\"?list=byproject&param=" . $row['ProjectID'] . "\">" . $row['ProjectID'] . "</a> $components<span style='font-size: x-small;'>(<a href='$url'>dash</a>)</span></td></tr>";
	}
	echo "</table>";
	echo "<br clear='all'/>";
	box_footer('whiteonblue');
	echo "<br clear='all'/></div>";
	box_footer('blueonwhite');

	} elseif($list == 'byproject') {
	$top = substr($param, 0, strpos($param, '.'));
	box_header('blueonwhite', "", '', false, true);
	echo "<div style='padding: 1em;'>";
	echo "<div><span class='pageheader'>$param</span>";
	echo isset($top) ? "<span style=\"font-size: small; color: white; margin-left: 2px;\">(<a href=\"http://dash.eclipse.org/dash/commits/web-app/summary.cgi?company=y&year=x&top=$top&project=$param\">dash</a>)</span>" : '';
	echo "</div>";
	box_header('whiteonblue', 'Committers', "$iconDir/apps/system-users.png");
	committers_for_project($param);
	box_footer('whiteonblue');

	box_header('whiteonblue', 'Project Leads', "$iconDir/apps/preferences-desktop-theme.png", true);
	leads_for_project($param);
	box_footer('whiteonblue');
	echo "<br clear='all'/>";

	echo "</div>";
	box_footer('blueonwhite');

	echo "<br clear='all'/>";

	} elseif($list == 'bycomponent') {
	$name = substr(strrchr($param2, '.'), 1);
	echo "<h1 style='margin: 0px; padding-left: 0px'>Committers for $param ";
	echo "</h1>";
	echo "<b style='color: gray; padding-left: 1em;'>component: $name </b><br/><br/>\n";
	echo "<table>\n";
	$result = $App->foundation_sql("SELECT FName, LName, People.PersonID
	FROM PeopleProjects, People, Projects
	WHERE ParentProjectID = '$param'
	AND Projects.ProjectID = '$param2'
	AND People.PersonID = PeopleProjects.PersonID
	AND Projects.ProjectID = PeopleProjects.ProjectID
	ORDER BY LName", $fdbh);
	if(mysql_num_rows($result) < 1) {
	die("That is not a project/component or there are no committers on the project/component");
	}
	while($row = mysql_fetch_assoc($result)) {
	echo "<tr><td> <a href='?list=projectsforcommitter&param=" . $row['PersonID'] ."'>" . $row['FName'] . " " . $row['LName'] . "</a></td></tr>";
	}
	echo "</table>";

	}

	echo "<br/><hr/>
	<div style='font-size: small;'>
	<b>How to read this:</b> Project and Committer names link to detail pages for their respective subject. (dash) links connect to
	the commits explorer dashboard at <a href='http://dash.eclipse.org/'>dash.eclipse.org</a>. On detail
	pages components are in comma-separated, gray lists after the name of each committer if the
	particular project is organizedby component.
	</div>
	</div></div>";

	$html = ob_get_contents();
	ob_end_clean();

	# Generate the web page
	$App->generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html);
	?>