/** * 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); } } }