| <?php | <?php |
| $includedFlot = false; | |
| function includeFlot() { | |
| if (!$includedFlot) { | |
| echo ' <!--[if lte IE 8]><script language="javascript" type="text/javascript" src="lib/flot/excanvas.min.js"></script><![endif]--> | |
| <script language="javascript" type="text/javascript" src="lib/flot/jquery.flot.js"></script> | |
| <script language="javascript" type="text/javascript" src="lib/flot/jquery.flot.pie.js"></script> | |
| '; | |
| $includedFlot = true; | |
| } | |
| } | |
| function CNDistributionGraph() { | |
| global $conn; | |
| includeFlot(); | |
| ?> | |
| <center><div id="cndist" style="width:900px;height:550px"></div></center> | |
| <script type="text/javascript"> | |
| $(function () { | |
| var d1 = []; | |
| <?php | |
| $query = 'select cnid, count(*) from (select ("CNID" - MOD("CNID",100)) as cnid from contractnotice where "CNID" < 999999) as a group by cnid order by cnid'; | |
| $query = $conn->prepare($query); | |
| $query->execute(); | |
| if (!$query) { | |
| databaseError($conn->errorInfo()); | |
| return Array(); | |
| } | |
| foreach ($query->fetchAll() as $delta) { | |
| echo "d1.push([ ".intval($delta['cnid']).", ".intval($delta['count'])."]); \n"; | |
| }; | |
| ?> | |
| var placeholder = $("#cndist"); | |
| var plot = $.plot(placeholder, [ | |
| { | |
| data: d1, | |
| bars: { show: true } | |
| }, | |
| ], | |
| { | |
| grid: { hoverable: true, clickable: true, labelMargin: 17 }, | |
| }); | |
| }); | |
| </script> | |
| <?php | |
| } | |
| function agenciesGraph() { | function agenciesGraph() { |
| $topX = 15; | |
| $query = "SELECT SUM(value) as val, agencyName FROM `contractnotice` WHERE (YEAR(contractStart) >= $startYear) AND childCN = 0 | global $conn; |
| GROUP BY agencyName ORDER BY val DESC limit $topX"; | includeFlot(); |
| $result = mysql_query($query); | $query = 'SELECT SUM("value") as val, MAX(contractnotice."agencyName") as agencyname FROM contractnotice join agency on contractnotice."agencyName"=agency."agencyName" WHERE "childCN" = 0 |
| $agencies = Array(); | GROUP BY abn ORDER BY SUM("value") DESC'; |
| $values = Array(); | $query = $conn->prepare($query); |
| while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { | $query->execute(); |
| $agencies[] = $row['agencyName']; | if (!$query) { |
| $values[] = doubleval($row["val"]); | databaseError($conn->errorInfo()); |
| } | return Array(); |
| mysql_free_result($result); | } |
| ?> | |
| $query = "SELECT sum(a.val) as value, count(1) as count from (SELECT SUM(value) as val, agencyName FROM `contractnotice` WHERE (YEAR(contractStart) >= $startYear) AND childCN = 0 | <script type="text/javascript"> |
| GROUP BY agencyName ORDER BY val DESC LIMIT 18446744073709551610 OFFSET $topX) as a"; | $(function () { |
| $result = mysql_query($query); | // data |
| while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { | var data = [ |
| $agencies[] = $row['count'] . " other agencies"; | <?php |
| $values[] = doubleval($row[0]); | foreach ($query->fetchAll() as $row) { |
| } | echo '{ label: "'.$row['agencyname'].'", data: '.doubleval($row["val"]).'},'; |
| mysql_free_result($result); | } |
| ?> | |
| ]; | |
| // GRAPH 7 | |
| $.plot($("#graph7"), data, | |
| { | |
| series: { | |
| pie: { | |
| show: true, | |
| radius: 1, | |
| tilt: 0.75, | |
| label: { | |
| show: true, | |
| radius: 1, | |
| formatter: function(label, series){ | |
| return '<div style="font-size:8pt;text-align:center;padding:2px;color:white;">'+label+': '+Math.round(series.percent)+'%</div>'; | |
| }, | |
| background: { | |
| opacity: 0.5, | |
| color: '#000' | |
| } | |
| }, | |
| combine: { | |
| color: '#999', | |
| threshold: 0.012 | |
| } | |
| } | |
| }, | |
| legend: { | |
| show: false | |
| } | |
| }); | |
| }); | |
| </script> | |
| <div id="graph7" style="width:900px;height:550px"></div> | |
| <?php | |
| }; | }; |
| function agencySuppliersGraph($agency) { | function agencySuppliersGraph($agency) { |
| $agency = "AusAid"; | $agency = "AusAid"; |
| $topX = 15; | $topX = 15; |
| $query = "SELECT SUM(value) as val, supplierName FROM `contractnotice` WHERE (YEAR(contractStart) >= $startYear) AND childCN = 0 AND agencyName = '$agency' | $query = "SELECT SUM(value) as val, supplierName FROM `contractnotice` WHERE (YEAR(contractStart) >= $startYear) AND childCN = 0 AND agencyName = '$agency' |
| GROUP BY lower(supplierName) ORDER BY val DESC limit $topX"; | GROUP BY lower(supplierName) ORDER BY val 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)) { |
| $suppliers[] = ucsmart($row['supplierName']); | $suppliers[] = ucsmart($row['supplierName']); |
| $values[] = doubleval($row["val"]); | $values[] = doubleval($row["val"]); |
| } | } |
| mysql_free_result($result); | mysql_free_result($result); |
| $query = "SELECT sum(a.val) as value, count(1) as count from (SELECT SUM(value) as val, supplierName FROM `contractnotice` WHERE (YEAR(contractStart) >= $startYear) AND childCN = 0 and agencyName = '$agency' | $query = "SELECT sum(a.val) as value, count(1) as count from (SELECT SUM(value) as val, supplierName FROM `contractnotice` WHERE (YEAR(contractStart) >= $startYear) AND childCN = 0 and agencyName = '$agency' |
| GROUP BY lower(supplierName) ORDER BY val DESC LIMIT 18446744073709551610 OFFSET $topX) as a"; | GROUP BY lower(supplierName) ORDER BY val DESC LIMIT 18446744073709551610 OFFSET $topX) as a"; |
| $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['count'] > 0) { | if ($row['count'] > 0) { |
| $suppliers[] = $row['count'] . " other suppliers"; | $suppliers[] = $row['count'] . " other suppliers"; |
| $values[] = doubleval($row[0]); | $values[] = doubleval($row[0]); |
| } | } |
| } | } |
| mysql_free_result($result); | mysql_free_result($result); |
| } | } |
| function CnCGraph() { | function CnCGraph() { |
| $query = "select procurementMethod, count(1) as count, SUM(value) as val, MONTH(contractStart) as month, YEAR(contractStart) as year from `contractnotice` | $query = "select procurementMethod, count(1) as count, SUM(value) as val, MONTH(contractStart) as month, YEAR(contractStart) as year from `contractnotice` |
| where $agencyQ $supplierQ $standardQ group by procurementMethod,year,month order by procurementMethod,year,month"; | where $agencyQ $supplierQ $standardQ group by procurementMethod,year,month order by procurementMethod,year,month"; |
| $result = mysql_query($query); | $result = mysql_query($query); |
| $methods = Array("Direct","Open","Select"); | $methods = Array("Direct","Open","Select"); |
| $dates = Array(); | $dates = Array(); |
| $methodCountsP = Array(); | $methodCountsP = Array(); |
| $methodCounts = Array(); | $methodCounts = Array(); |
| $maxValue = 0; | $maxValue = 0; |
| while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { | while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { |
| setlocale(LC_MONETARY, 'en_US'); | setlocale(LC_MONETARY, 'en_US'); |
| if ($row['val'] > $maxValue) $maxValue = $row['val']; | if ($row['val'] > $maxValue) $maxValue = $row['val']; |
| $date = date( 'F ', mktime(0, 0, 0, $row["month"]) ). $row["year"]; | $date = date( 'F ', mktime(0, 0, 0, $row["month"]) ). $row["year"]; |
| if (array_search($date,$dates) === false ) { | if (array_search($date,$dates) === false ) { |
| $dates[$row["year"]*100 + $row["month"]] = $date; | $dates[$row["year"]*100 + $row["month"]] = $date; |
| ksort($dates); | ksort($dates); |
| } | } |
| $methodCountsP[$row["procurementMethod"]][$date] = $row["count"]; | $methodCountsP[$row["procurementMethod"]][$date] = $row["count"]; |
| } | } |
| foreach ($methods as $method) { | foreach ($methods as $method) { |
| foreach($dates as $date) { | foreach($dates as $date) { |
| if ($methodCountsP[$method][$date] > 0) $methodCounts[$method][] = $methodCountsP[$method][$date]; | if ($methodCountsP[$method][$date] > 0) $methodCounts[$method][] = $methodCountsP[$method][$date]; |
| else $methodCounts[$method][] = 0; | else $methodCounts[$method][] = 0; |
| } | } |
| } | } |
| $dates = array_values($dates); | $dates = array_values($dates); |
| $totalRecords = array_sum_all($methodCounts); | $totalRecords = array_sum_all($methodCounts); |
| mysql_free_result($result); | mysql_free_result($result); |
| function formatCallback($aVal) { | function formatCallback($aVal) { |
| global $totalRecords; | global $totalRecords; |
| return percent($aVal, $totalRecords) . "%"; | return percent($aVal, $totalRecords) . "%"; |
| } | } |
| $attributes = Array(); | $attributes = Array(); |
| $attributeNames = Array( | $attributeNames = Array( |
| "Consultancies", | "Consultancies", |
| "Confidentialities" | "Confidentialities" |
| ); | ); |
| $query = "SELECT 'consultancy', count(1) FROM `contractnotice` WHERE $agencyQ $supplierQ consultancy='Yes' AND childCN = 0;"; | $query = "SELECT 'consultancy', count(1) FROM `contractnotice` WHERE $agencyQ $supplierQ consultancy='Yes' AND childCN = 0;"; |
| $result = mysql_query($query); | $result = mysql_query($query); |
| $row = mysql_fetch_array($result, MYSQL_BOTH); | $row = mysql_fetch_array($result, MYSQL_BOTH); |
| $attributes[0] = $row[1]; | $attributes[0] = $row[1]; |
| $query = "SELECT 'confidentiality', count(1) FROM `contractnotice` WHERE $agencyQ $supplierQ (confidentialityContract='Yes' OR confidentialityOutputs='Yes') AND childCN = 0;"; | $query = "SELECT 'confidentiality', count(1) FROM `contractnotice` WHERE $agencyQ $supplierQ (confidentialityContract='Yes' OR confidentialityOutputs='Yes') AND childCN = 0;"; |
| $result = mysql_query($query); | $result = mysql_query($query); |
| $row = mysql_fetch_array($result, MYSQL_BOTH); | $row = mysql_fetch_array($result, MYSQL_BOTH); |
| $attributes[1] = $row[1]; | $attributes[1] = $row[1]; |
| mysql_free_result($result); | mysql_free_result($result); |
| } | } |
| function ContractPublishedGraph() { | function ContractPublishedGraph() { |
| $query = "SELECT YEAR(publishDate), MONTH(publishDate), | $query = "SELECT YEAR(publishDate), MONTH(publishDate), |
| SUM(value) as val, count(1) as count FROM `contractnotice` | SUM(value) as val, count(1) as count FROM `contractnotice` |
| WHERE (YEAR(publishDate) >= 2008) | WHERE (YEAR(publishDate) >= 2008) |
| AND childCN = 0 | AND childCN = 0 |
| GROUP BY MONTH(publishDate), YEAR(publishDate) | GROUP BY MONTH(publishDate), YEAR(publishDate) |
| ORDER BY YEAR(publishDate), MONTH(publishDate)"; | ORDER BY YEAR(publishDate), MONTH(publishDate)"; |
| $result = mysql_query($query); | $result = mysql_query($query); |
| $dates = Array(); | $dates = 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["val"]),2); | $value = number_format(doubleval($row["val"]),2); |
| $month_name = date( 'F', mktime(0, 0, 0, $row[1]) ); | $month_name = date( 'F', mktime(0, 0, 0, $row[1]) ); |
| $dates[] = $month_name." {$row[0]}"; | $dates[] = $month_name." {$row[0]}"; |
| $counts[] = doubleval($row["count"]); | $counts[] = doubleval($row["count"]); |
| $values[] = doubleval($row["val"]); | $values[] = doubleval($row["val"]); |
| } | } |
| mysql_free_result($result); | mysql_free_result($result); |
| } | } |
| function ContractStartingGraph() { | function ContractStartingGraph() { |
| $query = "SELECT YEAR(contractStart), MONTH(contractStart), | $query = "SELECT YEAR(contractStart), MONTH(contractStart), |
| SUM(value) as val, count(1) as count FROM `contractnotice` | SUM(value) as val, count(1) as count FROM `contractnotice` |
| WHERE (YEAR(contractStart) >= 2008) | WHERE (YEAR(contractStart) >= 2008) |
| AND childCN = 0 | AND childCN = 0 |
| GROUP BY MONTH(contractStart), YEAR(contractStart) | GROUP BY MONTH(contractStart), YEAR(contractStart) |
| ORDER BY YEAR(contractStart), MONTH(contractStart)"; | ORDER BY YEAR(contractStart), MONTH(contractStart)"; |
| $result = mysql_query($query); | $result = mysql_query($query); |
| $dates = Array(); | $dates = 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["val"]),2); | $value = number_format(doubleval($row["val"]),2); |
| $month_name = date( 'F', mktime(0, 0, 0, $row[1]) ); | $month_name = date( 'F', mktime(0, 0, 0, $row[1]) ); |
| $dates[] = $month_name." {$row[0]}"; | $dates[] = $month_name." {$row[0]}"; |
| $counts[] = doubleval($row["count"]); | $counts[] = doubleval($row["count"]); |
| $values[] = doubleval($row["val"]); | $values[] = doubleval($row["val"]); |
| } | } |
| mysql_free_result($result); | mysql_free_result($result); |
| } | } |
| function MethodCountGraph() { | function MethodCountGraph() { |
| $query = "select procurementMethod, count(1) as count, SUM(value) as value, MONTH(contractStart) as month, YEAR(contractStart) as year from `contractnotice` | $query = "select procurementMethod, count(1) as count, SUM(value) as value, MONTH(contractStart) as month, YEAR(contractStart) as year from `contractnotice` |
| where $agencyQ $supplierQ $standardQ group by procurementMethod,year,month order by procurementMethod,year,month"; | where $agencyQ $supplierQ $standardQ group by procurementMethod,year,month order by procurementMethod,year,month"; |
| $result = mysql_query($query); | $result = mysql_query($query); |
| $methods = Array("Direct","Open","Select"); | $methods = Array("Direct","Open","Select"); |
| $dates = Array(); | $dates = Array(); |
| $methodCountsP = Array(); | $methodCountsP = Array(); |
| $methodCounts = Array(); | $methodCounts = Array(); |
| $maxValue = 0; | $maxValue = 0; |
| while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { | while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { |
| setlocale(LC_MONETARY, 'en_US'); | setlocale(LC_MONETARY, 'en_US'); |
| if ($row['value'] > $maxValue) $maxValue = $row['value']; | if ($row['value'] > $maxValue) $maxValue = $row['value']; |
| $date = date( 'F ', mktime(0, 0, 0, $row["month"]) ). $row["year"]; | $date = date( 'F ', mktime(0, 0, 0, $row["month"]) ). $row["year"]; |
| if (array_search($date,$dates) === false ) { | if (array_search($date,$dates) === false ) { |
| $dates[$row["year"]*100 + $row["month"]] = $date; | $dates[$row["year"]*100 + $row["month"]] = $date; |
| ksort($dates); | ksort($dates); |
| } | } |
| $methodCountsP[$row["procurementMethod"]][$date] = $row["count"]; | $methodCountsP[$row["procurementMethod"]][$date] = $row["count"]; |
| } | } |
| foreach ($methods as $method) { | foreach ($methods as $method) { |
| foreach($dates as $date) { | foreach($dates as $date) { |
| if ($methodCountsP[$method][$date] > 0) $methodCounts[$method][] = $methodCountsP[$method][$date]; | if ($methodCountsP[$method][$date] > 0) $methodCounts[$method][] = $methodCountsP[$method][$date]; |
| else $methodCounts[$method][] = 0; | else $methodCounts[$method][] = 0; |
| } | } |
| } | } |
| $dates = array_values($dates); | $dates = array_values($dates); |
| $totalRecords = array_sum_all($methodCounts); | $totalRecords = array_sum_all($methodCounts); |
| mysql_free_result($result); | mysql_free_result($result); |
| } | } |
| function MethodValueGraph() { | function MethodValueGraph() { |
| $query = "select procurementMethod, SUM(value) as value, MONTH(contractStart) as month, YEAR(contractStart) as year from `contractnotice` | $query = "select procurementMethod, SUM(value) as value, MONTH(contractStart) as month, YEAR(contractStart) as year from `contractnotice` |
| where $agencyQ $supplierQ $standardQ group by procurementMethod,year,month order by procurementMethod,year,month"; | where $agencyQ $supplierQ $standardQ group by procurementMethod,year,month order by procurementMethod,year,month"; |
| $result = mysql_query($query); | $result = mysql_query($query); |
| $methods = Array("Direct","Open","Select"); | $methods = Array("Direct","Open","Select"); |
| $dates = Array(); | $dates = Array(); |
| $methodValuesP = Array(); | $methodValuesP = Array(); |
| $methodValues = Array(); | $methodValues = Array(); |
| $maxValue = 0; | $maxValue = 0; |
| while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { | while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { |
| setlocale(LC_MONETARY, 'en_US'); | setlocale(LC_MONETARY, 'en_US'); |
| if ($row['value'] > $maxValue) $maxValue = $row['value']; | if ($row['value'] > $maxValue) $maxValue = $row['value']; |
| $date = date( 'F ', mktime(0, 0, 0, $row["month"]) ). $row["year"]; | $date = date( 'F ', mktime(0, 0, 0, $row["month"]) ). $row["year"]; |
| if (array_search($date,$dates) === false ) { | if (array_search($date,$dates) === false ) { |
| $dates[$row["year"]*100 + $row["month"]] = $date; | $dates[$row["year"]*100 + $row["month"]] = $date; |
| ksort($dates); | ksort($dates); |
| } | } |
| $methodValuesP[$row["procurementMethod"]][$date] = $row["value"]; | $methodValuesP[$row["procurementMethod"]][$date] = $row["value"]; |
| } | } |
| foreach ($methods as $method) { | foreach ($methods as $method) { |
| foreach($dates as $date) { | foreach($dates as $date) { |
| if ($methodValuesP[$method][$date] > 0) $methodValues[$method][] = $methodValuesP[$method][$date]; | if ($methodValuesP[$method][$date] > 0) $methodValues[$method][] = $methodValuesP[$method][$date]; |
| else $methodValues[$method][] = 0; | else $methodValues[$method][] = 0; |
| } | } |
| } | } |
| $dates = array_values($dates); | $dates = array_values($dates); |
| $totalRecords = array_sum_all($methodValues); | $totalRecords = array_sum_all($methodValues); |
| mysql_free_result($result); | mysql_free_result($result); |
| } | } |
| function SuppliersGraph() { | function SuppliersGraph() { |
| $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 |