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