<!--conexão à base-->


<?php

   // Database connection settings
   define("PG_DB"  , "pinhel");
   define("PG_HOST", "localhost");
   define("PG_USER", "pedro");
   define (PG_PASS", "pass");
   define("PG_PORT", "5432");
   define("TABLE",   "arcos");

   // Retrieve start point
   $start = split(' ',$_REQUEST['startpoint']);
   $startPoint = array($start[0], $start[1]);

   // Retrieve end point
   $end = split(' ',$_REQUEST['finalpoint']);
   $endPoint = array($end[0], $end[1]);

?>





<!--determinar inicio e fim da rota-->


<?php

   // Find the nearest point
   $startpoint = findNearestpoint($startPoint);
   $endpoint   = findNearestpoint($endPoint);

   // FUNCTION findNearestpoint
   function findNearestpoint($lonlat) {

      // Connect to database
      $con = pg_connect("dbname=".PG_DB." host=".PG_HOST." user=".PG_USER "password=".PG_PASS);

      $sql = "SELECT id, the_geom,
                  distance(the_geom, GeometryFromText(
                       'POINT(".$lonlat[0]." ".$lonlat[1].")', 27492)) AS dist
                 FROM vertices_tmp
                 WHERE the_geom && setsrid(
                       'BOX3D(".($lonlat[0]-0.1)."
                              ".($lonlat[1]-0.1).",
                              ".($lonlat[0]+0.1)."
                              ".($lonlat[1]+0.1).")'::box3d, 27492)
                 ORDER BY dist LIMIT 1";

      $query = pg_query($con,$sql);

      $edge['id']      = pg_fetch_result($query, 0, 0);
      $edge['source']   = pg_fetch_result($query, 0, 1);
      $edge['target']   = pg_fetch_result($query, 0, 2);
      $edge['the_geom'] = pg_fetch_result($query, 0, 3);

      // Close database connection
      pg_close($con);

      return $edge;
   }

?>



<!--query de custo-->

<?php

   // Select the routing algorithm
   switch($_REQUEST['method']) {

    case 'SP' : // Shortest Path


            §sql = "SELECT arcos.id, ST_AsGeoJSON(arcos.the_geom) AS geojson, length(arcos.the_geom) AS length, ".TABLE.".id
            FROM ".TABLE."
            JOIN
            (SELECT * FROM shortest_path('
            SELECT id,
            source::int4 AS source,
            target::int4 AS target,
            length::double precision AS cost
            FROM ".TABLE."',
            ".$startpoint['id'].",".$endpoint['id'].",false,false)) AS rota
            ON
            ".TABLE.".id = rota.edge_id;";



    break;



   } // close switch

   // Connect to database
   $dbcon = pg_connect("dbname=".PG_DB." host=".PG_HOST." user=".PG_USER "password=".PG_PASS);

   // Perform database query
   $query = pg_query($dbcon,$sql);

?>



<!--retornar resultado como geojson-->



<?php

   // Return route as GeoJSON
   $geojson = array(
      'type'      => 'FeatureCollection',
      'features'  => array()
   );

   // Add edges to GeoJSON array
   while($edge=pg_fetch_assoc($query)) {

      $feature = array(
         'type' => 'Feature',
         'geometry' => json_decode($edge['geojson'], true),
         'crs' => array(
            'type' => 'EPSG',
            'properties' => array('code' => '27492')
         ),
         'properties' => array(
            'id' => $edge['id'],
            'length' => $edge['length']
         )
      );

      // Add feature array to feature collection array
      array_push($geojson['features'], $feature);
   }


   // Close database connection
   pg_close($dbcon);

   // Return routing result
   header('Content-type: application/json',true);
   echo json_encode($geojson);

?>