Wiki statistics class. More...

Collaboration diagram for ilWikiStat:

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

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

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

static	handlePageRead (ilWikiPage $a_page_obj, $a_user_id)
	Handle wiki page read. More...

static	handlePageDeletion (ilWikiPage $a_page_obj, $a_user_id)
	Handle wiki page deletion. More...

static	handlePageRating (ilWikiPage $a_page_obj, $a_user_id)
	Handle wiki page rating. More...

static	getAvailableMonths ($a_wiki_id)

static	getFigures ()

static	getFiguresPage ()

static	getFigureTitle ($a_figure)

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

static	getFigureDataPage ($a_wiki_id, $a_page_id, $a_figure, $a_from, $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 ($a_table, array $a_primary, array $a_values)
	Write data to DB. More...

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

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

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

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

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

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

static	getWikiAggr ($a_wiki_id, $a_day_from, $a_day_to, $a_table, $a_field, $a_aggr_value, $a_sub_field=null, $a_sub_id=null, $a_build_full_period=false)

static	getWikiLast ($a_wiki_id, $a_day_from, $a_table, $a_field, $a_sub_field=null, $a_sub_id=null)

static	getWikiAggrSub ($a_wiki_id, $a_day_from, $a_day_to, $a_table, $a_field, $a_aggr_by, $a_aggr_value, $a_aggr_sub, $a_sub_field=null, $a_sub_id=null, $a_build_full_period=false)

static	buildFullPeriodData (array &$a_res, $a_day_from, $a_day_to, $a_last_before_period, $a_allow_zero=false)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Detailed Description

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; Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version: $Id$

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

Member Function Documentation

◆ buildFullPeriodData()

static ilWikiStat::buildFullPeriodData	(	array &	$a_res,
			$a_day_from,
			$a_day_to,
			$a_last_before_period,
			$a_allow_zero = `false`
	)

staticprotected

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

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

References $current, and date.

Referenced by getWikiAggr(), and getWikiAggrSub().

Here is the caller graph for this function:

◆ countPages()

static ilWikiStat::countPages ( $a_wiki_id )

staticprotected

Count pages in wiki.

Parameters

int $a_wiki_id

Returns: int

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

    {
        return sizeof(ilWikiPage::getAllWikiPages($a_wiki_id));
    }

References ilWikiPage\getAllWikiPages().

Here is the call graph for this function:

◆ getAvailableMonths()

static ilWikiStat::getAvailableMonths ( $a_wiki_id )

static

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

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

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

Referenced by ilWikiStatGUI\viewToolbar().

Here is the caller graph for this function:

◆ getAverageRating()

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

staticprotected

Get average rating for wiki or wiki page.

Parameters

int	$a_wiki_id
int	$a_page_id

Returns: array

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

    {
        include_once "Services/Rating/classes/class.ilRating.php";
        
        if (!$a_page_id) {
            return ilRating::getOverallRatingForObject(
                $a_wiki_id,
                "wiki"
            );
        } else {
            return ilRating::getOverallRatingForObject(
                $a_wiki_id,
                "wiki",
                $a_page_id,
                "wpg"
            );
        }
    }

References ilRating\getOverallRatingForObject().

Referenced by handlePageDeletion(), and handlePageRating().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getFigureData()

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

static

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

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

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getFigureDataPage()

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

static

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

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

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getFigureOptions()

static ilWikiStat::getFigureOptions ( )

static

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

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

References $res, and getFigureTitle().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getFigureOptionsPage()

static ilWikiStat::getFigureOptionsPage ( )

static

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

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

References $res, and getFigureTitle().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getFigures()

static ilWikiStat::getFigures ( )

static

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

    {
        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 1126 of file class.ilWikiStat.php.

    {
        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 ( $a_figure )

static

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

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

References $DIC, and $lng.

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

Here is the caller graph for this function:

◆ getTimestamp()

static ilWikiStat::getTimestamp ( )

staticprotected

Get current time frame (hourly)

Returns: string

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

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

References date.

Referenced by writeData().

Here is the caller graph for this function:

◆ getWikiAggr()

static ilWikiStat::getWikiAggr	(	$a_wiki_id,
		$a_day_from,
		$a_day_to,
		$a_table,
		$a_field,
		$a_aggr_value,
		$a_sub_field = `null`,
		$a_sub_id = `null`,
		$a_build_full_period = `false`
	)

staticprotected

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

    {
        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"], $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]) {
                $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;
    }

References $DIC, $ilDB, $res, $row, buildFullPeriodData(), getWikiLast(), and sprintf.

Referenced by getWikiDeletedPages(), getWikiNewPagesSum(), getWikiNumPages(), getWikiNumRating(), getWikiPageChanges(), getWikiPageCharacters(), getWikiPageExternalLinks(), getWikiPageFootnotes(), getWikiPageInternalLinks(), getWikiPageRatings(), getWikiPageRead(), getWikiPageWords(), getWikiRatingAvg(), and getWikiReadPages().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiAggrSub()

static ilWikiStat::getWikiAggrSub	(	$a_wiki_id,
		$a_day_from,
		$a_day_to,
		$a_table,
		$a_field,
		$a_aggr_by,
		$a_aggr_value,
		$a_aggr_sub,
		$a_sub_field = `null`,
		$a_sub_id = `null`,
		$a_build_full_period = `false`
	)

staticprotected

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

    {
        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)) {
                    var_dump("unexpected wiki_stat_page_entry", $row);
                }
                $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 (!is_array($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]) {
                    $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 = isset($first_day_in_period[$aggr_by_id])
                    ? $first_day_in_period[$aggr_by_id]
                    : $a_day_from;
                
                // if sub was deleted in period (see above), shorten period accordingly
                $last_period_day = isset($deleted_in_period[$aggr_by_id])
                    ? $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)/sizeof($values);
                        break;
                    
                    case "SUM(%s)":
                        $res[$day] = array_sum($values);
                        break;
                    
                    default:
                        var_dump("unsupport aggr " . $a_aggr_value);
                        break;
                }
            }
        }
        
        return $res;
    }

