ModelExtensionModule

Complexity

Total Complexity

8

Size/Duplication

Total Lines	88
Duplicated Lines	0 %

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	getModule()	0	11	2
A	getModules()	0	9	1
A	addModule()	0	7	1
A	editModule()	0	7	1
A	deleteModule()	0	11	1
A	getModulesByCode()	0	13	1
A	deleteModulesByCode()	0	12	1

<?php

/* 	Divine CMS - Open source CMS for widespread use.
    Copyright (c) 2019 Mykola Burakov (burakov.work@gmail.com)

    See SOURCE.txt for other and additional information.

    This file is part of Divine CMS.

    This program is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program. If not, see <http://www.gnu.org/licenses/>. */

class ModelExtensionModule extends \Divine\Engine\Core\Model

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

{
    public function addModule($code, $data)

Expected 2 blank lines before function; 0 found

    {
        $this->db->query("
            INSERT INTO `module` 
            SET `name` = '" . $this->db->escape($data['name']) . "', 
                `code` = '" . $this->db->escape($code) . "', 
                `setting` = '" . $this->db->escape(json_encode($data)) . "'
        ");
    }

    public function editModule($module_id, $data)
    {
        $this->db->query("
            UPDATE `module` 
            SET `name` = '" . $this->db->escape($data['name']) . "', 
                `setting` = '" . $this->db->escape(json_encode($data)) . "' 
            WHERE `module_id` = '" . (int) $module_id . "'
        ");
    }

    public function deleteModule($module_id)
    {
        $this->db->query("
            DELETE 
            FROM `module` 
            WHERE `module_id` = '" . (int) $module_id . "'
        ");
        $this->db->query("
            DELETE 
            FROM `layout_module` 
            WHERE `code` LIKE '%." . (int) $module_id . "'
        ");
    }

    public function getModule($module_id)
    {
        $query = $this->db->query("
            SELECT * FROM `module` 
            WHERE `module_id` = '" . (int) $module_id . "'
        ");

        if ($query->row) {
            return json_decode($query->row['setting'], true);
        } else {
            return array();
        }
    }

    public function getModules()
    {
        $query = $this->db->query("

The string literal \n SELECT * \n FROM `module` \n ORDER BY `code`\n does not require double quotes, as per coding-style, please use single quotes.

            SELECT * 
            FROM `module` 
            ORDER BY `code`
        ");

        return $query->rows;
    }

    public function getModulesByCode($code)
    {
        $query = $this->db->query("
            SELECT 
                *
            FROM
                `module`
            WHERE
                `code` = '" . $this->db->escape($code) . "'
            ORDER BY `name`
        ");

        return $query->rows;
    }

    public function deleteModulesByCode($code)
    {
        $this->db->query("
            DELETE 
            FROM `module` 
            WHERE `code` = '" . $this->db->escape($code) . "'
        ");
        $this->db->query("
            DELETE 
            FROM `layout_module` 
            WHERE `code` LIKE '" . $this->db->escape($code) . "' 
                OR `code` LIKE '" . $this->db->escape($code . '.%') . "'
        ");
    }
}