ilWikiStat Class Reference

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 785 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
                                        else if($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 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 351 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 1095 of file class.ilWikiStat.php.

        {
                global $ilDB;
                
                $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 $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 363 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 1202 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);                           
                }
        }

References getWikiCharacters(), getWikiCharactersAvg(), getWikiDeletedPages(), getWikiEditPagesAvg(), getWikiEditPagesSum(), getWikiExternalLinks(), getWikiExternalLinksAvg(), getWikiFootnotes(), getWikiFootnotesAvg(), getWikiInternalLinks(), getWikiInternalLinksAvg(), getWikiNewPagesAvg(), getWikiNewPagesSum(), getWikiNumPages(), getWikiNumRating(), getWikiNumRatingAvg(), getWikiRatingAvg(), getWikiReadPages(), getWikiUserEditPages(), getWikiWords(), getWikiWordsAvg(), 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, KEY_FIGURE_WIKI_NEW_PAGES, KEY_FIGURE_WIKI_NEW_PAGES_AVG, KEY_FIGURE_WIKI_NUM_PAGES, KEY_FIGURE_WIKI_NUM_RATING, KEY_FIGURE_WIKI_NUM_RATING_AVG, KEY_FIGURE_WIKI_RATING_AVG, KEY_FIGURE_WIKI_READ_PAGES, KEY_FIGURE_WIKI_USER_EDIT_PAGES, KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG, KEY_FIGURE_WIKI_WORDS, and KEY_FIGURE_WIKI_WORDS_AVG.

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

