Связать два списка в админке - страница 2 - Разработка расширений для Joomla

     <div class="control-group">
          <div class="control-label "><?php echo $this->form->getLabel('pname'); ?></div>
          <div class="controls"><?php echo $this->form->getInput('pname'); ?></div>
        </div>
        <div class="control-group">
          <div class="control-label"></div>
          <div class="controls own"><?php echo $this->form->getInput('own'); ?></div>
        </div>

 public function getListSites()
  {
      $options = array();
    $id = filter_input(INPUT_GET, 'p', FILTER_VALIDATE_INT);
    $valg = $_GET["sel"];
    
    $result = JFactory::getDbo()->setQuery('select `id`, `own` from `#__n_man` where `id_country`='.(int)$id)->loadObjectList();
    foreach ($result as $item)
      $options[] = JHTML::_('select.option', $item->id, $item->own);
    echo JHtml::_('select.genericlist', $options, 'jform['.$valg.']', '' );
    exit;
  }

            	   
             <div class="control-group">
          <div class="control-label "><label id="jform_pname-lbl" for="jform_pname" class="required">
	OWn<span class="star"> *</span></label></div>
          <div class="controls pname>"><select id="jform_pname" name="jform[pname]" class="required" size="45" required aria-required="true">
	<option value="1">Англия</option>
	<option value="2">Франция</option>
	<option value="3">Германия</option>
	<option value="5">Италия</option>
	<option value="6">Голландия</option>
	<option value="7">Япония</option>
	<option value="8">Китай</option>
	<option value="9">Австрия</option>
......

</select>
</div>
        </div>
   
             <div class="control-group">
          <div class="control-label "><label id="jform_own-lbl" for="jform_own" class="required">
	<span class="star"> *</span></label></div>
          <div class="controls own>"><select id="jform_own" name="jform[own]" class="required" size="45" required aria-required="true">
	<option value="0">Выбор</option>

</select>
</div>
        </div>

<select id="jformown" name="jform[own]" class="chzn-done" style="display: none;">
	<option value="1">Ас2</option>
	<option value="2">Ас3</option>
	<option value="9">Ас4</option>
	<option value="11">Ас5</option>
</select>
<div class="chzn-container chzn-container-single chzn-container-active chzn-with-drop" style="width: 220px;" title="" id="jformown_chzn">
	<a class="chzn-single" tabindex="-1">
		<span>Ас3</span>
		<div><b></b></div>
	</a>
<div class="chzn-drop"><div class="chzn-search">
	<input type="text" autocomplete="off">
</div>

<ul class="chzn-results">
<li class="active-result result-selected highlighted" style="" data-option-array-index="0">Ас2</li>
<li class="active-result result-selected" style="" data-option-array-index="1">Ас3</li>
<li class="active-result" style="" data-option-array-index="2">Ас4</li>
<li class="active-result" style="" data-option-array-index="3">Ас5</li>
</ul>
</div></div>

    <field name="partname" type="rqpartner" label="COM_CRMT_PARTNER_NAME" readonly="true" addfieldpath="/administrator/components/com_mycomponent/models/fields" >
      <option value="0">COM_CRMT_PARTNER_NAME_NOTHING</option>
    </field>
    <field name="partsite" type="rqsite" label="COM_CRMT_SITE_NAME" readonly="true" addfieldpath="/administrator/components/com_mycomponent/models/fields" >
      <option value="0">COM_CRMT_SITE_NAME_NOTHING</option>
    </field>

JFormHelper::loadFieldClass('list');

class JFormFieldRqpartner extends JFormFieldList
{
  public $type = 'rqpartner';
  protected static $options = array();

  protected function getOptions()
  {
    $hash = md5($this->element);

    if (!isset(static::$options[$hash])) {
      static::$options[$hash] = parent::getOptions();
      $options = array();
      $db = JFactory::getDbo();
      $query = $db->getQuery(true)
        ->select('p.id AS value, u.name AS text')
        ->from('#__crmt_partners AS p, #__users as u')
        ->where('u.id = p.joomid')
        ->order('u.name');
      $db->setQuery($query);
      if ($options = $db->loadObjectList())
        static::$options[$hash] = array_merge(static::$options[$hash], $options);
    }
    return static::$options[$hash];
  }
}

JFormHelper::loadFieldClass('list');

class JFormFieldRqsite extends JFormFieldList
{
  public $type = 'rqsite';
  protected static $options = array();

  protected function getOptions()
  {
    $hash = md5($this->element);

    if (!isset(static::$options[$hash])) {
      static::$options[$hash] = parent::getOptions();
      $options = array();
      $db = JFactory::getDbo();
      $query = $db->getQuery(true)
        ->select('s.id AS value, s.s_url AS text')
        ->from('#__crmt_sites AS s')
        ->where('s.published=1')
        ->order('s.s_url');
      $db->setQuery($query);
      if ($options = $db->loadObjectList())
        static::$options[$hash] = array_merge(static::$options[$hash], $options);
    }
    return static::$options[$hash];
  }
}

<?php defined('_JEXEC') or die;

JHtml::_('bootstrap.tooltip');
JHtml::_('behavior.formvalidation');
JHtml::_('formbehavior.chosen', 'select');
$input = JFactory::getApplication()->input;
?>
<script type="text/javascript">
  Joomla.submitbutton = function (task) {
    if (task == 'request.cancel' || document.formvalidator.isValid(document.id('item-form'))) {
      Joomla.submitform(task, document.getElementById('item-form'));
    } else {
      alert('<?php echo $this->escape(JText::_('JGLOBAL_VALIDATION_FORM_FAILED')); ?>');
    }
  }
  jQuery(document).ready(function (cash) {
    $('#jform_partname').on('change', function () {
      $.get('index.php', {option:'com_mycomponent', task:'getListSites', partner:$(this).val()}, function (response) {
        response && $('.partsite').html(response);
        $('select').chosen();
      });
    });
  })
</script>
<form action="<?php echo JRoute::_('index.php?option=com_mycomponent&layout=edit&id=' . $this->form->getValue('id')); ?>" method="post" name="adminForm" id="item-form" class="form-validate" enctype="multipart/form-data">
  
  <div class="form-horizontal">
    <div class="row-fluid form-horizontal-desktop">
      <div class="span6">
        <div class="control-group">
          <div class="control-label"><?php echo $this->form->getLabel('partname'); ?></div>
          <div class="controls"><?php echo $this->form->getInput('partname'); ?></div>
        </div>
        <div class="control-group">
          <div class="control-label"><?php echo $this->form->getLabel('partsite'); ?></div>
          <div class="controls partsite"><?php echo $this->form->getInput('partsite'); ?></div>
        </div>
      </div>
    </div>
  </div>

  <input type="hidden" name="task" value="" />
  <input type="hidden" name="return" value="<?php echo $input->getCmd('return'); ?>" />
  <?php echo JHtml::_('form.token'); ?>
</form>

class MycomponentController extends JControllerLegacy
{

  function display($cachable = false, $urlparams = array())
  {
    $this->default_view = 'firms';
    parent::display($cachable, $urlparams);
  }

  public function getListSites()
  {
    $options = array();
    $id = filter_input(INPUT_GET, 'partner', FILTER_VALIDATE_INT);
    $result = JFactory::getDbo()->setQuery('select `id`, `s_url` from `#__crmt_sites` where `s_partner`='.(int)$id)->loadObjectList();
    foreach ($result as $item)
      $options[] = JHTML::_('select.option', $item->id, $item->s_url);
    echo JHtml::_('select.genericlist', $options, 'jform[partsite]', '' );
    exit;
  }
  
}