public void addRecordDependentAccessSql(
final StringBuilder retSQL,
final AccessSqlParser asp,
final String tableName,
final boolean rw) {
final String mainSql = asp.getMainSql();
int AD_Table_ID = 0;
String whereColumnName = null;
final List<Integer> includes = new ArrayList<Integer>();
final List<Integer> excludes = new ArrayList<Integer>();
for (final TableRecordPermission recordDependentAccess : getDependentRecordPermissionsList()) {
final String columnName =
recordDependentAccess.getKeyColumnName(asp.getTableInfo(asp.getMainSqlIndex()));
if (columnName == null) {
continue; // no key column
}
if (mainSql.toUpperCase().startsWith("SELECT COUNT(*) FROM ")) {
// globalqss - Carlos Ruiz - [ 1965744 ] Dependent entities access problem
// this is the count select, it doesn't have the column but needs to be filtered
if (!TablesAccessInfo.instance.isPhysicalColumn(tableName, columnName)) {
continue;
}
} else {
final int posColumn = mainSql.indexOf(columnName);
if (posColumn == -1) {
continue;
}
// we found the column name - make sure it's a column name
char charCheck = mainSql.charAt(posColumn - 1); // before
if (!(charCheck == ',' || charCheck == '.' || charCheck == ' ' || charCheck == '(')) {
continue;
}
charCheck = mainSql.charAt(posColumn + columnName.length()); // after
if (!(charCheck == ',' || charCheck == ' ' || charCheck == ')')) {
continue;
}
}
if (AD_Table_ID != 0 && AD_Table_ID != recordDependentAccess.getAD_Table_ID()) {
retSQL.append(getDependentAccess(whereColumnName, includes, excludes));
}
AD_Table_ID = recordDependentAccess.getAD_Table_ID();
// *** we found the column in the main query
if (recordDependentAccess.isExclude()) {
excludes.add(recordDependentAccess.getRecord_ID());
logger.fine("Exclude " + columnName + " - " + recordDependentAccess);
} else if (!rw || !recordDependentAccess.isReadOnly()) {
includes.add(recordDependentAccess.getRecord_ID());
logger.fine("Include " + columnName + " - " + recordDependentAccess);
}
whereColumnName = getDependentRecordWhereColumn(mainSql, columnName);
} // for all dependent records
retSQL.append(getDependentAccess(whereColumnName, includes, excludes));
// //
// retSQL.append(orderBy);
// logger.finest(retSQL.toString());
// return retSQL.toString();
} // addAccessSQL
