Directory:~$ /home/lmsyaran/public_html/administrator/components/com_rsticketspro/models/fields/

Upload File

[Home] [System Details] [Kill Me]

<?php
/**
 * @package    RSTickets! Pro
 *
 * @copyright  (c) 2010 - 2016 RSJoomla!
 * @link       https://www.rsjoomla.com
 * @license    GNU General Public License
http://www.gnu.org/licenses/gpl-3.0.en.html
 */

// No direct access.
defined('_JEXEC') or die('Restricted access');

/**
 * Supports a nested check box field listing user groups.
 *
 */
class JFormFieldRSUsergroup extends JFormField
{
    /**
     * The form field type.
     *
     * @var string
     *
     * @access protected
     */
    protected $type = 'rsusergroup';

    /**
     * Method to get the user group field input markup.
     *
     * @access protected
     *
     * @return string The field input markup.
     */
    protected function getInput()
    {
        $options = array();
        $attr = '';

        // Initialize some field attributes.
        $attr .= empty($this->class) ? '' : '
class="' . $this->class . '"';
        $attr .= $this->disabled ? ' disabled' :
'';
        $attr .= $this->size ? ' size="' . $this->size
. '"' : '';
        $attr .= $this->multiple ? ' multiple' :
'';
        $attr .= $this->required ? ' required
aria-required="true"' : '';
        $attr .= $this->autofocus ? ' autofocus' :
'';

        // Initialize JavaScript field attributes.
        $attr .= empty($this->onchange) ? '' : '
onchange="' . $this->onchange . '"';
        $attr .= empty($this->onclick) ? '' : '
onclick="' . $this->onclick . '"';

        // Iterate through the children and build an array of options.
        foreach ($this->element->children() as $option)
        {
            // Only add <option /> elements.
            if ($option->getName() != 'option')
                continue;

            $disabled = (string)$option['disabled'];
            $disabled = $disabled == 'true' || $disabled ==
'disabled' || $disabled == '1';

            // Create a new option object based on the <option />
element.
            $tmp = JHtml::_( 'select.option',
(string)$option['value'], trim( (string)$option ),
'value', 'text', $disabled );

            // Set some option attributes.
            $tmp->class = (string)$option['class'];

            // Set some JavaScript option attributes.
            $tmp->onclick = (string)$option['onclick'];

            // Add the option object to the result set.
            $options[] = $tmp;
        }

        $db = JFactory::getDbo();

        $query = $db->getQuery(true)
            ->select( array( $db->qn('a.id',
'value'), $db->qn('a.title', 'text'),
'COUNT(DISTINCT ' . $db->qn('b.id') . ') AS
' . $db->qn('level') ) )
            ->from( $db->qn('#__usergroups', 'a')
)
            ->leftJoin( $db->qn('#__usergroups',
'b') . ' ON ' . $db->qn('a.lft') . '
> ' . $db->qn('b.lft') . ' AND ' .
$db->qn('a.rgt') . ' < ' .
$db->qn('b.rgt') )
            ->group( $db->qn( array('a.id',
'a.title', 'a.lft', 'a.rgt') ) )
            ->order( $db->qn('a.lft') . ' ASC'
);

        $db->setQuery($query);

        if ( $jgroups = $db->loadObjectList() )
        {
            $query = $db->getQuery(true)
                ->select( $db->qn('jgroup_id') )
                ->from(
$db->qn('#__rsticketspro_departments_relations') );

            // Get the selected ones if the id is set
            $id =
JFactory::getApplication()->input->getInt('id', 0);
            $query->where( $db->qn('department_id') .
' = ' . $db->q($id) );


            $db->setQuery($query);
            $jgroups_ids = $db->loadColumn();

            foreach ($jgroups as $jgroup)
            {
                $text = str_repeat('- ', $jgroup->level) .
$jgroup->text;
                $options[] = JHtml::_('select.option',
$jgroup->value, $text);
            }
        }

        return JHtml::_( 'select.genericlist', $options,
$this->name, array('list.attr' => $attr,
'list.select' => $jgroups_ids, 'id' =>
$this->id) );
    }
}