php - Yii - Self Referencing Table

Solution:

First step - define relation in model class:

public function relations()
{
    return array(
        'parent'=>array(self::BELONGS_TO, 'Category', 'parent_category_id'),
    );
}
Copy code

whereCategory - is name of AR model class,parent_category_id - foreign key referencing to itself.

Step 2 - CGridView,columns attribute:

...
'columns'=>array(
    'id',
    'category',
    array(
        'name'=>'Parent category', // col title
        'value'=>function (Category $data){
            if($data->parent_category_id)
                return $data->parent->category; // "parent" - relation name, defined in "relations" method 

            return "-= root category =-";


        }
    ),
)
...
Copy code

Note: code above requires php version>=5.3. Otherwise you have to avoid using anonymous function

Solution:

'columns'=>array(
 .....
  array('name'=>'id','value'=>'$data->Category->name'),
 )
Copy code

or create function inside call getCategoryName() and retreive name

'columns'=>array(
 .....
  array('name'=>'id','value'=>'$data->getCategoryName()'),
 )

 public function getCategoryName()
    {
       $equery= Category::model()->find("id=$this->id"); 
       $cnm=$equery['Category'];
       return $cnm;
    }
Copy code