AAAAhome/academiac/www/administrator/components/com_menus/models/fields/menuordering.php000064400000004435151457712160025220 0ustar00form->getValue('parent_id', 0); if ( empty($parent_id)) { return false; } $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('a.id AS value, a.title AS text'); $query->from('#__menu AS a'); $query->where('a.published >= 0'); $query->where('a.parent_id =' . (int) $parent_id); if ($menuType = $this->form->getValue('menutype')) { $query->where('a.menutype = '.$db->quote($menuType)); } else { $query->where('a.menutype != '.$db->quote('')); } $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()); } $options = array_merge( array(array ('value' =>'-1', 'text'=>JText::_('COM_MENUS_ITEM_FIELD_ORDERING_VALUE_FIRST'))), $options, array(array( 'value' =>'-2', 'text'=>JText::_('COM_MENUS_ITEM_FIELD_ORDERING_VALUE_LAST'))) ); // Merge any additional options in the XML definition. $options = array_merge(parent::getOptions(), $options); return $options; } /** * Method to get the field input markup * * @return string The field input markup. * @since 1.7 */ protected function getInput() { if ($this->form->getValue('id', 0) == 0) { return '' . JText::_('COM_MENUS_ITEM_FIELD_ORDERING_TEXT') . ''; } else { return parent::getInput(); } } }