Ejemplo n.º 1
0
 public function getNextQuestionForPass(PassModule $passModule)
 {
     return $this->createQueryBuilder('question')->leftJoin('question.module', 'module')->leftJoin('module.modulesUser', 'module_user')->leftJoin('module_user.passModules', 'pass_module')->orderBy('question.sort')->andWhere('pass_module.id = :idPassModule')->andWhere("question.id NOT IN(:questionIds)")->setParameter('idPassModule', $passModule->getId())->setParameter('questionIds', array_values($passModule->getAnsweredQuestionIds()))->setMaxResults(1)->getQuery()->getOneOrNullResult();
 }