fix value/sum
[contractdashboard.git] / graphs / displayContractStartingGraph.php
blob:a/graphs/displayContractStartingGraph.php -> blob:b/graphs/displayContractStartingGraph.php
--- a/graphs/displayContractStartingGraph.php
+++ b/graphs/displayContractStartingGraph.php
@@ -1,7 +1,7 @@
 <?php

 include_once("../lib/common.inc.php");

 $query = "SELECT YEAR(contractStart), MONTH(contractStart),

-value, count(1) as count FROM `contractnotice`

+SUM(value) as val, count(1) as count FROM `contractnotice`

 WHERE (YEAR(contractStart) >= 2008)

 AND childCN = 0

 GROUP BY MONTH(contractStart), YEAR(contractStart) 

@@ -12,11 +12,11 @@
 $values = Array();

 while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {

 setlocale(LC_MONETARY, 'en_US');

-$value = number_format(doubleval($row["value"]),2);

+$value = number_format(doubleval($row["val"]),2);

 $month_name = date( 'F', mktime(0, 0, 0, $row[1]) );

 	$dates[] = $month_name." {$row[0]}";

 	$counts[] = doubleval($row["count"]);

-	$values[] = doubleval($row["value"]);

+	$values[] = doubleval($row["val"]);

 }

 mysql_free_result($result);