1 /* 2 * Copyright (c) 2002-2017, Mairie de Paris 3 * All rights reserved. 4 * 5 * Redistribution and use in source and binary forms, with or without 6 * modification, are permitted provided that the following conditions 7 * are met: 8 * 9 * 1. Redistributions of source code must retain the above copyright notice 10 * and the following disclaimer. 11 * 12 * 2. Redistributions in binary form must reproduce the above copyright notice 13 * and the following disclaimer in the documentation and/or other materials 14 * provided with the distribution. 15 * 16 * 3. Neither the name of 'Mairie de Paris' nor 'Lutece' nor the names of its 17 * contributors may be used to endorse or promote products derived from 18 * this software without specific prior written permission. 19 * 20 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 21 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 22 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE 23 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR CONTRIBUTORS BE 24 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR 25 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF 26 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS 27 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN 28 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 29 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 30 * POSSIBILITY OF SUCH DAMAGE. 31 * 32 * License 1.0 33 */ 34 package fr.paris.lutece.plugins.insertajax.web; 35 36 import javax.servlet.http.HttpServletRequest; 37 38 import fr.paris.lutece.plugins.insertajax.business.InsertAjax; 39 import fr.paris.lutece.plugins.insertajax.business.InsertAjaxHome; 40 import fr.paris.lutece.portal.service.plugin.Plugin; 41 import fr.paris.lutece.portal.service.plugin.PluginService; 42 43 /** 44 * Return content to the insertAjax Javascript client define in the adminFeature 45 */ 46 public class InsertAjaxResult 47 { 48 private final static String PARAMETER_SQL_REQUEST_ID = "id"; 49 private final static String PARAMETER_PLUGIN_NAME = "plugin_name"; 50 private final static String DEFAULT_RESULT = "-1"; 51 52 public static String getResult( HttpServletRequest request ) 53 { 54 try 55 { 56 //get plugin 57 String strPluginName = request.getParameter( PARAMETER_PLUGIN_NAME ); 58 Plugin plugin = PluginService.getPlugin( strPluginName ); 59 60 String strIdSqlRequest = request.getParameter( PARAMETER_SQL_REQUEST_ID ); 61 int nIdSqlRequest = Integer.parseInt( strIdSqlRequest ); 62 63 //get the insertajax 64 InsertAjax ia = InsertAjaxHome.findByPrimaryKey( nIdSqlRequest, plugin ); 65 String strSql = ia.getSql( ); 66 67 //get result 68 String strResult = InsertAjaxHome.executeSql( strSql, plugin ); 69 70 //JSONObject json = new JSONObject(); 71 72 return strResult; 73 } 74 catch (NumberFormatException e) 75 { 76 return DEFAULT_RESULT; 77 } 78 catch (Exception e) 79 { 80 return DEFAULT_RESULT; 81 } 82 } 83 }