Changeset 84 for trunk/npemap.org.uk
- Timestamp:
- Oct 19, 2006, 9:29:13 PM (14 years ago)
- Location:
- trunk/npemap.org.uk
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/npemap.org.uk/cgi/get-postcodes.fcgi
r82 r84 73 73 } 74 74 75 my $sth = $dbh->prepare("SELECT outward || ' ' || inward AS postcode, easting, northing FROM postcodes WHERE easting BETWEEN ? AND ? AND northing BETWEEN ? AND ?"); 75 my $sth = $dbh->prepare("SELECT outward || ' ' || inward AS postcode, easting, northing,id FROM postcodes WHERE easting BETWEEN ? AND ? AND northing BETWEEN ? AND ?"); 76 76 77 if ($sth->execute($cgi->param('mineasting'), $cgi->param('maxeasting'), $cgi->param('minnorthing'), $cgi->param('maxnorthing'))) { 77 78 my $hr = $sth->fetchall_hashref('postcode'); … … 80 81 foreach my $key (keys %$hr) { 81 82 my $hash = $$hr{$key}; 82 print "addMarker('$$hash{postcode}', $$hash{easting}, $$hash{northing} );\n";83 print "addMarker('$$hash{postcode}', $$hash{easting}, $$hash{northing}, $$hash{id});\n"; 83 84 } 85 print "completeMarkers();\n"; 84 86 } else { 85 87 print_internal_err("Database error retrieving data"); … … 92 94 93 95 # Helper routines 94 sub print_err ($){96 sub print_err { 95 97 my $err = shift; 96 98 print header("text/plain", "400 $err"); … … 98 100 } 99 101 100 sub print_internal_err ($){102 sub print_internal_err { 101 103 my $err = shift; 102 104 print header("text/plain", "500 $err"); -
trunk/npemap.org.uk/static/tiles/map.html
r80 r84 32 32 </tr> 33 33 </table> 34 <span style="display: none" id="spinner">Loading...</span> 34 35 35 36 <div> -
trunk/npemap.org.uk/static/tiles/mapTiles.js
r80 r84 11 11 var tileHeight = 125; 12 12 13 var markerXOffset = 4; 14 var markerYOffset = 11; 13 15 14 16 var offsetGridX = 450; … … 39 41 var markerElement; 40 42 var postcodeFormElement; 41 43 var locationElement; 44 var mainPageElement; 45 var spinnerElement; 42 46 43 47 function go() { 44 mapElement = document.getElementById('map');45 mapContainerElement = document.getElementById('map_container');46 markerElement = document.getElementById('marker');47 postcodeFormElement = document.getElementById('postcode_form');48 locationElement = document.getElementById('location');49 48 mapElement.onclick = function(e) { 50 49 e = YAHOO.util.Event.getEvent(e); … … 174 173 175 174 function initializePage() { 176 size = 1000; 175 mapElement = document.getElementById('map'); 176 mapContainerElement = document.getElementById('map_container'); 177 markerElement = document.getElementById('marker'); 178 postcodeFormElement = document.getElementById('postcode_form'); 179 locationElement = document.getElementById('location'); 180 mainPageElement = document.getElementById('main_page'); 181 spinnerElement = document.getElementById('spinner'); 182 size = 1000; 177 183 178 184 urlquery=location.href.split("?") … … 225 231 226 232 removeMarkers(); 233 spinnerElement.style.display = 'block'; 227 234 YAHOO.util.Connect.asyncRequest('GET', url, callback); 235 } 236 237 function completeMarkers() { 238 spinnerElement.style.display = 'none'; 228 239 } 229 240 … … 239 250 240 251 var markers = new Array(); 252 var nextMarker = 0; 241 253 242 254 function removeMarkers() { 243 255 var pageElement = document.getElementById('main_page'); 244 for(var i=0; i< markers.length; i=i+1) {245 pageElement.removeChild(markers[i]);256 for(var i=0; i<nextMarker; i=i+1) { 257 markers[i].style.visibility = 'hidden'; 246 258 } 247 259 markerElement.style.visibility = 'hidden'; 248 markers = new Array(); 249 } 250 251 function addMarker(postcode, easting, northing) { 252 var markerXOffset = 4; 253 var markerYOffset = 11; 254 255 var newMarker = document.createElement('div'); 256 var img=document.createElement('img'); 257 img.title = postcode; 258 img.src = "../images/green-marker.gif"; 259 newMarker.appendChild(img); 260 newMarker.style.position = 'absolute'; 261 newMarker.style.zIndex = 1; 262 document.getElementById('main_page').appendChild(newMarker); 263 264 markers[markers.length] = newMarker; 260 nextMarker = 0; 261 } 262 263 function addMarker(postcode, easting, northing, id) { 264 var newMarker; 265 if (nextMarker < markers.length) { 266 newMarker = markers[nextMarker]; 267 newMarker.style.visibility = 'visible'; 268 } 269 else { 270 newMarker = document.createElement('div'); 271 var img=document.createElement('img'); 272 img.title = postcode; 273 img.src = "../images/green-marker.gif"; 274 newMarker.appendChild(img); 275 newMarker.style.position = 'absolute'; 276 newMarker.style.zIndex = 1; 277 markers[markers.length] = newMarker; 278 mainPageElement.appendChild(newMarker); 279 } 280 nextMarker = nextMarker + 1; 281 265 282 266 283 var x = ((easting / 1000) - minEasting) * tileWidth;
Note: See TracChangeset
for help on using the changeset viewer.