|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectp12f.exe.search.sqlutils.PaymentQuerySQLStatsComposerHelper
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 |
public java.lang.String viewId
public static final java.lang.String viewIdAdmLeftJoin
public static final java.lang.String viewIdAdmIniciados
public static final java.lang.String viewIdAdmCompletados
public static final java.lang.String viewIdAdmLeftJoinFieldDetail
public static final java.lang.String viewIdAdmIniciadosFieldDetail
public static final java.lang.String viewIdAdmCompletadosFieldDetail
public static final java.lang.String viewIdAdmDateLeftJoinFieldDetail
public static final java.lang.String viewIdAdmDateIniciadosFieldDetail
public static final java.lang.String viewIdAdmDateCompletadosFieldDetail
public static final java.lang.String viewIdFinantialOrgLeftJoin
public static final java.lang.String viewIdPaymentDateLeftJoin
public static final java.lang.String viewIdPaymentModeLeftJoin
public static final java.lang.String viewIdPaymentStatusLeftJoin
Constructor Detail |
public PaymentQuerySQLStatsComposerHelper()
Method Detail |
public java.util.HashMap doInitializeQueryViewTypes(PaymentQuery paymentQuery, java.lang.String vId)
public java.lang.String sqlToAlias(java.lang.String query, java.lang.String viewId)
public java.lang.String addLeftJoinClause(java.lang.String viewId)
public java.lang.String addLeftJoinClause()
public java.lang.String addFinantialOrgLeftJoinClause()
public java.lang.String addPaymentModeLeftJoinClause()
public java.lang.String addPaymentDateLeftJoinClause()
public java.lang.String addPaymentStatusLeftJoinClause()
public PaymentSQL addExpBlockClause(EXPSearchedParam expediente, PaymentSQL paymentSQL)
paymentSQL
-
public PaymentSQL addPaymentDataBlockClause(PaymentDataSearchedParam dataSearched, PaymentSQL paymentSQL)
dataSearched
- Condiciones a añadirpaymentSQL
- : SQL a la que se le añadiran las condiciones.
public PaymentSQL addFinantialOrgBlockClause(FinantialOrgSearchedParam finantialOrgParam, PaymentSQL paymentSQL)
paymentSQL
-
public PaymentSQL addPaymentModeBlockClause(PaymentModeSearchedParam paymentModeParam, PaymentSQL paymentSQL)
paymentModeParam
- paymentSQL
-
public PaymentSQL addStatusBlockClause(PaymentStateSearchedParam statusParam, PaymentSQL paymentSQL)
paymentSQL
-
public PaymentSQL addStatusCodeClause(PaymentSQL paymentSQL)
public PaymentSQL addStatusCodeClause(PaymentSQL paymentSQL, java.lang.String strEstado)
public PaymentSQL addThridPartyBlockClause(ThirdPartySearchedParam third, PaymentSQL paymentSQL)
third
- paymentSQL
-
public java.lang.String getParametersToSelect(java.lang.String id)
public java.lang.String getParametersToGroup(java.lang.String id)
public PaymentSQL addGroupByAttributes(PaymentSQL paymentSQL)
public PaymentSQL addGroupByAttributes(PaymentSQL paymentSQL, java.lang.String viewId)
public static void main(java.lang.String[] argv)
|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |