<?php
 // Å
 require_once('database.php');

 define('FEED_IMG_HEIGHT', 14);
 $extratitle = '';
 $nodemargin = 7.5;
 $nodespacing = 5;
 $nodewidth = 20;
 $lat = 65.6;
 $lng = 25;
 $zoom = 5;
 $zoomisdefault = 1;
 $flytospeed = 2; // 0 - 5
 $maptype = 'G_HYBRID_MAP';
 $feeds = array();
 $layers = array();
 $icons = array();
 $categories = array();
 $apikey = 'ABQIAAAASOhwwoQKvim7mEhL_6zrWhQx5_7khCAMUwniahOpsGGIDopiCBRDF_B4kmRNpEMgZ_nawtAL2Sym2A';
 $host = isset($_SERVER['REDIRECT_HOST']) ? $_SERVER['REDIRECT_HOST'] : '';
 $uri = isset($_SERVER['REQUEST_URI']) ? $_SERVER['REQUEST_URI'] : '/';
 if ($host) {
   $uri = str_replace("$host/", '', $uri);
 }
 if (isset($_REQUEST['ll'])) {
  list($la, $ln) = split(',', $_REQUEST['ll']);
  if (is_numeric($la) && is_numeric($ln)) {
    $lat = sprintf('%f', $la);
    $lng = sprintf('%f', $ln);
  }
 }
 if (isset($_REQUEST['zl']) && is_numeric($_REQUEST['zl'])) {
  $zoom = sprintf('%d', $_REQUEST['zl']);
  $zoomisdefault = 0;
 }
 if (isset($_REQUEST['lang'])) {
  $lang = sprintf('%2s', $_REQUEST['lang']);
 }
 else {
  $lang = 'FI';
 }
 $place = NULL;
 $host_re = '/^(.*?)\.tietopaikka.fi/';
 if (preg_match($host_re, $_SERVER['HTTP_HOST'], $match)) {
  $select = "
   SELECT p.id, p.shortname, p.name, p.coords,
          c.lat, c.lng, c.zoom, c.type
   FROM   place AS p, coords AS c
   WHERE  p.coords = c.id
   AND    LOWER(p.shortname) = '".db_escape_string(strtolower($match[1]))."'";
  $res = db_query($select);
  if ($row = db_fetch_row($res)) {
   $place = $row['id'];
   // $placename = $row['name'];
   $placecoords = $row['coords'];
   $lat = $row['lat'];
   $lng = $row['lng'];
   $zoom = $row['zoom'];
   $zoomisdefault = 0;
   $maptype = $row['type'];
   $extratitle = htmlentities($row['name'])." - ";
  }
  db_free_result($res);
 }

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="<?php echo htmlentities($lang); ?>">
 <head>
  <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
  <meta name="description" content="Tietopaikka ker&auml;&auml; paikkatietoa..." />
  <meta name="keywords" content="paikkatieto, hallinto, yritys, kunta, kansalainen" />
  <meta name="language" content="<?php echo htmlentities($lang); ?>" />
  <title><?php echo $extratitle; ?>Tietopaikka</title>
  <link rel="stylesheet" type="text/css" href="/s/common.css" id="common" />
  <script type="text/javascript" src="//www.google.fi/jsapi?key=<?php echo $apikey; ?>">
  </script>
  <script type="text/javascript">
   // <![CDATA[
   var lang = '<?php echo $lang; ?>';
   google.load('maps', '2', {'language' : lang, 'other_params': 'sensor=true'});
   google.load('elements', '1', {packages : ['localsearch'], 'language' : lang});
   google.load('search', '1');

   var layers = new Array();
   var nodes = new Array();
   var places = new Array();
   var feeds = new Array();
   var icons = new Array();
   var cameras = new Array();
   var Layer = function(id, title, bg, color) {
    this.id = id;
    this.title = title;
    this.backgroundColor = bg;
    this.color = color;
   }
   var Place = function(id, short, name, desc, icon, lat, lng, zoom, type) {
    this.id = id;
    this.shortName = short;
    this.name = name;
    this.desc = desc;
    this.icon = icon;
    this.lat = lat;
    this.lng = lng;
    this.zoom = zoom;
    this.type = type;
   }
   var IconHolder = function(id, opts) {
    this.id = id;
    this.opts = opts;
   }
   var LookAt = function(name, lat, lng, alt, dir, tilt, range, mode) {
    this.name = name;
    this.latitude = parseFloat(lat);
    this.longitude = parseFloat(lng);
    this.altitude = parseFloat(alt);
    this.heading = parseFloat(dir);
    this.tilt = parseFloat(tilt) || 70;
    this.range = parseFloat(range) || '250'; // meters
    this.altitudeMode = mode || 'relativeToGround';
   };

