citywebshop_cms/application/models/blog_model.php

<?php

class blog_model extends Model {

    public function getPage($slug) {
        $slug = $this->escapeString($slug);
        $result = $this->query("SELECT * FROM azonics_blog WHERE page_slug='".$slug."' AND page_status='1';");
        if (sizeof($result)>0) {
            return $result[0];
        }
        else {
            return false;
        }
    }


    public function getList($slug='') {
        $result = $this->query("SELECT * FROM azonics_blog WHERE page_status='1' AND page_slug <> '".$slug."' ORDER BY page_date DESC;");
        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;
        }
    }

}