class.ilWikiPageTemplate.php

Go to the documentation of this file.

<?php
 
class ilWikiPageTemplate
{
    public const TYPE_ALL = 0;
    public const TYPE_NEW_PAGES = 1;
    public const TYPE_ADD_TO_PAGE = 2;
 
    protected ilDBInterface $db;
    protected int $wiki_id;
 
    public function __construct(
        int $a_wiki_id
    ) {
        global $DIC;
 
        $this->wiki_id = $a_wiki_id;
        $this->db = $DIC->database();
    }
 
    public function getAllInfo(
        int $a_type = self::TYPE_ALL,
        string $lang = "-"
    ): array {
        if ($lang === "") {
            $lang = "-";
        }
        $and = "";
        if ($a_type === self::TYPE_NEW_PAGES) {
            $and = " AND t.new_pages = " . $this->db->quote(1, "integer");
        }
        if ($a_type === self::TYPE_ADD_TO_PAGE) {
            $and = " AND t.add_to_page = " . $this->db->quote(1, "integer");
        }
 
        $set = $this->db->queryF(
            $q = "SELECT t.wiki_id, t.wpage_id, p.title, t.new_pages, t.add_to_page FROM wiki_page_template t JOIN il_wiki_page p ON " .
            " (t.wpage_id = p.id AND p.lang = %s) " .
            " WHERE t.wiki_id = %s " .
            $and,
            ["text", "integer"],
            [$lang, $this->wiki_id]
        );
        $templates = array();
        while ($rec = $this->db->fetchAssoc($set)) {
            $templates[] = $rec;
        }
        return $templates;
    }
 
    public function save(
        int $a_id,
        int $a_new_pages = 0,
        int $a_add_to_page = 0
    ): void {
        if ($a_id <= 0) {
            return;
        }
 
        $set = $this->db->query(
            "SELECT * FROM wiki_page_template " .
            " WHERE wiki_id = " . $this->db->quote($this->wiki_id, "integer") .
            " AND wpage_id = " . $this->db->quote($a_id, "integer")
        );
        if (!$this->db->fetchAssoc($set)) {
            $this->db->manipulate("INSERT INTO wiki_page_template " .
                "(wiki_id, wpage_id, new_pages, add_to_page) VALUES (" .
                $this->db->quote($this->wiki_id, "integer") . "," .
                $this->db->quote($a_id, "integer") . "," .
                $this->db->quote($a_new_pages, "integer") . "," .
                $this->db->quote($a_add_to_page, "integer") .
                ")");
        } else {
            $this->db->manipulate(
                "UPDATE wiki_page_template SET " .
                " new_pages = " . $this->db->quote($a_new_pages, "integer") . "," .
                " add_to_page = " . $this->db->quote($a_add_to_page, "integer") .
                " WHERE wiki_id = " . $this->db->quote($this->wiki_id, "integer") .
                " AND wpage_id = " . $this->db->quote($a_id, "integer")
            );
        }
    }
 
    public function remove(
        int $a_id
    ): void {
        $this->db->manipulate(
            "DELETE FROM wiki_page_template WHERE " .
            " wiki_id = " . $this->db->quote($this->wiki_id, "integer") .
            " AND wpage_id = " . $this->db->quote($a_id, "integer")
        );
    }
 
    public function isPageTemplate(int $a_id): bool
    {
        $set = $this->db->query("SELECT t.wpage_id" .
            " FROM wiki_page_template t" .
            " JOIN il_wiki_page p ON " .
            " (t.wpage_id = p.id) " .
            " WHERE t.wiki_id = " . $this->db->quote($this->wiki_id, "integer") .
            " AND p.id = " . $this->db->quote($a_id, "integer"));
        return (bool) $this->db->numRows($set);
    }
}