StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCGridView Filter Multiple Models
text
Body
copied!<p>I have searched and searched for an answer to my problem but neither of them worked. My problem is regarding the filtering/searching in the CGridView for Yii.</p> <p>In my Applicant model I have the following:</p> <pre><code>private $_city = null; private $province_id = null; public function getCity() { if($this->_city === null && $this->address_id !== null) { $this->_city = $this->address->city; } return $this->_city; } public function setCity($value) { $this->_city = $value; } public function search() { // Warning: Please modify the following code to remove attributes that // should not be searched. $criteria=new CDbCriteria; $criteria->with = array('address'=>array('alias'=>'address')); $criteria->compare('id',$this->id); $criteria->compare('phn',$this->phn); $criteria->compare('gender',$this->gender); $criteria->compare('dob',$this->dob,true); $criteria->compare('first_name',$this->first_name,true); $criteria->compare('last_name',$this->last_name,true); $criteria->compare('band_id',$this->band_id); $criteria->compare('note',$this->note,true); $criteria->compare('address.city',$this->city); $criteria->compare('address.province_id',$this->province_id); return new CActiveDataProvider($this, array( 'criteria'=>$criteria, 'sort'=>array( 'attributes'=>array( 'id', 'phn', 'first_name', 'last_name', 'band_id', 'city'=>array( 'asc'=>'address.city ASC', 'desc'=>'address.city DESC', ), 'province_id'=>array( 'asc'=>'address.province_id ASC', 'desc'=>'address.province_id DESC', ), ) ) )); } </code></pre> <p>In my View I have</p> <pre><code>$this->widget('zii.widgets.grid.CGridView', array( 'id'=>'applicants-grid', 'dataProvider'=>$model->search(), 'filter'=>$model, 'columns'=>array( 'first_name', 'last_name', 'phn', array( 'name'=>'band_id', 'value'=>'$data->band->name', 'filter'=>CHtml::listData(Band::model()->findAll(), 'id', 'name') ), array( 'name'=>'city', 'value'=>'$data->address->city', // causes 'Trying to get property of non-object' - no error if $data->city 'filter'=>CHtml::listData(Address::model()->findAll(), 'city', 'city'), ), array( 'class'=>'CButtonColumn', 'template'=>'{view}', 'buttons'=>array( 'view'=>array( 'url'=>'Yii::app()->createUrl("/applicant/view", array("id"=>$data->id))', ) ) ), ) )); </code></pre> <p>I have the cities and drop down list showing but when I choose are city from the dropdown it does not filter the widget with the proper results.</p> <p>I have tried doing the solutions in the following pages</p> <p><a href="http://www.yiiframework.com/forum/index.php?/topic/11546-cgridview-with-mulitple-model/" rel="nofollow">http://www.yiiframework.com/forum/index.php?/topic/11546-cgridview-with-mulitple-model/</a> <a href="http://www.yiiframework.com/forum/index.php?/topic/19913-cgridview-with-multiple-models/" rel="nofollow">http://www.yiiframework.com/forum/index.php?/topic/19913-cgridview-with-multiple-models/</a></p>

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