root/tools/routingservice/trunk/src/jp/co/orkney/restlet/geo/TravelingSalesPerson.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 org.antlr.stringtemplate.StringTemplate;
import org.json.JSONException;

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;

/**
 * <b>TravelingSalesPerson is a class which represents a "traveling sales
 * person" algorithm.</b>
 * <p>
 * "traveling sales person" algorithm follows these steps:
 * <ul>
 * <li>Extract X and Y for start and each steps</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, TravelingSalesPerson class calls some method in IOHelper
 * and DatabaseConnection
 * </p>
 * 
 * @author Matthieu Bilbille - Orkney Inc.
 * @version 1.0
 * @see IOHelper
 * @see DatabaseConnection
 */
public class TravelingSalesPerson extends GeoAction
{

        private Point startPoint;
        private Point stepPoints[];


        /**
         * Constructor TravelingSalesPerson
         * <p>
         * Creates a new TravelingSalesPerson object using the specified
         * Configuration object and extracts X and Y from the data provides by GET
         * or POST request into a new point (for start and each steps).
         * </p>
         * 
         * @param configuration
         *            the current configuration
         */
        public TravelingSalesPerson(Configuration configuration, DatabaseConnection databaseConnection, IOHelper ioHelper, Log log)
        {
                super(configuration, databaseConnection, ioHelper, log);
                
                name = "TSP";

                // extract method for Geojson format
                if (this.configuration.getFormatIn().getName().equals("geojson"))
                {
                        startPoint = ioHelper.extractGEOJSONPxPy(this.configuration.getService().getParameter("point_start").getValue());
                        String stepTexts[] = ioHelper.extractPoints(this.configuration.getService().getParameter("points_step").getValue(), "::");
                        stepPoints = new Point[stepTexts.length];
                        for (int i = 0; i < stepTexts.length; i++)
                        {
                                stepPoints[i] = ioHelper.extractGEOJSONPxPy(stepTexts[i]);
                        }
                }
                // extract method for Gml format
                else if (this.configuration.getFormatIn().getName().equals("gml"))
                {
                }
                // extract method for lonlat format
                else if (this.configuration.getFormatIn().getName().equals("lonlat"))
                {
                }
                // extract method for wkt format
                else if (this.configuration.getFormatIn().getName().equals("wkt"))
                {
                }
                // extract method for kml format
                else if (this.configuration.getFormatIn().getName().equals("kml"))
                {
                }
        }

        /**
         * Gets the result of the traveling sales person algorithm
         * 
         * @return this traveling sales person's result
         */
        public String get()
        {
                return result;
        }

        /**
         * Starts the "traveling sales person" algorithm
         * 
         * @throws SQLException
         *             error to send the query to the database
         * @throws JSONException
         *             Error to transform the result in Geojson format
         */
        public void start() throws SQLException, JSONException
        {
                StringTemplate query = ioHelper.getQuery();
                float bboxSize = Float.parseFloat(configuration.getService().getParameter("bbox").getValue());

                // Makes the SQL query
                query.setAttribute("sonStartX", startPoint.getX());
                query.setAttribute("sonStartY", startPoint.getY());
                query.setAttribute("bbox", bboxSize);
                query.setAttribute("sesSteps", ioHelper.pointsToString(stepPoints));
                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(), 1);
                ResultSet rs = 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 = ioHelper.travelingSalesPersonGEOJSONResult(rs, reqId);
                }
                // Converts the SQL Result in HTML
                else if (configuration.getFormatOut().getName().equals("html"))
                {
                        result = ioHelper.travelingSalesPersonHTMLResult(rs, startPoint, reqId);
                }
                // Converts the SQL Result in XML
                else if (configuration.getFormatOut().getName().equals("xml"))
                {
                        result = ioHelper.travelingSalesPersonXMLResult(rs, reqId);
                }
                // Converts the SQL Result in GML
                else if (configuration.getFormatOut().getName().equals("gml"))
                {
                        result = ioHelper.travelingSalesPersonGMLResult(rs, reqId);
                }
                // Converts the SQL Result in WKT
                else if (configuration.getFormatOut().getName().equals("wkt"))
                {
                        result = ioHelper.travelingSalesPersonWKTResult(rs);
                }
                // Converts the SQL Result in KML
                else if (configuration.getFormatOut().getName().equals("kml"))
                {
                        result = ioHelper.travelingSalesPersonKMLResult(rs);
                }
                */
        }

}