web-gcov/cron/graph.php

<?php
/*
  +----------------------------------------------------------------------+
  | PHP QA GCOV Website                                                  |
  +----------------------------------------------------------------------+
  | Copyright (c) The PHP Group                                          |
  +----------------------------------------------------------------------+
  | This source file is subject to version 3.01 of the PHP license,      |
  | that is bundled with this package in the file LICENSE, and is        |
  | available through the world-wide-web at the following url:           |
  | http://www.php.net/license/3_01.txt                                  |
  | If you did not receive a copy of the PHP license and are unable to   |
  | obtain it through the world-wide-web, please send a note to          |
  | license@php.net so we can mail you a copy immediately.               |
  +----------------------------------------------------------------------+
  | Author: Daniel Pronych <pronych@php.net>                             |
  |         Nuno Lopes <nlopess@php.net>                                 |
  +----------------------------------------------------------------------+
*/

// File to generate graphs for a weekly or monthly basis

/*
Inportant Notes:

* We select the average number of each of the four criteria with the limitation of one data point
* allowed per period (day/month)

* Graphs can only be generated for the period of time if at least more than one data point exist
* during that time frame. Otherwise an error would occur when starting the graph creation process.

*/

if(!defined('CRON_PHP'))
{
	die(basename($_SERVER['PHP_SELF']).": Sorry this file must be called by a cron script.\n");
}

// periods for graph generation
$graph_modes = array(
		// title, xlabel, SQL period, php func converter (from mysql to x ploting)
	7	=> array('Week', 'Day', 'DATE', 'date2day'),
	30	=> array('Month', 'Day', 'DATE', 'date2day'),
	// 334 = 1 year - 1 month (so that we dont have mixed data with the current and last year month results)
	334	=> array('Year', 'Month', 'MONTH', 'month2text')
);

function date2day($d)
{
	return substr($d, 8);
}

function month2text($m)
{
	return date('M', mktime(0, 0, 0, $m));
}

include 'lib/jpgraph/jpgraph.php';
include 'lib/jpgraph/jpgraph_line.php';

// make sure the directory exists
@mkdir("$outdir/graphs");

foreach ($graph_modes as $days => $opts) {
	gen_graph($days, $opts[0], $opts[1], $opts[2], $opts[3]);
}


function gen_graph($graph_days, $graph_mode_text, $xLabel, $sqlgroup, $date2text)
{
	global $mysqlconn, $version_id, $outdir;

	try
	{
		$sql = "SELECT $sqlgroup(build_datetime), avg(build_percent_code_coverage), avg(build_numwarnings), avg(build_numfailures+IFNULL(build_numxfailures,0)), avg(build_numleaks) FROM local_builds WHERE DATE_SUB(CURDATE() , INTERVAL ? DAY) <= build_datetime AND version_id=? GROUP BY $sqlgroup(build_datetime) ORDER BY build_datetime";
		$stmt = $mysqlconn->prepare($sql);
		$stmt->execute(array($graph_days, $version_id));
	}
	catch(PDOException $e)
	{
	// if error occurs log, outptu and ensure the version_id is not legimate
	//$version_id = 0;
	}

	$data_x = array();

	$data_y = array();
	$data_y['warnings'] = array();	// stores number of warnings
	$data_y['codecoverage'] = array();	// stores number of errors
	$data_y['failures'] = array();	// stores number of test failures
	$data_y['memleaks'] = array();	// stores nunber if memory leaks

	$current_date = date('M d');

	$graph_array = array(
				array('name' => 'codecoverage',
						'title' => 'Code Coverage',
						'yformat' => 'percent'),
				array('name' => 'failures',
						'title' => 'Test Failures',
						'yformat' => 'integer'),
				array('name' => 'memleaks',
						'title' => 'Memory Leaks',
						'yformat' => 'integer'),
				array('name' => 'warnings',
						'title' => 'Compile Warnings',
						'yformat' => 'integer')
			);

	while($row = $stmt->fetch())
	{
		list($date, $build_codecoverage, $build_numwarnings, $build_numfailures, $build_numleaks) = $row;

		$date = $date2text($date);

		if ($build_codecoverage !== NULL) {
			$data_y['codecoverage'][] = $build_codecoverage;
			$data_x['codecoverage'][] = $date;
		}

		if ($build_numfailures !== NULL) {
			$data_y['failures'][] = $build_numfailures;
			$data_x['failures'][] = $date;
		}

		if ($build_numleaks !== NULL) {
			$data_y['memleaks'][] = $build_numleaks;
			$data_x['memleaks'][] = $date;
		}

		$data_y['warnings'][] = $build_numwarnings;
		$data_x['warnings'][] = $date;

	} // Cycle through the results

	// Ensure more than one data row exist for the period of time
	if(count($data_x))
	{
		// Create the graphs
		foreach($graph_array as $curgraph)
		{
			// Ensure individual graph has enough data to be drawn
			if(count($data_y[$curgraph['name']]) > 1)
			{
				$graph_filename = $outdir.DIRECTORY_SEPARATOR.'graphs'.DIRECTORY_SEPARATOR.$curgraph['name'].'_'.$graph_mode_text.'.png';

				// Create the graph. These two calls are always required
				$graph = new Graph(400, 300, 'auto');

				$graph->img->SetMargin(40 ,40 ,40, 40);
	
				$graph->SetScale('textlin');
				$graph->title->Set($curgraph['title'].' for the '
					.$graph_mode_text. ' Ending '.$current_date);

				$graph->SetShadow();
				//$graph->yscale->SetGrace(10,10); 

				// Create the linear plot on the Y axis
				$lineplot= new LinePlot($data_y[$curgraph['name']]); 
			
				$lineplot->SetColor('blue');

				// Add the plot to the graph
				$graph->Add($lineplot);
				$graph->xaxis->SetTitle($xLabel);
				$graph->xaxis->SetTickLabels($data_x[$curgraph['name']]);
				$graph->xaxis->SetTextTickInterval(1);

				if($curgraph['yformat'] == 'percent')
					$graph->yaxis->SetTitle('Percentage of '.$curgraph['title']);
				else // For now else assume integer
					$graph->yaxis->SetTitle('Number of '.$curgraph['title']);

				// Output the graph to a file location
				$graph->Stroke($graph_filename);

			} // End check for number of data points on the graph
			else
				echo "graph.php: graph of mode $curgraph[name] had an insufficient number of valid data points.\n";
		} // End looping each graph type

		echo "graph.php: completed the $graph_mode_text graph mode\n";
	} // End check that number of rows > 1
	else
	{
		echo "graph.php: has insufficent data rows to make these graphs for $version_id \n";
	}
}