[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3  * @version        $Id:sql.php 6961 2007-03-15 16:06:53Z tcp $
   4  * @package        Joomla.Framework
   5  * @subpackage    Parameter
   6  * @copyright    Copyright (C) 2005 - 2010 Open Source Matters. All rights reserved.
   7  * @license        GNU/GPL, see LICENSE.php
   8  * Joomla! is free software. This version may have been modified pursuant
   9  * to the GNU General Public License, and as distributed it includes or
  10  * is derivative of works licensed under the GNU General Public License or
  11  * other free or open source software licenses.
  12  * See COPYRIGHT.php for copyright notices and details.
  13  */
  14  
  15  // Check to ensure this file is within the rest of the framework
  16  defined('JPATH_BASE') or die();
  17  
  18  /**
  19   * Renders a SQL element
  20   *
  21   * @package     Joomla.Framework
  22   * @subpackage        Parameter
  23   * @since        1.5
  24   */
  25  
  26  class JElementSQL extends JElement
  27  {
  28      /**
  29      * Element name
  30      *
  31      * @access    protected
  32      * @var        string
  33      */
  34      var    $_name = 'SQL';
  35  
  36  	function fetchElement($name, $value, &$node, $control_name)
  37      {
  38          $db            = & JFactory::getDBO();
  39          $db->setQuery($node->attributes('query'));
  40          $key = ($node->attributes('key_field') ? $node->attributes('key_field') : 'value');
  41          $val = ($node->attributes('value_field') ? $node->attributes('value_field') : $name);
  42          return JHTML::_('select.genericlist',  $db->loadObjectList(), ''.$control_name.'['.$name.']', 'class="inputbox"', $key, $val, $value, $control_name.$name);
  43      }
  44  }