I've tried adding joins in my User model beforeFind():
public function beforeFind(array $query) {
$query['joins'] = array(
array(
'table' => 'roles_users',
'alias' => 'RolesUser',
'type' => 'INNER',
'conditions' =>
array('Milli.id=RolesUser.user_id')),
array(
'table' => 'roles',
'alias' => 'Role',
'type' => 'INNER',
'conditions' =>
array('RolesUser.role_id=Role.id')));
return $query;
}
Now Model::find() correctly does receives the join info:
/lib/Cake/Model/Model.php (line 2676)
array(
'conditions' => array(
'Milli.username' => 'rihad',
'Milli.password' => '17bce4ac9c39019189b7bba280af55de9fe1d9a7'
),
'fields' => null,
'joins' => array(
(int) 0 => array(
'table' => 'roles_users',
'alias' => 'RolesUser',
'type' => 'INNER',
'conditions' => array(
(int) 0 => 'Milli.id=RolesUser.user_id'
)
),
(int) 1 => array(
'table' => 'roles',
'alias' => 'Role',
'type' => 'INNER',
'conditions' => array(
(int) 0 => 'RolesUser.role_id=Role.id'
)
)
),
'limit' => (int) 1,
'offset' => null,
'order' => array(
(int) 0 => null
),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'recursive' => (int) 2
But the User is still fetched with Role side by side, so
BaseAuthenticate ignores Role.
array(
(int) 0 => array(
'Milli' => array(
'password' => '*****',
'id' => (int) 6,
'username' => 'rihad',
'password_expiration' => null,
'created' => '2012-05-15 16:30:10',
'modified' => '2012-05-18 10:14:07',
'last_accessed' => null
),
'Role' => array(
(int) 0 => array(
'id' => (int) 1,
'alias' => 'operations',
'RolesUser' => array(
'id' => (int) 6,
'role_id' => (int) 1,
'user_id' => (int) 6
)
)
)
)
)
I'm expecting Role to be nested inside Milli, or something like that.
Please help, it's a SNAFU, I've invested too much of my limited time
to get the job done, it's too late to go looking for a working
framework :( I admit that it's probably a misconfiguration from my
part. But I can't fix it.
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