References $DIC, $ilDB, $res, $row, buildFullPeriodData(), exit, getWikiLast(), and sprintf.

Referenced by getWikiCharacters(), getWikiCharactersAvg(), getWikiExternalLinks(), getWikiExternalLinksAvg(), getWikiFootnotes(), getWikiFootnotesAvg(), getWikiInternalLinks(), getWikiInternalLinksAvg(), getWikiNewPagesAvg(), getWikiNumRatingAvg(), getWikiPageChangesAvg(), getWikiWords(), and getWikiWordsAvg().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiCharacters()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiCharactersAvg()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiDeletedPages()

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

staticprotected

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

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

References getWikiAggr().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiEditPagesAvg()

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

staticprotected

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

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

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

Referenced by getFigureData().

Here is the caller graph for this function:

◆ getWikiEditPagesSum()

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

staticprotected

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

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

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

Referenced by getFigureData().

Here is the caller graph for this function:

◆ getWikiExternalLinks()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiExternalLinksAvg()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiFootnotes()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiFootnotesAvg()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiInternalLinks()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiInternalLinksAvg()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiLast()

static ilWikiStat::getWikiLast	(	$a_wiki_id,
		$a_day_from,
		$a_table,
		$a_field,
		$a_sub_field = `null`,
		$a_sub_id = `null`
	)

staticprotected

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

    {
        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);
        $set = $ilDB->query($sql);
        $last_before_period = $ilDB->fetchAssoc($set);
        return $last_before_period["latest"];
    }

References $DIC, and $ilDB.

Referenced by getWikiAggr(), and getWikiAggrSub().

Here is the caller graph for this function:

◆ getWikiNewPagesAvg()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiNewPagesSum()

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

staticprotected

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

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

References getWikiAggr().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiNumPages()

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

staticprotected

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

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

References getWikiAggr().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiNumRating()

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

staticprotected

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

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

References getWikiAggr().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiNumRatingAvg()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiPageChanges()

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

staticprotected

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

    {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page_user", "changes", "SUM(%s)", "page_id", $a_page_id);
    }

References getWikiAggr().

Referenced by getFigureDataPage().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiPageChangesAvg()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureDataPage().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiPageCharacters()

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

staticprotected

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

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

References getWikiAggr().

Referenced by getFigureDataPage().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiPageExternalLinks()

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

staticprotected

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

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

References getWikiAggr().

Referenced by getFigureDataPage().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiPageFootnotes()

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

staticprotected

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

    {
        return self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat_page", "footnotes", "MAX(%s)", "page_id", $a_page_id, true);
    }

References getWikiAggr().

Referenced by getFigureDataPage().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiPageInternalLinks()

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

staticprotected

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

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

References getWikiAggr().

Referenced by getFigureDataPage().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiPageRatings()

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

staticprotected

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

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

References getWikiAggr().

Referenced by getFigureDataPage().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiPageRead()

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

staticprotected

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

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

References getWikiAggr().

Referenced by getFigureDataPage().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiPageUserEdit()

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

staticprotected

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

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

