Relational data CGridview

Yii 1.1 General Discussion
1

Greetings,

Before i state my question, I would liek to clarify, I have searched the forum, and found some post regarding this issue. I followed it as close as i can, however I am still left with the following issue:

I have 2 tables:

User - with the folllowing relationship defined in the model: ‘role’ => array(self::BELONGS_TO, ‘Role’, ‘id’)

and "Role" with no relation defined(thats what i understand from how BELONGS_TO works, as i read in another thread)

The user table has a column named role_id

The role table has an id and a name

in the gridview, i want a column to show the name of the role that belongs to a user.

This is what I currently have:

Model->search():




$criteria=new CDbCriteria;


$criteria->compare('t.id',$this->id);

$criteria->compare('role.name',$this->role, true);

$criteria->compare('t.username',$this->username,true);

$criteria->compare('t.password',$this->password,true);

$criteria->compare('t.salutation',$this->salutation,true);

$criteria->compare('t.first_name',$this->first_name,true);

$criteria->compare('t.last_name',$this->last_name,true);


//load the related table at the same time:

$criteria->with=array('role');


return new CActiveDataProvider(get_class($this), array(

     'criteria'=>$criteria,

));

in my controller i have:




 $oUser = new User('search');

 $oUser->unsetAttributes();


 $this->render('index', array(

      'oUser' => $oUser

 ));

and last, the view:




$this->widget('zii.widgets.grid.CGridView', array(

        'id'=>'user-grid',

        'dataProvider'=>$oUser->search(),

        'columns'=>array(

            'username',

            'salutation',

            'first_name',

            'last_name',

            array(

                'name'=>'role',

                'value'=>'$data->role->name',

            ),

            array(

                'class'=>'CButtonColumn',

            ),

        ),

    ));

The current error I get is trying to get property of non-object.

Altough the error is clear, I still find myself failing at finding the solution… :confused:

Anyone that could tell me what im doing wrong?

Thanks for taking the trouble of reading this :)

2

Shouldn’t your role relation be like

?

3

I have changed the relationships to

Role model: ‘user’ => array(self::HAS_MANY, ‘User’, ‘role_id’)

User model: ‘role’ => array(self::HAS_ONE, ‘Role’, ‘id’) (id == role_id)

But im used to giving every table "id" rather then role_id or user_id as primary key

Anyway the changes dont affect the problem, it still persists, the error is caused because of the search() in user, im quite sure of that. But why its caused im not sure. Somewhere im doing something wrong.

4

have you tried with what I said ?

5

Sorry, yes I have, it did nothing. :(

6

Ok I’ saying that bcause the id in the role relation should be the foreign key(role_id) and not the pramery key.

7

You’re saying that my role table should have an id and a role_id? :confused:

I don’t think we are understanding eachother.

heres the table structure im working with:

User table:

PK: id int

FK: role int

username varchar

password varchar

salutation varchar

firstname varchar

lastname varchar

Role table:

PK: id int

name varchar

It’s very possible im just being stupid. Eitherway, I have tried what you said, and it’s not working.

8

Hi Kyura!

The best advice I can give you about relations, is to use InnoDb and generate the relations with Gii.

If you did so, your relations are correct.

Maybe you have some user that has not a role associated, therefore try using in the grid this:




'value'=>'($data->role)?$data->role->name:""',

This will not give you error, can be an help for debugging.

9

Thank you very much.

That was exactly the problem, a user not having a role assigned.

Thanks again and have a nice remaining day! ^.^ I know i will!

I also wrote a bit of a workaround in the meantime, but I hope I can fix it with this bit of logic. I should be able to.