Re: Conditional Model Query

You shouldn't need to use loadModel() if the associations are set up correctly.

When you call $this->Auth->user() with no params you get an array with
all data. I don't recall how deeply that goes. Try this in your
login() action, or some other action that requires authentication:

die(debug($this->Auth->user()));

If Auth doesn't make the Role data available you could fetch it for
that User and then check the result. But it's not clear where this
enduserid column resides. It's in the join table?

On Sun, Dec 9, 2012 at 12:10 PM, Md <mdaytrades@gmail.com> wrote:
> Hi there,
>
> I have a small application that has three tables. users, roles, and
> role_users. The role_users table is a join table as a user can have
> multiple roles. In my UsersController class I am trying to get a count for
> the number of roles the current user has where there is a enduserid = 1.
>
> public function hasEndUser(){
>
> $this->loadModel('RoleUser');
>
> $userId = $this->Auth->user('id');
>
> $conditions = array('RoleUser.user_id ='=>$userId,'RoleUser.enduserid
> ='=>1);
>
> $result = $this->RoleUser->find('count',$conditions);
>
> debug($result);
>
> }
>
> For whatever reason, this is the SQL that I am getting back:
>
> SELECT COUNT(*) AS `count` FROM `bridges`.`role_users` AS `RoleUser` LEFT
> JOIN `bridges`.`users` AS `User` ON (`RoleUser`.`user_id` = `User`.`id`)
> LEFT JOIN `bridges`.`roles` AS `Role` ON (`RoleUser`.`role_id` =
> `Role`.`id`) WHERE 1 = 1
>
>
> As a result, I am also getting the wrong count.
>
> --
> 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+unsubscribe@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>
>

--
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+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.