public function getAssignablePermissionsByUserType(AdminUserType $userType)
{
$currentUserRoles = $userType->getAdminUserRoles();
$ids = array();
foreach ($currentUserRoles as $each) {
$ids[] = $each->getId();
}
$idsNotIn = "'" . \implode("', '", $ids) . "'";
$dql = "SELECT a FROM UserBundle:AdminUserRole a WHERE a.status = :active AND a.id NOT IN ({$idsNotIn})";
$query = $this->getEntityManager()->createQuery($dql)->setParameter('active', AdminUserRole::STATUS_ACTIVE);
return $query->getResult();
}
