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