/** * @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; }