--- a/displayHeatmap.php
+++ b/displayHeatmap.php
@@ -1,1 +1,95 @@
-
+= '$year' AND supplierPostcode = postcode GROUP BY supplierPostcode";
+$result = mysql_query($query);
+
+$left = "FFFF50";
+$right= "EF0050";
+$leftR = hexdec(substr($left,0,2));
+$leftG = hexdec(substr($left,2,2));
+$leftB = hexdec(substr($left,4,2));
+$rightR = hexdec(substr($right,0,2));
+$rightG = hexdec(substr($right,2,2));
+$rightB = hexdec(substr($right,4,2));
+for($i=0;$i<250;$i++) {
+ $colorset[$i] = imagecolorallocatealpha($handle, $leftR + ($i*(($rightR-$leftR)/250)), $leftG + ($i*(($rightG-$leftG)/250)), $leftB + ($i*(($rightB-$leftB)/250)),117 - ($i/250)*40);
+}
+
+while ($row = mysql_fetch_array($result, MYSQL_BOTH))
+{
+ $xpage = round((($XRange - ($MaxX - $row['lon'])) / $xdivlength));
+ if ($row['lat'] < -40.25) $row['lat']-= 0.75;
+ $ypage = round(($YRange - (abs($MaxY) - abs($row['lat']))) / $ydivheight);
+ @$pagevalues[$xpage][$ypage] += $row['value'];
+ //echo $ypage." ".$xpage."
";
+}
+
+$max = 0;
+$min = 0;
+for ($i = 0;$i < $xdivs; $i++ ) {
+ for ($j = 0;$j < $ydivs; $j++ ) {
+ if (@$pagevalues[$i][$j])
+ {
+ if (@$pagevalues[$i][$j] > $max) $max = @$pagevalues[$i][$j];
+ if ($min == 0 || @$pagevalues[$i][$j] < $min) $min = @$pagevalues[$i][$j];
+ } else {
+ @$pagevalues[$i][$j] = ((@$pagevalues[$i][$j] + (@$pagevalues[$i+1][$j] + @$pagevalues[$i][$j+1]
+ + @$pagevalues[$i-1][$j] + @$pagevalues[$i][$j-1])/4) /2)-9;
+ @$pagevalues[$i-1][$j] = ((@$pagevalues[$i-1][$j] + (@$pagevalues[$i][$j] + @$pagevalues[$i-1][$j+1]
+ + @$pagevalues[$i-2][$j] + @$pagevalues[$i-1][$j-1])/4) /2)-9;
+ @$pagevalues[$i][$j-1] = ((@$pagevalues[$i][$j-1] + (@$pagevalues[$i+1][$j-1] + @$pagevalues[$i][$j]
+ + @$pagevalues[$i-1][$j-1] + @$pagevalues[$i][$j-2])/4) /2)-9;
+ }
+ }
+}
+//echo $max." ".$min;
+//echo "
". log10(@$pagevalues[$i][$j])/log10($max) ." | "); + if ((@$pagevalues[$i][$j]) > $min) { + $x = $i*($width/$xdivs); + $x1 = $borderLeft + $x -($width/$xdivs); + $x2 = $borderLeft + $x +($width/$xdivs); + $y = $j*($height/$ydivs); + $y1 = $borderTop + $y - ($height/$ydivs); + $y2 = $borderTop + $y + ($height/$ydivs); + imagefilledrectangle ($handle, $x1, $y1, $x2, $y2, $colorset[(int)((log10(@$pagevalues[$i][$j])/log10($max))*249)]); + } + } +//echo "