class.ilWikiStat.php

Go to the documentation of this file.

<?php
 
class ilWikiStat
{
    public const EVENT_PAGE_CREATED = 1;
    public const EVENT_PAGE_UPDATED = 2;
    public const EVENT_PAGE_READ = 3;
    public const EVENT_PAGE_DELETED = 4;
    public const EVENT_PAGE_RATING = 5;
 
    public const KEY_FIGURE_WIKI_NUM_PAGES = 1;
    public const KEY_FIGURE_WIKI_NEW_PAGES = 2;
    public const KEY_FIGURE_WIKI_NEW_PAGES_AVG = 3;
    public const KEY_FIGURE_WIKI_EDIT_PAGES = 4;
    public const KEY_FIGURE_WIKI_EDIT_PAGES_AVG = 5;
    public const KEY_FIGURE_WIKI_DELETED_PAGES = 6;
    public const KEY_FIGURE_WIKI_READ_PAGES = 7;
    public const KEY_FIGURE_WIKI_USER_EDIT_PAGES = 8;
    public const KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG = 9;
    public const KEY_FIGURE_WIKI_NUM_RATING = 10;
    public const KEY_FIGURE_WIKI_NUM_RATING_AVG = 11;
    public const KEY_FIGURE_WIKI_RATING_AVG = 12;
    public const KEY_FIGURE_WIKI_INTERNAL_LINKS = 13;
    public const KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG = 14;
    public const KEY_FIGURE_WIKI_EXTERNAL_LINKS = 15;
    public const KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG = 16;
    public const KEY_FIGURE_WIKI_WORDS = 17;
    public const KEY_FIGURE_WIKI_WORDS_AVG = 18;
    public const KEY_FIGURE_WIKI_CHARS = 19;
    public const KEY_FIGURE_WIKI_CHARS_AVG = 20;
    public const KEY_FIGURE_WIKI_FOOTNOTES = 21;
    public const KEY_FIGURE_WIKI_FOOTNOTES_AVG = 22;
 
    public const KEY_FIGURE_WIKI_PAGE_CHANGES = 23;
    public const KEY_FIGURE_WIKI_PAGE_CHANGES_AVG = 24;
    public const KEY_FIGURE_WIKI_PAGE_USER_EDIT = 25;
    public const KEY_FIGURE_WIKI_PAGE_READ = 26;
    public const KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS = 27;
    public const KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS = 28;
    public const KEY_FIGURE_WIKI_PAGE_WORDS = 29;
    public const KEY_FIGURE_WIKI_PAGE_CHARS = 30;
    public const KEY_FIGURE_WIKI_PAGE_FOOTNOTES = 31;
    public const KEY_FIGURE_WIKI_PAGE_RATINGS = 32;
 
    //
    // WRITE
    //
 
    public static function handleEvent(
        int $a_event,
        ilWikiPage $a_page_obj,
        ?int $a_user_id = null,
        ?array $a_additional_data = null
    ): void {
        global $DIC;
 
        $ilUser = $DIC->user();
 
        if (!$a_user_id) {
            $a_user_id = $ilUser->getId();
        }
        if (!$a_user_id || $a_user_id === ANONYMOUS_USER_ID) {
            return;
        }
 
        switch ($a_event) {
            case self::EVENT_PAGE_CREATED:
                self::handlePageCreated($a_page_obj, $a_user_id);
                break;
 
            case self::EVENT_PAGE_UPDATED:
                self::handlePageUpdated($a_page_obj, $a_user_id, $a_additional_data);
                break;
 
            case self::EVENT_PAGE_READ:
                self::handlePageRead($a_page_obj, $a_user_id);
                break;
 
            case self::EVENT_PAGE_DELETED:
                self::handlePageDeletion($a_page_obj, $a_user_id);
                break;
 
            case self::EVENT_PAGE_RATING:
                self::handlePageRating($a_page_obj, $a_user_id);
                break;
 
            default:
        }
    }
 
    protected static function getTimestamp(): string
    {
        return date("Y-m-d H:00:00");
    }
 
