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; } } } } }
/** * Shows the given interview. * * @param Application $application * @return \Symfony\Component\HttpFoundation\Response */ public function showAction(Application $application) { $interview = $application->getInterview(); if (is_null($interview)) { return $this->redirectToRoute('admissionadmin_show'); } // Only accessible for admin and above, or team members belonging to the same department as the interview if (!$this->get('security.authorization_checker')->isGranted('ROLE_SUPER_ADMIN') && !$interview->isInterviewer($this->getUser())) { throw $this->createAccessDeniedException(); } elseif ($this->getUser() == $application->getUser()) { throw $this->createAccessDeniedException(); } return $this->render('interview/show.html.twig', array('interview' => $interview, 'application' => $application)); }