예제 #1
0
 /**
  * Lists all Question entities.
  *
  * @Route("/questions")
  * @Method("GET")
  *
  * @return JsonResponse
  *
  * @author João Paulo Cercal <*****@*****.**>
  * @version 0.1
  */
 public function questionsAction()
 {
     $repository = $this->get('doctrine')->getRepository('CekurteZCPEBundle:Question');
     $entityFilter = new Question();
     $entityFilter->setDeleted(false);
     $entityFilter->setApproved(true);
     $result = $repository->getQuery($entityFilter, 'ck.id', 'asc')->getResult();
     $data = array();
     foreach ($result as $item) {
         $dataItem = array('id' => $item->getId(), 'google_groups_id' => $item->getGoogleGroupsId(), 'question' => $item->getTitle(), 'question_type' => array('id' => $item->getQuestionType()->getId(), 'type' => $item->getQuestionType()->getTitle()), 'difficulty' => $item->getDifficulty(), 'comment' => $item->getComment(), 'created_at' => $item->getCreatedAt(), 'created_by' => $item->getCreatedBy()->getName());
         foreach ($item->getCategory() as $row) {
             $dataItem['categories'][] = $row->getId();
         }
         foreach ($item->getQuestionHasAnswer() as $row) {
             $dataItem['alternatives'][] = array('id' => $row->getAnswer()->getId(), 'is_correct' => $row->isCorrect(), 'alternative' => $row->getAnswer()->getTitle());
         }
         $data[] = $dataItem;
     }
     return new JsonResponse($data);
 }
예제 #2
0
 /**
  * @Route("/admin/parser-database-content")
  * @Method("GET")
  * @Template("CekurteZCPEBundle:Default:parser.html.twig")
  */
 public function parserDatabaseContentAction()
 {
     set_time_limit(0);
     $em = $this->get('doctrine')->getManager();
     $itens = $em->getRepository('CekurteZCPEBundle:Parser')->findAll();
     foreach ($itens as $item) {
         $subject = $item->getSubject();
         $content = $item->getContent();
         if (preg_match_all("/[\r\n]+[^:alpha]{1}\\s*[\\:\\)\\/]{1}\\s*(.*)/", $content, $matches)) {
             $answers = end($matches);
             $answersComplete = $matches[0];
             $question = $content;
             foreach ($answersComplete as $answer) {
                 $question = str_replace($answer, '', $question);
             }
         }
         if (preg_match_all("/[\r\n]+[^:alpha]{1}\\s*[\\:\\)\\/]{1}\\s*(.*)/", $content, $matches)) {
             $answers = end($matches);
             $answersComplete = $matches[0];
             $question = $content;
             foreach ($answersComplete as $answer) {
                 $question = str_replace($answer, '', $question);
             }
         }
         $questionType = 'Single Choice';
         if (preg_match_all("/.*(\\_{5}).*/", $content, $matches)) {
             $questionType = 'Text';
         }
         if (preg_match("/\\(\\s*choose\\s*(\\d+)\\)/i", $content, $matches)) {
             $choose = (int) end($matches);
             if ($choose > 1) {
                 $questionType = 'Multiple Choice';
             }
             $question = str_replace($matches[0], '', $question);
         }
         if (preg_match("/\\d{1,4}/", $subject, $matches)) {
             $googleGroupsId = (int) $matches[0];
         }
         $category = array();
         if (preg_match("/(Categoria|Category){1}\\:{1}\\s+(.*)\\./i", $content, $matches)) {
             $category = explode(', ', end($matches));
         }
         $entity = $em->getRepository('CekurteZCPEBundle:Question')->findOneBy(array('googleGroupsId' => $googleGroupsId));
         if (!$entity instanceof Question) {
             $entity = new Question();
             $entity->setDeleted(false)->setCreatedBy($this->getUser())->setCreatedAt($item->getCreatedAt())->setGoogleGroupsId($googleGroupsId)->setGoogleGroupsAuthor($item->getAuthor())->setTitle(trim(nl2br($question)))->setComment($content);
             $questionTypeEntity = $em->getRepository('CekurteZCPEBundle:QuestionType')->findOneBy(array('title' => trim($questionType)));
             if ($questionTypeEntity instanceof QuestionType) {
                 $entity->setQuestionType($questionTypeEntity);
             }
             if (!empty($category)) {
                 foreach ($category as $title) {
                     $categoryEntity = $em->getRepository('CekurteZCPEBundle:Category')->findOneBy(array('title' => trim($title)));
                     if ($categoryEntity instanceof Category) {
                         $entity->addCategory($categoryEntity);
                     }
                 }
             }
             if (!empty($answers)) {
                 $em->persist($entity);
                 $em->flush();
                 $entity->setApproved(false)->setImportedFromGoogleGroups(true)->setDifficulty(0)->setEmailHasSent(true);
                 $em->persist($entity);
                 $em->flush();
                 foreach ($answers as $answer) {
                     $answerEntity = new Answer();
                     $answerEntity->setTitle($answer)->setDeleted(false)->setCreatedBy($this->getUser())->setCreatedAt(new \DateTime('NOW'));
                     $em->persist($answerEntity);
                     $em->flush();
                     $answerEntityRel = new QuestionHasAnswer();
                     $answerEntityRel->setAnswer($answerEntity)->setQuestion($entity)->setCorrect(false);
                     $em->persist($answerEntityRel);
                     $em->flush();
                 }
             }
         }
     }
     return array();
 }