<?php
// ab15karte.php - Zeige eine auszuw&auml;lende Linie auf der Karte

include 'header.php';


// ############ START QUERY ############################################################
if(isset($_POST['linie'])) {
   $sel_line = $_POST['linie'];
} else {
   $sel_line = '';
}

   
$query = "
SELECT stations.latitude, stations.longitude, routes.name, routes.color FROM stations, routes_stations, routes
WHERE routes_stations.r_id = $sel_line
AND routes_stations.s_id = stations.id
AND routes.id = $sel_line
;
";


$result = mysqli_query($db, $query);
if ($result) {
   $rows = mysqli_num_rows($result);
   $cols = mysqli_num_fields($result);
   for($r=0; $r< $rows; $r++) {
 		list($xobj[$r], $yobj[$r], $nobj[$r], $cobj[$r]) = mysqli_fetch_row($result);
   }
}

else {

}

// Gleicher Kartenmittelpunkt?????	
if($sel_line == "") {
   $lat = "31.250613";
   $long = "121.481323";
    }
else {
   $avg = $r/2-1;
   $lat = "31.250613";
   $long = "121.481323";

}
	
$zoom = "10";
	
//mysqli_free_result($result);

echo '
<script type="text/javascript">
';
echo '
   function load() {

      if (GBrowserIsCompatible()) {
         var map = new GMap2(document.getElementById("map"));
		 map.setMapType(G_SATELLITE_MAP);
         map.addControl(new GLargeMapControl());
         map.addControl(new GMapTypeControl());
         map.addControl(new GScaleControl());
         map.addControl(new GOverviewMapControl());
         var icon = new GIcon();
         icon.image = "images/markerstation.png";
         icon.shadow = "images/markerstation_schatten.png";
         icon.iconSize = new GSize(20, 20);
         icon.shadowSize = new GSize(20, 20);
         icon.iconAnchor = new GPoint(10, 10);
         icon.infoWindowAnchor = new GPoint(10, 10);
';
echo '
         map.setCenter(new GLatLng('.$lat.', '.$long.'), '.$zoom.');
         //var point = new Array();
         //var text = new Array();
';
if($sel_line !== '') {		 
   echo	 'var polyline = new GPolyline([
   ';

   for ($r=0; $r<$rows; $r++) {
      echo '
         new GLatLng('.$xobj[$r].','.$yobj[$r].'),
         //text['.$r.'] = "'.$nobj[$r].'";
      ';
   }
   // Farbe der Linien? manche schlecht erkennbar auf Karte
   echo '
         ], "#FF0000", 8);
         map.addOverlay(polyline);
   ';
}

echo '
        }
    }
    </script>
'; 



echo '</head>';
// ############ START BODY ############################################################
echo '<body onLoad="load()" onUnload="GUnload()">';

include 'menu.php';


// ############ START CONTENT ############################################################
echo '
   <div id="content">
   <a href="abfragen.htm" class="menulink">zur&uuml;ck zu den Abfragen</a>
';   

echo '<h1>Zeige eine auszuw&auml;lende Linie auf der Karte</h1>';

echo "<form method=\"post\" action=\"ab15karte.php\">";
echo '<input name="linie" type="radio" value="1">Linie 1 &nbsp;';
echo '<input name="linie" type="radio" value="2">Linie 2 &nbsp;';
echo '<input name="linie" type="radio" value="3">Linie 3 &nbsp;';
echo '<input name="linie" type="radio" value="4">Linie 4 &nbsp;';
echo '<input name="linie" type="radio" value="5">Linie 5 &nbsp;';
echo '<input name="linie" type="radio" value="6">Linie 6 &nbsp;';
echo '<input name="linie" type="radio" value="7">Linie 7 &nbsp;';
echo '<input name="linie" type="radio" value="8">Linie 8 &nbsp;';
echo '<input name="linie" type="radio" value="9">Linie 9 &nbsp;';
echo '<input name="linie" type="radio" value="10">Maglev &nbsp; ';
echo '&nbsp;<input type="submit" value="Anzeigen">';
echo '</form>';

if($sel_line == "") {
	echo	'<div id="map" align="center" style="width: 800px; height: 500px"></div>';
}
else
{

    echo  '<div align="center"><font color="'.$cobj[0].'"><b>'.$nobj[0].'</b></font></div><br>';
       
	echo	'<div id="map" align="center" style="width: 800px; height: 500px"></div>';
}

include 'footer.php';
?>