<?php

class Page extends BaseClass {

    ////////////////
    // Properties //
    ////////////////

    public $Id;
    public $Language;
    public $PageTitle;
    public $Slug;
    public $PageDescription;
    public $Active;
    public $HorizontalColumns;
    public $ContentType;
    public $Component;
    public $Template;

    public static $_primaryKey = array("Id", "Language");

    ////////////////////
    // Public Methods //
    ////////////////////

    public static function Select($Id)
    {
        return parent::Select($Id);
    }

    public static function SelectByMenu($Id)
    {
        return parent::SelectObjects("SELECT *
									  FROM Page
									  WHERE MenuId = '" . intval($Id) . "'");
    }

    public static function CheckSlug($slug)
    {
        return (parent::_db()->result(parent::_db()->query("SELECT COUNT(*) FROM Page WHERE Slug = '" . parent::_db()->escape($slug) . "'"),0) > 0);
    }

    public static function SelectBySlug($slug, $lang)
    {
        return reset(parent::SelectObjects("SELECT * FROM Page WHERE Slug = '". parent::_db()->escape($slug) ."' AND Language = '".parent::_db()->escape($lang)."'"));
    }

    public static function SelectByLang($lang)
    {
        return parent::SelectObjects("SELECT * FROM Page WHERE `Language` = '".parent::_db()->escape($lang)."'");
    }

    public static function SelectAll()
    {
        return parent::SelectAll();
    }

    public static function SelectAllWithMenu()
    {
        $pages = parent::SelectAll();
        //get menu ifo
        for($i = 0; $i < count($pages); $i++)
        {
            $pages[$i]->_menus = Menu::SelectByPage($pages[$i]->Id);
        }
        //sort by menu info
        usort($pages, "Page::_sortMenu");
        return $pages;
    }

    public function Insert()
    {
        return parent::Insert();
    }

    public function Update()
    {
        parent::Update();
    }

    public function Delete()
    {
        parent::Delete();
    }


    private static function _sortMenu($a, $b)
    {
        if($a->_menus->Sort == $b->_menus->Sort) return 0;
        if($a->_menus->Sort > $b->_menus->Sort) return 1;
        return -1;
    }

}
?>