it.eng.spagobi.engines.qbe.services.crosstab
Class LoadCrosstabAction

java.lang.Object
  extended by it.eng.spago.dispatching.service.DefaultRequestContext
      extended by it.eng.spago.dispatching.service.DefaultHttpRequestContext
          extended by it.eng.spago.dispatching.action.AbstractHttpAction
              extended by it.eng.spagobi.utilities.service.AbstractBaseHttpAction
                  extended by it.eng.spagobi.utilities.engines.AbstractEngineAction
                      extended by it.eng.spagobi.engines.qbe.services.core.AbstractQbeEngineAction
                          extended by it.eng.spagobi.engines.qbe.services.crosstab.LoadCrosstabAction
All Implemented Interfaces:
it.eng.spago.dispatching.action.ActionIFace, it.eng.spago.dispatching.service.HttpRequestContextIFace, it.eng.spago.dispatching.service.RequestContextIFace, it.eng.spago.dispatching.service.ServiceIFace, it.eng.spago.init.InitializerIFace, java.io.Serializable
Direct Known Subclasses:
LoadWorksheetCrosstabAction

public class LoadCrosstabAction
extends AbstractQbeEngineAction

See Also:
Serialized Form

Field Summary
static org.apache.log4j.Logger auditlogger
           
static org.apache.log4j.Logger logger
          Logger component.
 
Fields inherited from class it.eng.spagobi.utilities.engines.AbstractEngineAction
PRIVATE_SCOPE, PUBLIC_SCOPE
 
Constructor Summary
LoadCrosstabAction()
           
 
Method Summary
protected  java.lang.String buildSqlStatement(CrosstabDefinition crosstabDefinition, it.eng.qbe.query.Query baseQuery, java.lang.String sqlQuery, it.eng.qbe.statement.IStatement stmt)
          Build the sql statement for the temporary table
protected  org.json.JSONObject loadSmartFilterFormValues()
          Loads the values of the form if the calling engine is smart filter
 void service(it.eng.spago.base.SourceBean request, it.eng.spago.base.SourceBean response)
           
 
Methods inherited from class it.eng.spagobi.engines.qbe.services.core.AbstractQbeEngineAction
getDataSource, getEngineInstance, getFilteredQuery, getQuery, setDataSource
 
Methods inherited from class it.eng.spagobi.utilities.engines.AbstractEngineAction
getAuditServiceProxy, getConetxtManager, getEnv, getLocale, getSpagoBIHttpSessionContainer, getSpagoBISessionContainer, init, saveAnalysisState, setLocale
 
Methods inherited from class it.eng.spagobi.utilities.service.AbstractBaseHttpAction
delAttributeFromHttpSession, delAttributeFromSession, getAttribute, getAttributeAsBoolean, getAttributeAsBoolean, getAttributeAsCsvStringList, getAttributeAsInteger, getAttributeAsJSONArray, getAttributeAsJSONObject, getAttributeAsList, getAttributeAsString, getAttributeFromHttpSession, getAttributeFromHttpSessionAsBoolean, getAttributeFromHttpSessionAsBoolean, getAttributeFromHttpSessionAsString, getAttributeFromSession, getAttributeFromSessionAsBoolean, getAttributeFromSessionAsBoolean, getAttributeFromSessionAsString, getAttributesAsMap, getHttpSession, getSessionContainer, getSpagoBIRequestContainer, getSpagoBIResponseContainer, httpSessionContainsAttribute, requestContainsAttribute, requestContainsAttribute, sessionContainsAttribute, setAttribute, setAttributeInHttpSession, setAttributeInSession, setSpagoBIRequestContainer, setSpagoBIResponseContainer, tryToWriteBackToClient, writeBackToClient, writeBackToClient, writeBackToClient, writeBackToClient, writeBackToClient
 
Methods inherited from class it.eng.spago.dispatching.action.AbstractHttpAction
getActionMethod, getActionName, getConfig, setActionMethod, setActionName
 
Methods inherited from class it.eng.spago.dispatching.service.DefaultHttpRequestContext
freezeHttpResponse, getHttpRequest, getHttpResponse, getServletConfig, isHttpResponseFreezed, setRequestContext, unfreezeHttpResponse
 
Methods inherited from class it.eng.spago.dispatching.service.DefaultRequestContext
getErrorHandler, getRequestContainer, getResponseContainer, getServiceRequest, getServiceResponse
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface it.eng.spago.dispatching.service.RequestContextIFace
getErrorHandler, getRequestContainer, getResponseContainer, getServiceRequest, getServiceResponse
 

Field Detail

logger

public static transient org.apache.log4j.Logger logger
Logger component.


auditlogger

public static transient org.apache.log4j.Logger auditlogger
Constructor Detail

LoadCrosstabAction

public LoadCrosstabAction()
Method Detail

service

public void service(it.eng.spago.base.SourceBean request,
                    it.eng.spago.base.SourceBean response)
Specified by:
service in interface it.eng.spago.dispatching.service.ServiceIFace
Overrides:
service in class it.eng.spagobi.utilities.engines.AbstractEngineAction

loadSmartFilterFormValues

protected org.json.JSONObject loadSmartFilterFormValues()
                                                 throws org.json.JSONException
Loads the values of the form if the calling engine is smart filter

Returns:
Throws:
org.json.JSONException

buildSqlStatement

protected java.lang.String buildSqlStatement(CrosstabDefinition crosstabDefinition,
                                             it.eng.qbe.query.Query baseQuery,
                                             java.lang.String sqlQuery,
                                             it.eng.qbe.statement.IStatement stmt)
                                      throws org.json.JSONException
Build the sql statement for the temporary table

Parameters:
crosstabDefinition - definition of the crosstab
baseQuery - base query
sqlQuery - the sql rappresentation of the base query
stmt - the qbe statement
Returns:
Throws:
org.json.JSONException