    protected static function writeData(
        string $a_table,
        array $a_primary,
        array $a_values
    ): bool {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $tstamp = self::getTimestamp();
        $a_primary["ts"] = array("timestamp", $tstamp);
 
        $ilAtomQuery = $ilDB->buildAtomQuery();
        $ilAtomQuery->addTableLock($a_table);
 
        $ilAtomQuery->addQueryCallable(
            function (ilDBInterface $ilDB) use ($a_table, $a_primary, $a_values, $tstamp, &$is_update) {
                $primary = array();
                foreach ($a_primary as $column => $value) {
                    $primary[] = $column . " = " . $ilDB->quote($value[1], $value[0]);
                }
                $primary = implode(" AND ", $primary);
 
                $set = $ilDB->query("SELECT ts FROM " . $a_table .
                " WHERE " . $primary);
 
                $is_update = (bool) $ilDB->numRows($set);
 
                // update (current timeframe)
                if ($is_update) {
                    $values = array();
                    foreach ($a_values as $column => $value) {
                        if ($value[0] === "increment") {
                            $values[] = $column . " = " . $column . "+1";
                        } elseif ($value[0] === "decrement") {
                            $values[] = $column . " = " . $column . "-1";
                        } else {
                            $values[] = $column . " = " . $ilDB->quote($value[1], $value[0]);
                        }
                    }
                    $values = implode(", ", $values);
 
                    $sql = "UPDATE " . $a_table .
                    " SET " . $values .
                    " WHERE " . $primary;
                }
                // insert (no entry yet for current time frame)
                else {
                    $a_values = array_merge($a_primary, $a_values);
                    $a_values["ts_day"] = array("text", substr($tstamp, 0, 10));
                    $a_values["ts_hour"] = array("integer", (int) substr($tstamp, 11, 2));
 
                    $values = array();
                    foreach ($a_values as $column => $value) {
                        $columns[] = $column;
                        if ($value[0] === "increment") {
                            $value[0] = "integer";
                        } elseif ($value[0] === "decrement") {
                            $value[0] = "integer";
                            $value[1] = 0;
                        }
                        $values[] = $ilDB->quote($value[1], $value[0]);
                    }
                    $values = implode(", ", $values);
                    $columns = implode(", ", $columns);
 
                    $sql = "INSERT INTO " . $a_table .
                    " (" . $columns . ")" .
                    " VALUES (" . $values . ")";
                }
                $ilDB->manipulate($sql);
            }
        );
        $ilAtomQuery->run();
 
        return $is_update;
    }
 
    protected static function writeStat(
        string $a_wiki_id,
        array $a_values
    ): bool {
        $primary = array(
            "wiki_id" => array("integer", $a_wiki_id)
        );
        return self::writeData("wiki_stat", $primary, $a_values);
    }
 
    protected static function writeStatPage(
        int $a_wiki_id,
        int $a_page_id,
        array $a_values
    ): void {
        $primary = array(
            "wiki_id" => array("integer", $a_wiki_id),
            "page_id" => array("integer", $a_page_id),
        );
        self::writeData("wiki_stat_page", $primary, $a_values);
    }
 
    protected static function writeStatPageUser(
        int $a_wiki_id,
        int $a_page_id,
        int $a_user_id,
        array $a_values
    ): void {
        $primary = array(
            "wiki_id" => array("integer", $a_wiki_id),
            "page_id" => array("integer", $a_page_id),
            "user_id" => array("integer", $a_user_id)
        );
        self::writeData("wiki_stat_page_user", $primary, $a_values);
    }
 
    protected static function writeStatUser(
        int $a_wiki_id,
        int $a_user_id,
        array $a_values
    ): void {
        $primary = array(
            "wiki_id" => array("integer", $a_wiki_id),
            "user_id" => array("integer", $a_user_id)
        );
        self::writeData("wiki_stat_user", $primary, $a_values);
    }
 
    protected static function countPages(
        int $a_wiki_id
    ): int {
        return count(ilWikiPage::getAllWikiPages($a_wiki_id));
    }
 
    protected static function getAverageRating(
        int $a_wiki_id,
        ?int $a_page_id = null
    ): array {
        if (!$a_page_id) {
            return ilRating::getOverallRatingForObject(
                $a_wiki_id,
                "wiki"
            );
        } else {
            return ilRating::getOverallRatingForObject(
                $a_wiki_id,
                "wiki",
                $a_page_id,
                "wpg"
            );
        }
    }
 
    public static function handlePageCreated(
        ilWikiPage $a_page_obj,
        int $a_user_id
    ): void {
        // wiki: num_pages (count)
        self::writeStat(
            $a_page_obj->getWikiId(),
            array(
                "num_pages" => array("integer", self::countPages($a_page_obj->getWikiId())),
                "del_pages" => array("integer", 0),
                "avg_rating" => array("integer", 0)
            )
        );
 
        // user: new_pages+1
        self::writeStatUser(
            $a_page_obj->getWikiId(),
            $a_user_id,
            array(
                "new_pages" => array("increment", 1)
            )
        );
    }
 
    public static function handlePageUpdated(
        ilWikiPage $a_page_obj,
        int $a_user_id,
        ?array $a_page_data = null
    ): void {
        // page_user: changes+1
        self::writeStatPageUser(
            $a_page_obj->getWikiId(),
            $a_page_obj->getId(),
            $a_user_id,
            array(
                "changes" => array("increment", 1)
            )
        );
 
        // page: see ilWikiPage::afterUpdate()
        $values = array(
            "int_links" => array("integer", $a_page_data["int_links"]),
            "ext_links" => array("integer", $a_page_data["ext_links"]),
            "footnotes" => array("integer", $a_page_data["footnotes"]),
            "num_words" => array("integer", $a_page_data["num_words"]),
            "num_chars" => array("integer", $a_page_data["num_chars"]),
            "num_ratings" => array("integer", 0),
            "avg_rating" => array("integer", 0)
        );
        self::writeStatPage($a_page_obj->getWikiId(), $a_page_obj->getId(), $values);
    }
 
    public static function handlePageRead(
        ilWikiPage $a_page_obj,
        int $a_user_id
    ): void {
        // page_user: read_events+1
        self::writeStatPageUser(
            $a_page_obj->getWikiId(),
            $a_page_obj->getId(),
            $a_user_id,
            array(
                "read_events" => array("increment", 1)
            )
        );
    }
 
    public static function handlePageDeletion(
        ilWikiPage $a_page_obj,
        int $a_user_id
    ): void {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        // copy last entry to have deletion timestamp
        $sql = "SELECT * " .
            " FROM wiki_stat_page" .
            " WHERE wiki_id = " . $ilDB->quote($a_page_obj->getWikiId(), "integer") .
            " AND page_id = " . $ilDB->quote($a_page_obj->getId(), "integer") .
            " ORDER BY ts DESC";
        $ilDB->setLimit(1, 0);
        $set = $ilDB->query($sql);
 
        // #15748
        if ($ilDB->numRows($set)) {
            $data = $ilDB->fetchAssoc($set);
 
            // see self::handlePageUpdated()
            $values = array(
                "int_links" => array("integer", $data["int_links"]),
                "ext_links" => array("integer", $data["ext_links"]),
                "footnotes" => array("integer", $data["footnotes"]),
                "num_words" => array("integer", $data["num_words"]),
                "num_chars" => array("integer", $data["num_chars"]),
                "num_ratings" => array("integer", $data["num_ratings"]),
                "avg_rating" => array("integer", $data["avg_rating"]),
            );
            self::writeStatPage($a_page_obj->getWikiId(), $a_page_obj->getId(), $values);
        }
 
        // mark all page entries as deleted
        $ilDB->manipulate("UPDATE wiki_stat_page" .
            " SET deleted = " . $ilDB->quote(1, "integer") .
            " WHERE page_id = " . $ilDB->quote($a_page_obj->getId(), "integer") .
            " AND wiki_id = " . $ilDB->quote($a_page_obj->getWikiId(), "integer"));
 
        // wiki: del_pages+1, num_pages (count), avg_rating
        $rating = self::getAverageRating($a_page_obj->getWikiId());
        self::writeStat(
            $a_page_obj->getWikiId(),
            array(
                "del_pages" => array("increment", 1),
                "num_pages" => array("integer", self::countPages($a_page_obj->getWikiId())),
                "avg_rating" => array("integer", $rating["avg"] * 100)
            )
        );
    }
 
    public static function handlePageRating(
        ilWikiPage $a_page_obj,
        int $a_user_id
    ): void {
        // do page first!
        $rating = self::getAverageRating($a_page_obj->getWikiId(), $a_page_obj->getId());
 
        // wiki_stat_page: num_ratings, avg_rating
        self::writeStatPage(
            $a_page_obj->getWikiId(),
            $a_page_obj->getId(),
            array(
                "num_ratings" => array("integer", $rating["cnt"]),
                "avg_rating" => array("integer", $rating["avg"] * 100),
            )
        );
 
        $rating = self::getAverageRating($a_page_obj->getWikiId());
 
        // wiki_stat: avg_rating
        $is_update = self::writeStat(
            $a_page_obj->getWikiId(),
            array(
                "avg_rating" => array("integer", $rating["avg"] * 100)
            )
        );
 
        if (!$is_update) {
            // wiki: num_pages (count)
            self::writeStat(
                $a_page_obj->getWikiId(),
                array(
                    "num_pages" => array("integer", self::countPages($a_page_obj->getWikiId()))
                )
            );
        }
    }
 
 
    //
    // READ HELPER
    //
 
    protected static function getWikiAggr(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to,
        string $a_table,
        string $a_field,
        string $a_aggr_value,
        ?string $a_sub_field = null,
        ?int $a_sub_id = null,
        bool $a_build_full_period = false
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $res = array();
        $deleted = null;
 
        $sql = "SELECT ts_day, " . sprintf($a_aggr_value, $a_field) . " " . $a_field;
        if ($a_table === "wiki_stat_page" && $a_sub_field) {
            $sql .= ", MAX(deleted) deleted";
        }
        $sql .= " FROM " . $a_table .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND ts_day >= " . $ilDB->quote($a_day_from, "text") .
            " AND ts_day <= " . $ilDB->quote($a_day_to, "text");
        if (!$a_build_full_period) {
            // to build full period data we need all values in DB
            $sql .= " AND " . $a_field . " > " . $ilDB->quote(0, "integer") .
            " AND " . $a_field . " IS NOT NULL";
        }
        if ($a_sub_field) {
            $sql .= " AND " . $a_sub_field . " = " . $ilDB->quote($a_sub_id, "integer");
        }
        $sql .= " GROUP BY ts_day" .
            " ORDER BY ts_day";
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[$row["ts_day"]] = $row[$a_field];
 
            $deleted = max(($row["deleted"] ?? 0), $deleted);
        }
 
        if ($a_build_full_period) {
            $period_first = $a_day_from;
            $period_last = $a_day_to;
 
            // check if sub was deleted in period
            if ($a_table === "wiki_stat_page" && $a_sub_field && $deleted) {
                $sql = "SELECT MAX(ts_day) last_day, MIN(ts_day) first_day" .
                    " FROM " . $a_table .
                    " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
                    " AND " . $a_sub_field . " = " . $ilDB->quote($a_sub_id, "integer");
                $set = $ilDB->query($sql);
                $row = $ilDB->fetchAssoc($set);
                $last_day = $row["last_day"];
                if ($last_day < $period_last) {
                    $period_last = $last_day;
                }
                $first_day = $row["first_day"];
                if ($first_day > $period_first) {
                    $period_first = $first_day;
                }
            }
 
            $last_before_period = null;
            if (!($res[$a_day_from] ?? false)) {
                $last_before_period = self::getWikiLast($a_wiki_id, $a_day_from, $a_table, $a_field, $a_sub_field, $a_sub_id);
            }
 
            // no need to allow zero here as we are not building averages
            self::buildFullPeriodData($res, $period_first, $period_last, $last_before_period);
        }
 