References getWikiUserEditPages().

Referenced by getFigureDataPage().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiPageWords()

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

staticprotected

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

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

References getWikiAggr().

Referenced by getFigureDataPage().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiRatingAvg()

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

staticprotected

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

    {
        $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] = $res[$day]/100;
        }
        
        return $res;
    }

References $res, and getWikiAggr().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiReadPages()

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

staticprotected

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

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

References getWikiAggr().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiUserEditPages()

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

staticprotected

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

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

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

Referenced by getFigureData(), and getWikiPageUserEdit().

Here is the caller graph for this function:

◆ getWikiUserEditPagesAvg()

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

staticprotected

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

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

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

◆ getWikiWords()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getWikiWordsAvg()

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

staticprotected

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

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

References getWikiAggrSub().

Referenced by getFigureData().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ handleEvent()

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

static

Handle wiki page event.

Parameters

int	$a_event
ilWikiPage	$a_page_obj
int	$a_user_id
int	$a_additional_data

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

    {
        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 ((int) $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:
                return;
        }
    }

References $DIC, $ilUser, EVENT_PAGE_CREATED, EVENT_PAGE_DELETED, EVENT_PAGE_RATING, EVENT_PAGE_READ, EVENT_PAGE_UPDATED, handlePageCreated(), handlePageDeletion(), handlePageRating(), handlePageRead(), and handlePageUpdated().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ handlePageCreated()

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

static

Handle wiki page creation.

Parameters

ilWikiPage	$a_page_obj
int	$a_user_id

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

    {
        // 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)
            )
        );
    }

References ilWikiPage\getWikiId(), writeStat(), and writeStatUser().

Referenced by handleEvent().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ handlePageDeletion()

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

static

Handle wiki page deletion.

Parameters

ilWikiPage	$a_page_obj
int	$a_user_id

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

    {
        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);
        $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((int) $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)
            )
        );
    }

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

Referenced by handleEvent().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ handlePageRating()

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

static

Handle wiki page rating.

Parameters

ilWikiPage	$a_page_obj
int	$a_user_id

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

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

References getAverageRating(), ilPageObject\getId(), ilWikiPage\getWikiId(), writeStat(), and writeStatPage().

Referenced by handleEvent().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ handlePageRead()

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

static

Handle wiki page read.

Parameters

ilWikiPage	$a_page_obj
int	$a_user_id

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

    {
        // page_user: read_events+1
        self::writeStatPageUser(
            $a_page_obj->getWikiId(),
            $a_page_obj->getId(),
            $a_user_id,
            array(
                "read_events" => array("increment", 1)
            )
        );
    }

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

Referenced by handleEvent().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ handlePageUpdated()

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

static

Handle wiki page update.

Parameters

ilWikiPage	$a_page_obj
int	$a_user_id
array	$a_page_data

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

    {
        // 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);
    }

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

Referenced by handleEvent().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ writeData()

static ilWikiStat::writeData	(		$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

Parameters

string	$a_table
array	$a_primary
array	$a_values

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

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

References $column, $columns, $DIC, $ilDB, and getTimestamp().

Referenced by writeStat(), writeStatPage(), writeStatPageUser(), and writeStatUser().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ writeStat()

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

staticprotected

Write data to wiki_stat.

Parameters

int	$a_wiki_id
array	$a_values

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

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

References writeData().

Referenced by handlePageCreated(), handlePageDeletion(), and handlePageRating().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ writeStatPage()

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

staticprotected

Write data to wiki_stat_page.

Parameters

int	$a_wiki_id
int	$a_page_id
array	$a_values

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

    {
        $primary = array(
            "wiki_id" => array("integer", $a_wiki_id),
            "page_id" => array("integer", $a_page_id),
        );
        self::writeData("wiki_stat_page", $primary, $a_values);
    }

References writeData().

Referenced by handlePageDeletion(), handlePageRating(), and handlePageUpdated().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ writeStatPageUser()

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

staticprotected

Write data to wiki_stat_page_user.

Parameters

int	$a_wiki_id
int	$a_page_id
int	$a_user_id
array	$a_values

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

    {
        $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);
    }

References writeData().

Referenced by handlePageRead(), and handlePageUpdated().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ writeStatUser()

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

staticprotected

Write to wiki_stat_user.

Parameters

int	$a_wiki_id
int	$a_user_id
array	$a_values

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

    {
        $primary = array(
            "wiki_id" => array("integer", $a_wiki_id),
            "user_id" => array("integer", $a_user_id)
        );
        self::writeData("wiki_stat_user", $primary, $a_values);
    }