AAAAhome/academiac/www/administrator/components/com_menus/models/fields/menuparent.php000064400000004105151457562330024674 0ustar00getQuery(true); $query->select('a.id AS value, a.title AS text, a.level'); $query->from('#__menu AS a'); $query->join('LEFT', $db->quoteName('#__menu').' AS b ON a.lft > b.lft AND a.rgt < b.rgt'); if ($menuType = $this->form->getValue('menutype')) { $query->where('a.menutype = '.$db->quote($menuType)); } else { $query->where('a.menutype != '.$db->quote('')); } // 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); $query->where('NOT(a.lft >= p.lft AND a.rgt <= p.rgt)'); } $query->where('a.published != -2'); $query->group('a.id, a.title, a.level, a.lft, a.rgt, a.menutype, a.parent_id, a.published'); $query->order('a.lft ASC'); // Get the options. $db->setQuery($query); $options = $db->loadObjectList(); // Check for a database error. if ($db->getErrorNum()) { JError::raiseWarning(500, $db->getErrorMsg()); } // Pad the option text with spaces using depth level as a multiplier. for ($i = 0, $n = count($options); $i < $n; $i++) { $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; } }