/** * Fonction de configuration d'une équipe * * @param integer $id * @return Response * * @Template() * @Route("/configure/{id}", name="team_configure") * @Method({"GET"}) * * @Security("has_role('ROLE_USER')") * @author Benjamin Levoir <*****@*****.**> */ public function configureTeamAction($id) { $team = $this->getTeam($id, true); return array('team' => $team, 'lists' => $this->get('core.team')->getTeamUsersList($team), 'roles' => \CoreBundle\Entity\TeamUser::getAllRoles()); }
/** * Récupère tous les joueurs de la team * * @param integer $teamId * @return array * * @author Benjamin Levoir <*****@*****.**> */ public function getPlayersInTeam($teamId) { $res = $this->createQueryBuilder('tu')->leftJoin('tu.user', 'u')->select('u.id, u.displayName, u.username, tu.role')->where('tu.status = :status')->setParameter('status', \CoreBundle\Entity\TeamUser::STATUS_ACCEPTED)->andWhere('tu.role in (:roles)')->setParameter('roles', \CoreBundle\Entity\TeamUser::getPlayableRoles())->andWhere('tu.team = :teamId')->setParameter('teamId', $teamId)->getQuery()->getResult(); return $res; }