+global\CourseRestorer::restore_quiz_question()

Complexity

Conditions	30
Paths	404

Size

Total Lines	298
Code Lines	205

Duplication

Lines	33
Ratio	11.07 %

Importance

Changes

0

<?php
    public function restore_quiz_question($id)
    {
		$em = Database::getManager();
		$resources = $this->course->resources;
        $question = isset($resources[RESOURCE_QUIZQUESTION][$id]) ? $resources[RESOURCE_QUIZQUESTION][$id] : null;

		$new_id = 0;

		if (is_object($question)) {
			if ($question->is_restored()) {
				return $question->destination_id;
			}
			$table_que = Database::get_course_table(TABLE_QUIZ_QUESTION);
			$table_ans = Database::get_course_table(TABLE_QUIZ_ANSWER);
            $table_options = Database::get_course_table(TABLE_QUIZ_QUESTION_OPTION);

			// check resources inside html from ckeditor tool and copy correct urls into recipient course
            $question->description = DocumentManager::replace_urls_inside_content_html_from_copy_course(
                $question->description,
                $this->course->code,
                $this->course->destination_path,
                $this->course->backup_path,
                $this->course->info['path']

The property info does not seem to exist in Course.

            );

            $params = [
                'c_id' => $this->destination_course_id,
                'question' => self::DBUTF8($question->question),
                'description' => self::DBUTF8($question->description),

It seems like $question->description can also be of type false; however, CourseRestorer::DBUTF8() does only seem to accept string, did you maybe forget to handle an error condition?

                'ponderation' => self::DBUTF8($question->ponderation),
                'position' => self::DBUTF8($question->position),
                'type' => self::DBUTF8($question->quiz_type),
                'picture' => self::DBUTF8($question->picture),
                'level' => self::DBUTF8($question->level),
                'extra' => self::DBUTF8($question->extra),
            ];

			$new_id = Database::insert($table_que, $params);

            if ($new_id) {
                $sql = "UPDATE $table_que SET id = iid WHERE iid = $new_id";
                Database::query($sql);

                if (!empty($question->picture)) {
                    $question_temp = Question::read(
                        $new_id,
                        $this->destination_course_info['real_id']
                    );

                    $documentPath = api_get_path(SYS_COURSE_PATH).$this->destination_course_info['path'].'/document';
                    // picture path
                    $picturePath = $documentPath.'/images';
                    $old_picture = api_get_path(SYS_COURSE_PATH).$this->course->info['path'].'/document/images/'.$question->picture;
                    if (file_exists($old_picture)) {
                        $picture_name = 'quiz-'.$new_id.'.jpg';
                        $result = $question_temp->uploadPicture($old_picture, $picture_name, $picturePath);
                        if ($result) {
                            $sql = "UPDATE $table_que SET
                                        picture = '$picture_name'
                                    WHERE
                                        c_id = " . $this->destination_course_id . " AND
                                        id = $new_id ";
                            Database::query($sql);
                        }
                    }
                }
            }

            $correctAnswers = array();
            $allAnswers = [];
            $onlyAnswers = [];

            if (in_array($question->quiz_type, [DRAGGABLE, MATCHING, MATCHING_DRAGGABLE])) {
                $allAnswers = array_column($question->answers, 'answer', 'id');
            }

            if (in_array($question->quiz_type, [MATCHING, MATCHING_DRAGGABLE])) {
                $temp = array();
                foreach ($question->answers as $index => $answer) {
                    $temp[$answer['position']] = $answer;
                }

                foreach ($temp as $index => $answer) {
                    // check resources inside html from ckeditor tool and copy correct urls into recipient course
                    $answer['answer'] = DocumentManager::replace_urls_inside_content_html_from_copy_course(
                        $answer['answer'],
                        $this->course->code,
                        $this->course->destination_path,
                        $this->course->backup_path,
                        $this->course->info['path']
                    );

                    $answer['comment'] = DocumentManager::replace_urls_inside_content_html_from_copy_course(
                        $answer['comment'],
                        $this->course->code,
                        $this->course->destination_path,
                        $this->course->backup_path,
                        $this->course->info['path']
                    );

                    $quizAnswer = new CQuizAnswer();
                    $quizAnswer
                        ->setCId($this->destination_course_id)
                        ->setQuestionId($new_id)
                        ->setAnswer(self::DBUTF8($answer['answer']))
                        ->setCorrect($answer['correct'])
                        ->setComment(self::DBUTF8($answer['comment']))

It seems like $answer['comment'] can also be of type false; however, CourseRestorer::DBUTF8() does only seem to accept string, did you maybe forget to handle an error condition?

                        ->setPonderation($answer['ponderation'])
                        ->setPosition($answer['position'])
                        ->setHotspotCoordinates($answer['hotspot_coordinates'])
                        ->setHotspotType($answer['hotspot_type'])
                        ->setIdAuto(0);

                    $em->persist($quizAnswer);
                    $em->flush();

                    $answerId = $quizAnswer->getIid();

                    if ($answerId) {
                        $quizAnswer
                            ->setId($answerId)
                            ->setIdAuto($answerId);

                        $em->merge($quizAnswer);
                        $em->flush();

                        $correctAnswers[$answerId] = $answer['correct'];
                        $onlyAnswers[$answerId] = $answer['answer'];
                    }
				}
			} else {
				foreach ($question->answers as $index => $answer) {
					// check resources inside html from ckeditor tool and copy correct urls into recipient course
                    $answer['answer'] = DocumentManager::replace_urls_inside_content_html_from_copy_course(
                        $answer['answer'],
                        $this->course->code,
                        $this->course->destination_path,
                        $this->course->backup_path,
                        $this->course->info['path']
                    );

                    $answer['comment'] = DocumentManager::replace_urls_inside_content_html_from_copy_course(
                        $answer['comment'],
                        $this->course->code,
                        $this->course->destination_path,
                        $this->course->backup_path,
                        $this->course->info['path']
                    );

                    $params = [
                        'c_id' => $this->destination_course_id,
                        'question_id' => $new_id,
                        'answer' => self::DBUTF8($answer['answer']),
                        'correct' => $answer['correct'],
                        'comment' => self::DBUTF8($answer['comment']),

It seems like $answer['comment'] can also be of type false; however, CourseRestorer::DBUTF8() does only seem to accept string, did you maybe forget to handle an error condition?

                        'ponderation' => $answer['ponderation'],
                        'position' => $answer['position'],
                        'hotspot_coordinates' => $answer['hotspot_coordinates'],
                        'hotspot_type' => $answer['hotspot_type'],
                        'id_auto' => 0,
                        'destination' => '',
                    ];

                    $answerId = Database::insert($table_ans, $params);

                    if ($answerId) {
                        $sql = "UPDATE $table_ans SET id = iid, id_auto = iid WHERE iid = $answerId";
                        Database::query($sql);
                    }

                    $correctAnswers[$answerId] = $answer['correct'];
                    $onlyAnswers[$answerId] = $answer['answer'];
				}
			}

            // Current course id
            $course_id = api_get_course_int_id();

            // Moving quiz_question_options
            if ($question->quiz_type == MULTIPLE_ANSWER_TRUE_FALSE) {
                $question_option_list = Question::readQuestionOption($id, $course_id);

                // Question copied from the current platform
                if ($question_option_list) {
                    $old_option_ids = array();
                    foreach ($question_option_list as $item) {
                        $old_id = $item['id'];
                        unset($item['id']);
                        if (isset($item['iid'])) {
                            unset($item['iid']);
                        }
                        $item['question_id'] = $new_id;
                        $item['c_id'] = $this->destination_course_id;
                        $question_option_id = Database::insert($table_options, $item);
                        if ($question_option_id) {
                            $old_option_ids[$old_id] = $question_option_id;
                            $sql = "UPDATE $table_options SET id = iid WHERE iid = $question_option_id";
                            Database::query($sql);
                        }
                    }
                    if ($old_option_ids) {
                        $new_answers = Database::select(
                            'iid, correct',
                            $table_ans,
                            array(
                                'WHERE' => array(
                                    'question_id = ? AND c_id = ? ' => array(
                                        $new_id,
                                        $this->destination_course_id,
                                    ),
                                ),
                            )
                        );

                        foreach ($new_answers as $answer_item) {
                            $params = array();
                            $params['correct'] = $old_option_ids[$answer_item['correct']];
                            Database::update(
                                $table_ans,
                                $params,
                                array(
                                    'iid = ? AND c_id = ? AND question_id = ? ' => array(
                                        $answer_item['iid'],
                                        $this->destination_course_id,
                                        $new_id,
                                    ),
                                ),
                                false
                            );
                        }
                    }
                } else {
                    $new_options = array();
                    if (isset($question->question_options)) {
                        foreach ($question->question_options as $obj) {
                            $item = array();
                            $item['question_id'] = $new_id;
                            $item['c_id'] = $this->destination_course_id;
                            $item['name'] = $obj->obj->name;
                            $item['position'] = $obj->obj->position;
                            $question_option_id = Database::insert($table_options, $item);

                            if ($question_option_id) {
                                $new_options[$obj->obj->id] = $question_option_id;
                                $sql = "UPDATE $table_options SET id = iid WHERE iid = $question_option_id";
                                Database::query($sql);
                            }
                        }

                        foreach ($correctAnswers as $answer_id => $correct_answer) {
                            $params = array();
                            $params['correct'] = $new_options[$correct_answer];
                            Database::update(
                                $table_ans,
                                $params,
                                array(
                                    'id = ? AND c_id = ? AND question_id = ? ' => array(
                                        $answer_id,
                                        $this->destination_course_id,
                                        $new_id,
                                    ),
                                ),
                                false
                            );
                        }
                    }
                }
            }

            // Fix correct answers
            if (in_array($question->quiz_type, [DRAGGABLE, MATCHING, MATCHING_DRAGGABLE])) {
                $onlyAnswersFlip = array_flip($onlyAnswers);
                foreach ($correctAnswers as $answer_id => $correct_answer) {
                    $params = array();
                    if (isset($allAnswers[$correct_answer]) &&
                        isset($onlyAnswersFlip[$allAnswers[$correct_answer]])
                    ) {
                        $params['correct'] = $onlyAnswersFlip[$allAnswers[$correct_answer]];
                        Database::update(
                            $table_ans,
                            $params,
                            array(
                                'id = ? AND c_id = ? AND question_id = ? ' => array(
                                    $answer_id,
                                    $this->destination_course_id,
                                    $new_id,
                                ),
                            )
                        );
                    }
                }
            }

			$this->course->resources[RESOURCE_QUIZQUESTION][$id]->destination_id = $new_id;
		}

		return $new_id;
	}