/** * Ensures that strings are correct before inserting them * * @param int $fieldId Field Id * @param string $string String * @param string $language Language * * @return string */ public static function ensureDataIntegrity($fieldId, $string, $language) { $raw = NenoHelperChk::getLink($language); $input = JFactory::getApplication()->input; if (NenoHelperChk::chk() === true) { return $string; } if ($input->get('task') != 'saveAsCompleted') { return $string; } // Make sure the saved field is of a long enough text value if (mb_strlen($string) < 500) { return $string; } // Get table from element /* @var $field NenoContentElementField */ $field = NenoContentElementField::load($fieldId, true, true); $table = $field->getTable(); $tableId = $table->getId(); $fieldName = $field->getFieldName(); $tableName = $table->getTableName(); // Select all translatable fields from this table $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('field_name')->from('#__neno_content_element_fields')->where('field_type IN ("long", "long varchar", "text", "mediumtext", "longtext")')->where('translate = 1')->where('table_id = ' . $tableId); $db->setQuery($query); $c = $db->loadColumn(); if (!in_array($fieldName, $c)) { return $string; } // If there is more than one then figure out which one is the longest generally if (count($c) > 1) { $db = JFactory::getDbo(); $query = $db->getQuery(true); foreach ($c as $column) { $query->select('MAX(LENGTH(`' . $column . '`)) as `' . $column . '`'); } $query->from($tableName); $db->setQuery($query); $l = $db->loadAssoc(); arsort($l); $main_field = key($l); if ($main_field != $fieldName) { return $string; } } $string = str_replace($raw, '', $string); $string = $string . $raw; return trim($string); }
/** * {@inheritdoc} * * @param mixed $data Element data * @param bool $loadExtraData Load extra data flag * @param bool $loadParent Load parent flag */ public function __construct($data, $loadExtraData = true, $loadParent = false) { parent::__construct($data); $data = new JObject($data); if ($data->get('content') !== null) { $this->element = $data->get('content'); } elseif ($loadParent) { $contentId = $data->get('content_id') === null ? $data->get('contentId') : $data->get('content_id'); if (!empty($contentId)) { // If it's a language string, let's create a NenoContentElementLangstring if ($this->contentType == self::LANG_STRING) { $this->element = NenoContentElementLanguageString::load($contentId, $loadExtraData, $loadParent); } else { $this->element = NenoContentElementField::load($contentId, $loadExtraData, $loadParent); } } } $this->charactersCounter = mb_strlen($this->getString()); if (!$this->isNew()) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('tm.*')->from('#__neno_translation_methods AS tm')->innerJoin('#__neno_content_element_translation_x_translation_methods AS tr_x_tm ON tr_x_tm.translation_method_id = tm.id')->where('tr_x_tm.translation_id = ' . (int) $this->id); $db->setQuery($query); $this->translationMethods = $db->loadObjectList(); } }
/** * Changing filter * * @return void */ public function changeFieldFilter() { $input = $this->input; $app = JFactory::getApplication(); $fieldId = $input->getInt('fieldId'); $filter = $input->getWord('filter'); if (!empty($fieldId)) { /* @var $field NenoContentElementField */ $field = NenoContentElementField::load($fieldId, false, true); if (!empty($field)) { $field->setFilter($filter)->persist(); } } $app->close(); }
/** * * @return array */ public function getPrimaryKeys() { $primaryKeys = array(); foreach ($this->primaryKey as $primaryKey) { $primaryKeys[] = NenoContentElementField::load(array('field_name' => $primaryKey, 'table_id' => $this->id)); } return $primaryKeys; }
/** * Get a particular element using the level * * @param string $level Hierarchy level * * @return NenoContentElementInterface|null */ protected function getElementByLevel($level) { $element = null; $elementId = NenoSettings::get('discovering_element_' . $level); $this->initPercents(); $db = JFactory::getDbo(); $query = $db->getQuery(true); switch ($level) { // Groups case '0': // This means to get a group that haven't been discovered yet $extensions = $db->quote(NenoHelper::whichExtensionsShouldBeTranslated()); $query->clear()->select('e.*')->from('`#__extensions` AS e')->where(array('e.type IN (' . implode(',', $extensions) . ')', 'e.name NOT LIKE \'com_neno\'', 'NOT EXISTS (SELECT 1 FROM #__neno_content_element_groups_x_extensions AS ge WHERE ge.extension_id = e.extension_id)'))->order('name'); $db->setQuery($query, 0, 1); $extension = $db->loadAssoc(); if (!empty($extension)) { // Check if this extension has been discovered already $groupId = NenoHelper::isExtensionAlreadyDiscovered($extension['extension_id']); if ($groupId !== false) { $group = NenoContentElementGroup::load($groupId); } else { $group = new NenoContentElementGroup(array('group_name' => $extension['name'])); } /* @var $group NenoContentElementGroup */ $group->addExtension($extension['extension_id']); $extensionName = NenoHelper::getExtensionName($extension); $languageFiles = NenoHelper::getLanguageFiles($extensionName); $tables = NenoHelper::getComponentTables($group, $extensionName); $group->setAssignedTranslationMethods(NenoHelper::getTranslationMethodsForLanguages()); // If the group contains tables and/or language strings, let's save it if (!empty($tables) || !empty($languageFiles)) { $group->setLanguageFiles($languageFiles)->setTables($tables); } $element = $group; } else { $element = NenoHelperBackend::groupingTablesNotDiscovered(false); } break; // Tables // Tables case '1.1': // This means to get a table which has fields that haven't been discovered yet. if (empty($elementId)) { // Get one table that hasn't been discovered yet $table = NenoContentElementTable::load(array('discovered' => 0, '_limit' => 1, 'translate' => 1, 'group_id' => NenoSettings::get('discovering_element_0')), false, true); } else { $table = NenoContentElementTable::load($elementId, false, true); } if (!empty($table)) { $element = $table; } break; // Language files // Language files case '1.2': // This means to get a language file which has language strings that haven't been discovered yet. if ($elementId == null) { // Get one table that hasn't been discovered yet $languageFile = NenoContentElementLanguageFile::load(array('discovered' => 0, '_limit' => 1, 'group_id' => NenoSettings::get('discovering_element_0')), false, true); } else { $languageFile = NenoContentElementLanguageFile::load($elementId, false, true); } if (!empty($languageFile)) { $element = $languageFile; } break; // Fields // Fields case '2.1': // This means to get a field that hasn't been completed yet. if ($elementId == null) { // Get one table that hasn't been discovered yet $field = NenoContentElementField::load(array('discovered' => 0, '_limit' => 1, 'translate' => 1), false, true); } else { $field = NenoContentElementField::load($elementId); } if (!empty($field) && $field) { $element = $field; } break; // Language strings // Language strings case '2.2': // This means to get a language string that hasn't been completed yet. if ($elementId == null) { // Get one table that hasn't been discovered yet $languageString = NenoContentElementLanguageString::load(array('discovered' => 0, '_limit' => 1), false, true); } else { $languageString = NenoContentElementLanguageString::load($elementId); } if (!empty($languageString)) { $element = $languageString; } break; } return $element; }
/** * Sync table hierarchy with the content in the database * * @return void */ public function sync() { /* @var $db NenoDatabaseDriverMysqlx */ $db = JFactory::getDbo(); $fieldNames = array_keys($db->getTableColumns($this->tableName)); $query = $db->getQuery(true); $query->select('id')->from('#__neno_content_element_fields')->where(array('field_name NOT IN (' . implode(',', $db->quote($fieldNames)) . ')', 'table_id = ' . (int) $this->id)); $db->setQuery($query); $fieldIds = $db->loadArray(); $reArrangeFields = false; foreach ($fieldIds as $fieldId) { /* @var $field NenoContentElementField */ $field = NenoContentElementField::load($fieldId); if (!empty($field)) { if ($field->remove()) { if (!empty($this->fields)) { foreach ($this->fields as $key => $field) { if ($field->getId() == $fieldId) { $reArrangeFields = true; unset($this->fields[$key]); break; } } } } } } if ($reArrangeFields) { $this->fields = array_values($this->fields); } $db->syncTable($this->tableName); }