1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 | <html xmlns="http://www.w3.org/1999/xhtml"> <head> <script src="openlayers/OpenLayers.js"></script> <SCRIPT TYPE="text/javascript" SRC="OpenStreetMap.js"></SCRIPT> <script type="text/javascript" src="jquery.1.3.2.min.js"></script> <script type="text/javascript"> function init() { // create the ol map object var map = new OpenLayers.Map('map'); var osmtiles = new OpenLayers.Layer.OSM("local", "http://127.0.0.1/Maps/OSM/${z}/${x}/${y}.png") // use http://open.atlas.free.fr/GMapsTransparenciesImgOver.php and http://code.google.com/p/googletilecutter/ to make tiles markers = new OpenLayers.Layer.Markers("Between Stop Markers"); <?php $conn = pg_connect("dbname=bus user=postgres password=snmc"); if (!$conn) { echo "An error occured.\n"; exit; } $result_stops = pg_query($conn, "Select * FROM stops"); while ($stop = pg_fetch_assoc($result_stops)) { echo 'marker = new OpenLayers.Marker(new OpenLayers.LonLat(' . ($stop['lng'] / 10000000) . "," . ($stop['lat'] / 10000000) . ') .transform( new OpenLayers.Projection("EPSG:4326"), // transform from WGS 1984 new OpenLayers.Projection("EPSG:900913") // to Spherical Mercator Projection ));'; echo ' marker.id="' . $stop['geohash'] . '"; markers.addMarker(marker); marker.events.register("mousedown", marker, function() { document.getElementById("between_points").innerHTML += this.id+";"; }); '; } ?> var timeicon = new OpenLayers.Icon("http://maps.google.com/mapfiles/kml/pushpin/grn-pushpin.png",new OpenLayers.Size(32,32)); var timepoints = new OpenLayers.Layer.GeoRSS("Timing Points", "displaytimepoints.georss.php", { icon: timeicon }); map.addLayers([osmtiles, markers,timepoints]); map.addControl(new OpenLayers.Control.LayerSwitcher()); map.zoomToExtent(markers.getDataExtent()); } </script> <script type="text/javascript"> function submitBetween () { $.post("betweenpoint.submit.php", $("#inputform").serialize(), function(html){ $("#response").html(html); //clearForms(); return false; }); }; function OnChange(dropdown) { var myindex = dropdown.selectedIndex var selValue = dropdown.options[myindex].value; $("#routes").val(selValue.split(":",2)[0]); fromto = selValue.split(":",2)[1]; $("#from").val(fromto.split("->",2)[0]); $("#to").val(fromto.split("->",2)[1]); return true; } // function will clear input elements on each form function clearForms(){ document.getElementById("between_points").innerHTML = ""; // declare element type var type = null; // loop through forms on HTML page for (var x=0; x<document.forms.length; x++){ // loop through each element on form for (var y=0; y<document.forms[x].elements.length; y++){ // define element type type = document.forms[x].elements[y].type // alert before erasing form element //alert('form='+x+' element='+y+' type='+type); // switch on element type switch(type){ case "text": case "textarea": case "password": //case "hidden": document.forms[x].elements[y].value = ""; break; case "radio": case "checkbox": document.forms[x].elements[y].checked = true; break; case "select-one": document.forms[x].elements[y].options[0].selected = true; break; case "select-multiple": for (z=0; z<document.forms[x].elements[y].options.length; z++){ document.forms[x].elements[y].options[z].selected = false; } break; } } } } </script> </head> <body onload="init()"> <div id="inputpane"><form id="inputform"> <select name=selectPair onchange='OnChange(this.form.selectPair);'> <option>Select a from/to pair...</option> <?php include('spyc/spyc.php'); //$timetable = Spyc::YAMLLoad('../spyc.yaml'); $path = "maxious-canberra-transit-feed/output/"; $dhandle = opendir("maxious-canberra-transit-feed/output/"); // define an array to hold the files $files = array(); $paths = array(); if ($dhandle) { // loop through all of the files while (false !== ($fname = readdir($dhandle))) { if (($fname != '.') && ($fname != '..')) { $timetable = Spyc::YAMLLoad("maxious-canberra-transit-feed/output/" . $fname); // Strip off individual platforms because it usually doesn't matter for routes $timetable["time_points"] = preg_replace("/(Platform.*/","",$timetable["time_points"]); for ($i = 0; $i < sizeof($timetable["time_points"]) - 1; $i++) { @$paths[trim($timetable["time_points"][$i]) . "->" . trim($timetable["time_points"][$i + 1])] .= $timetable["short_name"] . ";"; } } } } ksort($paths); $completedPaths = array(); $result_betweenstops = pg_query($conn, "Select * FROM between_stops"); while ($path = pg_fetch_assoc($result_betweenstops)) { $completedPaths[trim($path['fromlocation']) . "->" . trim($path['tolocation'])] .= trim($path['routes']); } foreach ($paths as $path => $routes) { if (!in_array($path, array_keys($completedPaths))) { echo "<option value=\"$routes:$path\">" . sizeof(explode(";", $routes)) . " $path</option>\n"; } else { $completedRoutes = explode(";", $completedPaths[$path]); $incompleteRoutes = ""; foreach (explode(";", $routes) as $route) { if (!in_array($route,$completedRoutes)) { $incompleteRoutes .= $route.';'; } } if ($incompleteRoutes != "") echo "<option value=\"$incompleteRoutes:$path\">" . sizeof(explode(";", $incompleteRoutes)) . " $path</option>\n"; } } ?> </select> from <input type="text" name="from" id="from"/> to <input type="text" name="to" id="to"/> <br> on routes <input type="text" name="routes" id="routes"/> Reverse? <input type="checkbox" name="reverse" id="reverse" checked="true"/> <input type="button" onclick="javascript:submitBetween()" value="Submit!"> <input type="button" value="Clear" onclick="javascript:clearForms()" title="Start clearForms() JavaScript function"> <br> <textarea name="between_points" id="between_points" rows="1" cols="120"></textarea> </form> <div id="response"> <!-- Our message will be echoed out here --> </div> </div> <div id="map" width="100%" height="100%"></div> </body> </html> |