Changeset 195 for trunk/npemap.org.uk

Timestamp:

Oct 26, 2006, 10:32:50 PM (15 years ago)

Author:

David Sheldon

Message:

Colour the FTP postcodes blue.

Location:

trunk/npemap.org.uk

Files:

• cgi/get-postcodes.fcgi (modified) (2 diffs)
• static/tiles/mapTiles.js (modified) (2 diffs)

trunk/npemap.org.uk/cgi/get-postcodes.fcgi

@@ -73 +73 @@
     }
 
-    my $sth = $dbh->prepare("SELECT outward || ' ' || inward AS postcode, easting, northing,id FROM postcodes WHERE easting BETWEEN ? AND ? AND northing BETWEEN ? AND ? AND NOT deleted");
+    my $sth = $dbh->prepare("SELECT outward || ' ' || inward AS postcode, easting, northing,id,source FROM postcodes WHERE easting BETWEEN ? AND ? AND northing BETWEEN ? AND ? AND NOT deleted");
     
     if ($sth->execute($cgi->param('mineasting'), $cgi->param('maxeasting'), $cgi->param('minnorthing'), $cgi->param('maxnorthing'))) {
@@ -81 +81 @@
         foreach my $key (keys %$hr) {
             my $hash = $$hr{$key};
-            print "addMarker('$$hash{postcode}', $$hash{easting}, $$hash{northing}, $$hash{id});\n";
+            print "addMarker('$$hash{postcode}', $$hash{easting}, $$hash{northing}, [$$hash{id}, $$hash{source}]);\n";
         }
         print "completeMarkers();\n";

trunk/npemap.org.uk/static/tiles/mapTiles.js

@@ -336 +336 @@
 }
 
-function addMarker(postcode, easting, northing, id) {
+var markerColours = new Array(1);
+markerColours[0] = "../images/green-marker.gif";
+markerColours[1] = "../images/blue-marker.gif";
+
+
+function addMarker(postcode, easting, northing, others ) {
+  // Others is an array for us to put extra stuff in
+
   var newMarker;
+  var id = others[0];
+  var source = others[1];
+
   if (nextMarker < markers.length) {
     newMarker = markers[nextMarker]; 
         var img=newMarker.firstChild;
     img.title = postcode;
+    img.src = markerColours[source]; 
     newMarker.style.visibility = 'visible';
   }
@@ -348 +359 @@
         var img=document.createElement('img');
     img.title = postcode;
-    img.src = "../images/green-marker.gif";
+    img.src = markerColours[source]; 
     newMarker.appendChild(img);
     newMarker.style.position = 'absolute';