<?php
 if ($place) {
  $select = "
   SELECT name, latitude, longitude, altitude, heading, tilt, range,
          altitudeMode
   FROM lookat AS l
   WHERE l.coords = '$placecoords'";
  $res = db_query($select);
  # echo "// ".strip_tags(nl2br(htmlspecialchars($select))).": ".
  #      db_num_rows($res)."\n";
  if (db_num_rows($res) > 0) {
   while ($row = db_fetch_row($res)) {
    $row['name'] = htmlspecialchars($row['name']);
    echo "   cameras[cameras.length] = new LookAt('".
         join("', '", $row)."');\n";
   }
  }
  db_free_result($res);
  $select = "
   SELECT l.id, l.title, l.description AS `desc`, l.bgcolor, l.color
   FROM   layer AS l, layer_place AS lp
   WHERE  l.id = lp.layer_id AND lp.place_id = '$place'";
  # echo "// ".strip_tags(nl2br(htmlspecialchars($select)))."\n";
  $res = db_query($select);
  while ($row = db_fetch_row($res)) {
   $opts = array($row['title'], $row['desc'], $row['bgcolor'], $row['color']);
   $feeds = array();
   $select = "
    SELECT f.id, f.name, f.description AS `desc`, f.icon, i.image, f.url,
           UNIX_TIMESTAMP(f.modified) AS modified, fl.enabled,
           t.id AS typeid, t.name AS type, t.mime, t.usage
    FROM   type AS t, feed_layer AS fl, feed AS f
    LEFT JOIN icon AS i ON f.icon = i.id
    WHERE  t.id = f.type AND f.id = fl.feed_id AND fl.layer_id = '$row[id]'
    ORDER BY f.name";
   $subres = db_query($select);
   # echo "// ".strip_tags(nl2br(htmlspecialchars($select)))."\n";
   while ($subrow = db_fetch_row($subres)) {
    $feeds[] = $subrow;
    $icons[$subrow['icon']] += 1;
    $categories[$subrow['cat']] += 1;
    $url = $subrow['url'];
    if (stristr($url, '//tietopaikka.')) {
     $url .= (strstr($url, '?') ? '&' : '?')."v=$subrow[modified]";
    }
    $title = htmlspecialchars($subrow['name']);
    echo "   feeds['feed$subrow[id]'] = '$url';\n";
   }
   db_free_result($subres);
   $layers[$row['id']] = array($opts, $feeds);

   echo "   layers[layers.length] = new Layer('".
        $row['id']."', '".
        htmlspecialchars($row['title'])."', '".
        htmlspecialchars($row['bgcolor'])."', '".
        htmlspecialchars($row['color'])."');\n";
   echo "   nodes[nodes.length] = 'layer".$row['id']."'\n";
  }
  db_free_result($res);
  $nc = count($layers);
  if ($nc > 0) {
   $nodewidth = (100 - (2*$nodemargin) - (($nc-1)*$nodespacing))/$nc;
   echo "   var nodeWidth = $nodewidth;\n";
  }
 }
 else {
  $select = "
   SELECT p.id, p.shortname, p.name, p.description, p.icon,
          c.lat, c.lng, c.zoom, c.type
   FROM   place AS p, coords AS c
   WHERE  p.published IS NOT NULL AND p.published < NOW() AND p.coords = c.id";
  # echo "// ".strip_tags(nl2br(htmlspecialchars($select)))."\n";
  $res = db_query($select);
  while ($row = db_fetch_row($res)) {
   // db_convert_charset($row, $conn);
   echo "   places[places.length] = new Place('".
        htmlspecialchars(join("', '", $row))."');\n";
  }
  db_free_result($res);
  $icons[1] = 1;
 }
 if (count($icons) > 0) {
  // TODO: load icons, create JS objects, store PNG's to PHP vars
  $select = "
   SELECT id, name, image, shadow, iconSize, shadowSize, iconAnchor,
          infoWindowAnchor, printImage, mozPrintImage, printShadow,
          transparent, imageMap, maxHeight, dragCrossImage,
          dragCrossSize, dragCrossAnchor
   FROM   icon
   WHERE  id IN ('".join("', '", array_keys($icons))."')";
  # echo "// ".strip_tags(nl2br(htmlspecialchars($select)))."\n";
  $res = db_query($select);
  $counter = 0;
  while ($row = db_fetch_row($res)) {
   $opts = '';
   foreach($row as $property => $value) {
    if (strpos($property, 'Anchor') ||
        strpos($property, 'Map') ||
        strpos($property, 'Size')) {
     $opts .=  "'$property': [$value], ";
    }
    elseif ($value !== NULL) {
     $opts .=  "'$property': '$value', ";
    }
   }
   echo "   var opts = {".substr($opts, 0, -2)."};\n";
   echo "   icons[$counter] = new IconHolder($row[id], opts);\n";
   ++$counter;
  }
  db_free_result($res);
 }
 if (count($categories) > 0) {
 }
 echo "   var lat = $lat;\n";
 echo "   var lng = $lng;\n";
 echo "   var zoom = $zoom;\n";
 echo "   var zoomIsDefault = $zoomisdefault;\n";
 echo "   var maptype = '$maptype';\n";
 echo "   var nodeMargin = $nodemargin;\n";
 echo "   var nodeSpacing = $nodespacing;\n";
 echo "   var flyToSpeed = $flytospeed;\n";
