/joomla/administrator/components/com_finder/models/fields/contentmap.php
https://gitlab.com/ricardosanchez/prueba · PHP · 123 lines · 73 code · 18 blank · 32 comment · 5 complexity · 0efc9efd6b36c6ef2f9fef1cbffb628b MD5 · raw file
- <?php
- /**
- * @package Joomla.Administrator
- * @subpackage com_finder
- *
- * @copyright Copyright (C) 2005 - 2016 Open Source Matters, Inc. All rights reserved.
- * @license GNU General Public License version 2 or later; see LICENSE
- */
- defined('JPATH_PLATFORM') or die;
- JFormHelper::loadFieldClass('groupedlist');
- JLoader::register('FinderHelperLanguage', JPATH_ADMINISTRATOR . '/components/com_finder/helpers/language.php');
- /**
- * Form Field class for the Joomla CMS.
- * Supports a select grouped list of finder content map.
- *
- * @since 3.6.0
- */
- class JFormFieldContentMap extends JFormFieldGroupedList
- {
- /**
- * The form field type.
- *
- * @var string
- * @since 3.6.0
- */
- public $type = 'ContentMap';
- /**
- * Method to get the list of content map options grouped by first level.
- *
- * @return array The field option objects as a nested array in groups.
- *
- * @since 3.6.0
- */
- protected function getGroups()
- {
- $groups = array();
- // Get the database object and a new query object.
- $db = JFactory::getDbo();
- // Levels subquery.
- $levelQuery = $db->getQuery(true);
- $levelQuery->select('title AS branch_title, 1 as level')
- ->select($db->quoteName('id'))
- ->from($db->quoteName('#__finder_taxonomy'))
- ->where($db->quoteName('parent_id') . ' = 1');
- $levelQuery2 = $db->getQuery(true);
- $levelQuery2->select('b.title AS branch_title, 2 as level')
- ->select($db->quoteName('a.id'))
- ->from($db->quoteName('#__finder_taxonomy', 'a'))
- ->join('LEFT', $db->quoteName('#__finder_taxonomy', 'b') . ' ON ' . $db->qn('a.parent_id') . ' = ' . $db->qn('b.id'))
- ->where($db->quoteName('a.parent_id') . ' NOT IN (0, 1)');
- $levelQuery->union($levelQuery2);
- // Main query.
- $query = $db->getQuery(true)
- ->select($db->quoteName('a.title', 'text'))
- ->select($db->quoteName('a.id', 'value'))
- ->select($db->quoteName('d.level'))
- ->from($db->quoteName('#__finder_taxonomy', 'a'))
- ->join('LEFT', '(' . $levelQuery . ') AS d ON ' . $db->qn('d.id') . ' = ' . $db->qn('a.id'))
- ->where($db->quoteName('a.parent_id') . ' <> 0')
- ->order('d.branch_title ASC, d.level ASC, a.title ASC');
- $db->setQuery($query);
- try
- {
- $contentMap = $db->loadObjectList();
- }
- catch (RuntimeException $e)
- {
- return;
- }
- // Build the grouped list array.
- if ($contentMap)
- {
- $lang = JFactory::getLanguage();
- foreach ($contentMap as $branch)
- {
- if ((int) $branch->level === 1)
- {
- $name = $branch->text;
- }
- else
- {
- $levelPrefix = str_repeat('- ', max(0, $branch->level - 1));
- if (trim($name, '**') == 'Language')
- {
- $text = FinderHelperLanguage::branchLanguageTitle($branch->text);
- }
- else
- {
- $key = FinderHelperLanguage::branchSingular($branch->text);
- $text = $lang->hasKey($key) ? JText::_($key) : $branch->text;
- }
- // Initialize the group if necessary.
- if (!isset($groups[$name]))
- {
- $groups[$name] = array();
- }
- $groups[$name][] = JHtml::_('select.option', $branch->value, $levelPrefix . $text);
- }
- }
- }
- // Merge any additional groups in the XML definition.
- $groups = array_merge(parent::getGroups(), $groups);
- return $groups;
- }
- }