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