How to display a related HAS_MANY grid

fouss · December 14, 2010, 9:47am

I found this on McGuigan 's blog at http://learnyii.blogspot.com/2010/12/yii-how-to-display-related-hasmany-grid.html

In this example, we have a Cars table, as well as a Dealers table. A dealer has many cars.

I want to show the (single) Dealer view, but also all of the cars that belong to this dealer in a grid on the same page. Here’s how:

In your Dealer model, you should have something like this:

public function relations()

{

return array(‘cars’ => array(self::HAS_MANY, ‘Cars’, ‘dealer_id’),);

}

In your view, you have to convert the related cars data to a CArrayDataProvider for it to work with the CGridview. You also need to adjust the button Urls in the CGridView.

In your Dealer view "view.php", below your CDetailView, add this:

$config = array();

$dataProvider = new CArrayDataProvider($rawData=$model->cars, $config);

$this->widget(‘zii.widgets.grid.CGridView’, array(
'dataProvider'=&gt;&#036;dataProvider


, 'columns'=&gt;array(


    'id'


    , 'name'


    , array(


        'class'=&gt;'CButtonColumn'


        , 'viewButtonUrl'=&gt;'Yii::app()-&gt;createUrl(&quot;/Cars/view&quot;, array(&quot;id&quot;=&gt;&#036;data[&quot;id&quot;]))'


        , 'updateButtonUrl'=&gt;'Yii::app()-&gt;createUrl(&quot;/Cars/update&quot;, array(&quot;id&quot;=&gt;&#036;data[&quot;id&quot;]))'


        , 'deleteButtonUrl'=&gt;'Yii::app()-&gt;createUrl(&quot;/Cars/delete&quot;, array(&quot;id&quot;=&gt;&#036;data[&quot;id&quot;]))'


        )


)
));

Note that the viewButtonUrl is a PHP expression, but it’s quoted. The $data field is the name of the row object inside the grid.

That works find but how to do if I want cars of dealers which category= ‘some category’ ?

dealer(id,name,category)

car(id,type,colour,dealer_id)

thanks!

zaccaria · December 14, 2010, 10:51am

Is better to use a CActiveDataProvider:


$dataProvider = new CActiveDataProvider('cars', array(

   'criteria'=>array(

        'condition'=>"category= 'some category' and dealer='{$model->id}'"

    )

));

fouss · December 14, 2010, 11:20am

zaccaria:

Is better to use a CActiveDataProvider:


$dataProvider = new CActiveDataProvider('cars', array(

   'criteria'=>array(

        'condition'=>"category= 'some category' and dealer='{$model->id}'"

    )

));

I just try that

and I have this error

I have this in my dealer model :

fouss · December 15, 2010, 7:44am

It seems to be too complicate…

fouss · December 16, 2010, 5:33pm

Nobody to help me? I need that…

thx!

el_chief · December 16, 2010, 7:27pm

Hi Fouss,

I think you want ‘car’ instead of ‘cars’ in the CActiveDataProvider part, as that is your model name

Neil

fouss · December 22, 2010, 2:32pm

Yes it works with ‘car’ but I want to use the relation cars but I want to use the relation ‘cars’. How to do that?

perochak · December 23, 2010, 10:30am

I think you should use




'with'=>'relation'