web-api/inactive-non-corporate-committers.php

Version 3
<ul>
<?php
require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_foundation_ro.class.php";

$_dbcf = new DBConnectionFoundation();
$_dbhf = $_dbcf->connect();

$peeps = array();
$activ = array();
$anyact = array();

$sql = "
select distinct People.PersonID, ProjectID 
from People, PeopleProjects 
where People.PersonID = PeopleProjects.PersonID 
  and People.IsMember
  and PeopleProjects.Relation = 'CM' 
  and PeopleProjects.InactiveDate is null 
  and People.PersonID NOT IN (
  		SELECT PersonID 
  		FROM OrganizationContacts 
  		WHERE Relation = 'EMPLY') 
  AND Email NOT LIKE '%ibm%' ORDER BY ProjectID
";
$result = mysql_query( $sql, $_dbhf );
while( $row = mysql_fetch_array($result) ) {
	$peeps[$row[0] . ' x ' . $row[1]] = $row[0];
}
/*
 * Get all the committer activity
 */
$blob = file("http://dash.eclipse.org/dash/commits/web-api/commits-index.php");
foreach( $blob as $line ) {
	$words = split( "\t", $line );
	if( substr($words[0],0,1) == '#' ) {
		continue;
	}
	if( $words[2] == 9 && $words[1] > 0 )  {
		$activ[$words[0] . ' x ' . $words[3]] = 1;
		$anyact[$words[0]] = 1;
	}
}
/*
 * Figure out which non-corporate committers are inactive
 */
foreach( $peeps as $key => $value ) {
	if( !isset($activ[$key]) ) {
		if( !isset($anyact[$value]) ) 
			echo "<li>$key</li>";
	}
}
?>
</ul>