<?php
// ab6karte.php - Welche Sehenswürdigkeiten und Freizeitmöglichkeiten liegen in einem auszuwählenden District?

include 'header.php';


// ############ START QUERY############################################################
if(isset($_POST['district'])) {
   $sel_district = $_POST['district'];
} else {
   $sel_district = '';
}


$query = "
SELECT sights.latitude, sights.longitude, sights.name
FROM sights, districts
WHERE sights.districtnr = (SELECT id FROM districts WHERE name='$sel_district')
UNION
SELECT freetime.latitude, freetime.longitude, freetime.name
FROM freetime, districts
WHERE freetime.districtnr = (SELECT id FROM districts WHERE name='$sel_district');
";

$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]) = mysqli_fetch_row($result);
   }

} 
else {
   echo "Fehler";
}

if($sel_district == "") {
$lat = 31.195501;
$long = 121.47377;
}
else {
$lat = $xobj[0];
$long = $yobj[0];
}
$zoom = 12;	

mysqli_free_result($result);

echo '<script type="text/javascript">';
echo '
   function load() {
      function createListener (marker, text) {
         GEvent.addListener(marker, "click", function() {
            marker.openInfoWindowHtml(text);
         }
        );
      }
      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/markersight.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();
         var marker = new Array();
';
for ($r=0; $r<$rows; $r++) {
   echo '
         point['.$r.'] = new GLatLng('.$xobj[$r].','.$yobj[$r].');
         text['.$r.'] = "'.$nobj[$r].'";
   ';
}

echo '
         var marker = new Array();
  
         for (i=0; i< point.length; i++) {
            marker[i] = new GMarker(point[i], icon);
            map.addOverlay(marker[i]);
            createListener (marker[i], text[i]);
         }
';

echo '
      }
    }
    </script>
'; 




echo '</head>';
// ############ START BODY ############################################################
if($sel_district == "") {
   echo '<body>';
}
else {
   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>Welche Sehensw&uuml;rdigkeiten und Freizeitm&ouml;glichkeiten liegen in einem auszuw&auml;hlenden Distrikt?</h1>';


echo "<form method=\"post\" action=\"ab6karte.php\">";
echo '<select name="district" size="1"><option>Changning<option>Chengjiaqiao<option>Dapuqiao<option>Hongqiao<option>Huamu<option>Huangpu<option value="Jing An">Jing An<option>Laoximen<option>Longhua<option>Lujiazui<option>Luwan<option>Nanshi<option>Ni Cheng Qiao<option>Qibao<option>Xuhui<option>Xujiahui</select>';
echo '&nbsp;<input type="submit" name="form_linie" value="Distrikt w&auml;hlen">';
echo '</form><br>';


if($sel_district == "") {
}
else {
   echo "Im Distrikt <b>$sel_district</b> gibt es folgende Sehensw&uuml;rdigkeiten und/oder Freizeitm&ouml;glichkeiten: <br><br>"; 

   for($r=0; $r< $rows; $r++) {
      echo  "$nobj[$r]<br>";
   }
	echo	'<div id="map" align="center" style="width: 800px; height: 400px"></div>';
}

include 'footer.php';
?>