p12f.exe.search.sqlutils
Class PaymentQuerySQLStatsComposerHelper

java.lang.Object
  extended byp12f.exe.search.sqlutils.PaymentQuerySQLStatsComposerHelper

public class PaymentQuerySQLStatsComposerHelper
extends java.lang.Object


Field Summary
 java.lang.String viewId
           
static java.lang.String viewIdAdmCompletados
           
static java.lang.String viewIdAdmCompletadosFieldDetail
           
static java.lang.String viewIdAdmDateCompletadosFieldDetail
           
static java.lang.String viewIdAdmDateIniciadosFieldDetail
           
static java.lang.String viewIdAdmDateLeftJoinFieldDetail
           
static java.lang.String viewIdAdmIniciados
           
static java.lang.String viewIdAdmIniciadosFieldDetail
           
static java.lang.String viewIdAdmLeftJoin
           
static java.lang.String viewIdAdmLeftJoinFieldDetail
           
static java.lang.String viewIdFinantialOrgLeftJoin
           
static java.lang.String viewIdPaymentDateLeftJoin
           
static java.lang.String viewIdPaymentModeLeftJoin
           
static java.lang.String viewIdPaymentStatusLeftJoin
           
 
Constructor Summary
PaymentQuerySQLStatsComposerHelper()
           
 
Method Summary
 PaymentSQL addExpBlockClause(EXPSearchedParam expediente, PaymentSQL paymentSQL)
          Añade Condiciones propias del Bloque de Expedientes.
 PaymentSQL addFinantialOrgBlockClause(FinantialOrgSearchedParam finantialOrgParam, PaymentSQL paymentSQL)
          Añade Condiciones propias del Bloque de entidad financiera : 3035, 2095......
 java.lang.String addFinantialOrgLeftJoinClause()
           
 PaymentSQL addGroupByAttributes(PaymentSQL paymentSQL)
           
 PaymentSQL addGroupByAttributes(PaymentSQL paymentSQL, java.lang.String viewId)
           
 java.lang.String addLeftJoinClause()
           
 java.lang.String addLeftJoinClause(java.lang.String viewId)
           
 PaymentSQL addPaymentDataBlockClause(PaymentDataSearchedParam dataSearched, PaymentSQL paymentSQL)
          Añade condiciones del Bloque de datos del CSB
 java.lang.String addPaymentDateLeftJoinClause()
           
 PaymentSQL addPaymentModeBlockClause(PaymentModeSearchedParam paymentModeParam, PaymentSQL paymentSQL)
          Añade Condiciones propias del Bloque de modo de pago : LIQUIDACION, MOVIL......
 java.lang.String addPaymentModeLeftJoinClause()
           
 java.lang.String addPaymentStatusLeftJoinClause()
           
 PaymentSQL addStatusBlockClause(PaymentStateSearchedParam statusParam, PaymentSQL paymentSQL)
          Añade Condiciones propias del Bloque de Estado : PAGADO, NO_PAGADO, NRC......
 PaymentSQL addStatusCodeClause(PaymentSQL paymentSQL)
           
 PaymentSQL addStatusCodeClause(PaymentSQL paymentSQL, java.lang.String strEstado)
           
 PaymentSQL addThridPartyBlockClause(ThirdPartySearchedParam third, PaymentSQL paymentSQL)
          Añade condiciones del Bloque de datos de Tercero.
 java.util.HashMap doInitializeQueryViewTypes(PaymentQuery paymentQuery, java.lang.String vId)
           
 java.lang.String getParametersToGroup(java.lang.String id)
           
 java.lang.String getParametersToSelect(java.lang.String id)
          Inserta paramétros en la Query de Consulta : Select ID X.ID_1 , ID Y.
static void main(java.lang.String[] argv)
          Testeo de Metodos
 java.lang.String sqlToAlias(java.lang.String query, java.lang.String viewId)
           
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

viewId

public java.lang.String viewId

viewIdAdmLeftJoin

public static final java.lang.String viewIdAdmLeftJoin
See Also:
Constant Field Values

viewIdAdmIniciados

public static final java.lang.String viewIdAdmIniciados
See Also:
Constant Field Values

viewIdAdmCompletados

public static final java.lang.String viewIdAdmCompletados
See Also:
Constant Field Values

viewIdAdmLeftJoinFieldDetail

public static final java.lang.String viewIdAdmLeftJoinFieldDetail
See Also:
Constant Field Values

viewIdAdmIniciadosFieldDetail

public static final java.lang.String viewIdAdmIniciadosFieldDetail
See Also:
Constant Field Values

viewIdAdmCompletadosFieldDetail

public static final java.lang.String viewIdAdmCompletadosFieldDetail
See Also:
Constant Field Values

viewIdAdmDateLeftJoinFieldDetail

