/**
  * Find users that have the specified role
  *
  * @param Role $role
  *
  * @return ArrayCollection|QueryBuilder
  */
 public function findByRole($role)
 {
     $queryBuilder = $this->createQueryBuilder('u')->select('u')->innerJoin('u.roles', 'r')->where('r.id = :role_id')->setParameter('role_id', $role->getId())->orderBy('u.lastname', 'ASC');
     return $this->processQuery($queryBuilder);
 }