PlaygroundGame\Service\Quiz::updatePrediction()

Complexity

Conditions	8
Paths	10

Size

Total Lines

89

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function updatePrediction($question)
    {
        set_time_limit(0);
        $em = $this->serviceLocator->get('doctrine.entitymanager.orm_default');

        /* @var $dbal \Doctrine\DBAL\Connection */
        $dbal = $em->getConnection();

        $answers = $question->getAnswers();
        $victoryCondition = $question->getQuiz()->getVictoryConditions()/100;
        $maxCorrectAnswers = $question->getQuiz()->getMaxCorrectAnswers();
        $nbQuestionsWinner = $victoryCondition * $maxCorrectAnswers;

        // I update all the answers with points and correctness
        // Very fast (native query inside)
        if ($question->getType() == 2) {
            foreach ($answers as $answer) {
                $correct = ($answer->getCorrect() == 1)?$answer->getCorrect():0;
                $value  = trim(strip_tags($answer->getAnswer()));
                $points = ($correct)?$answer->getPoints():0;
                $sql    = "
                UPDATE game_quiz_reply_answer AS ra
                SET ra.points=IF(ra.answer=:answer, :points, 0),
                    ra.correct = IF(ra.answer=:answer, :isCorrect, 0)
                WHERE ra.question_id = :questionId
                ";
                $stmt = $dbal->prepare($sql);
                $stmt->execute(
                    array(
                        'answer'     => $value,
                        'points'     => $points,
                        'isCorrect'  => $correct,
                        'questionId' => $question->getId()
                    )
                );
            }
        } else {
            foreach ($answers as $answer) {
                $correct = ($answer->getCorrect() == 1)?$answer->getCorrect():0;
                $points = ($correct)?$answer->getPoints():0;
                $sql    = "
                UPDATE game_quiz_reply_answer AS ra
                SET ra.points=:points,
                    ra.correct = :isCorrect
                WHERE ra.question_id = :questionId
                    AND ra.answer_id = :answerId
                ";

                $stmt = $dbal->prepare($sql);
                $stmt->execute(
                    array(
                        'points'     => $points,
                        'isCorrect'  => $correct,
                        'questionId' => $question->getId(),
                        'answerId'   => $answer->getId()
                    )
                );
            }
        }

        // Entry update with points. WINNER is calculated also !
        $sql = "
        UPDATE game_entry as e
        INNER JOIN
        (
            SELECT e.id, SUM(ra.points) as points, SUM(ra.correct) as correct
            FROM game_entry as e
            INNER JOIN game_quiz_reply AS r ON r.entry_id = e.id
            INNER JOIN game_quiz_reply_answer AS ra ON ra.reply_id = r.id
            GROUP BY e.id
        ) i ON e.id = i.id
        SET e.points = i.points, e.winner = IF( i.correct >= :nbQuestionsWinner, 1, 0)
        WHERE e.game_id = :gameId
        ";

        $stmt = $dbal->prepare($sql);
        $stmt->execute(
            array(
                'gameId' => $question->getQuiz()->getId(),
                'nbQuestionsWinner' => $nbQuestionsWinner
            )
        );

        $this->getEventManager()->trigger(
            __FUNCTION__ .'.post',
            $this,
            array('question' => $question)
        );
    }
    /**