class.ilXHTMLPage.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilXHTMLPage
{
    protected $db;

    public $id = 0;
    public $content = "";

    public function __construct($a_id = 0)
    {
        global $DIC;

        $this->db = $DIC->database();
        if ($a_id > 0) {
            $this->setId($a_id);
            $this->read();
        }
    }
    
    public function getId()
    {
        return $this->id;
    }
    
    public function setId($a_id)
    {
        $this->id = $a_id;
    }

    public function getContent()
    {
        return $this->content;
    }
    
    public function setContent($a_content)
    {
        $this->content = $a_content;
    }

    public function read()
    {
        $ilDB = $this->db;
        
        $set = $ilDB->query("SELECT * FROM xhtml_page WHERE id = " .
            $ilDB->quote($this->getId(), "integer"));
        if ($rec = $ilDB->fetchAssoc($set)) {
            $this->setContent($rec["content"]);
        }
    }
    
    public static function _lookupContent($a_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $set = $ilDB->query("SELECT content FROM xhtml_page WHERE id = " .
            $ilDB->quote($a_id, "integer"));
        if ($rec = $ilDB->fetchAssoc($set)) {
            return $rec["content"];
        }
    }

    public static function _lookupSavedContent($a_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $set = $ilDB->query("SELECT save_content FROM xhtml_page WHERE id = " .
            $ilDB->quote($a_id, "integer"));
        if ($rec = $ilDB->fetchAssoc($set)) {
            return $rec["save_content"];
        }
    }

    public function save()
    {
        $ilDB = $this->db;
        
        if ($this->getId() > 0) {
            $old_content = ilXHTMLPage::_lookupContent($this->getId());
            $ilDB->update("xhtml_page", array(
                "content" => array("clob", $this->getContent()),
                "save_content" => array("clob", $old_content)
                ), array(
                "id" => array("integer", $this->getId())
                ));
        } else {
            $this->setId($ilDB->nextId("xhtml_page"));
            $ilDB->insert("xhtml_page", array(
                "id" => array("integer", $this->getId()),
                "content" => array("clob", $this->getContent())
                ));
        }
    }
    
    public function undo()
    {
        $ilDB = $this->db;
        
        if ($this->getId() > 0) {
            $content = ilXHTMLPage::_lookupContent($this->getId());
            $save_content = ilXHTMLPage::_lookupSavedContent($this->getId());
            $ilDB->update("xhtml_page", array(
                "content" => array("clob", $save_content),
                "save_content" => array("clob", $content)
                ), array(
                "id" => array("integer", $this->getId())
                ));
        }
    }

    public function clear()
    {
        $ilDB = $this->db;
        
        if ($this->getId() > 0) {
            $this->setContent("");
            $this->save();
        }
    }
}