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