StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Well, Yii is quite handy for this kind of feature, but you should first rewrite your model to use relations.</p> <p>In your model :</p> <pre><code>// this attribute will be used in search function private $_authorName; public function rules() { return array ( ..... array('authorName', 'safe', 'on'=>'search'), ..... ); } public function relations() { return array( ..... 'author' => array(self::BELONGS_TO, 'TUsers', 'fk_authorid'), ..... ); } // authorName getter public function getAuthorName() { if ($this->scenario=='search') return $this->_authorName; return $this->fk_authorid.', '.$this->author->ch_completeName; } // authorName setter public function setAuthorName($authorName) { $this->_authorName = $authorName; } public function search() { $criteria=new CDbCriteria; ..... // search author name ? if ($this->authorName!==null) { $criteria->with = array('author'); $criteria->compare('author.ch_completeName', $this->authorName, true); } ..... return new CActiveDataProvider($this, array( 'criteria'=>$criteria, )); } </code></pre> <p>And in your CGridView, you should simply define your column like this :</p> <pre><code>array( 'name'=>'authorName', 'htmlOptions'=>array('width'=>'16%'), ), </code></pre> <p>And you should read this : <a href="http://www.yiiframework.com/wiki/281/searching-and-sorting-by-related-model-in-cgridview/" rel="nofollow">http://www.yiiframework.com/wiki/281/searching-and-sorting-by-related-model-in-cgridview/</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