citywebshop_cms/application/models/pages_model.php

<?php

class pages_model extends Model {

    public function getPage($slug, $lang = 'en') {
        $slug = $this->escapeString($slug);
        $result = $this->query("SELECT * FROM azonics_pages WHERE page_slug='".$slug."' AND page_status='1';");
        if (sizeof($result)>0) {
            if ($lang == 'hu') {
                $data['title'] = $result[0]->page_title;
                $data['content'] = $result[0]->page_content;
            }
            else {
                $data['title'] = $result[0]->page_title_en;
                $data['content'] = $result[0]->page_content_en;
            }
            return $data;
        }
        else {
            return false;
        }
    }

    public function getPackages() {
        $result = $this->query("SELECT * FROM azonics_packages WHERE box_status='1' ORDER BY box_id ASC;");
        if (sizeof($result)>0) {
            return $result;
        }
        else {
            return false;
        }
    }

    public function getPackage($id) {
        $result = $this->query("SELECT * FROM azonics_packages WHERE box_id='".$id."';");
        if (sizeof($result)>0) {
            return $result[0];
        }
        else {
            return false;
        }
    }

    public function getBlocks($id) {
        $result = $this->query("SELECT * FROM azonics_package_blocks WHERE box_id='".$id."' AND block_status<>'0' ORDER BY block_order ASC;");
        if (sizeof($result)>0) {
            return $result;
        }
        else {
            return false;
        }
    }

    public function getMenu() {
        $i = 0;
        $mains = $this->query("SELECT * FROM menu WHERE menu_status='1' AND menu_parent='0' ORDER BY menu_order ASC;");
        if (sizeof($mains)>0) {
            foreach ($mains as $main) {
                $result[$i][] = $main;
                $subs = $this->query("SELECT * FROM menu WHERE menu_status='1' AND menu_parent='".$main->menu_id."' ORDER BY menu_order ASC;");
                if (sizeof($subs)>0) {
                    foreach ($subs as $sub) {
                        $result[$i][] = $sub;
                    }
                }
                $i++;
            }
            return $result;
        }
        else {
            return false;
        }
    }


    public function getParentSlug($slug) {
        $slug = $this->escapeString($slug);
        if ($slug!=='') {
            $main = $this->query("SELECT * FROM menu WHERE menu_slug='".$slug."' AND menu_parent<>'0' AND menu_status='1';");
            if (sizeof($main)>0) {
                $parent = $this->query("SELECT * FROM menu WHERE menu_id='".$main[0]->menu_parent."' AND menu_status='1';");
                if (sizeof($parent)>0) {
                    return $parent[0]->menu_slug;
                }
                else {
                    return false;
                }
            }
            else {
                return false;
            }
        }
        else {
            return false;
        }
    }


    public function getParentName($slug) {
        $slug = $this->escapeString($slug);
        if ($slug!=='') {
            $main = $this->query("SELECT * FROM menu WHERE menu_slug='".$slug."' AND menu_parent<>'0' AND menu_status='1';");
            if (sizeof($main)>0) {
                $parent = $this->query("SELECT * FROM menu WHERE menu_id='".$main[0]->menu_parent."' AND menu_status='1';");
                if (sizeof($parent)>0) {
                    return $parent[0]->menu_name;
                }
                else {
                    return false;
                }
            }
            else {
                return false;
            }
        }
        else {
            return false;
        }
    }

}