| <?php | <?php |
| include_once ("../lib/common.inc.php"); | include_once ("../lib/common.inc.php"); |
| $topX = 10; | $topX = 10; |
| $query = "SELECT value, supplierName | $query = "SELECT value, supplierName |
| FROM `contractnotice` WHERE (YEAR(contractStart) >= 2009) AND childCN = 0 | FROM `contractnotice` WHERE (YEAR(contractStart) >= 2009) AND childCN = 0 |
| GROUP BY supplierABN ORDER BY value DESC limit $topX"; | GROUP BY supplierABN ORDER BY value DESC limit $topX"; |
| $result = mysql_query($query); | $result = mysql_query($query); |
| $suppliers = Array(); | $suppliers = Array(); |
| $values = Array(); | $values = Array(); |
| while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { | while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { |
| setlocale(LC_MONETARY, 'en_US'); | setlocale(LC_MONETARY, 'en_US'); |
| // $value = number_format(doubleval($row["value"]) , 2); | // $value = number_format(doubleval($row["value"]) , 2); |
| $suppliers[] = ucsmart($row[1]); | $suppliers[] = ucsmart($row[1]); |
| $values[] = doubleval($row["value"]); | $values[] = doubleval($row["value"]); |
| } | } |
| mysql_free_result($result); | mysql_free_result($result); |
| $query = "SELECT sum(a.value) as val, supplierCountry from (SELECT value, supplierName, supplierCountry | $query = "SELECT sum(a.value) as val, supplierCountry from (SELECT value, supplierName, supplierCountry |
| FROM `contractnotice` WHERE (YEAR(contractStart) >= 2009) AND childCN = 0 | FROM `contractnotice` WHERE (YEAR(contractStart) >= 2009) AND childCN = 0 |
| GROUP BY supplierName ORDER BY value LIMIT 18446744073709551610 OFFSET $topX) as a group by supplierCountry order by val DESC limit 5 offset 1"; | GROUP BY supplierName ORDER BY value LIMIT 18446744073709551610 OFFSET $topX) as a group by supplierCountry order by val DESC limit 5 offset 1"; |
| $result = mysql_query($query); | $result = mysql_query($query); |
| while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { | while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { |
| $suppliers[] = "Other suppliers in ".ucsmart($row["supplierCountry"]); | $suppliers[] = "Other suppliers in ".ucsmart($row["supplierCountry"]); |
| $values[] = doubleval($row[0]); | $values[] = doubleval($row[0]); |
| } | } |
| mysql_free_result($result); | mysql_free_result($result); |
| $query = "SELECT sum(a.value) as val, TRUNCATE(supplierPostcode,-2) as postcode from (SELECT value, supplierName, supplierPostcode, supplierCountry | $query = "SELECT sum(a.value) as val, TRUNCATE(supplierPostcode,-2) as postcode from (SELECT value, supplierName, supplierPostcode, supplierCountry |
| FROM `contractnotice` WHERE (YEAR(contractStart) >= 2009) AND childCN = 0 | FROM `contractnotice` WHERE (YEAR(contractStart) >= 2009) AND childCN = 0 |
| GROUP BY supplierName ORDER BY value LIMIT 18446744073709551610 OFFSET $topX) as a | GROUP BY supplierName ORDER BY value LIMIT 18446744073709551610 OFFSET $topX) as a |
| WHERE (supplierCountry LIKE 'Australia' OR supplierCountry LIKE 'AUSTRALIA') AND supplierPostcode < 10000 | WHERE (supplierCountry LIKE 'Australia' OR supplierCountry LIKE 'AUSTRALIA') AND supplierPostcode < 10000 |
| group by TRUNCATE(supplierPostcode,-2) | group by TRUNCATE(supplierPostcode,-2) |
| order by val DESC"; | order by val DESC"; |
| $result = mysql_query($query); | $result = mysql_query($query); |
| while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { | while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { |
| if ($row['postcode'][0] == 2 && $row['postcode'][1] == 6) $ACTvalue += $row[0]; | if ($row['postcode'][0] == 2 && $row['postcode'][1] == 6) $ACTvalue += $row[0]; |
| else if ($row['postcode'][0] == 2 || $row['postcode'][0] == 1) $NSWvalue += $row[0]; | else if ($row['postcode'][0] == 2 || $row['postcode'][0] == 1) $NSWvalue += $row[0]; |
| else if ($row['postcode'][0] == 3 || $row['postcode'][0] == 8) $Vicvalue += $row[0]; | else if ($row['postcode'][0] == 3 || $row['postcode'][0] == 8) $Vicvalue += $row[0]; |
| else if ($row['postcode'][0] == 4 || $row['postcode'][0] == 9) $QLDvalue += $row[0]; | else if ($row['postcode'][0] == 4 || $row['postcode'][0] == 9) $QLDvalue += $row[0]; |
| else if ($row['postcode'][0] == 5) $SAvalue += $row[0]; | else if ($row['postcode'][0] == 5) $SAvalue += $row[0]; |
| else if ($row['postcode'][0] == 6) $WAvalue += $row[0]; | else if ($row['postcode'][0] == 6) $WAvalue += $row[0]; |
| else if ($row['postcode'][0] == 7) $Tasvalue += $row[0]; | else if ($row['postcode'][0] == 7) $Tasvalue += $row[0]; |
| else if ($row['postcode'][0] == 0) $NTvalue += $row[0]; | else if ($row['postcode'][0] == 0) $NTvalue += $row[0]; |
| } | } |
| mysql_free_result($result); | mysql_free_result($result); |
| $suppliers[] = "Other suppliers in Australia - ACT"; | $suppliers[] = "Other suppliers in Australia - ACT"; |
| $values[] = doubleval($ACTvalue); | $values[] = doubleval($ACTvalue); |
| $suppliers[] = "Other suppliers in Australia - NSW"; | $suppliers[] = "Other suppliers in Australia - NSW"; |
| $values[] = doubleval($NSWvalue); | $values[] = doubleval($NSWvalue); |
| $suppliers[] = "Other suppliers in Australia - Victoria"; | $suppliers[] = "Other suppliers in Australia - Victoria"; |
| $values[] = doubleval($Vicvalue); | $values[] = doubleval($Vicvalue); |
| $suppliers[] = "Other suppliers in Australia - Queensland"; | $suppliers[] = "Other suppliers in Australia - Queensland"; |
| $values[] = doubleval($QLDvalue); | $values[] = doubleval($QLDvalue); |
| $suppliers[] = "Other suppliers in Australia - NT"; | $suppliers[] = "Other suppliers in Australia - NT"; |
| $values[] = doubleval($NTvalue); | $values[] = doubleval($NTvalue); |
| $suppliers[] = "Other suppliers in Australia - West Australia"; | $suppliers[] = "Other suppliers in Australia - West Australia"; |
| $values[] = doubleval($WAvalue); | $values[] = doubleval($WAvalue); |
| $suppliers[] = "Other suppliers in Australia - South Australia"; | $suppliers[] = "Other suppliers in Australia - South Australia"; |
| $values[] = doubleval($SAvalue); | $values[] = doubleval($SAvalue); |
| $suppliers[] = "Other suppliers in Australia - Tasmania"; | $suppliers[] = "Other suppliers in Australia - Tasmania"; |
| $values[] = doubleval($Tasvalue); | $values[] = doubleval($Tasvalue); |
| // Width and height of the graph | // Width and height of the graph |
| $width = 800; | $width = 800; |
| $height = 800; | $height = 1000; |
| // Create a graph instance | // Create a graph instance |
| $graph = new PieGraph($width, $height); | $graph = new PieGraph($width, $height); |
| $pieplot = new PiePlot($values); | $pieplot = new PiePlot($values); |
| $pieplot->SetCenter(400, 300); | $pieplot->SetCenter(400, floor($height/2)); |
| $pieplot->SetGuideLines(true, false); | $pieplot->SetGuideLines(true, false); |
| $pieplot->SetLegends($suppliers); | $pieplot->SetLegends($suppliers); |
| $pieplot->SetTheme('earth'); | $pieplot->SetTheme('earth'); |
| // Add the plot to the graph | // Add the plot to the graph |
| $graph->Add($pieplot); | $graph->Add($pieplot); |
| $graph->legend->SetPos(0.1, 0.97, 'left', 'bottom'); | $graph->legend->SetPos(0.1, 0.97, 'left', 'bottom'); |
| $graph->legend->SetColumns(2); | $graph->legend->SetColumns(2); |
| // Display the graph | // Display the graph |
| $graph->Stroke(); | $graph->Stroke(); |
| ?> | ?> |