/** Obtains filter for TableSQLData */
public void getFilter(
SQLReturnObject result,
boolean isNewFilter,
VariablesSecureApp vars,
TableSQLData tableSQL,
Vector<String> filter,
Vector<String> filterParams,
Properties prop)
throws Exception {
String aux;
if (isNewFilter) {
aux =
vars.getRequestGlobalVariable(
"inpParam" + prop.getProperty("ColumnName"),
tableSQL.getTabID() + "|param" + prop.getProperty("ColumnName"));
} else {
aux = vars.getSessionValue(tableSQL.getTabID() + "|param" + prop.getProperty("ColumnName"));
}
// The filter is not applied if the parameter value is null or
// parameter value is '%' for string references.
if (!aux.equals("")) {
UIReferenceUtility.addFilter(
filter,
filterParams,
result,
tableSQL,
prop.getProperty("ColumnName"),
prop.getProperty("ColumnName"),
reference,
true,
aux);
}
if (addSecondaryFilter) {
if (isNewFilter) {
aux =
vars.getRequestGlobalVariable(
"inpParam" + prop.getProperty("ColumnName") + "_f",
tableSQL.getTabID() + "|param" + prop.getProperty("ColumnName") + "_f");
} else {
aux =
vars.getSessionValue(
tableSQL.getTabID() + "|param" + prop.getProperty("ColumnName") + "_f");
}
if (!aux.equals("")) {
UIReferenceUtility.addFilter(
filter,
filterParams,
result,
tableSQL,
prop.getProperty("ColumnName"),
prop.getProperty("ColumnName") + "_f",
reference,
false,
aux);
}
}
}
public void setComboTableDataIdentifier(
ComboTableData comboTableData, String tableName, FieldProvider field) throws Exception {
if (!UIReferenceUtility.checkTableTranslation(comboTableData, tableName, field, reference)) {
comboTableData.addSelectField(
UIReferenceUtility.formatField(
comboTableData.getVars(),
reference,
(((tableName != null && tableName.length() != 0) ? (tableName + ".") : "")
+ field.getField("name"))),
"NAME");
}
}
/** Helper method called from generateSQL to create the SQL for the identifier */
protected void identifier(
TableSQLData tableSql,
String parentTableName,
Properties field,
String identifierName,
String realName,
boolean tableRef)
throws Exception {
if (field == null) return;
if (!UIReferenceUtility.checkTableTranslation(
tableSql, parentTableName, field, reference, identifierName, realName, tableRef)) {
tableSql.addSelectField(
UIReferenceUtility.formatField(
tableSql.getVars(),
reference,
(parentTableName + "." + field.getProperty("ColumnName"))),
identifierName);
}
}
