Re: Trouble with model associations and query.
I seem to have resolved this, but I don't think it's the most efficient
query:
public function getStudents(){
$userId = $this->Auth->user('id');
$endusers = $this->RoleUser->findAllByuser_id($userId,
array('RoleUser.enduserid','RoleUser.user_id')); //Get the enduserid's for
all the roles I have been assigned
foreach ($endusers as $enduser){
$theusers[] = $this->User->findById($enduser['RoleUser']['enduserid']);
//store each user to an array.
}
debug($theusers);
Any ideas how I can get the same result by just querying the Users table
and associated roles/userroles ? }
On Sunday, December 9, 2012 2:30:38 PM UTC-5, MDay wrote:
>
> I am having trouble returning a query. I have the following setup
>
> Users - users class of all users in the system.
> Roles - roles class with a set of available roles. E.g. teacher, student,
> tutor
> RoleUsers - a mapping table between users and roles as a single user can
> have multiple roles.
>
>
> My Users class has this
>
> public $hasAndBelongsToMany = array(
>
> 'Role' =>
>
> array(
>
> 'className' => 'Role',
>
> 'joinTable' => 'role_users', //was
> roles_users
>
> 'foreignKey' => 'user_id',
>
> 'associationForeignKey' => 'role_id',
>
> 'unique' => true)
>
> );
>
>
> My RolesUser class has this
>
> public $belongsTo = array(
>
> 'User' =>
>
> array(
>
> 'className' => 'User',
>
> 'joinTable' => 'users',
>
> 'foreignKey' => 'user_id',
>
> 'unique' => true),
>
> 'Role' =>
>
> array(
>
> 'className' => 'Role',
>
> 'joinTable' => 'roles',
>
> 'foreignKey' => 'role_id',
>
> 'unique' => true)
>
>
> I am now trying to query the user table to determine the students
> belonging to the logged in user (a teacher or tutor)
>
>
> public function getStudents(){
>
> $userId = $this->Auth->user('id');
>
> $conditions = array('conditions' => array (array('Role.id =' => 75), //75
> is the role for all students
>
> array ('RoleUser.id = ' => $userId))); //this is the current logged in
> user
>
> $result = $this->User->find('all',$conditions);
>
> debug($result);
>
>
> In the top of my UsersController, I have:
>
> public $uses = array('Role', 'RoleUser');
>
>
> When I run the function getStudents above, I am getting *Error: *Call to
> a member function find() on a non-object
>
>
> );
>
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
Re: Trouble with model associations and query.
On Sun, Dec 9, 2012 at 2:30 PM, Md wrote:
>
> array ('RoleUser.id = ' => $userId))); //this is the current logged in user
RolesUser
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
Trouble with model associations and query.
I am having trouble returning a query. I have the following setup
Users - users class of all users in the system.
Roles - roles class with a set of available roles. E.g. teacher, student,
tutor
RoleUsers - a mapping table between users and roles as a single user can
have multiple roles.
My Users class has this
public $hasAndBelongsToMany = array(
'Role' =>
array(
'className' => 'Role',
'joinTable' => 'role_users', //was roles_users
'foreignKey' => 'user_id',
'associationForeignKey' => 'role_id',
'unique' => true)
);
My RolesUser class has this
public $belongsTo = array(
'User' =>
array(
'className' => 'User',
'joinTable' => 'users',
'foreignKey' => 'user_id',
'unique' => true),
'Role' =>
array(
'className' => 'Role',
'joinTable' => 'roles',
'foreignKey' => 'role_id',
'unique' => true)
I am now trying to query the user table to determine the students belonging
to the logged in user (a teacher or tutor)
public function getStudents(){
$userId = $this->Auth->user('id');
$conditions = array('conditions' => array (array('Role.id =' => 75), //75
is the role for all students
array ('RoleUser.id = ' => $userId))); //this is the current logged in user
$result = $this->User->find('all',$conditions);
debug($result);
In the top of my UsersController, I have:
public $uses = array('Role', 'RoleUser');
When I run the function getStudents above, I am getting *Error: *Call to a
member function find() on a non-object
);
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
