/** * Grouping tables that haven't been discovered * * @param bool $persist Persist the group * * @return NenoContentElementGroup */ public static function groupingTablesNotDiscovered($persist = true) { /* @var $db NenoDatabaseDriverMysqlx */ $db = JFactory::getDbo(); // Get all the tables that haven't been detected using naming convention. $tablesNotDiscovered = self::getTablesNotDiscovered(); $tablesAdded = false; $otherGroup = null; if (!empty($tablesNotDiscovered)) { // Check if this group exists already $query = $db->getQuery(true); $query->select('g.id')->from('#__neno_content_element_groups AS g')->where('NOT EXISTS (SELECT 1 FROM #__neno_content_element_groups_x_extensions AS ge WHERE ge.group_id = g.id)'); $db->setQuery($query); $groupId = $db->loadResult(); if (!empty($groupId)) { /* @var $otherGroup NenoContentElementGroup */ $otherGroup = NenoContentElementGroup::load($groupId); } else { $otherGroup = new NenoContentElementGroup(array('group_name' => 'Other')); } $tablesIgnored = NenoHelper::getDoNotTranslateTables(); foreach ($tablesNotDiscovered as $tableNotDiscovered) { if (!in_array($tableNotDiscovered, $tablesIgnored)) { // Create an array with the table information $tableData = array('tableName' => $tableNotDiscovered, 'primaryKey' => $db->getPrimaryKey($tableNotDiscovered), 'translate' => 1, 'group' => $otherGroup); // Create ContentElement object $table = new NenoContentElementTable($tableData); // Get all the columns a table contains $fields = $db->getTableColumns($table->getTableName()); foreach ($fields as $fieldName => $fieldType) { $fieldData = array('fieldName' => $fieldName, 'fieldType' => $fieldType, 'translate' => NenoContentElementField::isTranslatableType($fieldType), 'table' => $table); $field = new NenoContentElementField($fieldData); $table->addField($field); } $otherGroup->addTable($table); $tablesAdded = true; } } $otherGroup->setAssignedTranslationMethods(NenoHelper::getTranslationMethodsForLanguages()); if ($persist) { $otherGroup->persist(); } } if (!$tablesAdded) { $otherGroup = null; } return $otherGroup; }
/** * Get data for the installation step * * @param int $step Step number * * @return stdClass */ protected function getDataForStep($step) { $data = new stdClass(); switch ($step) { case 1: $languages = NenoHelper::findLanguages(true); $data->select_widget = JHtml::_('select.genericlist', $languages, 'source_language', null, 'iso', 'name', NenoSettings::get('source_language')); break; case 3: $language = JFactory::getLanguage(); $default = NenoSettings::get('source_language'); $knownLanguages = $language->getKnownLanguages(); $languagesData = array(); $defaultTranslationsMethods = NenoHelper::getDefaultTranslationMethods(); $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->insert('#__neno_content_language_defaults')->columns(array('lang', 'translation_method_id', 'ordering')); $insert = false; foreach ($knownLanguages as $key => $knownLanguage) { if ($knownLanguage['tag'] != $default) { $insert = true; $languagesData[$key] = $knownLanguage; $languagesData[$key]['lang_code'] = $knownLanguage['tag']; $languagesData[$key]['title'] = $knownLanguage['name']; $languagesData[$key]['translationMethods'] = $defaultTranslationsMethods; $languagesData[$key]['errors'] = NenoHelper::getLanguageErrors($languagesData[$key]); $languagesData[$key]['placement'] = 'installation'; $languagesData[$key]['image'] = NenoHelper::getLanguageImage($knownLanguage['tag']); $languagesData[$key]['published'] = NenoHelper::isLanguagePublished($knownLanguage['tag']); $languagesData[$key]['comment'] = NenoHelper::getLanguageTranslatorComment($knownLanguage['tag']); foreach ($defaultTranslationsMethods as $ordering => $defaultTranslationsMethod) { $query->values($db->quote($knownLanguage['tag']) . ',' . $defaultTranslationsMethod->id . ',' . ($ordering + 1)); } } } if ($insert) { $db->setQuery($query); $db->execute(); } $data->languages = $languagesData; break; case 4: /* @var $db NenoDatabaseDriverMysqlx */ $db = JFactory::getDbo(); $query = $db->getQuery(true); $tablesIgnored = NenoHelper::getDoNotTranslateTables(); /* @var $config \Joomla\Registry\Registry */ $config = JFactory::getConfig(); $query->select('DISTINCT TABLE_NAME')->from('INFORMATION_SCHEMA.COLUMNS')->where(array('COLUMN_NAME = ' . $db->quote('language'), 'TABLE_SCHEMA = ' . $db->quote($config->get('db')), 'TABLE_NAME NOT LIKE ' . $db->quote('%neno%'), 'TABLE_NAME NOT LIKE ' . $db->quote('%\\_\\_%'), 'TABLE_NAME NOT LIKE ' . $db->quote('%menu'))); $db->setQuery($query); $tables = $db->loadArray(); $tablesFound = array(); foreach ($tables as $table) { if (!in_array(str_replace($db->getPrefix(), '#__', $table), $tablesIgnored)) { $sourceLanguage = NenoSettings::get('source_language'); $sourceLanguageParts = explode('-', $sourceLanguage); $query->clear()->select(array('COUNT(*) AS counter', 'language', $db->quote($table) . ' AS `table`'))->from($db->quoteName($table))->where(array('language <> ' . $db->quote('*'), 'language <> ' . $db->quote(''), 'language <> ' . $db->quote($sourceLanguage), 'language <> ' . $db->quote($sourceLanguageParts[0])))->group('language'); $db->setQuery($query); $recordsFound = $db->loadObjectList(); if (!empty($recordsFound)) { $tablesFound = array_merge($tablesFound, $recordsFound); } } } $data->tablesFound = $tablesFound; break; case 5: $groups = NenoHelper::getGroups(); /* @var $group NenoContentElementGroup */ foreach ($groups as $key => $group) { $group->getTables(); $groups[$key] = $group->prepareDataForView(); } $data->groups = $groups; break; } return $data; }