_deprecated/team/statistics.php

<?php $areaRelative = "."; require_once "$areaRelative/_defs.php";  include "$areaRoot/_header.php"; 
########################################################################

require_once "$docRoot/modeling/includes/db.php";

$pageKeywords	= "";
$pageAuthor		= "Eike Stepper";

print '<div id="midcolumn">';

$result = wmysql_query("SELECT CommitterID, PhotoURL, Name, Company, Location, Role, Website, EMail FROM developers WHERE CommitterID = '" . $_GET["committerid"] . "'");
if ($result && mysql_num_rows($result) > 0)
{
	$row = mysql_fetch_row($result);
	$author = $row[0];
	$pageTitle = 'Statistics For ' . $row[2];

	print '<h1>' . $pageTitle . '</h1>';
	print '<p><table border="0" width="100%">' . "\n";
	print '<tr><td width="25%" height="130" align="center" valign="top">' .
	($row[1] && (preg_match("#https+://#", $row[1]) || is_file($_SERVER['DOCUMENT_ROOT'] . $row[1])) ?
				'<img border="0" src="' . $row[1] . '" style="" height="120"/>' : '<img border="0" src="/modeling/images/team/eclipseface.png"/>') .
				'</td><td align="left" valign="top">' . 
	($row[2] ? "<b>" . $row[2] . "</b><br/>" : "") .
	($row[3] ? $row[3] . "<br/>" : "") .
	($row[4] ? $row[4] . "<br/>" : "") .
		'<br/>' . "\n" .
	($row[5] ? "<i>" . $row[5] . "</i><br/>" : "") .
	($row[7] ? '<a href="mailto:' . $row[7] . '?subject=[CDO] "><img border="0" src="' . $projectPath . '/images/email.gif" alt="EMail"/></a>&nbsp;' : "") .
	($row[6] ? '<a href="' . $row[6] . '" target="_blank"><img border="0" src="' . $projectPath . '/images/website.gif" alt="WebSite"/></a>&nbsp;' : "") .
			'</td></tr>' . "\n";
	print "</table>\n";

	$branches = wmysql_query("SELECT " .
		"Branch, " .
		"SUM(LinesPlus) AS Added, " . 
		"SUM(LinesMinus) AS Removed, " . 
		"COUNT(commits.fid) AS Files, " . 
		"MIN(date) AS FromDate, " . 
		"MAX(date) AS UntilDate " . 
		"FROM commits JOIN cvsfiles " . 
		"WHERE Author = '" . $author . "' AND commits.fid = cvsfiles.fid AND cvsfiles.component = 'org.eclipse.emf.cdo' " . 
		"GROUP BY Branch " . 
		"ORDER BY UntilDate DESC");

	if ($branches && mysql_num_rows($branches) > 0)
	{
		$rows = mysql_num_rows($branches);
		$totalSum = 0;
		$totalLPF = 0;

		print '<h1>&nbsp;</h1>';
		print '<div class="homeitem">';
		print '<h1>Committed In ' . $rows . ' ' . $projectName . ($rows == 1 ? ' Branch' : ' Branches') . '</h1>';
		print '<p><table border="1" width="100%" align="right">' . "\n";
		print '<tr>' .
			'<td align="left"><b>Branch</b></td>' .
			'<td><b>Begin</b></td>' .
			'<td><b>Days</b></td>' .
			'<td><b>Files</b></td>' .
			'<td><b>Lines</b></td>' .
			'<td><b>&empty;</b></td>' .
			'</tr>' . "\n";
			
		while ($branch = mysql_fetch_row($branches))
		{
			$sum = $branch[1] + $branch[2];
			$lpf = $sum / $branch[3];
			$begin = formatDate($branch[4]);
			$days = daysBetween($branch[4], $branch[5]);

			print '<tr>' .
				'<td align="left"><a href="commits.php?committerid='. $_GET["committerid"] . '&branch=' . $branch[0] . '">' . $branch[0] . '</a></td>' .
				'<td>' . $begin . '</td>' .
				'<td>' . $days . '</td>' .
				'<td>' . $branch[3] . '</td>' .
				'<td>' . $sum . '</td>' .
				'<td>' . round($lpf) . '</td>' .
				'</tr>' . "\n";

			$totalSum += $sum;
			$totalLPF += $lpf;
		}

		print '<tr>' .
			'<td>&nbsp;</td>' .
			'<td>&nbsp;</td>' .
			'<td>&nbsp;</td>' .
			'<td>&nbsp;</td>' .
			'<td><b>' . $totalSum . '</b></td>' .
			'<td><b>' . round($totalLPF / $rows) . '</b></td>' .
			'</tr>' . "\n";
		print "</table>\n";
		print '</div>';
	}

	$bugs = wmysql_query("SELECT " .
			"bugdescs.bugid, " .
			"SUM(LinesPlus) AS Added, " . 
			"SUM(LinesMinus) AS Removed, " . 
			"COUNT(commits.fid) AS Files, " . 
			"Title, " . 
			"MAX(date) AS UntilDate " . 
			"FROM commits JOIN bugs JOIN bugdescs JOIN cvsfiles " . 
			"WHERE Author = '" . $author . "' AND commits.fid = bugs.fid AND commits.revision = bugs.revision AND bugs.bugid = bugdescs.bugid AND commits.fid = cvsfiles.fid AND cvsfiles.component = 'org.eclipse.emf.cdo' " . 
			"GROUP BY BugID " . 
			"ORDER BY UntilDate DESC");

	if ($bugs && mysql_num_rows($bugs) > 0)
	{
		$rows = mysql_num_rows($bugs);
		$totalSum = 0;
		$totalLPF = 0;

		print '<h1>&nbsp;</h1>';
		print '<div class="homeitem">';
		print '<h1>Committed In ' . $rows . ' ' . $projectName . ($rows == 1 ? ' Bugzilla' : ' Bugzillas') . '</h1>';
		print '<p><table border="1" width="100%" align="right">' . "\n";
		print '<tr>' .
				'<td align="left"><b>Bugzilla</b></td>' .
				'<td align="left"><b>Summary</b></td>' .
				'<td><b>Files</b></td>' .
				'<td><b>Lines</b></td>' .
				'<td><b>&empty;</b></td>' .
				'</tr>' . "\n";

		while ($bug = mysql_fetch_row($bugs))
		{
			$sum = $bug[1] + $bug[2];
			$lpf = $sum / $bug[3];

			print '<tr>' .
					'<td align="left"><a href="https://bugs.eclipse.org/' . $bug[0] . '" target="_blank">' . $bug[0] . '</a></td>' .
					'<td>' . $bug[4] . '</td>' .
					'<td>' . $bug[3] . '</td>' .
					'<td>' . $sum . '</td>' .
					'<td>' . round($lpf) . '</td>' .
					'</tr>' . "\n";

			$totalSum += $sum;
			$totalLPF += $lpf;
		}

		print '<tr>' .
				'<td>&nbsp;</td>' .
				'<td>&nbsp;</td>' .
				'<td>&nbsp;</td>' .
				'<td><b>' . $totalSum . '</b></td>' .
				'<td><b>' . round($totalLPF / $rows) . '</b></td>' .
				'</tr>' . "\n";
		print "</table>\n";
		print '</div>';
	}
}

print '</div>';

########################################################################
include "$areaRoot/_footer.php"; ?>