* @git Joomla Component Builder * @copyright Copyright (C) 2015 Vast Development Method. All rights reserved. * @license GNU General Public License version 2 or later; see LICENSE.txt */ // No direct access to this file defined('_JEXEC') or die('Restricted access'); use Joomla\CMS\Factory; use Joomla\CMS\Language\Text; use Joomla\CMS\HTML\HTMLHelper as Html; // import the list field type jimport('joomla.form.helper'); JFormHelper::loadFieldClass('list'); /** * Dynamicgetsfiltergettype Form Field class for the Componentbuilder component */ class JFormFieldDynamicgetsfiltergettype extends JFormFieldList { /** * The dynamicgetsfiltergettype field type. * * @var string */ public $type = 'dynamicgetsfiltergettype'; /** * Method to get a list of options for a list input. * * @return array An array of Html options. */ protected function getOptions() { // Get a db connection. $db = Factory::getDbo(); // Create a new query object. $query = $db->getQuery(true); // Select the text. $query->select($db->quoteName('gettype')); $query->from($db->quoteName('#__componentbuilder_dynamic_get')); $query->order($db->quoteName('gettype') . ' ASC'); // Reset the query using our newly populated query object. $db->setQuery($query); $_results = $db->loadColumn(); $_filter = []; $_filter[] = Html::_('select.option', '', '- ' . Text::_('COM_COMPONENTBUILDER_FILTER_SELECT_GETTYPE') . ' -'); if ($_results) { // get dynamic_getsmodel $_model = ComponentbuilderHelper::getModel('dynamic_gets'); $_results = array_unique($_results); foreach ($_results as $gettype) { // Translate the gettype selection $_text = $_model->selectionTranslation($gettype,'gettype'); // Now add the gettype and its text to the options array $_filter[] = Html::_('select.option', $gettype, Text::_($_text)); } } return $_filter; } }