public function getNLobby(User $user)
{
$nblb = 0;
$query = $this->createQueryBuilder('u')->where('u.id =:id')->setParameter('id', $user->getId())->leftJoin('u.orders', 'o')->addSelect('o')->andWhere('o.payer =1')->getQuery()->getResult();
foreach ($query as $lobby) {
$nblb = $nblb + 1;
}
return $nblb;
}
