| @@ -1,0 +1,50 @@ | ||
| 1 | +<?php | |
| 2 | +/** | |
| 3 | + * @package VikWP - Libraries | |
| 4 | + * @subpackage adapter.form | |
| 5 | + * @author E4J s.r.l. | |
| 6 | + * @copyright Copyright (C) 2023 E4J s.r.l. All Rights Reserved. | |
| 7 | + * @license http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL | |
| 8 | + * @link https://vikwp.com | |
| 9 | + */ | |
| 10 | + | |
| 11 | +// No direct access | |
| 12 | +defined('ABSPATH') or die('No script kiddies please!'); | |
| 13 | + | |
| 14 | +JLoader::import('adapter.form.fields.list'); | |
| 15 | + | |
| 16 | +/** | |
| 17 | + * Form field class to handle dropdown fields containing | |
| 18 | + * the values obtained by a SQL command. | |
| 19 | + * | |
| 20 | + * @since 10.0 | |
| 21 | + */ | |
| 22 | +class JFormFieldSql extends JFormFieldList | |
| 23 | +{ | |
| 24 | + /** | |
| 25 | + * @override | |
| 26 | + * Method to get the data to be passed to the layout for rendering. | |
| 27 | + * | |
| 28 | + * @return array An associative array of display data. | |
| 29 | + */ | |
| 30 | + public function getLayoutData() | |
| 31 | + { | |
| 32 | + $key = $this->key_field ? $this->key_field : 'id'; | |
| 33 | + $val = $this->value_field ? $this->value_field : 'value'; | |
| 34 | + | |
| 35 | + $dbo = JFactory::getDbo(); | |
| 36 | + | |
| 37 | + $dbo->setQuery($this->query); | |
| 38 | + $dbo->execute(); | |
| 39 | + | |
| 40 | + if ($dbo->getNumRows()) | |
| 41 | + { | |
| 42 | + foreach ($dbo->loadObjectlist() as $obj) | |
| 43 | + { | |
| 44 | + $this->option[$obj->{$key}] = $obj->{$val}; | |
| 45 | + } | |
| 46 | + } | |
| 47 | + | |
| 48 | + return parent::getLayoutData(); | |
| 49 | + } | |
| 50 | +} | |
