ILIAS\COPage\Page\PageDBRepository Class Reference

Collaboration diagram for ILIAS\COPage\Page\PageDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db)
	lookupParentId (int $page_id, string $parent_type)
	writeParentId (string $parent_type, int $page_id, int $parent_id)
	writeActive (int $page_id, string $parent_type, bool $active)
	getActivationDataByParentId (int $parent_id)
	getActivationData (int $page_id, string $parent_type, string $lang)
	lookupContainsDeactivatedElements (int $page_id, string $parent_type, string $lang)
	getParentObjectContributorData (string $parent_type, int $parent_id, string $lang)
	getPageContributorData (string $parent_type, int $page_id, string $lang)

Protected Attributes
ilDBInterface	$db

Detailed Description

Author

Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 26 of file class.PageDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\COPage\Page\PageDBRepository::__construct

(

\ilDBInterface

$db

)

Definition at line 30 of file class.PageDBRepository.php.

    {
        $this->db = $db;
    }

References ILIAS\COPage\Page\PageDBRepository\$db.

Member Function Documentation

getActivationData()

ILIAS\COPage\Page\PageDBRepository::getActivationData	(	int	$page_id,
		string	$parent_type,
		string	$lang
	)

Definition at line 84 of file class.PageDBRepository.php.

                                                                                      : ?array
    {
        $set = $this->db->queryF(
            "SELECT active, activation_start, activation_end, show_activation_info " .
            "FROM page_object WHERE page_id = %s AND parent_type = %s AND lang = %s",
            ["integer", "text", "text"],
            [$page_id, $parent_type, $lang]
        );
        $record = $this->db->fetchAssoc($set);
        return $record ?: null;
    }

getActivationDataByParentId()

ILIAS\COPage\Page\PageDBRepository::getActivationDataByParentId

(

int

$parent_id

)

Returns

list<array<string, mixed>>

Definition at line 69 of file class.PageDBRepository.php.

                                                               : array
    {
        $set = $this->db->queryF(
            "SELECT page_id, parent_type, lang, active, activation_start, activation_end, show_activation_info " .
            "FROM page_object WHERE parent_id = %s",
            ["integer"],
            [$parent_id]
        );
        $records = [];
        while ($record = $this->db->fetchAssoc($set)) {
            $records[] = $record;
        }
        return $records;
    }

getPageContributorData()

ILIAS\COPage\Page\PageDBRepository::getPageContributorData	(	string	$parent_type,
		int	$page_id,
		string	$lang
	)

Returns

array{pages: list<array<string, mixed>>, history: list<array<string, mixed>>}

Definition at line 157 of file class.PageDBRepository.php.

     : array {
        $and_lang = $lang !== "" ? " AND lang = %s" : "";
        $types = ["integer", "text", "integer"];
        $values = [$page_id, $parent_type, 0];
        if ($lang !== "") {
            $types[] = "text";
            $values[] = $lang;
        }
 
        $pages = [];
        $set = $this->db->queryF(
            "SELECT last_change_user, lang FROM page_object " .
            " WHERE page_id = %s AND parent_type = %s " .
            " AND last_change_user != %s" . $and_lang,
            $types,
            $values
        );
        while ($page = $this->db->fetchAssoc($set)) {
            $pages[] = $page;
        }
 
        $history = [];
        $set = $this->db->queryF(
            "SELECT count(*) as cnt, lang, page_id, user_id FROM page_history " .
            " WHERE page_id = %s AND parent_type = %s AND user_id != %s " . $and_lang .
            " GROUP BY user_id, page_id, lang ",
            $types,
            $values
        );
        while ($page = $this->db->fetchAssoc($set)) {
            $history[] = $page;
        }
 
        return ["pages" => $pages, "history" => $history];
    }

getParentObjectContributorData()

ILIAS\COPage\Page\PageDBRepository::getParentObjectContributorData	(	string	$parent_type,
		int	$parent_id,
		string	$lang
	)

