/**
* Method to get a list of options for a list input.
*
* @return array An array of JHtml options.
*
* @since 11.4
*/
protected function getOptions()
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
// Select the required fields from the table.
$query->select('c.id, c.country, c.country_jtext');
$query->from('`#__tj_country` AS c');
$query->where('c.com_quick2cart = 1');
$query->order($db->escape('c.ordering ASC'));
$db->setQuery($query);
// Get all countries.
$countries = $db->loadObjectList();
$options = array();
// Load lang file for countries
$lang = JFactory::getLanguage();
$lang->load('tjgeo.countries', JPATH_SITE, null, false, true);
foreach ($countries as $c) {
if ($lang->hasKey(strtoupper($c->country_jtext))) {
$c->country = JText::_($c->country_jtext);
}
$options[] = JHtml::_('select.option', $c->id, $c->country);
}
if (!$this->loadExternally) {
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
}
return $options;
}
/**
* Method to get the list of siblings in a menu.
* The method requires that parent be set.
*
* @return array The field option objects or false if the parent field has not been set
* @since 1.7
*/
protected function getOptions()
{
// Initialize variables.
$options = array();
// Get the parent
$parent_id = $this->form->getValue('parent_id', 0);
$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);
$query->where('a.client_id = 1');
$query->where('a.menutype = ' . $db->quote('admin'));
$query->order('a.lft ASC');
// Get the options.
$db->setQuery($query);
$options = $db->loadObjectList();
// Translate the items
for ($i = 0, $n = count($options); $i < $n; $i++) {
$options[$i]->text = JText::_($options[$i]->text);
}
// Check for a database error.
if ($db->getErrorNum()) {
JError::raiseWarning(500, $db->getErrorMsg());
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get the field options.
*
* @since 2.0
*
* @return array The field option objects.
*/
protected function getOptions()
{
$options = parent::getOptions();
if (!empty($options)) {
return $options;
}
// If no custom options were defined let's figure out which ones of the
// defaults we shall use...
$config = array('published' => 1, 'unpublished' => 1, 'archived' => 0, 'trash' => 0, 'all' => 0);
$stack = array();
// We are no longer using jgrid.publishedOptions as it's returning
// untranslated strings, unsuitable for our purposes.
if ($this->element['show_published'] == 'false') {
$stack[] = JHtml::_('select.option', '1', JText::_('JPUBLISHED'));
}
if ($this->element['show_unpublished'] == 'false') {
$stack[] = JHtml::_('select.option', '0', JText::_('JUNPUBLISHED'));
}
if ($this->element['show_archived'] == 'true') {
$stack[] = JHtml::_('select.option', '2', JText::_('JARCHIVED'));
}
if ($this->element['show_trash'] == 'true') {
$stack[] = JHtml::_('select.option', '-2', JText::_('JTRASHED'));
}
if ($this->element['show_all'] == 'true') {
$stack[] = JHtml::_('select.option', '*', JText::_('JALL'));
}
return $stack;
}
/**
* Method to get the custom field options.
* Use the query attribute to supply a query to generate the list.
*
* @return array The field option objects.
*
* @since 11.1
*/
protected function getOptions()
{
// Initialize variables.
$options = array();
// Initialize some field attributes.
$key = $this->element['key_field'] ? (string) $this->element['key_field'] : 'value';
$value = $this->element['value_field'] ? (string) $this->element['value_field'] : (string) $this->element['name'];
$translate = $this->element['translate'] ? (string) $this->element['translate'] : false;
$query = (string) $this->element['query'];
// Get the database object.
$db = JFactory::getDBO();
// Set the query and get the result list.
$db->setQuery($query);
$items = $db->loadObjectlist();
// Check for an error.
if ($db->getErrorNum()) {
JError::raiseWarning(500, $db->getErrorMsg());
return $options;
}
// Build the field options.
if (!empty($items)) {
foreach ($items as $item) {
if ($translate == true) {
$options[] = JHtml::_('select.option', $item->{$key}, JText::_($item->{$value}));
} else {
$options[] = JHtml::_('select.option', $item->{$key}, $item->{$value});
}
}
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}
public function getOptions()
{
# The options available are based on what type was selected
$options = array();
$type = $this->form->getField('entity_type')->value;
return array_merge(parent::getOptions(), JFormFieldParentEntity::getParents($type));
}
/**
* Method to get the field options for the list of installed editors.
*
* @return array The field option objects.
* @since 11.1
*/
protected function getOptions()
{
// Get the database object and a new query object.
$db = JFactory::getDBO();
$query = $db->getQuery(true);
// Build the query.
$query->select('element AS value, name AS text');
$query->from('#__extensions');
$query->where('folder = '.$db->quote('editors'));
$query->where('enabled = 1');
$query->order('ordering, name');
// Set the query and load the options.
$db->setQuery($query);
$options = $db->loadObjectList();
$lang = JFactory::getLanguage();
foreach ($options as $i=>$option) {
$lang->load('plg_editors_'.$option->value, JPATH_ADMINISTRATOR, null, false, false)
|| $lang->load('plg_editors_'.$option->value, JPATH_PLUGINS .'/editors/'.$option->value, null, false, false)
|| $lang->load('plg_editors_'.$option->value, JPATH_ADMINISTRATOR, $lang->getDefault(), false, false)
|| $lang->load('plg_editors_'.$option->value, JPATH_PLUGINS .'/editors/'.$option->value, $lang->getDefault(), false, false);
$options[$i]->text = JText::_($option->text);
}
// Check for a database error.
if ($db->getErrorNum()) {
JError::raiseWarning(500, $db->getErrorMsg());
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}
protected function getOptions()
{
$session = JFactory::getSession();
$attr = '';
// Initialize some field attributes.
$attr .= $this->element['class'] ? ' class="' . (string) $this->element['class'] . '"' : '';
// To avoid user's confusion, readonly="true" should imply disabled="true".
if ((string) $this->element['readonly'] == 'true' || (string) $this->element['disabled'] == 'true') {
$attr .= ' disabled="disabled"';
}
//
$attr .= $this->element['size'] ? ' size="' . (int) $this->element['size'] . '"' : '';
$attr .= $this->multiple ? ' multiple="multiple"' : '';
// Initialize JavaScript field attributes.
$attr .= $this->element['onchange'] ? ' onchange="' . (string) $this->element['onchange'] . '"' : '';
$db = JFactory::getDBO();
$db->setQuery("SELECT t.name AS name, t.id AS id FROM #__k2_tags AS t WHERE published = 1 ORDER BY t.name ASC");
$results = $db->loadObjectList();
$tags = array();
if (count($results)) {
foreach ($results as $tag) {
$tags[] = JHtml::_('select.option', $tag->id, $tag->name);
}
$tags = array_merge(parent::getOptions(), $tags);
return $tags;
} else {
$tags = array();
return $tags;
}
}
/**
* 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('a.id AS value, a.title AS text, a.level')->from('#__menu AS a')->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)->where('NOT(a.lft >= p.lft AND a.rgt <= p.rgt)');
}
$query->where('a.published != -2')->group('a.id, a.title, a.level, a.lft, a.rgt, a.menutype, a.parent_id, a.published')->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++) {
$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;
}
/**
* 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('a.id AS value, a.name AS text, a.level')->from('#__jdeveloper_forms AS a')->join('LEFT', $db->quoteName('#__jdeveloper_forms') . ' AS b ON a.lft > b.lft AND a.rgt < b.rgt')->where('a.parent_id > 0');
// Prevent parenting to children of this item.
if ($id = $this->form->getValue('id')) {
$query->join('LEFT', $db->quoteName('#__jdeveloper_forms') . ' AS p ON p.id = ' . (int) $id)->where('NOT(a.lft >= p.lft AND a.rgt <= p.rgt)');
}
$query->group('a.id, a.name, a.level, a.lft, a.rgt, a.parent_id');
$query->order('a.lft ASC');
// Get the options.
$db->setQuery($query);
try {
$root = new JObject(array("value" => 1, "text" => JText::_("JGLOBAL_ROOT_PARENT"), "level" => 0));
$options = array_merge(array($root), $db->loadObjectList());
} catch (RuntimeException $e) {
throw new Exception($e->getMessage());
}
// 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;
}
/**
* Method to get the options to populate list
*
* @return array The field option objects.
*
* @since 3.2
*/
protected function getOptions()
{
// Hash for caching
$hash = md5($this->element);
if (!isset(static::$options[$hash])) {
static::$options[$hash] = parent::getOptions();
$options = array();
$db = JFactory::getDbo();
$user = JFactory::getUser();
$query = $db->getQuery(true)->select('a.id AS value')->select('a.title AS text')->select('COUNT(DISTINCT b.id) AS level')->from('#__categories as a')->where('a.extension = "' . $this->extension . '"')->join('LEFT', '#__categories AS b ON a.lft > b.lft AND a.rgt < b.rgt')->group('a.id, a.title, a.lft, a.rgt')->order('a.lft ASC');
$isRoot = $user->authorise('core.admin');
if (!$isRoot) {
require_once JPATH_COMPONENT_ADMINISTRATOR . '/helpers/imc.php';
$allowed_catids = ImcHelper::getCategoriesByUserGroups();
$allowed_catids = implode(',', $allowed_catids);
if (!empty($allowed_catids)) {
$query->where('a.id IN (' . $allowed_catids . ')');
}
}
$db->setQuery($query);
if ($options = $db->loadObjectList()) {
foreach ($options as &$option) {
$option->text = str_repeat('- ', $option->level) . $option->text;
}
static::$options[$hash] = array_merge(static::$options[$hash], $options);
}
}
return static::$options[$hash];
}
function getOptions()
{
// Base name of the HTML control.
// $ctrl = $control_name .'['. $name .']';
$courses = JoomdleHelperContent::getCourseList(0);
// Construct an array of the HTML OPTION statements.
$options = array();
$c = array();
foreach ($courses as $course) {
$val = $course['remoteid'];
$text = $course['fullname'];
$options[] = JHtml::_('select.option', $val, $text);
// $op->id = $course['remoteid'];
// $op->text = $course['fullname'];
// $c[] = $op;
}
$options = array_merge(parent::getOptions(), $options);
return $options;
// Construct the various argument calls that are supported.
$attribs = ' ';
if ($v = $node->attributes('size')) {
$attribs .= 'size="' . $v . '"';
}
if ($v = $node->attributes('class')) {
$attribs .= 'class="' . $v . '"';
} else {
$attribs .= 'class="inputbox"';
}
if ($m = $node->attributes('multiple')) {
$attribs .= ' multiple="multiple"';
$ctrl .= '[]';
}
// Render the HTML SELECT list.
return JHTML::_('select.genericlist', $options, $ctrl, $attribs, 'value', 'text', $value, $control_name . $name);
}
/**
* Method to get the field options.
*
* @return array The field option objects.
*
* @since 11.1
*/
public function getOptions()
{
$options = array();
$db = JFactory::getDbo();
$query = $db->getQuery(true)->select('code As value, title As `text`, print_title')->from('#__sibdiet_countries')->order('title')->where('published = 1');
$db->setQuery($query);
try {
$options = $db->loadObjectList();
} catch (RuntimeException $e) {
JError::raiseWarning(500, $e->getMessage());
}
$lang_tag = JFactory::getLanguage()->get('tag');
foreach ($options as $option) {
// Convert the print_title field to an array.
$registry = new JRegistry();
$registry->loadString($option->print_title);
$print_title = $registry->toArray();
if (array_key_exists($lang_tag, $print_title)) {
$option->text = $print_title[$lang_tag];
}
}
// Sort Options
usort($options, function ($a, $b) {
return strcmp($a->text, $b->text);
});
return array_merge(parent::getOptions(), $options);
}
/**
* Method to get the field options.
*
* @return array The field option objects.
* @since 1.6
*/
protected function getOptions()
{
// Get the database object and a new query object.
$path = str_replace('administrator', '', JPATH_BASE);
$path = $path . 'components' . DS . 'com_awdwall' . DS . 'images' . DS;
$ldirs = listdirs($path);
//print_r($ldirs);
foreach ($ldirs as $ldir) {
$folders[] = str_replace($path . '/', '', $ldir);
}
$dir = str_replace('administrator', '', JPATH_BASE);
$dir = $dir . 'components' . DS . 'com_awdwall' . DS . 'css';
$needle = 'style_';
$length = strlen($needle);
$dh = opendir($dir);
while (false !== ($filename = readdir($dh))) {
if ($filename != "." && $filename != "..") {
if (substr($filename, 0, $length) === $needle) {
$order = '';
$newstr = '';
$order = array("style_", ".css");
$replace = '';
$newstr = str_replace($order, $replace, $filename);
if (in_array($newstr, $folders)) {
$files[] = $newstr;
$options[] = array('value' => $newstr, 'text' => $newstr);
}
}
}
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get the field options.
*
* @return array The field option objects.
*
* @since 11.1
*/
protected function getOptions()
{
// Initialize variables.
$options = array();
//echo 'this->element<br /><pre>~' . print_r($this->element,true) . '~</pre><br />';
$varname = (string) $this->element['varname'];
$vartable = (string) $this->element['targettable'];
$select_id = JRequest::getVar($varname);
if (is_array($select_id)) {
$select_id = $select_id[0];
}
if ($select_id) {
$db =& JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('t.id AS value, t.name AS text');
$query->from('#__joomleague_associations AS t');
$query->join('inner', '#__joomleague_' . $vartable . ' AS wt ON wt.country = t.country ');
$query->where('wt.id = ' . $select_id);
$query->order('t.name');
$db->setQuery($query);
$options = $db->loadObjectList();
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get a list of options for a list input.
*
* @return array An array of JHtml options.
*/
protected function getOptions()
{
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select($db->quoteName('car.id') . ', ' . $db->quoteName('car.name'));
$query->from($db->quoteName('#__agendadirigentes_cargos', 'car'));
if ($this->getAttribute('includecategory', false) == true) {
$query->select($db->quoteName('cat.title', 'category_name'));
$query->join('INNER', $db->quoteName('#__categories', 'cat') . ' ON ' . $db->quoteName('car.catid') . ' = ' . $db->quoteName('cat.id'));
$query->order($db->quoteName('cat.title') . 'ASC, ' . $db->quoteName('car.name') . ' ASC');
} else {
$query->order($db->quoteName('car.name') . ' ASC');
}
$db->setQuery((string) $query);
$cargos = $db->loadObjectList();
$options = array();
$options[] = JHtml::_('select.option', '', JText::_('COM_AGENDADIRIGENTES_SELECT_CARGO'));
if ($cargos) {
foreach ($cargos as $cargo) {
if ($this->getAttribute('includecategory', false)) {
$options[] = JHtml::_('select.option', $cargo->id, $cargo->category_name . ' - ' . $cargo->name);
} else {
$options[] = JHtml::_('select.option', $cargo->id, $cargo->name);
}
}
}
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get the list of siblings in a menu.
* The method requires that parent be set.
*
* @return array The field option objects or false if the parent field has not been set
* @since 1.7
*/
protected function getOptions()
{
$options = array();
// Get the parent
$parent_id = $this->form->getValue('parent_id', 0);
if (empty($parent_id) && $parent_id != 1) {
return false;
}
$db = JFactory::getDbo();
$query = $db->getQuery(true)->select('a.id AS value, a.title AS text')->from('#__mapfrance_areas AS a')->where('a.parent_id =' . (int) $parent_id);
if ($map = $this->form->getValue('map')) {
$query->where('a.map = ' . $db->quote($map));
} else {
$query->where('a.map != ' . $db->quote(''));
}
$query->order('a.lft ASC');
// Get the options.
$db->setQuery($query);
try {
$options = $db->loadObjectList();
} catch (RuntimeException $e) {
JError::raiseWarning(500, $e->getMessage());
}
$options = array_merge(array(array('value' => '-1', 'text' => JText::_('COM_MAPFRANCE_AREA_FIELD_ORDERING_VALUE_FIRST'))), $options, array(array('value' => '-2', 'text' => JText::_('COM_MAPFRANCE_AREA_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 options.
*
* @return array The field option objects.
*
* @since 11.1
*/
protected function getOptions()
{
// Initialize variables.
$options = array();
// Initialize some field attributes.
$filter = (string) $this->element['filter'];
$exclude = (string) $this->element['exclude'];
$hideNone = (string) $this->element['hide_none'];
$hideDefault = (string) $this->element['hide_default'];
// Get the path in which to search for file options.
$path = JPATH_ROOT . '/components/com_joomleague/extensions';
if (!is_dir($path)) {
$path = JPATH_ROOT . '/' . $path;
}
// Get a list of folders in the search path with the given filter.
$folders = JFolder::folders($path, $filter);
// Build the options list from the list of folders.
if (is_array($folders)) {
foreach ($folders as $folder) {
// Check to see if the file is in the exclude mask.
if ($exclude) {
if (preg_match(chr(1) . $exclude . chr(1), $folder)) {
continue;
}
}
$options[] = JHtml::_('select.option', $folder, $folder);
}
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get the field options.
*
* @return array The field option objects.
*
* @since 1.6
*/
protected function getOptions()
{
$app = JFactory::getApplication();
// Detect the native language.
$native = JLanguageHelper::detectLanguage();
if (empty($native)) {
$native = 'en-GB';
}
// Get a forced language if it exists.
$forced = $app->getLocalise();
if (!empty($forced['language'])) {
$native = $forced['language'];
}
// If a language is already set in the session, use this instead
$model = new InstallationModelSetup();
$options = $model->getOptions();
if (isset($options['language'])) {
$native = $options['language'];
}
// Get the list of available languages.
$options = JLanguageHelper::createLanguageList($native);
if (!$options || $options instanceof Exception) {
$options = array();
} else {
usort($options, array($this, '_sortLanguages'));
}
// Set the default value from the native language.
$this->value = $native;
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get a list of options for a list input.
*
* @return array An array of JHtml options.
*/
protected function getOptions()
{
$current_category_id = JRequest::getInt('id', '0');
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('`id`, `categoryname`, `parentid`');
$query->from('#__youtubegallery_categories');
$db->setQuery((string) $query);
$messages = $db->loadObjectList();
if (!$db->query()) {
die($db->stderr());
}
$options = array();
$options[] = JHtml::_('select.option', 0, JText::_('COM_YOUTUBEGALLERY_SELECT_CATEGORYROOT'));
$children = $this->getAllChildren($current_category_id);
if ($messages) {
foreach ($messages as $message) {
if ($current_category_id == 0) {
$options[] = JHtml::_('select.option', $message->id, $message->categoryname);
} else {
if ($message->id != $current_category_id and $message->parentid != $current_category_id and !in_array($message->id, $children)) {
$options[] = JHtml::_('select.option', $message->id, $message->categoryname);
}
}
}
}
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get a list of options for a list input.
*
* @return array An array of JHtml options.
*/
protected function getOptions()
{
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('#__helloworld.id as id,greeting,#__categories.title as category,catid');
$query->from('#__helloworld');
$query->leftJoin('#__categories on catid=#__categories.id');
// Retrieve only published items
$query->where('#__helloworld.published = 1');
$db->setQuery((string) $query);
$messages = $db->loadObjectList();
$options = array();
if ($messages)
{
foreach ($messages as $message)
{
$options[] = JHtml::_('select.option', $message->id, $message->greeting .
($message->catid ? ' (' . $message->category . ')' : ''));
}
}
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get the list of siblings in a menu.
* The method requires that parent be set.
*
* @return array The field option objects or false if the parent field has not been set
* @since 1.7
*/
protected function getOptions()
{
// Initialize variables.
$options = array();
// Get the parent
$parent_id = $this->form->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;
}
protected function getOptions()
{
$options = array();
if (!class_exists('tsmartModelVendor')) {
require VMPATH_ADMIN . DS . 'models' . DS . 'vendor.php';
}
$vendor_id = tsmartModelVendor::getLoggedVendor();
// set currency_id to logged vendor
if (empty($this->value)) {
$currency = tsmartModelVendor::getVendorCurrency($vendor_id);
$this->value = $currency->tsmart_currency_id;
}
// why not logged vendor? shared is missing
$db = JFactory::getDBO();
$query = 'SELECT `tsmart_currency_id` AS value, `currency_name` AS text
FROM `#__tsmart_currencies`
WHERE `tsmart_vendor_id` = "1" AND `published` = "1" ORDER BY `currency_name` ASC ';
// default value should be vendor currency
$db->setQuery($query);
$values = $db->loadObjectList();
foreach ($values as $v) {
$options[] = JHtml::_('select.option', $v->value, $v->text);
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get the field options.
*
* @return array The field option objects.
*
* @since 11.1
*/
protected function getOptions()
{
// Initialize some field attributes.
$client = (string) $this->element['client'];
if ($client != 'site' && $client != 'administrator') {
$client = 'site';
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), JLanguageHelper::createLanguageList($this->value, constant('JPATH_' . strtoupper($client)), true, true));
// Set the default value active language
if ($langParams = JComponentHelper::getParams('com_languages')) {
switch ((string) $this->value) {
case 'site':
case 'frontend':
case '0':
$this->value = $langParams->get('site', 'en-GB');
break;
case 'admin':
case 'administrator':
case 'backend':
case '1':
$this->value = $langParams->get('administrator', 'en-GB');
break;
case 'active':
case 'auto':
$lang = JFactory::getLanguage();
$this->value = $lang->getTag();
break;
default:
break;
}
}
return $options;
}
/**
* Method to get a list of content types
*
* @return array The field option objects.
*
* @since 3.1
*/
protected function getOptions()
{
$lang = JFactory::getLanguage();
$db = JFactory::getDbo();
$query = $db->getQuery(true)->select('a.type_id AS value, a.type_title AS text, a.type_alias AS alias')->from('#__content_types AS a')->order('a.type_title ASC');
// Get the options.
$db->setQuery($query);
try {
$options = $db->loadObjectList();
} catch (RuntimeException $e) {
return false;
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
foreach ($options as $option) {
// Make up the string from the component sys.ini file
$parts = explode('.', $option->alias);
$comp = array_shift($parts);
// Make sure the component sys.ini is loaded
$lang->load($comp . '.sys', JPATH_ADMINISTRATOR, null, false, true) || $lang->load($comp . '.sys', JPATH_ADMINISTRATOR . '/components/' . $comp, null, false, true);
$option->string = implode('_', $parts);
$option->string = $comp . '_CONTENT_TYPE_' . $option->string;
if ($lang->hasKey($option->string)) {
$option->text = JText::_($option->string);
}
}
return $options;
}
/**
* Method to get the field options.
*
* @return array The field option objects.
*
* @since 1.6
*/
public function getOptions()
{
$app = JFactory::getApplication();
$clientId = $app->getUserStateFromRequest('com_templates.styles.filter.client_id', 'filter_client_id', null);
$options = TemplatesHelper::getTemplateOptions($clientId);
return array_merge(parent::getOptions(), $options);
}
/**
* Method to get the field options.
*
* @return array The field option objects.
*
* @since 11.1
*/
protected function getOptions()
{
// Initialize variables.
$options = array();
// Initialize some field attributes.
$first = (int) $this->element['first'];
$last = (int) $this->element['last'];
$step = (int) $this->element['step'];
// Sanity checks.
if ($step == 0) {
// Step of 0 will create an endless loop.
return $options;
} elseif ($first < $last && $step < 0) {
// A negative step will never reach the last number.
return $options;
} elseif ($first > $last && $step > 0) {
// A position step will never reach the last number.
return $options;
}
// Build the options array.
for ($i = $first; $i <= $last; $i += $step) {
$options[] = JHtml::_('select.option', $i);
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}
protected function getOptions()
{
$options = array();
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query = '
SELECT
ct.id AS id,
c.locale_key AS container_name,
ct.liters AS liters
FROM #__reomi_container_types AS ct
INNER JOIN #__reomi_containers AS c ON ct.container_id = c.id
ORDER BY
c.name ASC,
ct.liters ASC
';
$db->setQuery($query);
$containers = $db->loadObjectList();
$options = array();
if ($containers) {
foreach ($containers as $item) {
$options[] = JHtml::_('select.option', $item->id, JText::_($item->container_name) . " " . $item->liters . "L");
}
}
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get the field options.
*
* @return array The field option objects.
*
* @since 11.1
*/
protected function getOptions()
{
$options = array();
$options[] = JHtml::_('select.option', 'id', JText::_('COM_VISFORMS_ID'), 'value', 'text', false);
$options[] = JHtml::_('select.option', 'created', JText::_('COM_VISFORMS_SUBMISSIONDATE'), 'value', 'text', false);
$options[] = JHtml::_('select.option', 'ismfd', JText::_('COM_VISFORMS_MODIFIED'), 'value', 'text', false);
$id = 0;
//extract form id
$form = $this->form;
$link = $form->getValue('link');
if (isset($link) && $link != "") {
$parts = array();
parse_str($link, $parts);
if (isset($parts['id']) && is_numeric($parts['id'])) {
$id = $parts['id'];
}
}
// Create options according to visfield settings
$db = JFactory::getDbo();
$query = ' SELECT c.id , c.label from #__visfields as c where c.fid=' . $id . ' AND c.published = 1 AND (c.frontdisplay is null or c.frontdisplay = 1 or c.frontdisplay = 2) ' . "and !(c.typefield = 'reset') and !(c.typefield = 'submit') and !(c.typefield = 'image') and !(c.typefield = 'fieldsep') and !(c.typefield = 'hidden')";
$db->setQuery($query);
$fields = $db->loadObjectList();
if ($fields) {
foreach ($fields as $field) {
$tmp = JHtml::_('select.option', $field->id, $field->label, 'value', 'text', false);
// Add the option object to the result set.
$options[] = $tmp;
}
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get the field options.
*
* @return array The field option objects.
* @since 1.6
*/
protected function getOptions()
{
$options = array();
$db = JFactory::getDbo();
$user = JFactory::getUser();
$query = $db->getQuery(true)->select('a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level')->from('#__users_groups AS a')->join('LEFT', $db->quoteName('#__users_groups') . ' AS b ON a.lft > b.lft AND a.rgt < b.rgt');
// Prevent parenting to children of this item.
if ($id = $this->form->getValue('id')) {
$query->join('LEFT', $db->quoteName('#__users_groups') . ' AS p ON p.id = ' . (int) $id)->where('NOT(a.lft >= p.lft AND a.rgt <= p.rgt)');
}
$query->group('a.id, a.title, a.lft, a.rgt')->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++) {
// Show groups only if user is super admin or group is not super admin
if ($user->authorise('core.admin') || !JAccess::checkGroup($options[$i]->value, 'core.admin')) {
$options[$i]->text = str_repeat('- ', $options[$i]->level) . $options[$i]->text;
} else {
unset($options[$i]);
}
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}
/**
* Method to get a list of options for a list input.
*
* @return array An array of JHtml options.
*
* @since 11.4
*/
protected function getOptions()
{
// Initialise variables
$folder = $this->element['folder'];
if (!empty($folder)) {
// Get list of plugins
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('element AS value, name AS text');
$query->from('#__extensions');
$query->where('folder = ' . $db->q($folder));
$query->where('enabled = 1');
$query->order('ordering, name');
$db->setQuery($query);
$options = $db->loadObjectList();
$lang = JFactory::getLanguage();
foreach ($options as $i => $item) {
$source = JPATH_PLUGINS . '/' . $folder . '/' . $item->value;
$extension = 'plg_' . $folder . '_' . $item->value;
$lang->load($extension . '.sys', JPATH_ADMINISTRATOR, null, false, false) || $lang->load($extension . '.sys', $source, null, false, false) || $lang->load($extension . '.sys', JPATH_ADMINISTRATOR, $lang->getDefault(), false, false) || $lang->load($extension . '.sys', $source, $lang->getDefault(), false, false);
$options[$i]->text = JText::_($item->text);
}
if ($db->getErrorMsg()) {
JError::raiseWarning(500, JText::_('JFRAMEWORK_FORM_FIELDS_PLUGINS_ERROR_FOLDER_EMPTY'));
return '';
}
} else {
JError::raiseWarning(500, JText::_('JFRAMEWORK_FORM_FIELDS_PLUGINS_ERROR_FOLDER_EMPTY'));
}
// Merge any additional options in the XML definition.
$options = array_merge(parent::getOptions(), $options);
return $options;
}