public function getPointsByAttempt(Attempt $attempt)
{
$points = $this->getEntityManager()->createQuery("SELECT SUM(answer.points) FROM AppBundle:UserAnswer u\n INNER JOIN u.answer answer\n WHERE u.attempt=" . $attempt->getId())->getSingleScalarResult();
if ($points != null) {
return $points;
} else {
return 0;
}
}
/**
* @Route("/q/{quizsession}", name="ajax_start")
*/
public function startQuizAction($quizsession, Request $request)
{
$session = $request->getSession();
$em = $this->getDoctrine()->getManager();
$quizsession = $em->getRepository('AppBundle:QuizSession')->find($quizsession);
$attempt = new Attempt();
$attempt->setSession($quizsession);
$attempt->setUser($this->getUser());
$em->persist($attempt);
$em->flush();
$session->set('attempt', $attempt->getId());
return $this->redirectToRoute('ajax_solve', array('attempt' => $attempt->getId()));
}