ILIAS\COPage\ReadingTime\ReadingTimeDBRepo Class Reference

Collaboration diagram for ILIAS\COPage\ReadingTime\ReadingTimeDBRepo:

Public Member Functions
	__construct ()
	getTime (int $page_id, string $parent_type, string $lang="-")
	saveTime (int $page_id, string $parent_type, string $lang="-", int $est_reading_time=0)
	getPagesWithMissingReadingTime (string $a_parent_type, int $a_parent_id)
	getParentReadingTime (string $a_parent_type, int $a_parent_id)

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 21 of file class.ReadingTimeDBRepo.php.

Constructor & Destructor Documentation

__construct()

ILIAS\COPage\ReadingTime\ReadingTimeDBRepo::__construct

(

)

Definition at line 25 of file class.ReadingTimeDBRepo.php.

    {
        global $DIC;
        $this->db = $DIC->database();
    }

References $DIC.

Member Function Documentation

getPagesWithMissingReadingTime()

ILIAS\COPage\ReadingTime\ReadingTimeDBRepo::getPagesWithMissingReadingTime	(	string	$a_parent_type,
		int	$a_parent_id
	)

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

     : array {
        $db = $this->db;
        $q = "SELECT * FROM page_object " .
            " WHERE parent_id = " . $db->quote($a_parent_id, "integer") .
            " AND parent_type = " . $db->quote($a_parent_type, "text") .
            " AND est_reading_time = " . $db->quote(0, "integer");
 
        $set = $db->query($q);
        $pages = [];
        while ($rec = $db->fetchAssoc($set)) {
            $pages[] = [
                "parent_type" => $a_parent_type,
                "parent_id" => $a_parent_id,
                "page_id" => (int) $rec["page_id"],
                "lang" => $rec["lang"]
            ];
        }
        return $pages;
    }

References ILIAS\Repository\int().

Here is the call graph for this function:

getParentReadingTime()

ILIAS\COPage\ReadingTime\ReadingTimeDBRepo::getParentReadingTime	(	string	$a_parent_type,
		int	$a_parent_id
	)

Definition at line 92 of file class.ReadingTimeDBRepo.php.

     : int {
        $db = $this->db;
        $q = "SELECT SUM(est_reading_time) as rt FROM page_object " .
            " WHERE parent_id = " . $db->quote($a_parent_id, "integer") .
            " AND parent_type = " . $db->quote($a_parent_type, "text") .
            " AND lang = " . $db->quote("-", "text");
 
        $set = $db->query($q);
        $rec = $db->fetchAssoc($set);
        return (int) ($rec["rt"] ?? 0);
    }

getTime()

ILIAS\COPage\ReadingTime\ReadingTimeDBRepo::getTime	(	int	$page_id,
		string	$parent_type,
		string	$lang = "-"
	)

Definition at line 31 of file class.ReadingTimeDBRepo.php.

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

saveTime()

ILIAS\COPage\ReadingTime\ReadingTimeDBRepo::saveTime	(	int	$page_id,
		string	$parent_type,
		string	$lang = "-",
		int	$est_reading_time = 0
	)

Definition at line 49 of file class.ReadingTimeDBRepo.php.

     : void {
        $db = $this->db;
        $db->update(
            "page_object",
            [
            "est_reading_time" => ["integer", $est_reading_time]
        ],
            [    // where
                "page_id" => ["integer", $page_id],
                "parent_type" => ["text", $parent_type],
                "lang" => ["text", $lang],
            ]
        );
    }

Field Documentation

$db

ilDBInterface ILIAS\COPage\ReadingTime\ReadingTimeDBRepo::$db

protected

Definition at line 23 of file class.ReadingTimeDBRepo.php.

---

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

• components/ILIAS/COPage/ReadingTime/class.ReadingTimeDBRepo.php