File Manager

X7ROOT File Manager

Current Path: /home/jurarevi/beta.jurareview.ro/application/models

home / jurarevi / beta.jurareview.ro / application / models /

📁 ..
📄 announcements_model.php(1.01 KB)
📄 chapters_model.php(5.22 KB)
📄 headerfooter_model.php(1.05 KB)
📄 index.html(114 B)
📄 menu_model.php(2.28 KB)
📄 miscconfig_model.php(1.98 KB)
📄 pagini_model.php(1.22 KB)
📄 sidebars_model.php(873 B)
📄 volumes_model.php(3.9 KB)

Editing: menu_model.php

<?php

class Menu_Model extends MY_Model {

public function getMenuList()
    {
        $sql = "
            SELECT * FROM Menu WHERE `deleted` = 0
        ";

$query = $this->db->query($sql);
        return $query->result_array();
    }

public function getFormatedMenuList()
    {
        $sql = "
            SELECT * FROM Menu WHERE `deleted` = 0 ORDER BY id ASC
        ";

$query = $this->db->query($sql);
        $results = $query->result_array();
        $menus = array();
        $children = array();
        foreach ($results as $result) {
            if (-1 != $result['parent']) {
                $children[] = $result;
            } else {
                $menus[$result['id']] = $result;
            }
        }

if (!empty($children) && is_array($children)) {
            foreach ($children as $child) {
                if (!isset($menus[$child['parent']]['children'])) {
                    $menus[$child['parent']]['children'] = array();
                }
                $menus[$child['parent']]['children'][] = $child;
            }
        }
        return $menus;
    }

public function getMenuById($id)
    {
        $sql = "
            SELECT * FROM Menu WHERE `deleted` = 0 AND `id` = " . $id . "
        ";

$query = $this->db->query($sql);
        return $query->row_array();
    }

public function insertMenu($text, $url, $parent)
    {
        $sql = "
            INSERT INTO `Menu` (`text`, `url`, `parent`) VALUES ('" . $text . "', '" . $url . "', " . $parent . ")
        ";

$query = $this->db->query($sql);
        return true;
    }

public function updateMenu($id, $text, $url, $parent)
    {
        $sql = "
            UPDATE `Menu` 
            SET 
                `text` = '" . $text . "',
                `url` = '" . $url . "',
                `parent` = " . $parent . "
            WHERE `id` = " . $id . "
        ";

$query = $this->db->query($sql);
        return true;
    }

public function deleteMenu($id)
    {
        $sql = "
            UPDATE `Menu` 
            SET 
                `deleted` = 1
            WHERE `id` = " . $id . "
        ";

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

}
}

X7ROOT File Manager

Editing: menu_model.php

Upload File

Create Folder