Returns

array{pages: list<array<string, mixed>>, history: list<array<string, mixed>>}

Definition at line 114 of file class.PageDBRepository.php.

     : array {
        $and_lang = $lang !== "" ? " AND lang = %s" : "";
        $types = ["integer", "text", "integer"];
        $values = [$parent_id, $parent_type, 0];
        if ($lang !== "") {
            $types[] = "text";
            $values[] = $lang;
        }
 
        $pages = [];
        $set = $this->db->queryF(
            "SELECT last_change_user, lang, page_id FROM page_object " .
            " WHERE parent_id = %s AND parent_type = %s " .
            " AND last_change_user != %s" . $and_lang,
            $types,
            $values
        );
        while ($page = $this->db->fetchAssoc($set)) {
            $pages[] = $page;
        }
 
        $history = [];
        $set = $this->db->queryF(
            "SELECT count(*) as cnt, lang, page_id, user_id FROM page_history " .
            " WHERE parent_id = %s AND parent_type = %s AND user_id != %s " . $and_lang .
            " GROUP BY page_id, user_id, lang ",
            $types,
            $values
        );
        while ($page = $this->db->fetchAssoc($set)) {
            $history[] = $page;
        }
 
        return ["pages" => $pages, "history" => $history];
    }

lookupContainsDeactivatedElements()

ILIAS\COPage\Page\PageDBRepository::lookupContainsDeactivatedElements	(	int	$page_id,
		string	$parent_type,
		string	$lang
	)

Definition at line 96 of file class.PageDBRepository.php.

     : bool {
        $set = $this->db->queryF(
            "SELECT page_id FROM page_object " .
            "WHERE page_id = %s AND parent_type = %s AND lang = %s " .
            "AND inactive_elements = %s",
            ["integer", "text", "text", "integer"],
            [$page_id, $parent_type, $lang, 1]
        );
        return (bool) $this->db->fetchAssoc($set);
    }

lookupParentId()

ILIAS\COPage\Page\PageDBRepository::lookupParentId	(	int	$page_id,
		string	$parent_type
	)

Definition at line 35 of file class.PageDBRepository.php.

                                                                     : int
    {
        $set = $this->db->queryF(
            "SELECT parent_id FROM page_object WHERE page_id = %s AND parent_type = %s",
            ["integer", "text"],
            [$page_id, $parent_type]
        );
        $record = $this->db->fetchAssoc($set);
        return (int) ($record["parent_id"] ?? 0);
    }

writeActive()

ILIAS\COPage\Page\PageDBRepository::writeActive	(	int	$page_id,
		string	$parent_type,
		bool	$active
	)

Definition at line 55 of file class.PageDBRepository.php.

                                                                                : void
    {
        $this->db->manipulateF(
            "UPDATE page_object SET active = %s, activation_start = %s, " .
            " activation_end = %s WHERE page_id = %s" .
            " AND parent_type = %s AND lang = %s",
            ["int", "timestamp", "timestamp", "integer", "text", "text"],
            [(int) $active, null, null, $page_id, $parent_type, "-"]
        );
    }

writeParentId()

ILIAS\COPage\Page\PageDBRepository::writeParentId	(	string	$parent_type,
		int	$page_id,
		int	$parent_id
	)

Definition at line 46 of file class.PageDBRepository.php.

                                                                                    : void
    {
        $this->db->manipulateF(
            "UPDATE page_object SET parent_id = %s WHERE page_id = %s AND parent_type = %s",
            ["integer", "integer", "text"],
            [$parent_id, $page_id, $parent_type]
        );
    }

Field Documentation

$db

ilDBInterface ILIAS\COPage\Page\PageDBRepository::$db

protected

Definition at line 28 of file class.PageDBRepository.php.

Referenced by ILIAS\COPage\Page\PageDBRepository\__construct().

---

The documentation for this class was generated from the following file:

• components/ILIAS/COPage/Page/class.PageDBRepository.php