protected function _join(&$sql, &$bindParams)
{
foreach ($this->relationships as $relationship) {
$relsql = array();
$table = $relationship['table'];
$tableAlias = $relationship['tableAlias'];
foreach ($relationship['query'] as $key => $value) {
if ($value instanceof Horde_Rdo_Query_Literal) {
$relsql[] = $key . ' = ' . str_replace("{$table}.", "{$tableAlias}.", (string) $value);
} else {
$relsql[] = $key . ' = ?';
$bindParams[] = $value;
}
}
$sql .= ' ' . $relationship['join_type'] . ' ' . $relationship['table'] . ' ' . $tableAlias . ' ON ' . implode(' AND ', $relsql);
}
}