This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilWikiStat:

Static Public Member Functions
static	handleEvent (int $a_event, ilWikiPage $a_page_obj, ?int $a_user_id=null, array $a_additional_data=null)
	Handle wiki page event. More...

static	handlePageCreated (ilWikiPage $a_page_obj, int $a_user_id)
	Handle wiki page creation. More...

static	handlePageUpdated (ilWikiPage $a_page_obj, int $a_user_id, array $a_page_data=null)
	Handle wiki page update. More...

static	handlePageRead (ilWikiPage $a_page_obj, int $a_user_id)

static	handlePageDeletion (ilWikiPage $a_page_obj, int $a_user_id)

static	handlePageRating (ilWikiPage $a_page_obj, int $a_user_id)

static	getAvailableMonths (int $a_wiki_id)

static	getFigures ()

static	getFiguresPage ()

static	getFigureTitle (int $a_figure)

static	getFigureData (int $a_wiki_id, int $a_figure, string $a_from, string $a_to)

static	getFigureDataPage (int $a_wiki_id, int $a_page_id, int $a_figure, string $a_from, string $a_to)

static	getFigureOptions ()

static	getFigureOptionsPage ()

Data Fields
const	EVENT_PAGE_CREATED = 1

const	EVENT_PAGE_UPDATED = 2

const	EVENT_PAGE_READ = 3

const	EVENT_PAGE_DELETED = 4

const	EVENT_PAGE_RATING = 5

const	KEY_FIGURE_WIKI_NUM_PAGES = 1

const	KEY_FIGURE_WIKI_NEW_PAGES = 2

const	KEY_FIGURE_WIKI_NEW_PAGES_AVG = 3

const	KEY_FIGURE_WIKI_EDIT_PAGES = 4

const	KEY_FIGURE_WIKI_EDIT_PAGES_AVG = 5

const	KEY_FIGURE_WIKI_DELETED_PAGES = 6

const	KEY_FIGURE_WIKI_READ_PAGES = 7

const	KEY_FIGURE_WIKI_USER_EDIT_PAGES = 8

const	KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG = 9

const	KEY_FIGURE_WIKI_NUM_RATING = 10

const	KEY_FIGURE_WIKI_NUM_RATING_AVG = 11

const	KEY_FIGURE_WIKI_RATING_AVG = 12

const	KEY_FIGURE_WIKI_INTERNAL_LINKS = 13

const	KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG = 14

const	KEY_FIGURE_WIKI_EXTERNAL_LINKS = 15

const	KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG = 16

const	KEY_FIGURE_WIKI_WORDS = 17

const	KEY_FIGURE_WIKI_WORDS_AVG = 18

const	KEY_FIGURE_WIKI_CHARS = 19

const	KEY_FIGURE_WIKI_CHARS_AVG = 20

const	KEY_FIGURE_WIKI_FOOTNOTES = 21

const	KEY_FIGURE_WIKI_FOOTNOTES_AVG = 22

const	KEY_FIGURE_WIKI_PAGE_CHANGES = 23

const	KEY_FIGURE_WIKI_PAGE_CHANGES_AVG = 24

const	KEY_FIGURE_WIKI_PAGE_USER_EDIT = 25

const	KEY_FIGURE_WIKI_PAGE_READ = 26

const	KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS = 27

const	KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS = 28

const	KEY_FIGURE_WIKI_PAGE_WORDS = 29

const	KEY_FIGURE_WIKI_PAGE_CHARS = 30

const	KEY_FIGURE_WIKI_PAGE_FOOTNOTES = 31

const	KEY_FIGURE_WIKI_PAGE_RATINGS = 32

Static Protected Member Functions
static	getTimestamp ()
	Get current time frame (hourly) More...

static	writeData (string $a_table, array $a_primary, array $a_values)
	Write data to DB. More...

static	writeStat (string $a_wiki_id, array $a_values)
	Write data to wiki_stat. More...

