使用CGRIDVIEW显示另一个模型的属性

Question

I have 2 tables/models:

Tmp1

• Header
• QuestionText

Tmp2

• Header
• Part
• OutOf

I'm trying to display the columns: Header, QuestionText, Part, OutOf
in a single CGRIDVIEW.

In Tmp1 model:

public function relations()  
{  
  return array(  
               'tmp2s' => array(self::HAS_MANY, 'Tmp2', 'Header'),  
              );  
}  

In Tmp2 Model:

public function relations()
{  
    return array(  
        'header' => array(self::BELONGS_TO, 'Tmp1', 'Header'),  
    );  
}  

Controller:

 public function actionReviewAll()  
    {  
        $tmp1 = new Tmp1('search');  
                $tmp1->unsetAttributes();  

        if(isset($_GET['Tmp1'])){  
            $model->attributes=$_GET['Tmp1'];  
        }  

        $this->render('ReviewAll',array(  
                'tmp1'=>$tmp1,  
        ));  
    }  

View:

$this->widget('zii.widgets.grid.CGridView', array(
    'id'=>'tmp-grid',
    'dataProvider'=>$tmp1->search(),
    'filter'=>$tmp1,
    'columns'=>array(
        'Header',
        'QuestionText',
        array(
            'name' => 'tmp2.OutOf',
            'value' => '$data->tmp2[0].OutOf',
            'type' => 'raw'
        ),

    ),

)); ?>

Error:

Property "Tmp1.tmp2" is not defined.

Any help is greatly appreciated

Answer 1

You have a sintax error:

Tmp1.tmp2 = Tmp1.tmp2s

The relation alias is with 's'. "tmp2s".

    $this->widget('zii.widgets.grid.CGridView', array(
    'id'=>'tmp-grid',
    'dataProvider'=>$tmp1->search(),
    'filter'=>$tmp1,
    'columns'=>array(
        'Header',
        'QuestionText',
        'tmp2s.Part',
        'tmp2s.OutOf',
    ),

)); ?>

But you are trying to show a 'self::HAS_MANY' relationship, you can't show that on a normal CGridView widget...