/**
* @return mixed
*/
public function prepareQueryBeforeCount(xPDOQuery $c)
{
$rid = trim($this->getProperty('resource'));
$c->setClassAlias('Permissions');
$c->leftJoin('modUserProfile', 'User', 'Permissions.principal = User.internalKey AND Permissions.principal_type = "usr"');
$c->leftJoin('modUserGroup', 'Group', 'Permissions.principal = Group.id AND Permissions.principal_type = "grp"');
$c->select('Permissions.*, User.fullname, Group.name as groupname');
$c->where(array('Permissions.rid' => $rid));
$c->sortby('Permissions.weight', 'ASC');
//$c->sortby('Permissions.priority', 'DESC');
return $c;
}