static	writeStatPage (int $a_wiki_id, int $a_page_id, array $a_values)
	Write data to wiki_stat_page. More...

static	writeStatPageUser (int $a_wiki_id, int $a_page_id, int $a_user_id, array $a_values)
	Write data to wiki_stat_page_user. More...

static	writeStatUser (int $a_wiki_id, int $a_user_id, array $a_values)
	Write to wiki_stat_user. More...

static	countPages (int $a_wiki_id)
	Count pages in wiki. More...

static	getAverageRating (int $a_wiki_id, ?int $a_page_id=null)
	Get average rating for wiki or wiki page. More...

static	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)

static	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)

static	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)

static	buildFullPeriodData (array &$a_res, string $a_day_from, string $a_day_to, ?int $a_last_before_period=null, bool $a_allow_zero=false)

static	getWikiNumPages (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiNewPagesSum (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiNewPagesAvg (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiDeletedPages (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiReadPages (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiEditPagesSum (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiEditPagesAvg (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiUserEditPages (int $a_wiki_id, string $a_day_from, string $a_day_to, ?string $a_sub_field=null, ?int $a_sub_id=null)

static	getWikiUserEditPagesAvg (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiNumRating (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiNumRatingAvg (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiRatingAvg (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiInternalLinks (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiInternalLinksAvg (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiExternalLinks (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiExternalLinksAvg (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiWords (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiWordsAvg (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiCharacters (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiCharactersAvg (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiFootnotes (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiFootnotesAvg (int $a_wiki_id, string $a_day_from, string $a_day_to)

static	getWikiPageChanges (int $a_wiki_id, int $a_page_id, string $a_day_from, string $a_day_to)

static	getWikiPageChangesAvg (int $a_wiki_id, int $a_page_id, string $a_day_from, string $a_day_to)

static	getWikiPageUserEdit (int $a_wiki_id, int $a_page_id, string $a_day_from, string $a_day_to)

static	getWikiPageRead (int $a_wiki_id, int $a_page_id, string $a_day_from, string $a_day_to)

static	getWikiPageInternalLinks (int $a_wiki_id, int $a_page_id, string $a_day_from, string $a_day_to)

static	getWikiPageExternalLinks (int $a_wiki_id, int $a_page_id, string $a_day_from, string $a_day_to)

static	getWikiPageWords (int $a_wiki_id, int $a_page_id, string $a_day_from, string $a_day_to)

static	getWikiPageCharacters (int $a_wiki_id, int $a_page_id, string $a_day_from, string $a_day_to)

static	getWikiPageFootnotes (int $a_wiki_id, int $a_page_id, string $a_day_from, string $a_day_to)

static	getWikiPageRatings (int $a_wiki_id, int $a_page_id, string $a_day_from, string $a_day_to)

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Wiki statistics class

Timestamp / Current Record

If an event occurs the current timestamp is calculated, for not this is the timestamp without minuts/seconds 2014-01-14 07:34:45 -> 2014-01-14 07:00:00 (i.e. we count "per hour" and the numbers represent 07:00:00 to 07:59:59)

Table / Primary Key / Stats / Events

wiki_stat pk: wiki_id, timestamp

          (1) number of pages             ev: page created, page deleted
                                                          action: count pages of wiki and replace number in current record

          (2) deleted pages               ev: page deleted
                                                          action: increment number in current record +1

          (3) average rating              ev: rating saved
                                                          [action: do (10), then for current records in wiki_stat_page: sum average rating / number of records where average rating is > 0]
                                                  REVISION action: do (10), then build average rating from wiki page rating records NOT wiki_stat_page

wiki_stat_page pk: wiki_id, page_id, timestamp

          (4) internal links              ev: page saved
                                                          action: count internal links and replace number in current record

          (5) external links              see internal links

          (6) footnotes                   see internal links

          (7) ratings                             ev: rating saved
                                                          action: count ratings and replace number in current record

          (8)     words                           see internal links

          (9) characters                  see internal links

          (10) average rating             ev: rating saved
                                                          sum ratings / number of ratings (0 if no rating given)

wiki_stat_user pk: wiki_id, user_id, timestamp

          (11) new pages                  ev: page created
                                                          action: increment number of user in current record + 1

wiki_stat_page_user pk: wiki_id, page_id, user_id, timestamp

  (12) changes                    ev: page saved
                                                  action: increment number of user/page in current record + 1

  (13) read                               ev: page read
                                                  action: increment number of user/page in current record + 1

Events

page created (empty) (1) (11)
page deleted (1) (2)
page saved (content) (4) (5) (6) (8) (9) (12)
page read (13)
rating saved (3) (10)

Deleted pages

All historic records are kept. A current wiki_stat_page record with all values 0 is replaced/created. (?)

Author: Jörg Lützenkirchen luetz.nosp@m.enki.nosp@m.rchen.nosp@m.@lei.nosp@m.fos.d.nosp@m.e; Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 93 of file class.ilWikiStat.php.

Member Function Documentation

◆ buildFullPeriodData()

static ilWikiStat::buildFullPeriodData	(	array &	$a_res,
		string	$a_day_from,
		string	$a_day_to,
		?int	$a_last_before_period = `null`,
		bool	$a_allow_zero = `false`
	)

staticprotected

Definition at line 781 of file class.ilWikiStat.php.

      : 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]));
         }
     }

◆ countPages()

static ilWikiStat::countPages ( int $a_wiki_id )

staticprotected

Count pages in wiki.

Definition at line 342 of file class.ilWikiStat.php.

References ilWikiPage\getAllWikiPages().

      : int {
         return count(ilWikiPage::getAllWikiPages($a_wiki_id));
     }

Here is the call graph for this function:

◆ getAvailableMonths()

static ilWikiStat::getAvailableMonths ( int $a_wiki_id )

static

Definition at line 1199 of file class.ilWikiStat.php.

References $DIC, $ilDB, and $res.

Referenced by ilWikiStatGUI\viewToolbar().

      : 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;
     }

Here is the caller graph for this function:

◆ getAverageRating()

static ilWikiStat::getAverageRating	(	int	$a_wiki_id,
		?int	$a_page_id = `null`
	)

staticprotected

Get average rating for wiki or wiki page.

Definition at line 351 of file class.ilWikiStat.php.

References ilRating\getOverallRatingForObject().

      : array {
         if (!$a_page_id) {
             return ilRating::getOverallRatingForObject(
                 $a_wiki_id,
                 "wiki"
             );
         } else {
             return ilRating::getOverallRatingForObject(
                 $a_wiki_id,
                 "wiki",
                 $a_page_id,
                 "wpg"
             );
         }
     }

Here is the call graph for this function:

◆ getFigureData()

static ilWikiStat::getFigureData	(	int	$a_wiki_id,
		int	$a_figure,
		string	$a_from,
		string	$a_to
	)

static

Definition at line 1311 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\getChartData(), and ilWikiStatGUI\getListData().

      : 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 [];
     }

Here is the caller graph for this function:

◆ getFigureDataPage()

static ilWikiStat::getFigureDataPage	(	int	$a_wiki_id,
		int	$a_page_id,
		int	$a_figure,
		string	$a_from,
		string	$a_to
	)

static

Definition at line 1387 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\getChartData(), and ilWikiStatGUI\getListData().

      : 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 [];
     }

Here is the caller graph for this function:

◆ getFigureOptions()

static ilWikiStat::getFigureOptions ( )

static

Definition at line 1428 of file class.ilWikiStat.php.

References $res.

Referenced by ilWikiStatGUI\getListData(), and ilWikiStatGUI\viewToolbar().

                                              : array
     {
         $res = array();
 
         foreach (self::getFigures() as $figure) {
             $res[$figure] = self::getFigureTitle($figure);
         }
 
         return $res;
     }

Here is the caller graph for this function:

◆ getFigureOptionsPage()

static ilWikiStat::getFigureOptionsPage ( )

static

Definition at line 1439 of file class.ilWikiStat.php.

References $res.

Referenced by ilWikiStatGUI\getListData(), and ilWikiStatGUI\viewToolbar().

                                                  : array
     {
         $res = array();
 
         foreach (self::getFiguresPage() as $figure) {
             $res[$figure] = self::getFigureTitle($figure);
         }
 
         return $res;
     }

Here is the caller graph for this function:

◆ getFigures()

static ilWikiStat::getFigures ( )

static

Definition at line 1220 of file class.ilWikiStat.php.

                                        : 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
         );
     }

◆ getFiguresPage()

static ilWikiStat::getFiguresPage ( )

static

Definition at line 1248 of file class.ilWikiStat.php.

                                            : 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
         );
     }

◆ getFigureTitle()

static ilWikiStat::getFigureTitle ( int $a_figure )

static

Definition at line 1264 of file class.ilWikiStat.php.

References $DIC, and $lng.

Referenced by ilWikiStatGUI\export(), and ilWikiStatGUI\renderGraph().

      : 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];
     }

Here is the caller graph for this function:

◆ getTimestamp()

static ilWikiStat::getTimestamp ( )

staticprotected

Get current time frame (hourly)

Definition at line 187 of file class.ilWikiStat.php.

                                             : string
     {
         return date("Y-m-d H:00:00");
     }

◆ getWikiAggr()

static ilWikiStat::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`
	)

staticprotected

Definition at line 538 of file class.ilWikiStat.php.

References $DIC, $ilDB, and $res.

      : 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;
     }

◆ getWikiAggrSub()

static ilWikiStat::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`
	)

staticprotected

Definition at line 643 of file class.ilWikiStat.php.

References $DIC, $ilDB, $res, and exit.

      : 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;
     }

◆ getWikiCharacters()

static ilWikiStat::getWikiCharacters	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1067 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiCharactersAvg()

static ilWikiStat::getWikiCharactersAvg	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1075 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiDeletedPages()

static ilWikiStat::getWikiDeletedPages	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 845 of file class.ilWikiStat.php.

      : array {
         return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat", "del_pages", "SUM(%s)");
     }

◆ getWikiEditPagesAvg()

static ilWikiStat::getWikiEditPagesAvg	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 889 of file class.ilWikiStat.php.

References $DIC, $ilDB, and $res.

      : 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;
     }

◆ getWikiEditPagesSum()

static ilWikiStat::getWikiEditPagesSum	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 861 of file class.ilWikiStat.php.

References $DIC, $ilDB, and $res.

      : 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;
     }

◆ getWikiExternalLinks()

static ilWikiStat::getWikiExternalLinks	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1035 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiExternalLinksAvg()

static ilWikiStat::getWikiExternalLinksAvg	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1043 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiFootnotes()

static ilWikiStat::getWikiFootnotes	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1083 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiFootnotesAvg()

static ilWikiStat::getWikiFootnotesAvg	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1091 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiInternalLinks()

static ilWikiStat::getWikiInternalLinks	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1019 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiInternalLinksAvg()

static ilWikiStat::getWikiInternalLinksAvg	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1027 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiLast()

static ilWikiStat::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`
	)

staticprotected

Definition at line 615 of file class.ilWikiStat.php.

References $DIC, and $ilDB.

      : 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);
     }

◆ getWikiNewPagesAvg()

static ilWikiStat::getWikiNewPagesAvg	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 837 of file class.ilWikiStat.php.

      : array {
         return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_user", "new_pages", "user_id", "AVG(%s)", "SUM(%s)");
     }

◆ getWikiNewPagesSum()

static ilWikiStat::getWikiNewPagesSum	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 829 of file class.ilWikiStat.php.

      : array {
         return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_user", "new_pages", "SUM(%s)");
     }

◆ getWikiNumPages()

static ilWikiStat::getWikiNumPages	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 821 of file class.ilWikiStat.php.

      : array {
         return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat", "num_pages", "MAX(%s)", null, null, true);
     }

◆ getWikiNumRating()

static ilWikiStat::getWikiNumRating	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 988 of file class.ilWikiStat.php.

      : array {
         return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "num_ratings", "SUM(%s)");
     }

◆ getWikiNumRatingAvg()

static ilWikiStat::getWikiNumRatingAvg	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 996 of file class.ilWikiStat.php.

      : array {
         return self::getWikiAggrSub($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "num_ratings", "page_id", "AVG(%s)", "SUM(%s)");
     }

◆ getWikiPageChanges()

static ilWikiStat::getWikiPageChanges	(	int	$a_wiki_id,
		int	$a_page_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1104 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiPageChangesAvg()

static ilWikiStat::getWikiPageChangesAvg	(	int	$a_wiki_id,
		int	$a_page_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1113 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiPageCharacters()

static ilWikiStat::getWikiPageCharacters	(	int	$a_wiki_id,
		int	$a_page_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1167 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiPageExternalLinks()

static ilWikiStat::getWikiPageExternalLinks	(	int	$a_wiki_id,
		int	$a_page_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1149 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiPageFootnotes()

static ilWikiStat::getWikiPageFootnotes	(	int	$a_wiki_id,
		int	$a_page_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1176 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiPageInternalLinks()

static ilWikiStat::getWikiPageInternalLinks	(	int	$a_wiki_id,
		int	$a_page_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1140 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiPageRatings()

static ilWikiStat::getWikiPageRatings	(	int	$a_wiki_id,
		int	$a_page_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1185 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiPageRead()

static ilWikiStat::getWikiPageRead	(	int	$a_wiki_id,
		int	$a_page_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1131 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiPageUserEdit()

static ilWikiStat::getWikiPageUserEdit	(	int	$a_wiki_id,
		int	$a_page_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1122 of file class.ilWikiStat.php.

      : array {
         return self::getWikiUserEditPages($a_wiki_id, $a_day_from, $a_day_to, "page_id", $a_page_id);
     }

◆ getWikiPageWords()

static ilWikiStat::getWikiPageWords	(	int	$a_wiki_id,
		int	$a_page_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1158 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiRatingAvg()

static ilWikiStat::getWikiRatingAvg	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1004 of file class.ilWikiStat.php.

References $res.

      : 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;
     }

◆ getWikiReadPages()

static ilWikiStat::getWikiReadPages	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 853 of file class.ilWikiStat.php.

      : array {
         return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page_user", "read_events", "SUM(%s)");
     }

◆ getWikiUserEditPages()

static ilWikiStat::getWikiUserEditPages	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to,
		?string	$a_sub_field = `null`,
		?int	$a_sub_id = `null`
	)

staticprotected

Definition at line 922 of file class.ilWikiStat.php.

References $DIC, $ilDB, and $res.

      : 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;
     }

◆ getWikiUserEditPagesAvg()

static ilWikiStat::getWikiUserEditPagesAvg	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 955 of file class.ilWikiStat.php.

References $DIC, $ilDB, and $res.

      : 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;
     }

◆ getWikiWords()

static ilWikiStat::getWikiWords	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1051 of file class.ilWikiStat.php.

      : 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);
     }

◆ getWikiWordsAvg()

static ilWikiStat::getWikiWordsAvg	(	int	$a_wiki_id,
		string	$a_day_from,
		string	$a_day_to
	)

staticprotected

Definition at line 1059 of file class.ilWikiStat.php.

      : 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);
     }

◆ handleEvent()

static ilWikiStat::handleEvent	(	int	$a_event,
		ilWikiPage	$a_page_obj,
		?int	$a_user_id = `null`,
		array	$a_additional_data = `null`
	)

static

Handle wiki page event.

Definition at line 142 of file class.ilWikiStat.php.

References $DIC, $ilUser, and ANONYMOUS_USER_ID.

Referenced by ilWikiPage\afterUpdate(), ilWikiPage\create(), ilWikiPage\delete(), ilWikiPageGUI\increaseViewCount(), and ilWikiPageGUI\updateStatsRating().

      : 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:
         }
     }

Here is the caller graph for this function:

◆ handlePageCreated()

static ilWikiStat::handlePageCreated	(	ilWikiPage	$a_page_obj,
		int	$a_user_id
	)

static

Handle wiki page creation.

Definition at line 373 of file class.ilWikiStat.php.

References ilWikiPage\getWikiId().

      : 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)
             )
         );
     }

Here is the call graph for this function:

◆ handlePageDeletion()

static ilWikiStat::handlePageDeletion	(	ilWikiPage	$a_page_obj,
		int	$a_user_id
	)

static

Definition at line 443 of file class.ilWikiStat.php.

References $data, $DIC, $ilDB, ilPageObject\getId(), and ilWikiPage\getWikiId().

      : 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)
             )
         );
     }

Here is the call graph for this function:

◆ handlePageRating()

static ilWikiStat::handlePageRating	(	ilWikiPage	$a_page_obj,
		int	$a_user_id
	)

static

Definition at line 495 of file class.ilWikiStat.php.

References ilPageObject\getId(), and ilWikiPage\getWikiId().

      : 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()))
                 )
             );
         }
     }

Here is the call graph for this function:

◆ handlePageRead()

static ilWikiStat::handlePageRead	(	ilWikiPage	$a_page_obj,
		int	$a_user_id
	)

static

Definition at line 428 of file class.ilWikiStat.php.

References ilPageObject\getId(), and ilWikiPage\getWikiId().

      : 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)
             )
         );
     }

Here is the call graph for this function:

◆ handlePageUpdated()

static ilWikiStat::handlePageUpdated	(	ilWikiPage	$a_page_obj,
		int	$a_user_id,
		array	$a_page_data = `null`
	)

static

Handle wiki page update.

Definition at line 400 of file class.ilWikiStat.php.

References ilPageObject\getId(), and ilWikiPage\getWikiId().

      : 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);
     }

Here is the call graph for this function:

◆ writeData()

static ilWikiStat::writeData	(	string	$a_table,
		array	$a_primary,
		array	$a_values
	)

staticprotected

Write data to DB.

Handles update/insert depending on time frame
supports increment/decrement custom values

Definition at line 198 of file class.ilWikiStat.php.

References $DIC, $ilDB, ilDBInterface\manipulate(), ilDBInterface\numRows(), ilDBInterface\query(), and ilDBInterface\quote().

      : 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;
     }

Here is the call graph for this function:

◆ writeStat()

static ilWikiStat::writeStat	(	string	$a_wiki_id,
		array	$a_values
	)

staticprotected

Write data to wiki_stat.

Definition at line 279 of file class.ilWikiStat.php.

      : bool {
         $primary = array(
             "wiki_id" => array("integer", $a_wiki_id)
         );
         return self::writeData("wiki_stat", $primary, $a_values);
     }

◆ writeStatPage()

static ilWikiStat::writeStatPage	(	int	$a_wiki_id,
		int	$a_page_id,
		array	$a_values
	)

staticprotected

Write data to wiki_stat_page.

Parameters

int	$a_wiki_id
int	$a_page_id
array	$a_values

Definition at line 295 of file class.ilWikiStat.php.

      : 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);
     }

◆ writeStatPageUser()

static ilWikiStat::writeStatPageUser	(	int	$a_wiki_id,
		int	$a_page_id,
		int	$a_user_id,
		array	$a_values
	)

staticprotected

Write data to wiki_stat_page_user.

Definition at line 310 of file class.ilWikiStat.php.

      : 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);
     }

◆ writeStatUser()

static ilWikiStat::writeStatUser	(	int	$a_wiki_id,
		int	$a_user_id,
		array	$a_values
	)

staticprotected

Write to wiki_stat_user.

Definition at line 327 of file class.ilWikiStat.php.

      : 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);
     }

Field Documentation

◆ EVENT_PAGE_CREATED

const ilWikiStat::EVENT_PAGE_CREATED = 1

Definition at line 95 of file class.ilWikiStat.php.

Referenced by ilWikiPage\create().

◆ EVENT_PAGE_DELETED

const ilWikiStat::EVENT_PAGE_DELETED = 4

Definition at line 98 of file class.ilWikiStat.php.

Referenced by ilWikiPage\delete().

◆ EVENT_PAGE_RATING

const ilWikiStat::EVENT_PAGE_RATING = 5

Definition at line 99 of file class.ilWikiStat.php.

Referenced by ilWikiPageGUI\updateStatsRating().

◆ EVENT_PAGE_READ

const ilWikiStat::EVENT_PAGE_READ = 3

Definition at line 97 of file class.ilWikiStat.php.

Referenced by ilWikiPageGUI\increaseViewCount().

◆ EVENT_PAGE_UPDATED

const ilWikiStat::EVENT_PAGE_UPDATED = 2

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

Referenced by ilWikiPage\afterUpdate().

◆ KEY_FIGURE_WIKI_CHARS

const ilWikiStat::KEY_FIGURE_WIKI_CHARS = 19

Definition at line 119 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_CHARS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_CHARS_AVG = 20

Definition at line 120 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_DELETED_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_DELETED_PAGES = 6

Definition at line 106 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_EDIT_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_EDIT_PAGES = 4

Definition at line 104 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_EDIT_PAGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_EDIT_PAGES_AVG = 5

Definition at line 105 of file class.ilWikiStat.php.

◆ KEY_FIGURE_WIKI_EXTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_EXTERNAL_LINKS = 15

Definition at line 115 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG = 16

Definition at line 116 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_FOOTNOTES

const ilWikiStat::KEY_FIGURE_WIKI_FOOTNOTES = 21

Definition at line 121 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_FOOTNOTES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_FOOTNOTES_AVG = 22

Definition at line 122 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_INTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_INTERNAL_LINKS = 13

Definition at line 113 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG = 14

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_NEW_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_NEW_PAGES = 2

Definition at line 102 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_NEW_PAGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_NEW_PAGES_AVG = 3

Definition at line 103 of file class.ilWikiStat.php.

◆ KEY_FIGURE_WIKI_NUM_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_NUM_PAGES = 1

Definition at line 101 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph(), and ilWikiStatGUI\viewToolbar().

◆ KEY_FIGURE_WIKI_NUM_RATING

const ilWikiStat::KEY_FIGURE_WIKI_NUM_RATING = 10

Definition at line 110 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_NUM_RATING_AVG

const ilWikiStat::KEY_FIGURE_WIKI_NUM_RATING_AVG = 11

Definition at line 111 of file class.ilWikiStat.php.

◆ KEY_FIGURE_WIKI_PAGE_CHANGES

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_CHANGES = 23

Definition at line 124 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph(), and ilWikiStatGUI\viewToolbar().

◆ KEY_FIGURE_WIKI_PAGE_CHANGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_CHANGES_AVG = 24

Definition at line 125 of file class.ilWikiStat.php.

◆ KEY_FIGURE_WIKI_PAGE_CHARS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_CHARS = 30

Definition at line 131 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS = 28

Definition at line 129 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_FOOTNOTES

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_FOOTNOTES = 31

Definition at line 132 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS = 27

Definition at line 128 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_RATINGS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_RATINGS = 32

Definition at line 133 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_READ

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_READ = 26

Definition at line 127 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_USER_EDIT

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_USER_EDIT = 25

Definition at line 126 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_WORDS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_WORDS = 29

Definition at line 130 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_RATING_AVG

const ilWikiStat::KEY_FIGURE_WIKI_RATING_AVG = 12

Definition at line 112 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_READ_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_READ_PAGES = 7

Definition at line 107 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_USER_EDIT_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_USER_EDIT_PAGES = 8

Definition at line 108 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG = 9

Definition at line 109 of file class.ilWikiStat.php.

◆ KEY_FIGURE_WIKI_WORDS

const ilWikiStat::KEY_FIGURE_WIKI_WORDS = 17

Definition at line 117 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_WORDS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_WORDS_AVG = 18

Definition at line 118 of file class.ilWikiStat.php.

Referenced by ilWikiStatGUI\renderGraph().

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

Modules/Wiki/classes/class.ilWikiStat.php

Static Public Member Functions

Data Fields

Static Protected Member Functions

Detailed Description

Member Function Documentation

◆ buildFullPeriodData()

◆ countPages()

◆ getAvailableMonths()

◆ getAverageRating()

◆ getFigureData()

◆ getFigureDataPage()

◆ getFigureOptions()

◆ getFigureOptionsPage()

◆ getFigures()

◆ getFiguresPage()

◆ getFigureTitle()

◆ getTimestamp()

◆ getWikiAggr()

◆ getWikiAggrSub()

◆ getWikiCharacters()

◆ getWikiCharactersAvg()

◆ getWikiDeletedPages()

◆ getWikiEditPagesAvg()

◆ getWikiEditPagesSum()

◆ getWikiExternalLinks()

◆ getWikiExternalLinksAvg()

◆ getWikiFootnotes()

◆ getWikiFootnotesAvg()

◆ getWikiInternalLinks()

◆ getWikiInternalLinksAvg()

◆ getWikiLast()

◆ getWikiNewPagesAvg()

◆ getWikiNewPagesSum()

◆ getWikiNumPages()

◆ getWikiNumRating()

◆ getWikiNumRatingAvg()

◆ getWikiPageChanges()

◆ getWikiPageChangesAvg()

◆ getWikiPageCharacters()

◆ getWikiPageExternalLinks()

◆ getWikiPageFootnotes()

◆ getWikiPageInternalLinks()

◆ getWikiPageRatings()

◆ getWikiPageRead()

◆ getWikiPageUserEdit()

◆ getWikiPageWords()

◆ getWikiRatingAvg()

◆ getWikiReadPages()

◆ getWikiUserEditPages()

◆ getWikiUserEditPagesAvg()

◆ getWikiWords()

◆ getWikiWordsAvg()

◆ handleEvent()

◆ handlePageCreated()

◆ handlePageDeletion()

◆ handlePageRating()

◆ handlePageRead()

◆ handlePageUpdated()

◆ writeData()

◆ writeStat()

◆ writeStatPage()

◆ writeStatPageUser()

◆ writeStatUser()

Field Documentation

◆ EVENT_PAGE_CREATED

◆ EVENT_PAGE_DELETED

◆ EVENT_PAGE_RATING

◆ EVENT_PAGE_READ

◆ EVENT_PAGE_UPDATED

◆ KEY_FIGURE_WIKI_CHARS

◆ KEY_FIGURE_WIKI_CHARS_AVG

◆ KEY_FIGURE_WIKI_DELETED_PAGES

◆ KEY_FIGURE_WIKI_EDIT_PAGES

◆ KEY_FIGURE_WIKI_EDIT_PAGES_AVG

◆ KEY_FIGURE_WIKI_EXTERNAL_LINKS

◆ KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG

◆ KEY_FIGURE_WIKI_FOOTNOTES

◆ KEY_FIGURE_WIKI_FOOTNOTES_AVG

◆ KEY_FIGURE_WIKI_INTERNAL_LINKS

◆ KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG