public function getUserQuestions(Users $user, Quizset $quizset) { try { $result = $this->getEntityManager()->createQuery('SELECT us.hashQuestion, us.hashAns1, us.hashAns2, us.hashAns3, us.id, us.idQuestion, q.content, q.ans1, q.ans2, q.ans3, q.type FROM AppBundle:QuestionToUserSet us, AppBundle:Question q WHERE us.idSet = :idset AND us.idUser = :user AND q.id = us.idQuestion ')->setParameter(':idset', $quizset->getId())->setParameter(':user', $user->getId())->execute(); if (!$result) { return false; } return $result; } catch (NoResultException $e) { return false; } }
public static function createUserSet(Users $user, Quizset $set) { $UserQuizSet = new UsersToQuizset(); $UserQuizSet->setIdSet($set->getId()); $UserQuizSet->setIdUser($user->getId()); $UserQuizSet->setMasterHash(md5($user->getId() . $user->getEmail() . time())); return $UserQuizSet; }
public static function getQuizAnwsers(QuizData $qd, Quizset $quizset) { $users = $qd->getUsersWhoFinished($quizset->getId()); if (!$users && empty($users)) { throw new \InvalidArgumentException("There is no users"); } $quizAnsCollection = QuizCollection::create($qd, $users); return $quizAnsCollection->getOutcome(); }