development/bugs/graphOpenBugs.php - gerrit/www.eclipse.org/webtools - Git at Google


            
            <svg xmlns="http://www.w3.org/2000/svg" height="100%" width="100%">

            
            <?php

            
            	function drawGraph($title, $xmax, $ymax, $xlegend, $ylegend)

            
            	{

            
            		echo "<text style=\"text-anchor:middle\" x=\"50%\" y=\"10%\">$title</text>";

            
            		echo "<line style=\"stroke:rgb(128,128,128);stroke-width:1\" x1=\"15%\" y1=\"15%\" x2=\"15%\" y2=\"85%\"/>";

            
            		echo "<line style=\"stroke:rgb(128,128,128);stroke-width:1\" x1=\"15%\" y1=\"85%\" x2=\"85%\" y2=\"85%\"/>";

            
            		echo "<text style=\"text-anchor:middle\" x=\"50%\" y=\"93%\">$xlegend</text>";

            
            		echo "<text style=\"text-anchor:middle\" x=\"8%\" y=\"50%\">$ylegend</text>";

            
            		$delta = (int)$ymax/10;

            
            		for ($i = 0; $i < $ymax; $i++)

            
            		{

            
            			if ($i % $delta == 0)

            
            			{

            
            				$y = 85 - ($i/$ymax*70);

            
            				echo "<text style=\"text-anchor:end\" x=\"14.5%\" y=\"$y%\">$i</text>";

            
            				echo "<line style=\"stroke:rgb(128,128,128);stroke-width:1\" x1=\"14.5%\" y1=\"$y%\" x2=\"15.5%\" y2=\"$y%\"/>";

            
            			}

            
            		}

            
            	}


            	function countTimeIntervals($start, $end)

            
            	{

            
            		$count = 0;

            
            		while ($start < $end)

            
            		{

            
            			$count++;

            
            			$start = date("YmdHis", mktime(substr($start, 8, 2), substr($start, 10, 2), substr($start, 12, 2), substr($start, 4, 2), substr($start, 6, 2) + 7, substr($start, 0, 4)));

            
            		}

            
            		$count++;

            
            		return $count;

            
            	}


            	function plot($xmax, $ymax, $width, $height, $xstart, $ystart, $prevx, $prevy, $currx, $curry, $x, $y, $r, $g, $b, $text)

            
            	{

            
            		$x1 = $prevx/$xmax*$width + $xstart;

            
            		$y1 = $ystart - ($prevy/$ymax*$height);

            
            		$x2 = $currx/$xmax*$width + $xstart;

            
            		$y2 = $ystart - ($curry/$ymax*$height);

            
            		echo "<line style=\"stroke:rgb($r,$g,$b);stroke-width:1\" x1=\"$x1%\" y1=\"$y1%\" x2=\"$x2%\" y2=\"$y2%\"/>\n";

            
            		if ($text != null)

            
            		{

            
            			echo "<text fill=\"rgb($r,$g,$b)\" style=\"text-anchor:middle\" x=\"$x2%\" y=\"";

            
            			echo $y2 - 1;

            
            			echo "%\">$text</text>";

            
            		}

            
            		$i = (int)$xmax/10;

            
            		if ($currx == 0 || $currx % $i == 0)

            
            		{

            
            			echo "<text style=\"text-anchor:middle\" x=\"$x2%\" y=\"88%\">";

            
            			echo substr($x, 0, 8);

            
            			echo "</text>";

            
            			echo "<line style=\"stroke:rgb(128,128,128);stroke-width:1\" x1=\"$x2%\" y1=\"84.5%\" x2=\"$x2%\" y2=\"85.5%\"/>";

            
            		}

            
            	}

            
            ?>

            
            <?php

            
            	require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_bugs_ro.class.php";


            	# Connect to database

            
            	$allBugsQuery = "SELECT

            
            					BUG.bug_id,

            
            					BUG.creation_ts

            
            				FROM

            
            					bugs AS BUG

            
            					INNER JOIN products AS PROD ON PROD.id = BUG.product_id

            
            				WHERE

            
            					PROD.name='Web Tools'

            
            				ORDER BY

            
            					BUG.creation_ts";


            	$resolvedBugsQuery = "SELECT

            
            					BUG_ACT.bug_id,

            
            					BUG_ACT.bug_when,

            
            					BUG_ACT.added

            
            				FROM

            
            					bugs_activity AS BUG_ACT

            
            					INNER JOIN bugs AS BUG ON BUG.bug_id = BUG_ACT.bug_id

            
            					INNER JOIN products AS PROD ON PROD.id = BUG.product_id

            
            					INNER JOIN fielddefs AS FIELD ON FIELD.fieldid = BUG_ACT.fieldid

            
            				WHERE

            
            					PROD.name='Web Tools'

            
            					AND FIELD.fieldid=8

            
            					AND (BUG_ACT.added='RESOLVED' OR BUG_ACT.added='REOPENED')

            
            				ORDER BY

            
            					BUG_ACT.bug_when";


            	$dbc = new DBConnectionBugs();

            
            	$dbh = $dbc->connect();

            
            	$rs = mysql_query($allBugsQuery, $dbh);


            	if(mysql_errno($dbh) > 0)

            
            	{

            
            		echo "There was an error processing this request".


            		# For debugging purposes - don't display this stuff in a production page.

            
            		# echo mysql_error($dbh);


            		# Mysql disconnects automatically, but I like my disconnects to be explicit.

            
            		$dbc->disconnect();

            
            		exit;

            
            	}


            	$today = date("YmdHis");

            
            	$cutoff = 20040801000000;

            
            	$prevBugCount = 0;

            
            	$currBugCount = 0;

            
            	$dateCount = 0;

            
            	$xmax = countTimeIntervals($cutoff, $today);

            
            	$ymax = mysql_num_rows($rs);

            
            	drawGraph("New / Assigned / Reopened Bugs", $xmax, $ymax, "Time", "# Bugs");

            
            	$total = array();

            
            	while($myrow = mysql_fetch_assoc($rs))

            
            	{

            
            		$creation_ts = $myrow['creation_ts'];

            
            		$creation_ts = substr($creation_ts, 0, 4) . substr($creation_ts, 5, 2) . substr($creation_ts, 8, 2) . substr($creation_ts, 11, 2) . substr($creation_ts, 14, 2) . substr($creation_ts, 17, 2);

            
            		if ($creation_ts > $cutoff)

            
            		{

            
            			$total[] = $currBugCount;

            
            			plot($xmax, $ymax, 70, 70, 15, 85, $dateCount, $prevBugCount, $dateCount + 1, $currBugCount, $cutoff, $currBugCount, 0, 0, 128, null);

            
            			$prevBugCount = $currBugCount;

            
            			$dateCount++;

            
            			$cutoff = date("YmdHis", mktime(substr($cutoff, 8, 2), substr($cutoff, 10, 2), substr($cutoff, 12, 2), substr($cutoff, 4, 2), substr($cutoff, 6, 2) + 7, substr($cutoff, 0, 4)));

            
            		}

            
            		$currBugCount++;

            
            	}

            
            	$total[] = $currBugCount;

            
            	plot($xmax, $ymax, 70, 70, 15, 85, $dateCount, $prevBugCount, $dateCount + 1, $currBugCount, $cutoff, $currBugCount, 0, 0, 128, "Total: " . $currBugCount);


            	$rs = mysql_query($resolvedBugsQuery, $dbh);


            	if(mysql_errno($dbh) > 0)

            
            	{

            
            		echo "There was an error processing this request".


            		# For debugging purposes - don't display this stuff in a production page.

            
            		# echo mysql_error($dbh);


            		# Mysql disconnects automatically, but I like my disconnects to be explicit.

            
            		$dbc->disconnect();

            
            		exit;

            
            	}


            	$cutoff = 20040801000000;

            
            	$prevBugCount = 0;

            
            	$currBugCount = 0;

            
            	$dateCount = 0;

            
            	while($myrow = mysql_fetch_assoc($rs))

            
            	{

            
            		$bug_when = $myrow['bug_when'];

            
            		$bug_when = substr($bug_when, 0, 4) . substr($bug_when, 5, 2) . substr($bug_when, 8, 2) . substr($bug_when, 11, 2) . substr($bug_when, 14, 2) . substr($bug_when, 17, 2);

            
            		if ($bug_when > $cutoff)

            
            		{

            
            			plot($xmax, $ymax, 70, 70, 15, 85, $dateCount, $prevBugCount, $dateCount + 1, $total[$dateCount] - $currBugCount, $cutoff, $total[$dateCount] - $currBugCount, 255, 128, 0, null);

            
            			$prevBugCount = $total[$dateCount] - $currBugCount;

            
            			$dateCount++;

            
            			$cutoff = date("YmdHis", mktime(substr($cutoff, 8, 2), substr($cutoff, 10, 2), substr($cutoff, 12, 2), substr($cutoff, 4, 2), substr($cutoff, 6, 2) + 7, substr($cutoff, 0, 4)));

            
            		}

            
            		if ($myrow['added'] == "REOPENED")

            
            		{

            
            			$currBugCount--;

            
            		}

            
            		else

            
            		{

            
            			$currBugCount++;

            
            		}

            
            	}

            
            	plot($xmax, $ymax, 70, 70, 15, 85, $dateCount, $prevBugCount, $dateCount + 1, $total[$dateCount] - $currBugCount, $cutoff, $total[$dateCount] - $currBugCount, 255, 128, 0, "New/Assigned/Reopened: " . ($total[$dateCount] - $currBugCount));


            	$dbc->disconnect();

            
            	$rs = null;

            
            	$dbh = null;

            
            	$dbc = null;

            
            ?>

            
            </svg>
	<svg xmlns="http://www.w3.org/2000/svg" height="100%" width="100%">
	<?php
	function drawGraph($title, $xmax, $ymax, $xlegend, $ylegend)
	{
	echo "<text style=\"text-anchor:middle\" x=\"50%\" y=\"10%\">$title</text>";
	echo "<line style=\"stroke:rgb(128,128,128);stroke-width:1\" x1=\"15%\" y1=\"15%\" x2=\"15%\" y2=\"85%\"/>";
	echo "<line style=\"stroke:rgb(128,128,128);stroke-width:1\" x1=\"15%\" y1=\"85%\" x2=\"85%\" y2=\"85%\"/>";
	echo "<text style=\"text-anchor:middle\" x=\"50%\" y=\"93%\">$xlegend</text>";
	echo "<text style=\"text-anchor:middle\" x=\"8%\" y=\"50%\">$ylegend</text>";
	$delta = (int)$ymax/10;
	for ($i = 0; $i < $ymax; $i++)
	{
	if ($i % $delta == 0)
	{
	$y = 85 - ($i/$ymax*70);
	echo "<text style=\"text-anchor:end\" x=\"14.5%\" y=\"$y%\">$i</text>";
	echo "<line style=\"stroke:rgb(128,128,128);stroke-width:1\" x1=\"14.5%\" y1=\"$y%\" x2=\"15.5%\" y2=\"$y%\"/>";
	}
	}
	}

	function countTimeIntervals($start, $end)
	{
	$count = 0;
	while ($start < $end)
	{
	$count++;
	$start = date("YmdHis", mktime(substr($start, 8, 2), substr($start, 10, 2), substr($start, 12, 2), substr($start, 4, 2), substr($start, 6, 2) + 7, substr($start, 0, 4)));
	}
	$count++;
	return $count;
	}

	function plot($xmax, $ymax, $width, $height, $xstart, $ystart, $prevx, $prevy, $currx, $curry, $x, $y, $r, $g, $b, $text)
	{
	$x1 = $prevx/$xmax*$width + $xstart;
	$y1 = $ystart - ($prevy/$ymax*$height);
	$x2 = $currx/$xmax*$width + $xstart;
	$y2 = $ystart - ($curry/$ymax*$height);
	echo "<line style=\"stroke:rgb($r,$g,$b);stroke-width:1\" x1=\"$x1%\" y1=\"$y1%\" x2=\"$x2%\" y2=\"$y2%\"/>\n";
	if ($text != null)
	{
	echo "<text fill=\"rgb($r,$g,$b)\" style=\"text-anchor:middle\" x=\"$x2%\" y=\"";
	echo $y2 - 1;
	echo "%\">$text</text>";
	}
	$i = (int)$xmax/10;
	if ($currx == 0 \|\| $currx % $i == 0)
	{
	echo "<text style=\"text-anchor:middle\" x=\"$x2%\" y=\"88%\">";
	echo substr($x, 0, 8);
	echo "</text>";
	echo "<line style=\"stroke:rgb(128,128,128);stroke-width:1\" x1=\"$x2%\" y1=\"84.5%\" x2=\"$x2%\" y2=\"85.5%\"/>";
	}
	}
	?>
	<?php
	require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_bugs_ro.class.php";

	# Connect to database
	$allBugsQuery = "SELECT
	BUG.bug_id,
	BUG.creation_ts
	FROM
	bugs AS BUG
	INNER JOIN products AS PROD ON PROD.id = BUG.product_id
	WHERE
	PROD.name='Web Tools'
	ORDER BY
	BUG.creation_ts";

	$resolvedBugsQuery = "SELECT
	BUG_ACT.bug_id,
	BUG_ACT.bug_when,
	BUG_ACT.added
	FROM
	bugs_activity AS BUG_ACT
	INNER JOIN bugs AS BUG ON BUG.bug_id = BUG_ACT.bug_id
	INNER JOIN products AS PROD ON PROD.id = BUG.product_id
	INNER JOIN fielddefs AS FIELD ON FIELD.fieldid = BUG_ACT.fieldid
	WHERE
	PROD.name='Web Tools'
	AND FIELD.fieldid=8
	AND (BUG_ACT.added='RESOLVED' OR BUG_ACT.added='REOPENED')
	ORDER BY
	BUG_ACT.bug_when";

	$dbc = new DBConnectionBugs();
	$dbh = $dbc->connect();
	$rs = mysql_query($allBugsQuery, $dbh);

	if(mysql_errno($dbh) > 0)
	{
	echo "There was an error processing this request".

	# For debugging purposes - don't display this stuff in a production page.
	# echo mysql_error($dbh);

	# Mysql disconnects automatically, but I like my disconnects to be explicit.
	$dbc->disconnect();
	exit;
	}

	$today = date("YmdHis");
	$cutoff = 20040801000000;
	$prevBugCount = 0;
	$currBugCount = 0;
	$dateCount = 0;
	$xmax = countTimeIntervals($cutoff, $today);
	$ymax = mysql_num_rows($rs);
	drawGraph("New / Assigned / Reopened Bugs", $xmax, $ymax, "Time", "# Bugs");
	$total = array();
	while($myrow = mysql_fetch_assoc($rs))
	{
	$creation_ts = $myrow['creation_ts'];
	$creation_ts = substr($creation_ts, 0, 4) . substr($creation_ts, 5, 2) . substr($creation_ts, 8, 2) . substr($creation_ts, 11, 2) . substr($creation_ts, 14, 2) . substr($creation_ts, 17, 2);
	if ($creation_ts > $cutoff)
	{
	$total[] = $currBugCount;
	plot($xmax, $ymax, 70, 70, 15, 85, $dateCount, $prevBugCount, $dateCount + 1, $currBugCount, $cutoff, $currBugCount, 0, 0, 128, null);
	$prevBugCount = $currBugCount;
	$dateCount++;
	$cutoff = date("YmdHis", mktime(substr($cutoff, 8, 2), substr($cutoff, 10, 2), substr($cutoff, 12, 2), substr($cutoff, 4, 2), substr($cutoff, 6, 2) + 7, substr($cutoff, 0, 4)));
	}
	$currBugCount++;
	}
	$total[] = $currBugCount;
	plot($xmax, $ymax, 70, 70, 15, 85, $dateCount, $prevBugCount, $dateCount + 1, $currBugCount, $cutoff, $currBugCount, 0, 0, 128, "Total: " . $currBugCount);

	$rs = mysql_query($resolvedBugsQuery, $dbh);

	if(mysql_errno($dbh) > 0)
	{
	echo "There was an error processing this request".

	# For debugging purposes - don't display this stuff in a production page.
	# echo mysql_error($dbh);

	# Mysql disconnects automatically, but I like my disconnects to be explicit.
	$dbc->disconnect();
	exit;
	}

	$cutoff = 20040801000000;
	$prevBugCount = 0;
	$currBugCount = 0;
	$dateCount = 0;
	while($myrow = mysql_fetch_assoc($rs))
	{
	$bug_when = $myrow['bug_when'];
	$bug_when = substr($bug_when, 0, 4) . substr($bug_when, 5, 2) . substr($bug_when, 8, 2) . substr($bug_when, 11, 2) . substr($bug_when, 14, 2) . substr($bug_when, 17, 2);
	if ($bug_when > $cutoff)
	{
	plot($xmax, $ymax, 70, 70, 15, 85, $dateCount, $prevBugCount, $dateCount + 1, $total[$dateCount] - $currBugCount, $cutoff, $total[$dateCount] - $currBugCount, 255, 128, 0, null);
	$prevBugCount = $total[$dateCount] - $currBugCount;
	$dateCount++;
	$cutoff = date("YmdHis", mktime(substr($cutoff, 8, 2), substr($cutoff, 10, 2), substr($cutoff, 12, 2), substr($cutoff, 4, 2), substr($cutoff, 6, 2) + 7, substr($cutoff, 0, 4)));
	}
	if ($myrow['added'] == "REOPENED")
	{
	$currBugCount--;
	}
	else
	{
	$currBugCount++;
	}
	}
	plot($xmax, $ymax, 70, 70, 15, 85, $dateCount, $prevBugCount, $dateCount + 1, $total[$dateCount] - $currBugCount, $cutoff, $total[$dateCount] - $currBugCount, 255, 128, 0, "New/Assigned/Reopened: " . ($total[$dateCount] - $currBugCount));

	$dbc->disconnect();
	$rs = null;
	$dbh = null;
	$dbc = null;
	?>
	</svg>