foundation/council.php - www.eclipse.org/org - Git at Google


            
            <?php

            
            /*******************************************************************************

            
            * Copyright (c) 205, 2011 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

            
            *

            
            * Contributors:

            
            *    Denis Roy (Eclipse Foundation)- initial API and implementation

            
            *    Wayne Beaton (Eclipse Foundation) - Bug 359782

            
            *******************************************************************************/

            
            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");


            $App  = new App();

            
            $Nav = new Nav();

            
            $Menu = new Menu();

            
            include($App->getProjectCommon());


            $pageTitle 		= "Eclipse Foundation Councils";

            
            $pageKeywords	= "foundation, legal, councils, emo";

            
            $pageAuthor		= "Mike Milinkovich, Nov. 22, 2005";


            # Lookup the relations and return the list

            
            function find_relations($relations_array, $include_year = false) {

            
            	global $App;


            	$relations = "'" . implode( "','", $relations_array ) . "'";

            
            	/*

            
            	 * people and chairs are arrays of

            
            	 *	"Last, First" => array(

            
            	 *		the html for the row in the table

            
            	 *			<td>name</td><td>employer</td><td>reason</td>

            
            	 *		, PersonID )

            
            	 * each code section overwrites the results of the previous ones

            
            	 * if they have a result for the same person. Thus if a person is

            
            	 * both a PMC member and a company member, then whichever query

            
            	 * was *last* determines what shows for that person.

            
            	 */

            
            	$people = array();

            
            	$chairs = array();

            
            	/*

            
            	 * chairs

            
            	 */

            
            	$rel = 'NONE';

            
            	foreach( $relations_array as $r ) {

            
            		if( $r == 'PZ' || $r == 'AZ' || $r == 'RZ' ) {

            
            			$rel = $r;

            
            		}

            
            	}

            
            	$result = $App->foundation_sql("SELECT PersonID

            
            		FROM PeopleRelations

            
            		WHERE Relation = '$rel'

            
            		");


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

            
            		$chairs[$row['PersonID']] = 1;

            
            	}

            
            	/*

            
            	 * appointed members with company relationships

            
            	 */

            
            	$result = $App->foundation_sql("SELECT distinct(People.PersonID), FName, LName, Name1, year(EntryDate) as year

            
            		FROM PeopleRelations, People, Organizations,

            
            			OrganizationContacts

            
            		WHERE PeopleRelations.Relation IN ($relations)

            
            			AND People.PersonID = PeopleRelations.PersonID

            
            			AND OrganizationContacts.PersonID =

            
            				People.PersonID

            
            			AND Organizations.OrganizationID =

            
            				OrganizationContacts.OrganizationID");


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

            
            		$people[ucwords($row['LName'].', '.$row['FName'])] = array(

            
            		'<td>' .

            
            		((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '<b>' : '') .

            
            		ucwords($row['FName']) .

            
            		' ' . ucwords($row['LName']) .

            
            		((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '*</b>' : '') .

            
            		'</td><td>' . $row['Name1'] .

            
            		'</td><td>appointed' .

            
            		($include_year ? (' (' . $row['year'] . ')') : '') .

            
            		'</td>', $row['PersonID'] );

            
            	}


            	/*

            
            	 * appointed members without company relationships

            
            	 */

            
            	$result = $App->foundation_sql("SELECT distinct(People.PersonID), FName, LName, year(EntryDate) as year

            
            		FROM PeopleRelations, People

            
            		WHERE PeopleRelations.Relation IN ($relations)

            
            			AND People.PersonID = PeopleRelations.PersonID

            
            			");

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

            
            		if( !isset($people[ucwords($row['LName'].', '.$row['FName'])]) ) {

            
            			$people[ucwords($row['LName'].', '.$row['FName'])] = array(

            
            			'<td>' .

            
            			((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '<b>' : '') .

            
            			ucwords($row['FName']) .

            
            			' ' . ucwords($row['LName']) .

            
            			((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '*</b>' : '') .

            
            			'</td><td>' . '&nbsp;' . '</td><td>appointed' .

            
            			($include_year ? (' (' . $row['year'] . ')') : '') .

            
            			'</td>', $row['PersonID'] );

            
            		}

            
            	}


            	/*

            
            	 * company members

            
            	 */

            
            	$result = $App->foundation_sql("SELECT distinct(People.PersonID),

            
            			Name1, FName, LName

            
            		FROM OrganizationContacts, Organizations, People

            
            		WHERE OrganizationContacts.Relation IN ($relations)

            
            			AND OrganizationContacts.OrganizationID =

            
            				Organizations.OrganizationID

            
            			AND OrganizationContacts.PersonID =

            
            				People.PersonID");


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

            
            		$people[ucwords($row['LName'].', '.$row['FName'])] = array(

            
            		'<td>' .

            
            		((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '<b>' : '') .

            
            		ucwords($row['FName']) .

            
            		' ' . ucwords($row['LName']) .

            
            		((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '*</b>' : '') .

            
            		'</td><td>' . $row['Name1'] . '</td><td>Strategic Developer</td>', $row['PersonID'] );

            
            	}


            	/*

            
            	 * project members with company relationships

            
            	 */

            
            	$result = $App->foundation_sql("SELECT distinct(People.PersonID),

            
            			ProjectID, FName, LName, Name1

            
            		FROM PeopleProjects, People, OrganizationContacts,

            
            			Organizations

            
            		WHERE PeopleProjects.Relation IN ($relations)

            
            			AND PeopleProjects.PersonID =

            
            				People.PersonID

            
            			AND InactiveDate IS NULL

            
            			AND OrganizationContacts.PersonID =

            
            				People.PersonID

            
            			AND OrganizationContacts.Relation =

            
            				'CC'

            
            			AND Organizations.OrganizationID =

            
            				OrganizationContacts.OrganizationID");


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

            
            		$people[ucwords($row['LName'].', '.$row['FName'])] = array(

            
            		'<td>' .

            
            		((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '<b>' : '') .

            
            		ucwords($row['FName']) .

            
            		' ' . ucwords($row['LName']) .

            
            		((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '*</b>' : '') .

            
            		'</td><td>' . $row['Name1'] . "</td><td>" .

            
            		ucfirst($row['ProjectID']) . " PMC</td>", $row['PersonID'] );

            
            	}


            	/*

            
            	 * project members without company relationships

            
            	 */

            
            	$result = $App->foundation_sql("SELECT distinct(People.PersonID),

            
            			ProjectID, FName, LName

            
            		FROM PeopleProjects, People

            
            		WHERE PeopleProjects.Relation IN ($relations)

            
            			AND PeopleProjects.PersonID =

            
            				People.PersonID

            
            			AND InactiveDate IS NULL

            
            			");


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

            
            		if( !isset($people[ucwords($row['LName'].', '.$row['FName'])]) ) {

            
            			$people[ucwords($row['LName'].', '.$row['FName'])] = array(

            
            			'<td>' .

            
            		((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '<b>' : '') .

            
            			ucwords($row['FName']) .

            
            			 ' ' . ucwords($row['LName']) .

            
            		((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '*</b>' : '') .

            
            			'</td><td>' . '&nbsp;' . "</td><td>" .

            
            			ucfirst($row['ProjectID']) . " PMC</td>", $row['PersonID'] );

            
            		}

            
            	}


            	return $people;

            
            }


            ob_start();

            
            ?>

            
            <div id="midcolumn">

            
            	<h1><?= $pageTitle ?></h1>

            
            	<p>As defined by the <a href="/projects/dev_process/development_process.php">Eclipse Development Process</a>,

            
            	the open source projects in Eclipse are guided and co-ordinated by the Architecture Council.</p>

            
            	<p>

            
            		The Architecture Council is responsible for (i) monitoring, guiding, and influencing the software

            
            		architectures used by Projects,  (ii) new  project mentoring,  and (iii) maintaining

            
            		and revising  the Eclipse Development Process subject to the approval of the Board.

            
            		More explanation of the Architecture Council

            
            		can be found in the <a href="/projects/dev_process/development_process.php#4_5_Councils">Eclipse Development Process</a> and in

            
            		the <a href="http://wiki.eclipse.org/Architecture_Council">guidelines and checklists</a>

            
            		for the Architecture Council.

            
            	</p>


            <div class="homeitem3col">

            
            <h3><a name="architecture"></a>Architecture council</h3>

            
            <p align=right><em>Architecture Council members and the projects they are mentoring.</em>

            
            <p/>

            
            	<table class="table table-bordered table-hover">

            
            <?php

            
            // Architecture Council

            
            $architecture_relations = array( 'AC', 'RA', 'EA', 'AZ' );

            
            $people = find_relations($architecture_relations, true);

            
            ksort($people);


            $mentors = array();

            
            $result = $App->foundation_sql("

            
            	SELECT

            
            		PP.PersonID, PP.ProjectID, P.UrlIndex, P.ProjectPhase

            
            	FROM PeopleProjects PP

            
            		INNER JOIN Projects P ON PP.ProjectId = P.ProjectID

            
            	WHERE

            
            		P.IsActive

            
            		and P.ProjectPhase like 'Incubation%'

            
            		and Relation = 'ME'

            
            		and InactiveDate is null

            
            ");


            while($obj = mysqli_fetch_object($result)) {

            
            	if( !isset($mentors[$obj->PersonID]) ) $mentors[$obj->PersonID] = array();


            	// WTB While we're here... set the link to go to the project info page.

            
            	$mentors[$obj->PersonID][] = "<a href=\"/projects/project.php?id=$obj->ProjectID\">$obj->ProjectID</a>";

            
            }


            foreach($people as $name => $value) {

            
            	echo "		<tr>" . $value[0] . "</tr>\n";

            
            	if( isset($mentors[$value[1]]) ) {

            
            		echo "<tr class=\"info\"><td colspan=\"3\" class=\"small\">Mentor for: " . implode(', ', $mentors[$value[1]] ) . "</td></tr>\n";

            
            	}

            
            }

            
            ?>

            
            	</table>


            <ul>

            
            <li><a href="http://wiki.eclipse.org/Architecture_Council">Architecture Council's wiki page and meeting minutes</a>.

            
            </ul>

            
            </div>


            <p><em>* chair</em></p>

            
            </div>

            
            <?php


            $html = ob_get_contents();

            
            ob_end_clean();

            
            # Generate the web page

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

            
            ?>
	<?php
	/*******************************************************************************
	* Copyright (c) 205, 2011 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
	*
	* Contributors:
	* Denis Roy (Eclipse Foundation)- initial API and implementation
	* Wayne Beaton (Eclipse Foundation) - Bug 359782
	*******************************************************************************/
	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");

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

	$pageTitle = "Eclipse Foundation Councils";
	$pageKeywords = "foundation, legal, councils, emo";
	$pageAuthor = "Mike Milinkovich, Nov. 22, 2005";


	# Lookup the relations and return the list
	function find_relations($relations_array, $include_year = false) {
	global $App;

	$relations = "'" . implode( "','", $relations_array ) . "'";
	/*
	* people and chairs are arrays of
	* "Last, First" => array(
	* the html for the row in the table
	* <td>name</td><td>employer</td><td>reason</td>
	* , PersonID )
	* each code section overwrites the results of the previous ones
	* if they have a result for the same person. Thus if a person is
	* both a PMC member and a company member, then whichever query
	* was last determines what shows for that person.
	*/
	$people = array();
	$chairs = array();
	/*
	* chairs
	*/
	$rel = 'NONE';
	foreach( $relations_array as $r ) {
	if( $r == 'PZ' \|\| $r == 'AZ' \|\| $r == 'RZ' ) {
	$rel = $r;
	}
	}
	$result = $App->foundation_sql("SELECT PersonID
	FROM PeopleRelations
	WHERE Relation = '$rel'
	");

	while($row = mysqli_fetch_assoc($result)) {
	$chairs[$row['PersonID']] = 1;
	}
	/*
	* appointed members with company relationships
	*/
	$result = $App->foundation_sql("SELECT distinct(People.PersonID), FName, LName, Name1, year(EntryDate) as year
	FROM PeopleRelations, People, Organizations,
	OrganizationContacts
	WHERE PeopleRelations.Relation IN ($relations)
	AND People.PersonID = PeopleRelations.PersonID
	AND OrganizationContacts.PersonID =
	People.PersonID
	AND Organizations.OrganizationID =
	OrganizationContacts.OrganizationID");

	while($row = mysqli_fetch_assoc($result)) {
	$people[ucwords($row['LName'].', '.$row['FName'])] = array(
	'<td>' .
	((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '<b>' : '') .
	ucwords($row['FName']) .
	' ' . ucwords($row['LName']) .
	((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '*</b>' : '') .
	'</td><td>' . $row['Name1'] .
	'</td><td>appointed' .
	($include_year ? (' (' . $row['year'] . ')') : '') .
	'</td>', $row['PersonID'] );
	}

	/*
	* appointed members without company relationships
	*/
	$result = $App->foundation_sql("SELECT distinct(People.PersonID), FName, LName, year(EntryDate) as year
	FROM PeopleRelations, People
	WHERE PeopleRelations.Relation IN ($relations)
	AND People.PersonID = PeopleRelations.PersonID
	");
	while($row = mysqli_fetch_assoc($result)) {
	if( !isset($people[ucwords($row['LName'].', '.$row['FName'])]) ) {
	$people[ucwords($row['LName'].', '.$row['FName'])] = array(
	'<td>' .
	((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '<b>' : '') .
	ucwords($row['FName']) .
	' ' . ucwords($row['LName']) .
	((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '*</b>' : '') .
	'</td><td>' . ' ' . '</td><td>appointed' .
	($include_year ? (' (' . $row['year'] . ')') : '') .
	'</td>', $row['PersonID'] );
	}
	}

	/*
	* company members
	*/
	$result = $App->foundation_sql("SELECT distinct(People.PersonID),
	Name1, FName, LName
	FROM OrganizationContacts, Organizations, People
	WHERE OrganizationContacts.Relation IN ($relations)
	AND OrganizationContacts.OrganizationID =
	Organizations.OrganizationID
	AND OrganizationContacts.PersonID =
	People.PersonID");

	while($row = mysqli_fetch_assoc($result)) {
	$people[ucwords($row['LName'].', '.$row['FName'])] = array(
	'<td>' .
	((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '<b>' : '') .
	ucwords($row['FName']) .
	' ' . ucwords($row['LName']) .
	((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '*</b>' : '') .
	'</td><td>' . $row['Name1'] . '</td><td>Strategic Developer</td>', $row['PersonID'] );
	}

	/*
	* project members with company relationships
	*/
	$result = $App->foundation_sql("SELECT distinct(People.PersonID),
	ProjectID, FName, LName, Name1
	FROM PeopleProjects, People, OrganizationContacts,
	Organizations
	WHERE PeopleProjects.Relation IN ($relations)
	AND PeopleProjects.PersonID =
	People.PersonID
	AND InactiveDate IS NULL
	AND OrganizationContacts.PersonID =
	People.PersonID
	AND OrganizationContacts.Relation =
	'CC'
	AND Organizations.OrganizationID =
	OrganizationContacts.OrganizationID");

	while($row = mysqli_fetch_assoc($result)) {
	$people[ucwords($row['LName'].', '.$row['FName'])] = array(
	'<td>' .
	((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '<b>' : '') .
	ucwords($row['FName']) .
	' ' . ucwords($row['LName']) .
	((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '*</b>' : '') .
	'</td><td>' . $row['Name1'] . "</td><td>" .
	ucfirst($row['ProjectID']) . " PMC</td>", $row['PersonID'] );
	}

	/*
	* project members without company relationships
	*/
	$result = $App->foundation_sql("SELECT distinct(People.PersonID),
	ProjectID, FName, LName
	FROM PeopleProjects, People
	WHERE PeopleProjects.Relation IN ($relations)
	AND PeopleProjects.PersonID =
	People.PersonID
	AND InactiveDate IS NULL
	");

	while($row = mysqli_fetch_assoc($result)) {
	if( !isset($people[ucwords($row['LName'].', '.$row['FName'])]) ) {
	$people[ucwords($row['LName'].', '.$row['FName'])] = array(
	'<td>' .
	((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '<b>' : '') .
	ucwords($row['FName']) .
	' ' . ucwords($row['LName']) .
	((isset($chairs[$row['PersonID']]) && $chairs[$row['PersonID']] == 1) ? '*</b>' : '') .
	'</td><td>' . ' ' . "</td><td>" .
	ucfirst($row['ProjectID']) . " PMC</td>", $row['PersonID'] );
	}
	}

	return $people;
	}


	ob_start();
	?>
	<div id="midcolumn">
	<h1><?= $pageTitle ?></h1>
	<p>As defined by the <a href="/projects/dev_process/development_process.php">Eclipse Development Process</a>,
	the open source projects in Eclipse are guided and co-ordinated by the Architecture Council.</p>
	<p>
	The Architecture Council is responsible for (i) monitoring, guiding, and influencing the software
	architectures used by Projects, (ii) new project mentoring, and (iii) maintaining
	and revising the Eclipse Development Process subject to the approval of the Board.
	More explanation of the Architecture Council
	can be found in the <a href="/projects/dev_process/development_process.php#4_5_Councils">Eclipse Development Process</a> and in
	the <a href="http://wiki.eclipse.org/Architecture_Council">guidelines and checklists</a>
	for the Architecture Council.
	</p>

	<div class="homeitem3col">
	<h3><a name="architecture"></a>Architecture council</h3>
	<p align=right><em>Architecture Council members and the projects they are mentoring.</em>
	<p/>
	<table class="table table-bordered table-hover">
	<?php
	// Architecture Council
	$architecture_relations = array( 'AC', 'RA', 'EA', 'AZ' );
	$people = find_relations($architecture_relations, true);
	ksort($people);

	$mentors = array();
	$result = $App->foundation_sql("
	SELECT
	PP.PersonID, PP.ProjectID, P.UrlIndex, P.ProjectPhase
	FROM PeopleProjects PP
	INNER JOIN Projects P ON PP.ProjectId = P.ProjectID
	WHERE
	P.IsActive
	and P.ProjectPhase like 'Incubation%'
	and Relation = 'ME'
	and InactiveDate is null
	");

	while($obj = mysqli_fetch_object($result)) {
	if( !isset($mentors[$obj->PersonID]) ) $mentors[$obj->PersonID] = array();

	// WTB While we're here... set the link to go to the project info page.
	$mentors[$obj->PersonID][] = "<a href=\"/projects/project.php?id=$obj->ProjectID\">$obj->ProjectID</a>";
	}

	foreach($people as $name => $value) {
	echo " <tr>" . $value[0] . "</tr>\n";
	if( isset($mentors[$value[1]]) ) {
	echo "<tr class=\"info\"><td colspan=\"3\" class=\"small\">Mentor for: " . implode(', ', $mentors[$value[1]] ) . "</td></tr>\n";
	}
	}
	?>
	</table>

	<ul>
	<li><a href="http://wiki.eclipse.org/Architecture_Council">Architecture Council's wiki page and meeting minutes</a>.
	</ul>
	</div>

	<p><em>* chair</em></p>
	</div>
	<?php

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