References getWikiPageChanges(), getWikiPageChangesAvg(), getWikiPageCharacters(), getWikiPageExternalLinks(), getWikiPageFootnotes(), getWikiPageInternalLinks(), getWikiPageRatings(), getWikiPageRead(), getWikiPageUserEdit(), getWikiPageWords(), KEY_FIGURE_WIKI_PAGE_CHANGES, KEY_FIGURE_WIKI_PAGE_CHANGES_AVG, KEY_FIGURE_WIKI_PAGE_CHARS, KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS, KEY_FIGURE_WIKI_PAGE_FOOTNOTES, KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS, KEY_FIGURE_WIKI_PAGE_RATINGS, KEY_FIGURE_WIKI_PAGE_READ, KEY_FIGURE_WIKI_PAGE_USER_EDIT, and KEY_FIGURE_WIKI_PAGE_WORDS.

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 1310 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 1322 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 1114 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 1142 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 1158 of file class.ilWikiStat.php.

        {
                global $lng;
                
                $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 $lng.

Referenced by 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 180 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 543 of file class.ilWikiStat.php.

        {
                global $ilDB;
                
                $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 $ilDB, $res, $row, buildFullPeriodData(), and getWikiLast().

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

        {
                global $ilDB;
                
                $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 $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 1015 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 1020 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 842 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 876 of file class.ilWikiStat.php.

        {
                global $ilDB;
                
                $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 $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 852 of file class.ilWikiStat.php.

        {               
                global $ilDB;
                
                $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 $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 995 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 1000 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 1025 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 1030 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 985 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 990 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 618 of file class.ilWikiStat.php.

        {
                global $ilDB;
                
                // 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 $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 837 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 832 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 827 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 962 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 967 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 1040 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 1045 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 1075 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 1065 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 1080 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 1060 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 1085 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 1055 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 1050 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 1070 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 972 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 847 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 905 of file class.ilWikiStat.php.

        {               
                global $ilDB;
                
                $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 $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 933 of file class.ilWikiStat.php.

        {
                global $ilDB;
                
                $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 $ilDB, $res, and $row.

getWikiWords()

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

staticprotected

Definition at line 1005 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 1010 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 $ilUser;
                
                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 $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 389 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 $ilDB;
                
                // 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, $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 508 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 440 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 413 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 195 of file class.ilWikiStat.php.

        {
                global $ilDB;
                
                $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";
                                        }
                                        else if($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";
                                        }
                                        else if($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, $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 287 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 302 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 319 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 336 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);
        }

References writeData().

Referenced by handlePageCreated().

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

EVENT_PAGE_CREATED

const ilWikiStat::EVENT_PAGE_CREATED = 1

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

Referenced by ilWikiPage\create(), and handleEvent().

EVENT_PAGE_DELETED

const ilWikiStat::EVENT_PAGE_DELETED = 4

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

Referenced by ilWikiPage\delete(), and handleEvent().

EVENT_PAGE_RATING

const ilWikiStat::EVENT_PAGE_RATING = 5

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

Referenced by handleEvent(), and ilWikiPageGUI\updateStatsRating().

EVENT_PAGE_READ

const ilWikiStat::EVENT_PAGE_READ = 3

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

Referenced by handleEvent(), and ilWikiPageGUI\increaseViewCount().

EVENT_PAGE_UPDATED

const ilWikiStat::EVENT_PAGE_UPDATED = 2

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

Referenced by ilWikiPage\afterUpdate(), and handleEvent().

KEY_FIGURE_WIKI_CHARS

const ilWikiStat::KEY_FIGURE_WIKI_CHARS = 19

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

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

KEY_FIGURE_WIKI_CHARS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_CHARS_AVG = 20

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

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

KEY_FIGURE_WIKI_DELETED_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_DELETED_PAGES = 6

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

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

KEY_FIGURE_WIKI_EDIT_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_EDIT_PAGES = 4

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

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

KEY_FIGURE_WIKI_EDIT_PAGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_EDIT_PAGES_AVG = 5

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

Referenced by getFigureData().

KEY_FIGURE_WIKI_EXTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_EXTERNAL_LINKS = 15

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

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

KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG = 16

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

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

KEY_FIGURE_WIKI_FOOTNOTES

const ilWikiStat::KEY_FIGURE_WIKI_FOOTNOTES = 21

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

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

KEY_FIGURE_WIKI_FOOTNOTES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_FOOTNOTES_AVG = 22

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

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

KEY_FIGURE_WIKI_INTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_INTERNAL_LINKS = 13

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

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

KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG = 14

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

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

KEY_FIGURE_WIKI_NEW_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_NEW_PAGES = 2

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

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

KEY_FIGURE_WIKI_NEW_PAGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_NEW_PAGES_AVG = 3

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

Referenced by getFigureData().

KEY_FIGURE_WIKI_NUM_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_NUM_PAGES = 1

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

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

KEY_FIGURE_WIKI_NUM_RATING

const ilWikiStat::KEY_FIGURE_WIKI_NUM_RATING = 10

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

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

KEY_FIGURE_WIKI_NUM_RATING_AVG

const ilWikiStat::KEY_FIGURE_WIKI_NUM_RATING_AVG = 11

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

Referenced by getFigureData().

KEY_FIGURE_WIKI_PAGE_CHANGES

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_CHANGES = 23

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

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

KEY_FIGURE_WIKI_PAGE_CHANGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_CHANGES_AVG = 24

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

Referenced by getFigureDataPage().

KEY_FIGURE_WIKI_PAGE_CHARS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_CHARS = 30

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

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

KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS = 28

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

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

KEY_FIGURE_WIKI_PAGE_FOOTNOTES

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_FOOTNOTES = 31

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

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

KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS = 27

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

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

KEY_FIGURE_WIKI_PAGE_RATINGS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_RATINGS = 32

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

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

KEY_FIGURE_WIKI_PAGE_READ

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_READ = 26

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

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

KEY_FIGURE_WIKI_PAGE_USER_EDIT

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_USER_EDIT = 25

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

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

KEY_FIGURE_WIKI_PAGE_WORDS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_WORDS = 29

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

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

KEY_FIGURE_WIKI_RATING_AVG

const ilWikiStat::KEY_FIGURE_WIKI_RATING_AVG = 12

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

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

KEY_FIGURE_WIKI_READ_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_READ_PAGES = 7

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

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

KEY_FIGURE_WIKI_USER_EDIT_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_USER_EDIT_PAGES = 8

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

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

KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG = 9

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

Referenced by getFigureData().

KEY_FIGURE_WIKI_WORDS

const ilWikiStat::KEY_FIGURE_WIKI_WORDS = 17

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

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

KEY_FIGURE_WIKI_WORDS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_WORDS_AVG = 18

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

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

---

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

• Modules/Wiki/classes/class.ilWikiStat.php