updated update script and merged lobbylens admin scripts
[contractdashboard.git] / graphs / displayContractPublishedGraph.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
<?php
include_once("../lib/common.inc.php");
$query = "SELECT YEAR(publishDate), MONTH(publishDate),
value, count(1) as count FROM `contractnotice`
WHERE (YEAR(publishDate) >= 2008)
AND childCN = 0
GROUP BY MONTH(publishDate), YEAR(publishDate) 
ORDER BY YEAR(publishDate), MONTH(publishDate)";
 
$result = mysql_query($query);
$dates = Array();
$values = Array();
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
setlocale(LC_MONETARY, 'en_US');
$value = number_format(doubleval($row["value"]),2);
$month_name = date( 'F', mktime(0, 0, 0, $row[1]) );
        $dates[] = $month_name." {$row[0]}";
        $counts[] = doubleval($row["count"]);
        $values[] = doubleval($row["value"]);
}
mysql_free_result($result);
 
 // Width and height of the graph
$width = 1000; $height = 400;
 
// Create a graph instance
$graph = new Graph($width,$height);
 $graph->SetMargin(85,45,45,115);
 
// Specify what scale we want to use,
$graph->SetScale('textlog');
 
// Setup a title for the graph
$graph->title->Set('Contracts Starting - All Agencies since July 2008');
$graph->SetUserFont("ttf-liberation/LiberationSans-Regular.ttf");
$graph->title->SetFont(FF_USERFONT,FS_NORMAL,12);
 
// Setup font for axis
$graph->xaxis->SetFont(FF_USERFONT,FS_NORMAL,10);
$graph->yaxis->SetFont(FF_USERFONT,FS_NORMAL,10);
 
// Setup titles and X-axis labels
$graph->xaxis->SetTickLabels($dates);
$graph->xaxis->SetLabelAngle(50);
 
// Create the linear plot
$valueplot=new LinePlot($values);
$valueplot->SetFillColor('orange@0.5');
$valueplot->SetLegend("Total Value");
$countplot=new LinePlot($counts);
$countplot->SetFillColor('red@0.5');
$countplot->SetLegend("Number of Contracts");
 
// Add the plot to the graph
$graph->Add($valueplot);
$graph->SetYScale(0,'lin');
$graph->ynaxis[0]->SetColor('red');
$graph->AddY(0,$countplot);
 
// Display the graph
$graph->Stroke();
?>