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;
}
/**
* {@inheritDoc}
*/
public function load(ObjectManager $manager)
{
$user = new User();
$user->setEmail('*****@*****.**');
$user->setPassword('JTuucPr5pDwpSn7L7c90JXK/khKwpUfs9m5ITjWTPO233LLc2/IJrYSy5aLwcS8vocnl4Qb+SpPCWnkPkQ2sUA==');
$user->setUsername('raxer7');
$user->setSuperAdmin(true);
$user->setEnabled(true);
$user->setPsn('test psn');
$user->setPsnpassword('test psn');
$user1 = new User();
$user1->setEmail('*****@*****.**');
$user1->setPassword('raxer1');
$user1->setUsername('raxer1');
$user1->setPsn('test2');
$user1->setPsnpassword('test2');
$manager->persist($user);
$manager->persist($user1);
$manager->flush();
}
public function getLobbyUser(User $user)
{
$query = $this->createQueryBuilder('o')->where('o.user = :user')->setParameter('user', $user->getid())->leftJoin('o.formule', 'f')->addselect('f')->getQuery()->getResult();
return $query;
}
/**
* Set user
*
* @param \challenge\UserBundle\Entity\User $user
*
* @return Orders
*/
public function setUser(\challenge\UserBundle\Entity\User $user)
{
$this->user = $user;
$user->addOrder($this);
return $this;
}