public static final java.lang.String viewIdAdmDateLeftJoinFieldDetail
See Also:
Constant Field Values

viewIdAdmDateIniciadosFieldDetail

public static final java.lang.String viewIdAdmDateIniciadosFieldDetail
See Also:
Constant Field Values

viewIdAdmDateCompletadosFieldDetail

public static final java.lang.String viewIdAdmDateCompletadosFieldDetail
See Also:
Constant Field Values

viewIdFinantialOrgLeftJoin

public static final java.lang.String viewIdFinantialOrgLeftJoin
See Also:
Constant Field Values

viewIdPaymentDateLeftJoin

public static final java.lang.String viewIdPaymentDateLeftJoin
See Also:
Constant Field Values

viewIdPaymentModeLeftJoin

public static final java.lang.String viewIdPaymentModeLeftJoin
See Also:
Constant Field Values

viewIdPaymentStatusLeftJoin

public static final java.lang.String viewIdPaymentStatusLeftJoin
See Also:
Constant Field Values
Constructor Detail

PaymentQuerySQLStatsComposerHelper

public PaymentQuerySQLStatsComposerHelper()
Method Detail

doInitializeQueryViewTypes

public java.util.HashMap doInitializeQueryViewTypes(PaymentQuery paymentQuery,
                                                    java.lang.String vId)

sqlToAlias

public java.lang.String sqlToAlias(java.lang.String query,
                                   java.lang.String viewId)

addLeftJoinClause

public java.lang.String addLeftJoinClause(java.lang.String viewId)

addLeftJoinClause

public java.lang.String addLeftJoinClause()

addFinantialOrgLeftJoinClause

public java.lang.String addFinantialOrgLeftJoinClause()

addPaymentModeLeftJoinClause

public java.lang.String addPaymentModeLeftJoinClause()

addPaymentDateLeftJoinClause

public java.lang.String addPaymentDateLeftJoinClause()

addPaymentStatusLeftJoinClause

public java.lang.String addPaymentStatusLeftJoinClause()

addExpBlockClause

public PaymentSQL addExpBlockClause(EXPSearchedParam expediente,
                                    PaymentSQL paymentSQL)
Añade Condiciones propias del Bloque de Expedientes.

Parameters:
paymentSQL -
Returns:

addPaymentDataBlockClause

public PaymentSQL addPaymentDataBlockClause(PaymentDataSearchedParam dataSearched,
                                            PaymentSQL paymentSQL)
Añade condiciones del Bloque de datos del CSB

Parameters:
dataSearched - Condiciones a añadir
paymentSQL - : SQL a la que se le añadiran las condiciones.
Returns:

addFinantialOrgBlockClause

public PaymentSQL addFinantialOrgBlockClause(FinantialOrgSearchedParam finantialOrgParam,
                                             PaymentSQL paymentSQL)
Añade Condiciones propias del Bloque de entidad financiera : 3035, 2095......

Parameters:
paymentSQL -
Returns:

addPaymentModeBlockClause

public PaymentSQL addPaymentModeBlockClause(PaymentModeSearchedParam paymentModeParam,
                                            PaymentSQL paymentSQL)
Añade Condiciones propias del Bloque de modo de pago : LIQUIDACION, MOVIL......

Parameters:
paymentModeParam -
paymentSQL -
Returns:

addStatusBlockClause

public PaymentSQL addStatusBlockClause(PaymentStateSearchedParam statusParam,
                                       PaymentSQL paymentSQL)
Añade Condiciones propias del Bloque de Estado : PAGADO, NO_PAGADO, NRC......

Parameters:
paymentSQL -
Returns:

addStatusCodeClause

public PaymentSQL addStatusCodeClause(PaymentSQL paymentSQL)

addStatusCodeClause

public PaymentSQL addStatusCodeClause(PaymentSQL paymentSQL,
                                      java.lang.String strEstado)

addThridPartyBlockClause

public PaymentSQL addThridPartyBlockClause(ThirdPartySearchedParam third,
                                           PaymentSQL paymentSQL)
Añade condiciones del Bloque de datos de Tercero.

Parameters:
third -
paymentSQL -
Returns:

getParametersToSelect

public java.lang.String getParametersToSelect(java.lang.String id)
Inserta paramétros en la Query de Consulta : Select ID X.ID_1 , ID Y. ID_2


getParametersToGroup

public java.lang.String getParametersToGroup(java.lang.String id)

addGroupByAttributes

public PaymentSQL addGroupByAttributes(PaymentSQL paymentSQL)

addGroupByAttributes

public PaymentSQL addGroupByAttributes(PaymentSQL paymentSQL,
                                       java.lang.String viewId)

main

public static void main(java.lang.String[] argv)
Testeo de Metodos