?>
   // ]]>
  </script>
  <style type="text/css">
<?php
 $layercount = 0;
 while (list($i, list($opts, $feeds)) = each($layers)) {
  list($layername, $layerdesc, $bgcolor, $color) = $opts;
  $left = (($nodewidth + $nodespacing) * $layercount) + $nodemargin;
  ++$layercount;
  echo <<<EOS
   #layer$i {
    background-color: #$bgcolor;
    border-color: #$bgcolor;
    color: #$color;
    left: $left%;
    width: $nodewidth%;
   }
   #layer$i h2 {
    background-color: #$bgcolor;
    color: #$color;
   }
   #shim$i {
    left: $left%;
    width: $nodewidth%;
   }

EOS;
 }
 reset($layers);
?>
  </style>
 </head>
 <body>
  <div id="map">
  </div>
  <noscript>Tietopaikka.fi hy&ouml;dynt&auml;&auml; Google Maps -palvelua, joka toimii JavaScriptin avulla. JavaScript ei toimi selaimessasi, tai se on kytketty pois toiminnasta.</noscript>
<?php

 $networklinknote = ' <span class="info">(P&auml;ivittyy kartalla'.
                    ' siirrytt&auml;ess&auml;.'.
                    ' Ei v&auml;ltt&auml;m&auml;tt&auml; n&auml;y kuin '.
                    ' <strong>Maa</strong>-n&auml;kym&auml;ss&auml;.'.
                    ')</span>';
 while (list($i, list($opts, $feeds)) = each($layers)) {
  list($layername, $layerdesc) = $opts;
  echo "  <div id=\"layer".htmlentities($i)."\" class=\"menu\">\n";
  echo "  <h2>".htmlentities($layername)."</h2>\n";
  echo "   <p>".htmlentities($layerdesc)."</p>\n";
  if (count($feeds) > 0) {
   echo "  <form action=\"#layer".htmlentities($i)."\" class=\"choices\">\n";
   echo "   <fieldset>\n";
   echo "    <legend>N&auml;yt&auml; kartalla</legend>\n";
   while (list($id, $feed) = each($feeds)) {
    $name = htmlentities($feed['name']);
    if ($feed['image']) {
     $image = '<img src="'.htmlentities($feed['image']).'" alt="kuvake"'.
              ' height="'.FEED_IMG_HEIGHT.'" class="kuvake" /> '."\n";
    }
    else {
     $image = '';
    }
    if ($feed['desc']) {
     $desc = '     <p class="desc">'.htmlentities($feed['desc']).
             (($feed['typeid'] == 6) ? $networklinknote : '').
             "</p>\n";
    }
    else {
     $desc = '';
    }

    $checked = $feed['enabled'] ? ' checked="checked"' : '';
    $link = '<a class="link" href="'.htmlentities($feed['url']).'"'.
            ' title="'.htmlentities($feed['usage']).'"'.
            ' type="'.htmlentities($feed['mime']).'"'.
            '>'.htmlentities($feed['type']).'</a>';
    $updated = '<span class="updated">Lis&auml;tty palveluun '.
               date('d.m.Y', $feed['modified']).
               '</span>';
    echo <<<EOI
    <div>
     <input type="checkbox" id="feed$feed[id]" class="toggler"$checked />
     <label for="feed$feed[id]">$name $image<span class="info">$link $updated</span></label>
$desc    </div>

EOI;
   }
   echo "   </fieldset>\n";
   echo "  </form>\n";
  }
  else {
   echo "<p class=\"info\">Ei viel&auml; sis&auml;lt&ouml;&auml;...</p>\n";
  }
  echo "  </div>\n";
  # echo # "  <div class=\"shim\">".
       # "<iframe class=\"shim\" id=\"shim".htmlentities($i)."\"".
       # " src=\"#layer".htmlentities($i)."\"".
       # " frameborder=\"0\" scrolling=\"no\"></iframe>".
       # "</div>".
       # "\n";
 }
