StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I have Restaurant, City, Country and User models with relations between them.</p> <p>Model:</p> <pre><code>public function search() { $criteria=new CDbCriteria; $criteria->together = true; $criteria->with= array('xCountry','xCity','User'); $criteria->compare('Id',$this->Id,true); $criteria->compare('Restaurant.Name',$this->Name,true); $criteria->addSearchCondition('xCountry.Name',$this->Country); $criteria->addSearchCondition('xCity.Name',$this->City); $criteria->compare('Zip',$this->Zip,true); $criteria->compare('Address',$this->Address,true); $criteria->compare('Description',$this->Description,true); $criteria->compare('Restaurant.Active',$this->Active,true); $criteria->addSearchCondition('User.Username',$this->Owner); $criteria->compare('Lat',$this->Lat); $criteria->compare('Lon',$this->Lon); return new CActiveDataProvider($this, array( 'criteria'=>$criteria, )); } </code></pre> <p>View:</p> <pre><code>$this->widget('zii.widgets.grid.CGridView', array( 'id'=>'restaurant-grid', 'dataProvider'=>$model->search(), 'filter'=>$model, 'columns'=>array( 'Id', 'Name', 'Zip', 'Address', 'Active', array( 'name' => 'User.Username', 'header' => 'Username', 'filter' => CHtml::activeTextField($model, 'Owner'), 'value' => '$data->User->Username', ), array( 'name' => 'xCountry.Name', 'header' => 'Country', 'filter' => CHtml::activeTextField($model, 'Country'), 'value' => '$data->xCountry->Name', ), array( 'name' => 'xCity.Name', 'header' => 'City', 'filter' => CHtml::activeTextField($model, 'City'), 'value' => '$data->xCity->Name', ), array( 'class'=>'CButtonColumn', ), ), )); </code></pre> <p>I hope this can help you.</p> <p>UPDATE:</p> <p>What if you try something like this:</p> <pre><code>... 'columns'=>array( 'mailTemplate.name', 'sendDate', 'mailTemplate.subject', 'client.email', ... </code></pre> <p>UPDATE #2:</p> <p>Prepare yourself this will be a bit dirty.</p> <p>Let's say we've got two classes, A and B. B belongs to A. B's got a property, let's say "color" and we want to display it in our grid where we list the "A"s.</p> <p>The first thing you have to do is, manually create a property to your data provider class (what is "A"). This property will be "colorOfB", so you have to add "public $colorOfB;" to your model A.</p> <p>Add criteria for this property:</p> <pre><code>$criteria->compare('B.color',$this->colorOfB,true); </code></pre> <p>Add the column to the grid:</p> <pre><code>array( 'name' => 'B.color', 'header' => 'Color of B', 'filter' => CHtml::activeTextField($model, 'colorOfB'), 'value' => '$data->B->color'), </code></pre> <p>The final thing is to set this property manually in A's controller:</p> <pre><code>$modelA = new A('search'); $modelA->colorOfB = $_GET['A']['colorOfB']; </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload