Example #1
0
    public function checkMultipleApplication(Application $application)
    {
        $team = $application->getTeam()->getId();
        $user = '******' . $application->getUser()->getId();
        $query = $this->em->createQuery('SELECT p
		    FROM AppBundle:Application p
		    WHERE p.team = ' . $team . $user . 'and p.origin=\'team\'');
        $appTeams = $query->getResult();
        $query = $this->em->createQuery('SELECT p
		    FROM AppBundle:Application p
		    WHERE p.team = ' . $team . $user . 'and p.origin=\'player\'');
        $appPlayers = $query->getResult();
        if ($appTeams && $appPlayers) {
            foreach ($appTeams as $appTeam) {
                foreach ($appPlayers as $appPlayer) {
                    if ($appTeam->getTeam() == $appPlayer->getTeam() && $appTeam->getUser() == $appPlayer->getUser()) {
                        $user = $appTeam->getUser();
                        $team = $appTeam->getTeam();
                        $game = $team->getGame();
                        $query = $this->em->createQuery('SELECT p
						    FROM AppBundle:Player p
						    WHERE p.user = '******'and p.game = ' . $game->getId());
                        $players = $query->getResult();
                        $player = $players[0];
                        $player->setTeam($team);
                        $this->em->remove($appTeam);
                        $this->em->remove($appPlayer);
                        $this->em->persist($player);
                        $this->em->flush();
                        return;
                    }
                }
            }
        }
    }