?>
  <div id="search">
  </div>
  <div id="info">
   <h2>Tietoja palvelusta</h2>
   <p>Tietopaikka.fi ei viel&auml; ole oikea palvelu, vaan vasta prototyyppi ja hahmottelua siit&auml;, mink&auml;laisia ominaisuuksia valmiissa palvelussa voisi olla. Lue <a href="/demo.html">esimerkkej&auml; palvelun hy&ouml;dynt&auml;misest&auml;</a>.</p>
<!--
   <ul>
    <li>Yleist&auml;</li>
    <li>Palvelun hyödyt hallinnolle</li>
    <li>Palvelun hyödyt yrityksille, yrittäjille ja yhdistyksille</li>
    <li>Palvelun hyödyt kuluttajille ja kansalaisille</li>
   </ul>
   <p class="vcard"><a class="email" href="mailto:samuel@iki.fi">samuel@iki.fi</a></p>
-->
  </div>
  <script type="text/javascript" src="//yui.yahooapis.com/3.0.0b1/build/yui/yui-min.js">
  </script>
  <script type="text/javascript" src="/js/init.js">
  </script>
  <script type="text/javascript" src="/js/eyecandy.js">
  </script>
  <script type="text/javascript">
   // <![CDATA[
   var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
   document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
  </script>
  <script type="text/javascript">
   try {
    var pageTracker = _gat._getTracker("UA-4404005-9");
    pageTracker._trackPageview();
   } catch(err) {}
   // ]]>
  </script>
 </body>
</html>
