ModelDesignCustomMenu::getChildcustommenus() - Code Metrics - Nickbur/Sunrise-CMS - Measure and Improve Code Quality continuously with Scrutinizer

ModelDesignCustomMenu::getChildcustommenus() A
last analyzed 2019-09-02 14:26 UTC

↳ Parent: ModelDesignCustomMenu

Complexity

Conditions	3
Paths	2

Size

Total Lines	21
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	3
eloc	8
c	0
b	0
f	0
nc	2
nop	0
dl	0
loc	21
rs	10

<?php

/* 	Divine CMS - Open source CMS for widespread use.
    Copyright (c) 2019 Mykola Burakov ([email protected])

    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 ModelDesignCustomMenu extends \Divine\Engine\Core\Model
namespace YourVendor;

class YourClass { }
{
    public function getcustommenus()

    {
        $data = array();

        $sql = "
            SELECT * 
            FROM `custommenu` m 
            LEFT JOIN custommenu_description md ON (m.custommenu_id = md.custommenu_id) 
            WHERE md.language_id = '" . (int)$this->config->get('config_language_id') . "' 
            ORDER BY m.sort_order
        ";

        $query = $this->db->query($sql);

        if ($query->rows) {
            foreach ($query->rows as $custommenu) {
                $data[$custommenu['custommenu_id']] = $custommenu;
            }
        }

        return $data;
    }

    public function getChildcustommenus()
    {
        $data = array();

        $sql = "
            SELECT * 
            FROM `custommenu_child` mc 
            LEFT JOIN custommenu_child_description mcd ON (mc.custommenu_child_id = mcd.custommenu_child_id) 
            WHERE mcd.language_id = '" . (int)$this->config->get('config_language_id') . "' 
            ORDER BY mc.sort_order
        ";

        $query = $this->db->query($sql);

        if ($query->rows) {
            foreach ($query->rows as $custommenu_child) {
                $data[$custommenu_child['custommenu_child_id']] = $custommenu_child;
            }
        }

        return $data;
    }

    public function add($data, $languages)
    {
        $this->db->query("
            INSERT INTO custommenu 
            SET sort_order= '1', 
                columns = '1', 
                custommenu_type = '" . $this->db->escape($data['type']) . "', 
                status = '1'
        ");

        $custommenu_id = $this->db->getLastId();

        if ($data['type'] == 'custom') {
            $link = $data['link'];

            $data['custommenu_desc'] = array();
            
            foreach ($languages as $language) {
                $data['custommenu_desc'][] = array('name' => $data['name'], 'language_id' => $language['language_id']);
            }
        } else {
            $link = (int)$data['id'];

            if ($data['type'] == 'information') {
                $fields = 'title AS name, '.$data['type'].'_id, language_id';
            } else {
                $fields = 'name, '.$data['type'].'_id, language_id';
            }
        
            if ($data['type'] != 'manufacturer') {
                $query = $this->db->query("
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                    SELECT " . $fields . " F
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                    ROM " . $data['type'] . "_description 
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                    WHERE ". $data['type'] ."_id = '" . (int)$data['id'] . "'
                ");

                $data['custommenu_desc'] = $query->rows;
            } else {
                $fields = 'name, '.$data['type'].'_id ';
                
                $query = $this->db->query("
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                    SELECT " . $fields . " 
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                    FROM " . $data['type'] . " 
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
                    WHERE ". $data['type'] ."_id = '" . (int)$data['id'] . "'
                ");
                $result  = array();

                foreach ($languages as $language) {
                    $result[] = array('name' => $query->row['name'], 'manufacturer_id' => $query->row['manufacturer_id'], 'language_id' => $language['language_id']);
                };

                $data['custommenu_desc'] =  $result;
            }
        }

        foreach ($data['custommenu_desc'] as $desc) {
            $this->db->query("
                INSERT INTO custommenu_description 
                SET custommenu_id = '" . (int)$custommenu_id . "', 
                    language_id = '" . (int)$desc['language_id'] . "', 
                    name = '" . $this->db->escape($desc['name']) . "', 
                    link = '" . $link . "'
            ");
        }

        $custommenu = array(
            'name' =>$data['custommenu_desc'][0]['name'],
            'custommenu_type' =>$data['type'],
            'custommenu_id' => $custommenu_id
        );

        return $custommenu;
    }

    public function save($data)
    {
        foreach ($data['custommenu-item-typecustommenu'] as $key => $value) {
            $_custommenu_id = explode('-', $key);
        }
        $custommenu_id = $_custommenu_id[1];


        $this->db->query("
            UPDATE `custommenu` 
            SET columns = '" . (int)$data['custommenu_columns'] . "' 
            WHERE custommenu_id = '" . (int)$custommenu_id . "'
        ");

        $this->db->query("
            DELETE 
			FROM custommenu_description 
            WHERE custommenu_id = '" . (int)$custommenu_id . "'
        ");

        foreach ($data['custommenu_name'] as $language_id => $value) {
            $this->db->query("
                INSERT INTO custommenu_description 
                SET custommenu_id = '" . (int)$custommenu_id . "', 
                    language_id = '" . (int)$language_id . "', 
                    name = '" . $this->db->escape($value) . "', 
                    link = '" . $this->db->escape($data['custommenu_link'][$language_id]) . "'
            ");
        }
    }

    public function saveChild($data)
    {
        foreach ($data['custommenu-item-typecustommenu'] as $key => $value) {
            $_custommenu_id = explode('-', $key);
        }
        $custommenu_child_id = $_custommenu_id[1];


        $query = $this->db->query("
            SELECT * 
            FROM custommenu_child 
            WHERE custommenu_child_id = '" . (int)$custommenu_child_id . "'
        ");

        $custommenu_id = $query->row['custommenu_id'];

        $this->db->query("
            DELETE 
			FROM custommenu_child_description 
            WHERE custommenu_child_id = '" . (int)$custommenu_child_id . "'
        ");

        foreach ($data['custommenu_child_name'] as $language_id => $value) {
            $this->db->query("
                INSERT INTO custommenu_child_description 
                SET custommenu_id = '" . (int)$custommenu_id . "', 
                    custommenu_child_id = '" . (int)$custommenu_child_id . "', 
                    language_id = '" . (int)$language_id . "', 
                    name = '" . $this->db->escape($value) . "', 
                    link = '" . $this->db->escape($data['custommenu_child_link'][$language_id]) . "'
            ");
        }
    }

    public function deletecustommenu($custommenu_id)
    {
        $this->db->query("
            DELETE 
			FROM `custommenu` 
            WHERE custommenu_id = '" . (int)$custommenu_id . "'
        ");
        $this->db->query("
            DELETE 
			FROM `custommenu_description` 
            WHERE custommenu_id = '" . (int)$custommenu_id . "'
        ");
        
        $query = $this->db->query("

            SELECT * 
            FROM custommenu_child 
            WHERE custommenu_id = '" . (int)$custommenu_id . "'
        ");
        
        $this->db->query("
            DELETE 
			FROM `custommenu_child` 
            WHERE custommenu_id = '" . (int)$custommenu_id . "'
        ");
        $this->db->query("
            DELETE 
			FROM `custommenu_child_description` 
            WHERE custommenu_id = '" . (int)$custommenu_id . "'
        ");
    }

    public function deleteChildcustommenu($custommenu_child_id)
    {
        $this->db->query("
        	DELETE 
			FROM `custommenu_child` 
        	WHERE custommenu_child_id = '" . (int)$custommenu_child_id . "'
        ");
        $this->db->query("
        	DELETE 
			FROM `custommenu_child_description` 
        	WHERE custommenu_child_id = '" . (int)$custommenu_child_id . "'
        ");
    }

    public function getcustommenuDesc()
    {
        $data = array();

        $link = array();

        $query = $this->db->query("
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
            SELECT * FROM custommenu_description AS md 
            LEFT JOIN custommenu m ON (m.custommenu_id = md.custommenu_id)
        ");

        foreach ($query->rows as $result) {
            // Quick fix for multilanguage
            // Check if link exists to set for later usage
            if (!empty($result['link'])) {
                $link[$result['custommenu_id']] = $result['link'];
            }

            // Try to get the link from previous set if not already exists
            if (empty($result['link']) and !empty($link[$result['custommenu_id']])) {
                $result['link'] = $link[$result['custommenu_id']];
            }

            $data[$result['custommenu_id']][$result['language_id']] = $result;
        }

        return $data;
    }

    public function getcustommenuChildDesc()
    {
        $data = array();

        $link = array();

        $query = $this->db->query("
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
            SELECT * 
            FROM custommenu_child_description AS md 
            LEFT JOIN custommenu_child m ON (m.custommenu_child_id = md.custommenu_child_id)
        ");

        foreach ($query->rows as $result) {
            // Quick fix for multilanguage
            // Check if link exists to set for later usage
            if (!empty($result['link'])) {
                $link[$result['custommenu_child_id']] = $result['link'];
            }

            // Try to get the link from previous set if not already exists
            if (empty($result['link']) and !empty($link[$result['custommenu_child_id']])) {
                $result['link'] = $link[$result['custommenu_child_id']];
            }

            $data[$result['custommenu_child_id']][$result['language_id']] = $result;
        }

        return $data;
    }

    public function enablecustommenu($custommenu_id)
    {
        $this->db->query("
            UPDATE `custommenu` 
            SET status = '1' 
            WHERE custommenu_id = '" . (int)$custommenu_id . "'
        ");
    }

    public function enableChildcustommenu($custommenu_child_id)
    {
        $this->db->query("
            UPDATE `custommenu_child` 
            SET status = '1' 
            WHERE custommenu_child_id = '" . (int)$custommenu_child_id . "'
        ");
    }

    public function disablecustommenu($custommenu_id)
    {
        $this->db->query("
            UPDATE `custommenu` 
            SET status = '0' 
            WHERE custommenu_id = '" . (int)$custommenu_id . "'
        ");
    }

    public function disableChildcustommenu($custommenu_child_id)
    {
        $this->db->query("
            UPDATE `custommenu_child` 
            SET status = '0' 
            WHERE custommenu_child_id = '" . (int)$custommenu_child_id . "'
        ");
    }
    
    public function changecustommenuPosition($data)
    {
        $custommenuOrder = 1;
        $custommenuSubOrder = 1;

        foreach ($data['custommenu-item-db-id'] as $key => $value) {
            $custommenuType = explode('-', $key);
            
            $subcustommenu = 0;

            if (($custommenuType[0] == 'Childcustommenu') && $data['custommenu-item-parent-id'][$key] == 0) {
                $insertData = $this->db->query("
                    SELECT * 
                    FROM `custommenu_child` 
                    WHERE custommenu_child_id = '" . $custommenuType[1] . "'
                ");
                $insertDataDesc = $this->db->query("
                    SELECT * 
                    FROM `custommenu_child_description` 
                    WHERE custommenu_child_id = '" . $custommenuType[1] . "'
                ");

                $this->db->query("
                    INSERT INTO `custommenu` 
                    SET sort_order = '" . (int)$insertData->row['sort_order'] . "', 
                        columns = '1', 
                        custommenu_type = '" . $insertData->row['custommenu_type'] . "', 
                        status = '1'
                ");

                $custommenu_id = $this->db->getLastId();

                foreach ($insertDataDesc->rows as $dataDesc) {
                    $this->db->query("
                        INSERT INTO custommenu_description 
                        SET custommenu_id = '" . (int)$custommenu_id . "', 
                            language_id = '" . (int)$dataDesc['language_id'] . "', 
                            name = '" . $this->db->escape($dataDesc['name']) . "', 
                            link = '" . $this->db->escape($dataDesc['link']) . "'
                    ");
                }

                $this->db->query("
                    DELETE 
                    FROM `custommenu_child` 
                    WHERE custommenu_child_id = '" . $custommenuType[1] . "'
                ");
                $this->db->query("
                    DELETE 
			        FROM `custommenu_child_description` 
                    WHERE custommenu_child_id = '" . $custommenuType[1] . "'
                ");

                $custommenuType[0] = 'Maincustommenu';
                $custommenuType[1] = $custommenu_id;
            }

            if (($custommenuType[0] == 'Maincustommenu') && $data['custommenu-item-parent-id'][$key] <> 0) {
                $insertData = $this->db->query("
                    SELECT * 
                    FROM `custommenu` 
                    WHERE custommenu_id = '" . $custommenuType[1] . "'
                ");
                $insertDataDesc = $this->db->query("
                    SELECT * 
                    FROM `custommenu_description` 
                    WHERE custommenu_id = '" . $custommenuType[1] . "'
                ");

                $this->db->query("
                    INSERT INTO custommenu_child 
                    SET custommenu_id = '" . $data['custommenu-item-parent-id'][$key] ."', s
                        ort_order = '" . (int)$insertData->row['sort_order'] . "', 
                        custommenu_type = '" . $insertData->row['custommenu_type'] . "', 
                        status = '1'
                ");

                $custommenu_child_id = $this->db->getLastId();

                foreach ($insertDataDesc->rows as $dataDesc) {
                    $this->db->query("
                        INSERT INTO custommenu_child_description 
                        SET custommenu_id = '" . $data['custommenu-item-parent-id'][$key] . "', 
                            custommenu_child_id = '" . (int)$custommenu_child_id . "', 
                            language_id = '" . (int)$dataDesc['language_id'] . "', 
                            name = '" . $this->db->escape($dataDesc['name']) . "', 
                            link = '" . $this->db->escape($dataDesc['link']) . "'
                    ");
                }

                $this->db->query("
                    DELETE 
			        FROM `custommenu` 
                    WHERE custommenu_id = '" . $custommenuType[1] . "'
                ");
                $this->db->query("
                    DELETE 
			        FROM `custommenu_description` 
                    WHERE custommenu_id = '" . $custommenuType[1] . "'
                ");

                $custommenuType[1] = $custommenu_child_id;

                $subcustommenu = '1';
            }

            if ($custommenuType[0] == 'Maincustommenu' && empty($subcustommenu)) {
                $this->db->query("
                    UPDATE `custommenu` 
                    SET sort_order = '" . (int)$custommenuOrder . "' 
                    WHERE custommenu_id = '" . $custommenuType[1] . "'
                ");
                $custommenuOrder++;
                $custommenuSubOrder = 1;
            } else {
                $this->db->query("
                    UPDATE `custommenu_child` 
                    SET sort_order = '" . (int)$custommenuSubOrder . "', 
                        custommenu_id = '" . $data['custommenu-item-parent-id'][$key] . "' 
                    WHERE custommenu_child_id = '" . $custommenuType[1] . "'
                ");
                $this->db->query("
                    UPDATE `custommenu_child_description` 
                    SET  custommenu_id = '" . $data['custommenu-item-parent-id'][$key] . "' 
                    WHERE custommenu_child_id = '" . $custommenuType[1] . "'
                ");
                $custommenuSubOrder++;
            }
        }
    }
}


1			<?php
2
3			/* Divine CMS - Open source CMS for widespread use.
4			Copyright (c) 2019 Mykola Burakov ([email protected])
5
6			See SOURCE.txt for other and additional information.
7
8			This file is part of Divine CMS.
9
10			This program is free software: you can redistribute it and/or modify
11			it under the terms of the GNU General Public License as published by
12			the Free Software Foundation, either version 3 of the License, or
13			(at your option) any later version.
14
15			This program is distributed in the hope that it will be useful,
16			but WITHOUT ANY WARRANTY; without even the implied warranty of
17			MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18			GNU General Public License for more details.
19
20			You should have received a copy of the GNU General Public License
21			along with this program. If not, see <http://www.gnu.org/licenses/>. */
22
23			class ModelDesignCustomMenu extends \Divine\Engine\Core\Model
			0 ignored issues – show Coding Style Compatibility introduced 2019-07-29 15:05 UTC by Report Bug Copy Issue Report PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions. You can fix this by adding a namespace to your class: namespace YourVendor; class YourClass { } When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries. Loading history...
24			{
25			public function getcustommenus()
			0 ignored issues – show Coding Style introduced 2019-07-29 15:05 UTC by Report Bug Copy Issue Report Expected 2 blank lines before function; 0 found Loading history...
26			{
27			$data = array();
28
29			$sql = "
30			SELECT *
31			FROM `custommenu` m
32			LEFT JOIN custommenu_description md ON (m.custommenu_id = md.custommenu_id)
33			WHERE md.language_id = '" . (int)$this->config->get('config_language_id') . "'
34			ORDER BY m.sort_order
35			";
36
37			$query = $this->db->query($sql);
38

Nickbur / Sunrise-CMS

ModelDesignCustomMenu::getChildcustommenus() A last analyzed 2019-09-02 14:26 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

ModelDesignCustomMenu::getChildcustommenus() A
last analyzed 2019-09-02 14:26 UTC