drop-down-menu - Yii2 中从属下拉列表中的 Fatch 值

Question

我创建了一个从属下拉列表，现在我想在更新页面上获取这些值。我该怎么办？

我创建了 2 个下拉列表 - 第一个客户和第二个员工在更新页面上，我得到了客户的值(value)，但我没有得到员工的值(value)(因为它是依赖下拉列表)

表单

   <?php  
    //First drop-down  
    echo $form->field($model, 'client')->dropDownList($Client, 
     ['prompt'=>'-Select Client-',
      'onchange'=>'
        $.post
        ( 
            "'.urldecode(
      Yii::$app->urlManager->createUrl
      ('leads/lists&id=')).'"+$(this).val(), function( data ) 
         {
          $( "select#staff_id" ).html( data );
        });
    ']); ?> 

     // depend dropdown
    <?php echo $form->field($model, 'staff')
          ->dropDownList
           (     
                 ['prompt'=>'-Choose a Sub Category-'],
                 ['id'=>'staff_id','value'=>$Staff]
            );
    ?>

Controller

public function actionLists($id)
{
    $sql = "select * from staff  where client='$id' ";
   //exit;
    $models = Staff::findBySql($sql)->asArray()->all();   
    //echo "<pre>";print_r($model);exit;

    if(sizeof($models) >0){
        echo "<option>-Choose a Sub Category-</option>";
        foreach($models as $model){
            echo "<option value='".$model['id']."'>".$model['fname']."</option>";
        }
    }
    else{
        echo "<option>-Choose a Sub Category-</option><option></option>";
    }

}

Answer 1

首先将 $modelsStaff 变量添加到您的创建和更新操作中，如下所示:

<?
public function actionCreate() 
{ 
    $modelsStaff=null;
    $model = new model(); 
    if ($model->load(Yii::$app->request->post()) && $model->save()) 
    { 
        return $this->redirect(['view', 'id' => $model->id]); 
    } 
    else
    {
        return $this->render('create', [ 'model' => $model,'modelsStaff'=>$modelsStaff]); 
    } 
}
public function actionUpdate($id) 
{ 
    $model = $this->findModel($id); 
    if ($model->load(Yii::$app->request->post()) && $model->save()) 
    { 
        return $this->redirect(['view', 'id' => $model->id]); 
    } 
    else
    {
        $sql = "select * from staff  where client='$model->client'";
        $modelsStaff = Staff::findBySql($sql)->asArray()->all();    
        return $this->render('update', [ 'model' => $model,'modelsStaff'=>$modelsStaff]); 
    } 
}

?>

在你的更新操作中找到所有使用 $model->client 的员工，并让所有员工都在这个客户下，并像这样更新你的 View

<?php  
    //First drop-down  
    echo $form->field($model, 'client')->dropDownList($Client, 
     ['prompt'=>'-Select Client-',
      'onchange'=>'
        $.post
        ( 
            "'.urldecode(
      Yii::$app->urlManager->createUrl
      ('leads/lists?id=')).'"+$(this).val(), function( data ) //<---
         {
          $( "select#staff_id" ).html( data );
        });
    ']); ?> 

     // depend dropdown
    <?php echo $form->field($model, 'staff')->dropDownList
           ($modelsStaff,    
                 ['prompt'=>'-Choose a Sub Category-'],
                 ['id'=>'staff_id','value'=>$Staff]
            );
    ?>