Multiple Model Associations to same table

Question

My situation: I want to bring a HABTM and a hasOne relation working in the same model. unfortunatelly its not loading the groupleaders userinformation into the usergroups.

a user can have multiple usergroups
a usergroup can have one groupleader (user id)

any help apreciated

I'm having a table layout like this:

users

id
username

user_usergroups

id
user_id
usergroup_id

usergroups

id
groupname
groupleader (value is user_id)

usergroups model

public $hasAndBelongsToMany = array(
    'User' => array(
        'className' => 'Users',
        'foreignKey' => 'usergroup_id',
        'associationForeignKey' => 'user_id'
    )
);


public $hasOne = array(
    'GroupLeader' => array( 'className' => 'User',
    'foreignKey' => 'usergroup_groupleader' )
);

score 1 · Accepted Answer · answered Jan 17 '13 at 13:40

1

the following was missing in the controller

$this->Staffgroup->recursive = 1;

answered Jan 17 '13 at 13:40

endo.anaconda

2,449
4
29
55

score 0 · Answer 2 · answered Jan 16 '13 at 11:49

0

Add

public $hasAndBelongsToMany = array(
'User' => array(
    'className' => 'Users',
    'joinTable'=>'user_usergroups',
    'foreignKey' => 'usergroup_id',
    'associationForeignKey' => 'user_id'
)

);

now when you retrieve information in usersgroup controller , it will contain information of User-group leaders.

answered Jan 16 '13 at 11:49

Meet Brahmbhatt

57
1
1
8

my problem is about the hasOne relation, not the HABTM relation – endo.anaconda Jan 17 '13 at 11:44

Multiple Model Associations to same table

2 Answers2