        return $res;
    }
 
    protected static function getWikiLast(
        int $a_wiki_id,
        string $a_day_from,
        string $a_table,
        string $a_field,
        ?string $a_sub_field = null,
        ?int $a_sub_id = null
    ): int {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        // get last existing value before period (zero is valid)
        $sql = "SELECT MAX(" . $a_field . ") latest" .
            " FROM " . $a_table .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND ts_day < " . $ilDB->quote($a_day_from, "text");
        if ($a_sub_field) {
            $sql .= " AND " . $a_sub_field . " = " . $ilDB->quote($a_sub_id, "integer");
        }
        $sql .= " GROUP BY ts_day" .
            " ORDER BY ts_day DESC";
        $ilDB->setLimit(1, 0);
        $set = $ilDB->query($sql);
        $last_before_period = $ilDB->fetchAssoc($set);
        return (int) ($last_before_period["latest"] ?? 0);
    }
 
    protected static function getWikiAggrSub(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to,
        string $a_table,
        string $a_field,
        string $a_aggr_by,
        string $a_aggr_value,
        string $a_aggr_sub,
        ?string $a_sub_field = null,
        ?int $a_sub_id = null,
        bool $a_build_full_period = false
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $res = array();
 
        if (!$a_build_full_period) {
            $sql = "SELECT ts_day, " . sprintf($a_aggr_value, $a_field) . " " . $a_field .
                " FROM (" .
                    // subquery to build average per $a_aggr_by
                    " SELECT ts_day, " . sprintf($a_aggr_sub, $a_field) . " " . $a_field .
                    " FROM " . $a_table .
                    " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
                    " AND ts_day >= " . $ilDB->quote($a_day_from, "text") .
                    " AND ts_day <= " . $ilDB->quote($a_day_to, "text") .
                    " AND " . $a_field . " > " . $ilDB->quote(0, "integer") .
                    " AND " . $a_field . " IS NOT NULL";
            if ($a_sub_field) {
                $sql .= " AND " . $a_sub_field . " = " . $ilDB->quote($a_sub_id, "integer");
            }
            $sql .= " GROUP BY ts_day, " . $a_aggr_by .
                ") aggr_sub" .
                " GROUP BY ts_day" .
                " ORDER BY ts_day";
            $set = $ilDB->query($sql);
            while ($row = $ilDB->fetchAssoc($set)) {
                $res[$row["ts_day"]] = $row[$a_field];
            }
        } else {
            $tmp = $all_aggr_ids = $deleted_in_period = $first_day_in_period = array();
 
            if ($a_table !== "wiki_stat_page") {
                echo "can only build full period averages for wiki_stat_page";
                exit();
            }
 
            // as current period can be totally empty, gather existing subs
            $sql = " SELECT *" .
                " FROM (" .
                    " SELECT " . $a_aggr_by . ", MAX(deleted) deleted, MAX(ts_day) last_day, MIN(ts_day) first_day" .
                    " FROM " . $a_table .
                    " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
                    " GROUP BY " . $a_aggr_by .
                ") aggr_sub" .
                " WHERE first_day <= " . $ilDB->quote($a_day_to, "text") . // not created after period
                " AND (last_day >= " . $ilDB->quote($a_day_from, "text") . // (deleted in/after period
                " OR deleted = " . $ilDB->quote(0, "integer") . ")";            // or still existing)
            $set = $ilDB->query($sql);
            while ($row = $ilDB->fetchAssoc($set)) {
                $all_aggr_ids[] = $row[$a_aggr_by];
 
                // if deleted in period we need the last day
                if ($row["deleted"] && $row["last_day"] < $a_day_to) {
                    $deleted_in_period[$row[$a_aggr_by]] = $row["last_day"];
                }
                // if created in period we need the first day
                if ($row["first_day"] > $a_day_from) {
                    $first_day_in_period[$row[$a_aggr_by]] = $row["first_day"];
                }
            }
 
            // we need to build average manually after completing period data (zero is valid)
            $sql = " SELECT ts_day, " . $a_aggr_by . ", " . sprintf($a_aggr_sub, $a_field) . " " . $a_field .
                " FROM " . $a_table .
                " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
                " AND ts_day >= " . $ilDB->quote($a_day_from, "text") .
                " AND ts_day <= " . $ilDB->quote($a_day_to, "text");
            $sql .= " GROUP BY ts_day, " . $a_aggr_by;
            $set = $ilDB->query($sql);
            while ($row = $ilDB->fetchAssoc($set)) {
                if (!in_array($row[$a_aggr_by], $all_aggr_ids)) {
                    throw new ilWikiException("Unexpected wiki_stat_page_entry: " . print_r($row, true));
                }
                $tmp[$row[$a_aggr_by]][$row["ts_day"]] = $row[$a_field];
            }
 
            // build full period for each sub
            foreach ($all_aggr_ids as $aggr_by_id) {
                // last of entry of sub is before period
                if (!isset($tmp[$aggr_by_id])) {
                    $tmp[$aggr_by_id] = array();
                }
 
                // get last value before period to add missing entries in period
                $last_before_period = null;
                if (!($tmp[$aggr_by_id][$a_day_from] ?? false)) {
                    $last_before_period = self::getWikiLast($a_wiki_id, $a_day_from, $a_table, $a_field, $a_aggr_by, $aggr_by_id);
                }
 
                // if sub was created in period (see above), shorten period accordingly
                $first_period_day = $first_day_in_period[$aggr_by_id] ?? $a_day_from;
 
                // if sub was deleted in period (see above), shorten period accordingly
                $last_period_day = $deleted_in_period[$aggr_by_id] ?? $a_day_to;
 
                // allow zero as we need to correct number of valid subs per day (see below - AVG)
                self::buildFullPeriodData($tmp[$aggr_by_id], $first_period_day, $last_period_day, $last_before_period, true);
 
                // distribute sub to days
                foreach ($tmp[$aggr_by_id] as $day => $value) {
                    $res[$day][$aggr_by_id] = $value;
                }
            }
 
            // build average over subs
            foreach ($res as $day => $values) {
                switch ($a_aggr_value) {
                    case "AVG(%s)":
                        $res[$day] = array_sum($values) / count($values);
                        break;
 
                    case "SUM(%s)":
                        $res[$day] = array_sum($values);
                        break;
 
                    default:
                        throw new ilWikiException("Wiki: unsupport aggr " . $a_aggr_value);
                        break;
                }
            }
        }
 
        return $res;
    }
 
    protected static function buildFullPeriodData(
        array &$a_res,
        string $a_day_from,
        string $a_day_to,
        ?int $a_last_before_period = null,
        bool $a_allow_zero = false
    ): void {
        // build full data for period
        $safety = 0;
        $last = null;
        $today = date("Y-m-d");
        $current = explode("-", $a_day_from);
        $current = date("Y-m-d", mktime(0, 0, 1, $current[1], $current[2], $current[0]));
        while ($current <= $a_day_to &&
            ++$safety < 1000) {
            if (!isset($a_res[$current])) {
                if ($current <= $today) {
                    // last existing value in period
                    if ($last !== null) {
                        $a_res[$current] = $last;
                    }
                    // last existing value before period
                    elseif ($a_last_before_period || $a_allow_zero) {
                        $a_res[$current] = $a_last_before_period;
                    }
                }
            } else {
                $last = $a_res[$current];
            }
 
            $current = explode("-", $current);
            $current = date("Y-m-d", mktime(0, 0, 1, $current[1], $current[2] + 1, $current[0]));
        }
    }
 
 
    //
    // READ WIKI
    //
 
    protected static function getWikiNumPages(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat", "num_pages", "MAX(%s)", null, null, true);
    }
 
    protected static function getWikiNewPagesSum(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_user", "new_pages", "SUM(%s)");
    }
 
    protected static function getWikiNewPagesAvg(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_user", "new_pages", "user_id", "AVG(%s)", "SUM(%s)");
    }
 
    protected static function getWikiDeletedPages(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat", "del_pages", "SUM(%s)");
    }
 
    protected static function getWikiReadPages(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page_user", "read_events", "SUM(%s)");
    }
 
    protected static function getWikiEditPagesSum(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $res = array();
 
        $sql = "SELECT ts_day, COUNT(DISTINCT(page_id)) num_changed_pages" .
            " FROM wiki_stat_page_user" .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND ts_day >= " . $ilDB->quote($a_day_from, "text") .
            " AND ts_day <= " . $ilDB->quote($a_day_to, "text") .
            " AND changes > " . $ilDB->quote(0, "integer") .
            " AND changes IS NOT NULL" .
            " GROUP BY ts_day" .
            " ORDER BY ts_day";
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[$row["ts_day"]] = $row["num_changed_pages"];
        }
 
        return $res;
    }
 
    protected static function getWikiEditPagesAvg(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $res = array();
 
        $sql = "SELECT ts_day, AVG(num_changed_pages) num_changed_pages" .
            " FROM (" .
                // subquery to build average per user
                " SELECT ts_day, COUNT(DISTINCT(page_id)) num_changed_pages" .
                " FROM wiki_stat_page_user" .
                " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
                " AND ts_day >= " . $ilDB->quote($a_day_from, "text") .
                " AND ts_day <= " . $ilDB->quote($a_day_to, "text") .
                " AND changes > " . $ilDB->quote(0, "integer") .
                " AND changes IS NOT NULL" .
                " GROUP BY ts_day, user_id" .
            ") aggr_user" .
            " GROUP BY ts_day" .
            " ORDER BY ts_day";
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[$row["ts_day"]] = $row["num_changed_pages"];
        }
 
        return $res;
    }
 
    protected static function getWikiUserEditPages(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to,
        ?string $a_sub_field = null,
        ?int $a_sub_id = null
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $res = array();
 
        $sql = "SELECT ts_day, COUNT(DISTINCT(user_id)) num_changed_users" .
            " FROM wiki_stat_page_user" .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND ts_day >= " . $ilDB->quote($a_day_from, "text") .
            " AND ts_day <= " . $ilDB->quote($a_day_to, "text") .
            " AND changes > " . $ilDB->quote(0, "integer") .
            " AND changes IS NOT NULL";
        if ($a_sub_field) {
            $sql .= " AND " . $a_sub_field . " = " . $ilDB->quote($a_sub_id, "integer");
        }
        $sql .= " GROUP BY ts_day" .
            " ORDER BY ts_day";
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[$row["ts_day"]] = $row["num_changed_users"];
        }
 
        return $res;
    }
 
    protected static function getWikiUserEditPagesAvg(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $res = array();
 
        $sql = "SELECT ts_day, AVG(num_changed_users) num_changed_users" .
            " FROM (" .
                // subquery to build average per page
                " SELECT ts_day, COUNT(DISTINCT(user_id)) num_changed_users" .
                " FROM wiki_stat_page_user" .
                " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
                " AND ts_day >= " . $ilDB->quote($a_day_from, "text") .
                " AND ts_day <= " . $ilDB->quote($a_day_to, "text") .
                " AND changes > " . $ilDB->quote(0, "integer") .
                " AND changes IS NOT NULL" .
                " GROUP BY ts_day, page_id" .
            ") aggr_user" .
            " GROUP BY ts_day" .
            " ORDER BY ts_day";
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[$row["ts_day"]] = $row["num_changed_users"];
        }
 
        return $res;
    }
 
    protected static function getWikiNumRating(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "num_ratings", "SUM(%s)");
    }
 
    protected static function getWikiNumRatingAvg(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "num_ratings", "page_id", "AVG(%s)", "SUM(%s)");
    }
 
    protected static function getWikiRatingAvg(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        $res = self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat", "avg_rating", "AVG(%s)");
 
        foreach (array_keys($res) as $day) {
            // int-to-float
            $res[$day] /= 100;
        }
 
        return $res;
    }
 
    protected static function getWikiInternalLinks(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "int_links", "page_id", "SUM(%s)", "MAX(%s)", null, null, true);
    }
 
    protected static function getWikiInternalLinksAvg(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "int_links", "page_id", "AVG(%s)", "MAX(%s)", null, null, true);
    }
 
    protected static function getWikiExternalLinks(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "ext_links", "page_id", "SUM(%s)", "MAX(%s)", null, null, true);
    }
 
    protected static function getWikiExternalLinksAvg(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "ext_links", "page_id", "AVG(%s)", "MAX(%s)", null, null, true);
    }
 
    protected static function getWikiWords(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "num_words", "page_id", "SUM(%s)", "MAX(%s)", null, null, true);
    }
 
    protected static function getWikiWordsAvg(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "num_words", "page_id", "AVG(%s)", "MAX(%s)", null, null, true);
    }
 
    protected static function getWikiCharacters(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "num_chars", "page_id", "SUM(%s)", "MAX(%s)", null, null, true);
    }
 
    protected static function getWikiCharactersAvg(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "num_chars", "page_id", "AVG(%s)", "MAX(%s)", null, null, true);
    }
 
    protected static function getWikiFootnotes(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "footnotes", "page_id", "SUM(%s)", "MAX(%s)", null, null, true);
    }
 
    protected static function getWikiFootnotesAvg(
        int $a_wiki_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "footnotes", "page_id", "AVG(%s)", "MAX(%s)", null, null, true);
    }
 
 
    //
    // READ PAGE
    //
 
    protected static function getWikiPageChanges(
        int $a_wiki_id,
        int $a_page_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page_user", "changes", "SUM(%s)", "page_id", $a_page_id);
    }
 
    protected static function getWikiPageChangesAvg(
        int $a_wiki_id,
        int $a_page_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page_user", "changes", "user_id", "AVG(%s)", "SUM(%s)", "page_id", $a_page_id);
    }
 
    protected static function getWikiPageUserEdit(
        int $a_wiki_id,
        int $a_page_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiUserEditPages($a_wiki_id, $a_day_from, $a_day_to, "page_id", $a_page_id);
    }
 
    protected static function getWikiPageRead(
        int $a_wiki_id,
        int $a_page_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page_user", "read_events", "SUM(%s)", "page_id", $a_page_id);
    }
 
    protected static function getWikiPageInternalLinks(
        int $a_wiki_id,
        int $a_page_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "int_links", "MAX(%s)", "page_id", $a_page_id, true);
    }
 
    protected static function getWikiPageExternalLinks(
        int $a_wiki_id,
        int $a_page_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "ext_links", "MAX(%s)", "page_id", $a_page_id, true);
    }
 
    protected static function getWikiPageWords(
        int $a_wiki_id,
        int $a_page_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "num_words", "MAX(%s)", "page_id", $a_page_id, true);
    }
 
    protected static function getWikiPageCharacters(
        int $a_wiki_id,
        int $a_page_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "num_chars", "MAX(%s)", "page_id", $a_page_id, true);
    }
 
    protected static function getWikiPageFootnotes(
        int $a_wiki_id,
        int $a_page_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "footnotes", "MAX(%s)", "page_id", $a_page_id, true);
    }
 
    protected static function getWikiPageRatings(
        int $a_wiki_id,
        int $a_page_id,
        string $a_day_from,
        string $a_day_to
    ): array {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "num_ratings", "SUM(%s)", "page_id", $a_page_id);
    }
 
 
    //
    // GUI HELPER
    //
 
    public static function getAvailableMonths(
        int $a_wiki_id
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $res = array();
 
        // because of read_events this db table is updated most often
        $set = $ilDB->query("SELECT DISTINCT(SUBSTR(ts_day, 1, 7)) " . $ilDB->quoteIdentifier("month") .
            " FROM wiki_stat_page_user" .
            " WHERE wiki_id = " . $ilDB->quote($a_wiki_id, "integer") .
            " AND ts_day IS NOT NULL");
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[] = $row["month"];
        }
 
        return $res;
    }
 
    public static function getFigures(): array
    {
        return array(
            self::KEY_FIGURE_WIKI_NUM_PAGES
            ,self::KEY_FIGURE_WIKI_NEW_PAGES
            ,self::KEY_FIGURE_WIKI_NEW_PAGES_AVG
            ,self::KEY_FIGURE_WIKI_EDIT_PAGES
            ,self::KEY_FIGURE_WIKI_EDIT_PAGES_AVG
            ,self::KEY_FIGURE_WIKI_DELETED_PAGES
            ,self::KEY_FIGURE_WIKI_READ_PAGES
            ,self::KEY_FIGURE_WIKI_USER_EDIT_PAGES
            ,self::KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG
            ,self::KEY_FIGURE_WIKI_NUM_RATING
            ,self::KEY_FIGURE_WIKI_NUM_RATING_AVG
            ,self::KEY_FIGURE_WIKI_RATING_AVG
            ,self::KEY_FIGURE_WIKI_INTERNAL_LINKS
            ,self::KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG
            ,self::KEY_FIGURE_WIKI_EXTERNAL_LINKS
            ,self::KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG
            ,self::KEY_FIGURE_WIKI_WORDS
            ,self::KEY_FIGURE_WIKI_WORDS_AVG
            ,self::KEY_FIGURE_WIKI_CHARS
            ,self::KEY_FIGURE_WIKI_CHARS_AVG
            ,self::KEY_FIGURE_WIKI_FOOTNOTES
            ,self::KEY_FIGURE_WIKI_FOOTNOTES_AVG
        );
    }
 
    public static function getFiguresPage(): array
    {
        return array(
            self::KEY_FIGURE_WIKI_PAGE_CHANGES
            ,self::KEY_FIGURE_WIKI_PAGE_CHANGES_AVG
            ,self::KEY_FIGURE_WIKI_PAGE_USER_EDIT
            ,self::KEY_FIGURE_WIKI_PAGE_READ
            ,self::KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS
            ,self::KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS
            ,self::KEY_FIGURE_WIKI_PAGE_WORDS
            ,self::KEY_FIGURE_WIKI_PAGE_CHARS
            ,self::KEY_FIGURE_WIKI_PAGE_FOOTNOTES
            ,self::KEY_FIGURE_WIKI_PAGE_RATINGS
        );
    }
 
    public static function getFigureTitle(
        int $a_figure
    ): string {
        global $DIC;
 
        $lng = $DIC->language();
 
        $map = array(
            // wiki
            self::KEY_FIGURE_WIKI_NUM_PAGES => $lng->txt("wiki_stat_num_pages")
            ,self::KEY_FIGURE_WIKI_NEW_PAGES => $lng->txt("wiki_stat_new_pages")
            ,self::KEY_FIGURE_WIKI_NEW_PAGES_AVG => $lng->txt("wiki_stat_new_pages_avg")
            ,self::KEY_FIGURE_WIKI_EDIT_PAGES => $lng->txt("wiki_stat_edit_pages")
            ,self::KEY_FIGURE_WIKI_EDIT_PAGES_AVG => $lng->txt("wiki_stat_edit_pages_avg")
            ,self::KEY_FIGURE_WIKI_DELETED_PAGES => $lng->txt("wiki_stat_deleted_pages")
            ,self::KEY_FIGURE_WIKI_READ_PAGES => $lng->txt("wiki_stat_read_pages")
            ,self::KEY_FIGURE_WIKI_USER_EDIT_PAGES => $lng->txt("wiki_stat_user_edit_pages")
            ,self::KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG => $lng->txt("wiki_stat_user_edit_pages_avg")
            ,self::KEY_FIGURE_WIKI_NUM_RATING => $lng->txt("wiki_stat_num_rating")
            ,self::KEY_FIGURE_WIKI_NUM_RATING_AVG => $lng->txt("wiki_stat_num_rating_avg")
            ,self::KEY_FIGURE_WIKI_RATING_AVG => $lng->txt("wiki_stat_rating_avg")
            ,self::KEY_FIGURE_WIKI_INTERNAL_LINKS => $lng->txt("wiki_stat_internal_links")
            ,self::KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG => $lng->txt("wiki_stat_internal_links_avg")
            ,self::KEY_FIGURE_WIKI_EXTERNAL_LINKS => $lng->txt("wiki_stat_external_links")
            ,self::KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG => $lng->txt("wiki_stat_external_links_avg")
            ,self::KEY_FIGURE_WIKI_WORDS => $lng->txt("wiki_stat_words")
            ,self::KEY_FIGURE_WIKI_WORDS_AVG => $lng->txt("wiki_stat_words_avg")
            ,self::KEY_FIGURE_WIKI_CHARS => $lng->txt("wiki_stat_chars")
            ,self::KEY_FIGURE_WIKI_CHARS_AVG => $lng->txt("wiki_stat_chars_avg")
            ,self::KEY_FIGURE_WIKI_FOOTNOTES => $lng->txt("wiki_stat_footnotes")
            ,self::KEY_FIGURE_WIKI_FOOTNOTES_AVG => $lng->txt("wiki_stat_footnotes_avg")
            // page
            ,self::KEY_FIGURE_WIKI_PAGE_CHANGES => $lng->txt("wiki_stat_page_changes")
            ,self::KEY_FIGURE_WIKI_PAGE_CHANGES_AVG => $lng->txt("wiki_stat_page_changes_avg")
            ,self::KEY_FIGURE_WIKI_PAGE_USER_EDIT => $lng->txt("wiki_stat_page_user_edit")
            ,self::KEY_FIGURE_WIKI_PAGE_READ => $lng->txt("wiki_stat_page_read")
            ,self::KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS => $lng->txt("wiki_stat_page_internal_links")
            ,self::KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS => $lng->txt("wiki_stat_page_external_links")
            ,self::KEY_FIGURE_WIKI_PAGE_WORDS => $lng->txt("wiki_stat_page_words")
            ,self::KEY_FIGURE_WIKI_PAGE_CHARS => $lng->txt("wiki_stat_page_characters")
            ,self::KEY_FIGURE_WIKI_PAGE_FOOTNOTES => $lng->txt("wiki_stat_page_footnotes")
            ,self::KEY_FIGURE_WIKI_PAGE_RATINGS => $lng->txt("wiki_stat_page_ratings")
        );
 
        return $map[$a_figure];
    }
 
    public static function getFigureData(
        int $a_wiki_id,
        int $a_figure,
        string $a_from,
        string $a_to
    ): array {
        switch ($a_figure) {
            case self::KEY_FIGURE_WIKI_NUM_PAGES:
                return self::getWikiNumPages($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_NEW_PAGES:
                return self::getWikiNewPagesSum($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_NEW_PAGES_AVG:
                return self::getWikiNewPagesAvg($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_EDIT_PAGES:
                return self::getWikiEditPagesSum($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_EDIT_PAGES_AVG:
                return self::getWikiEditPagesAvg($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_DELETED_PAGES:
                return self::getWikiDeletedPages($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_READ_PAGES:
                return self::getWikiReadPages($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_USER_EDIT_PAGES:
                return self::getWikiUserEditPages($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG:
                return self::getWikiUserEditPagesAvg($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_NUM_RATING:
                return self::getWikiNumRating($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_NUM_RATING_AVG:
                return self::getWikiNumRatingAvg($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_RATING_AVG:
                return self::getWikiRatingAvg($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_INTERNAL_LINKS:
                return self::getWikiInternalLinks($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG:
                return self::getWikiInternalLinksAvg($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_EXTERNAL_LINKS:
                return self::getWikiExternalLinks($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG:
                return self::getWikiExternalLinksAvg($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_WORDS:
                return self::getWikiWords($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_WORDS_AVG:
                return self::getWikiWordsAvg($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_CHARS:
                return self::getWikiCharacters($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_CHARS_AVG:
                return self::getWikiCharactersAvg($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_FOOTNOTES:
                return self::getWikiFootnotes($a_wiki_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_FOOTNOTES_AVG:
                return self::getWikiFootnotesAvg($a_wiki_id, $a_from, $a_to);
        }
        return [];
    }
 
    public static function getFigureDataPage(
        int $a_wiki_id,
        int $a_page_id,
        int $a_figure,
        string $a_from,
        string $a_to
    ): array {
        switch ($a_figure) {
            case self::KEY_FIGURE_WIKI_PAGE_CHANGES:
                return self::getWikiPageChanges($a_wiki_id, $a_page_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_PAGE_CHANGES_AVG:
                return self::getWikiPageChangesAvg($a_wiki_id, $a_page_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_PAGE_USER_EDIT:
                return self::getWikiPageUserEdit($a_wiki_id, $a_page_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_PAGE_READ:
                return self::getWikiPageRead($a_wiki_id, $a_page_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS:
                return self::getWikiPageInternalLinks($a_wiki_id, $a_page_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS:
                return self::getWikiPageExternalLinks($a_wiki_id, $a_page_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_PAGE_FOOTNOTES:
                return self::getWikiPageFootnotes($a_wiki_id, $a_page_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_PAGE_WORDS:
                return self::getWikiPageWords($a_wiki_id, $a_page_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_PAGE_CHARS:
                return self::getWikiPageCharacters($a_wiki_id, $a_page_id, $a_from, $a_to);
 
            case self::KEY_FIGURE_WIKI_PAGE_RATINGS:
                return self::getWikiPageRatings($a_wiki_id, $a_page_id, $a_from, $a_to);
        }
        return [];
    }
 
    public static function getFigureOptions(): array
    {
        $res = array();
 
        foreach (self::getFigures() as $figure) {
            $res[$figure] = self::getFigureTitle($figure);
        }
 
        return $res;
    }
 
    public static function getFigureOptionsPage(): array
    {
        $res = array();
 
        foreach (self::getFiguresPage() as $figure) {
            $res[$figure] = self::getFigureTitle($figure);
        }
 
        return $res;
    }
}