root/tools/routingservice/trunk/src/jp/co/orkney/restlet/geo/ClosestEdge.java

/**
 * Copyright (c) 2007 Orkney, Inc. <http://www.orkney.co.jp/>
 * 
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

package jp.co.orkney.restlet.geo;

import java.sql.ResultSet;
import java.sql.SQLException;

import jp.co.orkney.restlet.util.IOHelper;
import jp.co.orkney.restlet.util.Log;
import jp.co.orkney.restlet.util.Point;
import jp.co.orkney.restlet.util.Configuration;
import jp.co.orkney.restlet.util.DatabaseConnection;

import org.antlr.stringtemplate.StringTemplate;
import org.json.JSONException;

/**
 * <b>ClosestEdge is a class which represents a "closest edge" algorithm.</b>
 * <p>
 * "closest edge" algorithm follows these steps:
 * <ul>
 * <li>Extract X and Y</li>
 * <li>Start the database connection</li>
 * <li>Make the query</li>
 * <li>Send the query to the database</li>
 * <li>Transform the result in the specified format</li>
 * <li>Close the database connection</li>
 * </ul>
 * To do these steps, ClosestEdge class calls some method in IOHelper and
 * DatabaseConnection
 * </p>
 * 
 * @author Matthieu Bilbille - Orkney Inc.
 * @version 1.0
 * @see IOHelper
 * @see DatabaseConnection
 */
public class ClosestEdge extends GeoAction
{
        /**
         * Constructor ClosestEdge
         * <p>
         * Creates a new ClosestEdge object using the specified Configuration object
         * and extracts X and Y from the data provides by GET or POST request into a
         * new point.
         * </p>
         * 
         * @param configuration
         *            the current configuration
         */
        public ClosestEdge(Configuration configuration, DatabaseConnection databaseConnection, IOHelper ioHelper, Log log)
        {
                super(configuration, databaseConnection, ioHelper, log);
                
                name = "Closest edge";

                // extract method for Geojson format
                if (configuration.getFormatIn().getName().equals("geojson"))
                {
                        point = this.ioHelper.extractGEOJSONPxPy(configuration.getService().getParameter("point").getValue());
                }
                // extract method for Gml format
                else if (configuration.getFormatIn().getName().equals("gml"))
                {
                        point = this.ioHelper.extractGMLPxPy(configuration.getService().getParameter("point").getValue());
                }
                // extract method for lonlat format
                else if (configuration.getFormatIn().getName().equals("lonlat"))
                {
                        point = this.ioHelper.extractLONLATPxPy(configuration.getService().getParameter("point").getValue());
                }
                // extract method for wkt format
                else if (configuration.getFormatIn().getName().equals("wkt"))
                {
                        point = this.ioHelper.extractWKTPxPy(configuration.getService().getParameter("point").getValue());
                }
                // extract method for kml format
                else if (configuration.getFormatIn().getName().equals("kml"))
                {
                        point = this.ioHelper.extractKMLPxPy(configuration.getService().getParameter("point").getValue());
                }
        }

        public void start() throws SQLException, JSONException
        {
                StringTemplate query = this.ioHelper.getQuery();
                float bboxSize = Float.parseFloat(configuration.getService().getParameter("bbox").getValue());

                // Makes the SQL query
                query.setAttribute("sonPx", point.getX());
                query.setAttribute("sonPy", point.getY());
                query.setAttribute("sonPxM", point.getX(-bboxSize));
                query.setAttribute("sonPxP", point.getX(bboxSize));
                query.setAttribute("sonPyM", point.getY(-bboxSize));
                query.setAttribute("sonPyP", point.getY(bboxSize));
                query.setAttribute("sridProvider", configuration.getService().getDataProjection());
                query.setAttribute("sridIn", configuration.getService().getParameter("sridInput").getValue());
                query.setAttribute("sridOut", configuration.getService().getParameter("sridOutput").getValue());

                // System.out.println(query.toString());
                log.write(query.toString(), 2);
                ResultSet rs = this.databaseConnection.getResult(configuration.getService(), query.toString());
                
                String reqId = configuration.getService().getParameter("request_id").getValue();
        
                StringTemplate template = this.configuration.getFormatOut().getTemplate();
        
                result = this.ioHelper.fillTemplate(rs, this.configuration.getFormatOut().getName(),
                        template, reqId);               

                /*
                // Converts the SQL Result in Geojson
                if (configuration.getFormatOut().getName().equals("geojson"))
                {
                        result = this.ioHelper.closestEdgeGEOJSONResult(rs, reqId);
                }
                // Converts the SQL Result in HTML
                else if (configuration.getFormatOut().getName().equals("html"))
                {
                        System.out.println("hjhh");
                        result = this.ioHelper.closestEdgeHTMLResult(rs, point, reqId);
                }
                // Converts the SQL Result in XML
                else if (configuration.getFormatOut().getName().equals("xml"))
                {
                        result = this.ioHelper.closestEdgeXMLResult(rs, reqId);
                }
                // Converts the SQL Result in ID (edge id)
                else if (configuration.getFormatOut().getName().equals("id"))
                {
                        result = this.ioHelper.closestEdgeIDResult(rs);
                }
                // Converts the SQL Result in GML
                else if (configuration.getFormatOut().getName().equals("gml"))
                {
                        result = this.ioHelper.closestEdgeGMLResult(rs, reqId);
                }
                // Converts the SQL Result in WKT
                else if (configuration.getFormatOut().getName().equals("wkt"))
                {
                        result = this.ioHelper.closestEdgeWKTResult(rs);
                }
                // Converts the SQL Result in KML
                else if (configuration.getFormatOut().getName().equals("kml"))
                {
                        result = this.ioHelper.closestEdgeKMLResult(rs);
                }
                */

                /*
                 * databaseConnection.close(); }
                 */
        }

}