<?php /** * @package Joomla.Administrator * @subpackage com_menus * * @copyright Copyright (C) 2005 - 2019 Open Source Matters, Inc. All rights reserved. * @license GNU General Public License version 2 or later; see LICENSE.txt */ defined('JPATH_BASE') or die; JFormHelper::loadFieldClass('list'); /** * Menu Parent field. * * @since 1.6 */ class JFormFieldMenuParent extends JFormFieldList { /** * The form field type. * * @var string * @since 1.6 */ protected $type = 'MenuParent'; /** * Method to get the field options. * * @return array The field option objects. * * @since 1.6 */ protected function getOptions() { $options = array(); $db = JFactory::getDbo(); $query = $db->getQuery(true) ->select('DISTINCT(a.id) AS value, a.title AS text, a.level, a.lft') ->from('#__menu AS a'); // Filter by menu type. if ($menuType = $this->form->getValue('menutype')) { $query->where('a.menutype = ' . $db->quote($menuType)); } else { // Skip special menu types $query->where('a.menutype != ' . $db->quote('')); $query->where('a.menutype != ' . $db->quote('main')); } // Filter by client id. $clientId = $this->getAttribute('clientid'); if (!is_null($clientId)) { $query->where($db->quoteName('a.client_id') . ' = ' . (int) $clientId); } // Prevent parenting to children of this item. if ($id = $this->form->getValue('id')) { $query->join('LEFT', $db->quoteName('#__menu') . ' AS p ON p.id = ' . (int) $id) ->where('NOT(a.lft >= p.lft AND a.rgt <= p.rgt)'); } $query->where('a.published != -2') ->order('a.lft ASC'); // Get the options. $db->setQuery($query); try { $options = $db->loadObjectList(); } catch (RuntimeException $e) { JError::raiseWarning(500, $e->getMessage()); } // Pad the option text with spaces using depth level as a multiplier. for ($i = 0, $n = count($options); $i < $n; $i++) { if ($clientId != 0) { // Allow translation of custom admin menus $options[$i]->text = str_repeat('- ', $options[$i]->level) . JText::_($options[$i]->text); } else { $options[$i]->text = str_repeat('- ', $options[$i]->level) . $options[$i]->text; } } // Merge any additional options in the XML definition. $options = array_merge(parent::getOptions(), $options); return $options; } }