/**
* generates the part of the FROM clause for outer joins
* @return array [0]=> the part of the FROM clause, [1]=> the part to add to the WHERE clause when needed
*/
protected function buildOuterJoins(&$tables, $primaryTableName)
{
$sqlFrom = '';
foreach ($this->_dataParser->getOuterJoins() as $tablejoin) {
$table = $tables[$tablejoin[0]];
$tablename = $this->_encloseName($table['name']);
$r = $this->_encloseName($table['realname']) . $this->aliasWord . $tablename;
$fieldjoin = '';
foreach ($table['fk'] as $k => $fk) {
$fieldjoin .= ' AND ' . $primaryTableName . '.' . $this->_encloseName($fk) . '=' . $tablename . '.' . $this->_encloseName($table['pk'][$k]);
}
$fieldjoin = substr($fieldjoin, 4);
if ($tablejoin[1] == 0) {
$sqlFrom .= ' LEFT JOIN ' . $r . ' ON (' . $fieldjoin . ')';
} elseif ($tablejoin[1] == 1) {
$sqlFrom .= ' RIGHT JOIN ' . $r . ' ON (' . $fieldjoin . ')';
}
}
return array($sqlFrom, '');
}
protected function import($xml, $tools)
{
if (isset($xml['import'])) {
$import = (string) $xml['import'];
jApp::pushCurrentModule($this->selector->module);
// Keep the same driver as current used
$importSel = new jSelectorDaoDb($import, $this->selector->driver, $this->selector->dbType);
jApp::popCurrentModule();
$doc = new DOMDocument();
if (!$doc->load($importSel->getPath())) {
throw new jException('jelix~daoxml.file.unknown', $importSel->getPath());
}
$parser = new jDaoParser($importSel);
$parser->parse(simplexml_import_dom($doc), $tools);
$this->_properties = $parser->getProperties();
$this->_tables = $parser->getTables();
$this->_primaryTable = $parser->getPrimaryTable();
$this->_methods = $parser->getMethods();
$this->_ojoins = $parser->getOuterJoins();
$this->_ijoins = $parser->getInnerJoins();
$this->_eventList = $parser->getEvents();
$this->_userRecord = $parser->getUserRecord();
$this->_importedDao = $parser->getImportedDao();
$this->hasOnlyPrimaryKeys = $parser->hasOnlyPrimaryKeys;
if ($this->_importedDao) {
$this->_importedDao[] = $importSel;
} else {
$this->_importedDao = array($importSel);
}
}
}
