citywebshop_cms/application/models/admin_menueditor_model.php

<?php

class admin_menueditor_model extends Model {
    
    
    public function getMenus() {
        $result = $this->query("select * from azonics_menus where box_status<>'0';");
        return $result;
    }
    
    
    public function loadMenu() {
        $box_id = $this->escapeString($_REQUEST['id']);
        $row = $this->query("select * from azonics_menus where box_id='".$box_id."';");
        return $row[0];
    }
    
    
    public function saveMenu() {
        $data = $this->escapeArray($_REQUEST);
        
        if ($data['box_id']!='') {
            $this->execute("update azonics_menus set "
                    . "box_title='".$data['box_title']."', "
                    . "box_subtitle='".$data['box_subtitle']."', "
                    . "box_url='".$data['box_url']."' "
                    . "where box_id='".$data['box_id']."';");
            
            return true;
        }
        else {
            $this->execute("insert into azonics_menus set "
                . "box_title='".$data['box_title']."', "
                . "box_subtitle='".$data['box_subtitle']."', "
                . "box_url='".$data['box_url']."', "
                . "box_status='1', "
                . "box_user='".$_SESSION['admin_user']->admin_id."';");

            return true;
        }
    }
    
    
    public function deleteMenu() {
        $box_id = $this->escapeString($_REQUEST['id']);
        $this->execute("update azonics_menus set box_status='0' where box_id='".$box_id."';");
        return true;
    }
    
    
}