Egzaminer\Model\QuestionEditModel

Complexity

Total Complexity

8

Size/Duplication

Total Lines	77
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	edit()	0	5	2
B	editQuestion()	0	26	4
A	editAnswers()	0	14	2

<?php

namespace Egzaminer\Model;

use PDO;

class QuestionEditModel extends AbstractModel
{
    /**
     * Edit question.
     *
     * @param int $questionID
     * @param array $post
     * @param array $thumbUpload
     * @param string $rootDir
     *
     * @return bool
     */
    public function edit($questionID, $post, $thumbUpload, $rootDir)
    {
        return $this->editQuestion($questionID, $post['question'], $thumbUpload, $rootDir)
        && $this->editAnswers($post['answers']);
    }

    /**
     * Edit question in exam.
     *
     * @param int    $questionID
     * @param array  $question
     * @param array  $thumbUpload
     * @param string $rootDir
     *
     * @return book
     */
    private function editQuestion($questionID, $question, $thumbUpload, $rootDir)
    {
        $stmt = $this->db->prepare('UPDATE questions SET content = :content,
            correct = :correct WHERE id = :id');
        $stmt->bindValue(':content', trim($question['content']), PDO::PARAM_STR);
        $stmt->bindValue(':correct', $question['correct'], PDO::PARAM_INT);
        $stmt->bindValue(':id', $questionID, PDO::PARAM_INT);
        $status = $stmt->execute();

        if (isset($question['delete-img'])) {
            array_map('unlink', glob($rootDir.'/public/storage/'.$questionID.'_*'));
            $stmt = $this->db->prepare('UPDATE questions SET image = \'\' WHERE id = ?');
            $stmt->execute([$questionID]);
        } elseif (!empty($thumbUpload['name'])) {
            if (is_uploaded_file($thumbUpload['tmp_name'])) {
                array_map('unlink', glob($rootDir.'/public/storage/'.$questionID.'_*'));
                $file = $rootDir.'/public/storage/'.$questionID.'_'.$thumbUpload['name'];
                move_uploaded_file($thumbUpload['tmp_name'], $file);
            }

            $stmt = $this->db->prepare('UPDATE questions SET image = ? WHERE id = ?');
            $stmt->execute([$thumbUpload['name'], $questionID]);
        }

        return $status;
    }

    /**
     * Edit answers in exam.
     *
     * @param array $answers
     *
     * @return bool
     */
    private function editAnswers($answers)
    {
        $stmt = $this->db->prepare('UPDATE answers SET content = :content
            WHERE id = :id');
        $this->db->beginTransaction();

        foreach ($answers as $key => $value) {
            $stmt->bindValue(':content', trim($value), PDO::PARAM_STR);
            $stmt->bindValue(':id', $key, PDO::PARAM_INT);
            $stmt->execute();
        }

        return $this->db->commit();
    }
}