Justification

Complexity

Total Complexity

9

Size/Duplication

Total Lines	94
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	getJustification()	0	8	1
A	getList()	0	6	1
A	uninstall()	0	7	1
A	create()	0	5	2
A	__construct()	0	8	1
A	getUserJustification()	0	8	1
A	getUserJustificationList()	0	8	1
A	install()	0	20	1

<?php
/* For license terms, see /license.txt */

class Justification extends Plugin
{
    protected function __construct()
    {
        parent::__construct(
            '1.1',
            'Julio Montoya',
            [
                'tool_enable' => 'boolean',
                'default_course_id' => 'text',
            ]
        );
    }

    /**
     * @return $this
     */
    public static function create()
    {
        static $result = null;

        return $result ? $result : $result = new self();
    }

    public function getJustification($id)
    {
        $id = (int) $id;

        $sql = 'SELECT * FROM justification_document WHERE id = '.$id;
        $query = Database::query($sql);

        return Database::fetch_array($query, 'ASSOC');
    }

    public function getUserJustificationList($userId)
    {
        $userId = (int) $userId;

        $sql = "SELECT * FROM justification_document_rel_users WHERE user_id = $userId ";
        $query = Database::query($sql);

        return Database::store_result($query, 'ASSOC');
    }

    public function getUserJustification($id)
    {
        $id = (int) $id;

        $sql = "SELECT * FROM justification_document_rel_users WHERE id = $id ";
        $query = Database::query($sql);

        return Database::fetch_array($query, 'ASSOC');
    }

    public function getList()
    {
        $sql = 'SELECT * FROM justification_document ORDER BY name ';
        $query = Database::query($sql);

        return Database::store_result($query, 'ASSOC');
    }

    /**
     * Install.
     */
    public function install()
    {
        $sql = "CREATE TABLE IF NOT EXISTS justification_document (
            id INT unsigned NOT NULL auto_increment PRIMARY KEY,
            code TEXT NULL,
            name TEXT NULL,
            validity_duration INT,
            comment TEXT NULL,
            date_manual_on INT
        )";
        Database::query($sql);

        $sql = "CREATE TABLE IF NOT EXISTS justification_document_rel_users (
            id INT unsigned NOT NULL auto_increment PRIMARY KEY,
            justification_document_id INT NOT NULL,
            file_path VARCHAR(255),
            user_id INT,
            date_validity DATE
        )";
        Database::query($sql);
    }

    public function uninstall()
    {
        $sql = 'DROP TABLE IF EXISTS justification_document';
        Database::query($sql);

        $sql = 'DROP TABLE IF EXISTS justification_document_rel_users';
        Database::query($sql);
    }
}