ILIAS  release_5-0 Revision 5.0.0-1144-gc4397b1f870
•All Data Structures Namespaces Files Functions Variables Modules Pages
Static Public Member Functions | Data Fields | Static Protected Member Functions
ilWikiStat Class Reference
Modules/Wiki

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

778  {
779  // build full data for period
780  $safety = 0;
781  $last = null;
782  $today = date("Y-m-d");
783  $current = explode("-", $a_day_from);
784  $current = date("Y-m-d", mktime(0, 0, 1, $current[1], $current[2], $current[0]));
785  while($current <= $a_day_to &&
786  ++$safety < 1000)
787  {
788  if(!isset($a_res[$current]))
789  {
790  if($current <= $today)
791  {
792  // last existing value in period
793  if($last !== null)
794  {
795  $a_res[$current] = $last;
796  }
797  // last existing value before period
798  else if($a_last_before_period || $a_allow_zero)
799  {
800  $a_res[$current] = $a_last_before_period;
801  }
802  }
803  }
804  else
805  {
806  $last = $a_res[$current];
807  }
808 
809  $current = explode("-", $current);
810  $current = date("Y-m-d", mktime(0, 0, 1, $current[1], $current[2]+1, $current[0]));
811  }
812  }

◆ countPages()

static ilWikiStat::countPages (   $a_wiki_id)
staticprotected

Count pages in wiki.

Parameters
int$a_wiki_id
Returns
int

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

References ilWikiPage\getAllPages().

348  {
349  return sizeof(ilWikiPage::getAllPages($a_wiki_id));
350  }
ilWikiPage\getAllPages
static getAllPages($a_wiki_id)
Get all pages of wiki.
Definition: class.ilWikiPage.php:502
+ Here is the call graph for this function:

◆ getAvailableMonths()

static ilWikiStat::getAvailableMonths (   $a_wiki_id)
static

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

References $ilDB, $res, and $row.

Referenced by ilWikiStatGUI\viewToolbar().

1088  {
1089  global $ilDB;
1090 
1091  $res = array();
1092 
1093  // because of read_events this db table is updated most often
1094  $set = $ilDB->query("SELECT DISTINCT(SUBSTR(ts_day, 1, 7)) month".
1095  " FROM wiki_stat_page_user".
1096  " WHERE wiki_id = ".$ilDB->quote($a_wiki_id, "integer").
1097  " AND ts_day IS NOT NULL");
1098  while($row = $ilDB->fetchAssoc($set))
1099  {
1100  $res[] = $row["month"];
1101  }
1102 
1103  return $res;
1104  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16
+ 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 359 of file class.ilWikiStat.php.

References ilRating\getOverallRatingForObject().

360  {
361  include_once "Services/Rating/classes/class.ilRating.php";
362 
363  if(!$a_page_id)
364  {
365  return ilRating::getOverallRatingForObject(
366  $a_wiki_id,
367  "wiki");
368  }
369  else
370  {
371  return ilRating::getOverallRatingForObject(
372  $a_wiki_id,
373  "wiki",
374  $a_page_id,
375  "wpg");
376  }
377  }
ilRating\getOverallRatingForObject
static getOverallRatingForObject($a_obj_id, $a_obj_type, $a_sub_obj_id=null, $a_sub_obj_type=null, $a_category_id=null)
Get overall rating for an object.
Definition: class.ilRating.php:141
+ Here is the call graph for this function:

◆ getFigureData()

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

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

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

1195  {
1196  switch($a_figure)
1197  {
1198  case self::KEY_FIGURE_WIKI_NUM_PAGES:
1199  return self::getWikiNumPages($a_wiki_id, $a_from, $a_to);
1200 
1201  case self::KEY_FIGURE_WIKI_NEW_PAGES:
1202  return self::getWikiNewPagesSum($a_wiki_id, $a_from, $a_to);
1203 
1204  case self::KEY_FIGURE_WIKI_NEW_PAGES_AVG:
1205  return self::getWikiNewPagesAvg($a_wiki_id, $a_from, $a_to);
1206 
1207  case self::KEY_FIGURE_WIKI_EDIT_PAGES:
1208  return self::getWikiEditPagesSum($a_wiki_id, $a_from, $a_to);
1209 
1210  case self::KEY_FIGURE_WIKI_EDIT_PAGES_AVG:
1211  return self::getWikiEditPagesAvg($a_wiki_id, $a_from, $a_to);
1212 
1213  case self::KEY_FIGURE_WIKI_DELETED_PAGES:
1214  return self::getWikiDeletedPages($a_wiki_id, $a_from, $a_to);
1215 
1216  case self::KEY_FIGURE_WIKI_READ_PAGES:
1217  return self::getWikiReadPages($a_wiki_id, $a_from, $a_to);
1218 
1219  case self::KEY_FIGURE_WIKI_USER_EDIT_PAGES:
1220  return self::getWikiUserEditPages($a_wiki_id, $a_from, $a_to);
1221 
1222  case self::KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG:
1223  return self::getWikiUserEditPages($a_wiki_id, $a_from, $a_to);
1224 
1225  case self::KEY_FIGURE_WIKI_NUM_RATING:
1226  return self::getWikiNumRating($a_wiki_id, $a_from, $a_to);
1227 
1228  case self::KEY_FIGURE_WIKI_NUM_RATING_AVG:
1229  return self::getWikiNumRatingAvg($a_wiki_id, $a_from, $a_to);
1230 
1231  case self::KEY_FIGURE_WIKI_RATING_AVG:
1232  return self::getWikiRatingAvg($a_wiki_id, $a_from, $a_to);
1233 
1234  case self::KEY_FIGURE_WIKI_INTERNAL_LINKS:
1235  return self::getWikiInternalLinks($a_wiki_id, $a_from, $a_to);
1236 
1237  case self::KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG:
1238  return self::getWikiInternalLinksAvg($a_wiki_id, $a_from, $a_to);
1239 
1240  case self::KEY_FIGURE_WIKI_EXTERNAL_LINKS:
1241  return self::getWikiExternalLinks($a_wiki_id, $a_from, $a_to);
1242 
1243  case self::KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG:
1244  return self::getWikiExternalLinksAvg($a_wiki_id, $a_from, $a_to);
1245 
1246  case self::KEY_FIGURE_WIKI_WORDS:
1247  return self::getWikiWords($a_wiki_id, $a_from, $a_to);
1248 
1249  case self::KEY_FIGURE_WIKI_WORDS_AVG:
1250  return self::getWikiWordsAvg($a_wiki_id, $a_from, $a_to);
1251 
1252  case self::KEY_FIGURE_WIKI_CHARS:
1253  return self::getWikiCharacters($a_wiki_id, $a_from, $a_to);
1254 
1255  case self::KEY_FIGURE_WIKI_CHARS_AVG:
1256  return self::getWikiCharactersAvg($a_wiki_id, $a_from, $a_to);
1257 
1258  case self::KEY_FIGURE_WIKI_FOOTNOTES:
1259  return self::getWikiFootnotes($a_wiki_id, $a_from, $a_to);
1260 
1261  case self::KEY_FIGURE_WIKI_FOOTNOTES_AVG:
1262  return self::getWikiFootnotesAvg($a_wiki_id, $a_from, $a_to);
1263  }
1264  }
+ 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 1266 of file class.ilWikiStat.php.

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

1267  {
1268  switch($a_figure)
1269  {
1270  case self::KEY_FIGURE_WIKI_PAGE_CHANGES:
1271  return self::getWikiPageChanges($a_wiki_id, $a_page_id, $a_from, $a_to);
1272 
1273  case self::KEY_FIGURE_WIKI_PAGE_CHANGES_AVG:
1274  return self::getWikiPageChangesAvg($a_wiki_id, $a_page_id, $a_from, $a_to);
1275 
1276  case self::KEY_FIGURE_WIKI_PAGE_USER_EDIT:
1277  return self::getWikiPageUserEdit($a_wiki_id, $a_page_id, $a_from, $a_to);
1278 
1279  case self::KEY_FIGURE_WIKI_PAGE_READ:
1280  return self::getWikiPageRead($a_wiki_id, $a_page_id, $a_from, $a_to);
1281 
1282  case self::KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS:
1283  return self::getWikiPageInternalLinks($a_wiki_id, $a_page_id, $a_from, $a_to);
1284 
1285  case self::KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS:
1286  return self::getWikiPageExternalLinks($a_wiki_id, $a_page_id, $a_from, $a_to);
1287 
1288  case self::KEY_FIGURE_WIKI_PAGE_FOOTNOTES:
1289  return self::getWikiPageFootnotes($a_wiki_id, $a_page_id, $a_from, $a_to);
1290 
1291  case self::KEY_FIGURE_WIKI_PAGE_WORDS:
1292  return self::getWikiPageWords($a_wiki_id, $a_page_id, $a_from, $a_to);
1293 
1294  case self::KEY_FIGURE_WIKI_PAGE_CHARS:
1295  return self::getWikiPageCharacters($a_wiki_id, $a_page_id, $a_from, $a_to);
1296 
1297  case self::KEY_FIGURE_WIKI_PAGE_RATINGS:
1298  return self::getWikiPageRatings($a_wiki_id, $a_page_id, $a_from, $a_to);
1299  }
1300  }
+ Here is the caller graph for this function:

◆ getFigureOptions()

static ilWikiStat::getFigureOptions ( )
static

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

References $res.

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

1303  {
1304  $res = array();
1305 
1306  foreach(self::getFigures() as $figure)
1307  {
1308  $res[$figure] = self::getFigureTitle($figure);
1309  }
1310 
1311  return $res;
1312  }
+ Here is the caller graph for this function:

◆ getFigureOptionsPage()

static ilWikiStat::getFigureOptionsPage ( )
static

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

References $res.

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

1315  {
1316  $res = array();
1317 
1318  foreach(self::getFiguresPage() as $figure)
1319  {
1320  $res[$figure] = self::getFigureTitle($figure);
1321  }
1322 
1323  return $res;
1324  }
+ Here is the caller graph for this function:

◆ getFigures()

static ilWikiStat::getFigures ( )
static

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

1107  {
1108  return array(
1109  self::KEY_FIGURE_WIKI_NUM_PAGES
1110  ,self::KEY_FIGURE_WIKI_NEW_PAGES
1111  ,self::KEY_FIGURE_WIKI_NEW_PAGES_AVG
1112  ,self::KEY_FIGURE_WIKI_EDIT_PAGES
1113  ,self::KEY_FIGURE_WIKI_EDIT_PAGES_AVG
1114  ,self::KEY_FIGURE_WIKI_DELETED_PAGES
1115  ,self::KEY_FIGURE_WIKI_READ_PAGES
1116  ,self::KEY_FIGURE_WIKI_USER_EDIT_PAGES
1117  ,self::KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG
1118  ,self::KEY_FIGURE_WIKI_NUM_RATING
1119  ,self::KEY_FIGURE_WIKI_NUM_RATING_AVG
1120  ,self::KEY_FIGURE_WIKI_RATING_AVG
1121  ,self::KEY_FIGURE_WIKI_INTERNAL_LINKS
1122  ,self::KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG
1123  ,self::KEY_FIGURE_WIKI_EXTERNAL_LINKS
1124  ,self::KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG
1125  ,self::KEY_FIGURE_WIKI_WORDS
1126  ,self::KEY_FIGURE_WIKI_WORDS_AVG
1127  ,self::KEY_FIGURE_WIKI_CHARS
1128  ,self::KEY_FIGURE_WIKI_CHARS_AVG
1129  ,self::KEY_FIGURE_WIKI_FOOTNOTES
1130  ,self::KEY_FIGURE_WIKI_FOOTNOTES_AVG
1131  );
1132  }

◆ getFiguresPage()

static ilWikiStat::getFiguresPage ( )
static

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

1135  {
1136  return array(
1137  self::KEY_FIGURE_WIKI_PAGE_CHANGES
1138  ,self::KEY_FIGURE_WIKI_PAGE_CHANGES_AVG
1139  ,self::KEY_FIGURE_WIKI_PAGE_USER_EDIT
1140  ,self::KEY_FIGURE_WIKI_PAGE_READ
1141  ,self::KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS
1142  ,self::KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS
1143  ,self::KEY_FIGURE_WIKI_PAGE_WORDS
1144  ,self::KEY_FIGURE_WIKI_PAGE_CHARS
1145  ,self::KEY_FIGURE_WIKI_PAGE_FOOTNOTES
1146  ,self::KEY_FIGURE_WIKI_PAGE_RATINGS
1147  );
1148  }

◆ getFigureTitle()

static ilWikiStat::getFigureTitle (   $a_figure)
static

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

References $lng.

Referenced by ilWikiStatGUI\renderGraph().

1151  {
1152  global $lng;
1153 
1154  $map = array(
1155  // wiki
1156  self::KEY_FIGURE_WIKI_NUM_PAGES => $lng->txt("wiki_stat_num_pages")
1157  ,self::KEY_FIGURE_WIKI_NEW_PAGES => $lng->txt("wiki_stat_new_pages")
1158  ,self::KEY_FIGURE_WIKI_NEW_PAGES_AVG => $lng->txt("wiki_stat_new_pages_avg")
1159  ,self::KEY_FIGURE_WIKI_EDIT_PAGES => $lng->txt("wiki_stat_edit_pages")
1160  ,self::KEY_FIGURE_WIKI_EDIT_PAGES_AVG => $lng->txt("wiki_stat_edit_pages_avg")
1161  ,self::KEY_FIGURE_WIKI_DELETED_PAGES => $lng->txt("wiki_stat_deleted_pages")
1162  ,self::KEY_FIGURE_WIKI_READ_PAGES => $lng->txt("wiki_stat_read_pages")
1163  ,self::KEY_FIGURE_WIKI_USER_EDIT_PAGES => $lng->txt("wiki_stat_user_edit_pages")
1164  ,self::KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG => $lng->txt("wiki_stat_user_edit_pages_avg")
1165  ,self::KEY_FIGURE_WIKI_NUM_RATING => $lng->txt("wiki_stat_num_rating")
1166  ,self::KEY_FIGURE_WIKI_NUM_RATING_AVG => $lng->txt("wiki_stat_num_rating_avg")
1167  ,self::KEY_FIGURE_WIKI_RATING_AVG => $lng->txt("wiki_stat_rating_avg")
1168  ,self::KEY_FIGURE_WIKI_INTERNAL_LINKS => $lng->txt("wiki_stat_internal_links")
1169  ,self::KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG => $lng->txt("wiki_stat_internal_links_avg")
1170  ,self::KEY_FIGURE_WIKI_EXTERNAL_LINKS => $lng->txt("wiki_stat_external_links")
1171  ,self::KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG => $lng->txt("wiki_stat_external_links_avg")
1172  ,self::KEY_FIGURE_WIKI_WORDS => $lng->txt("wiki_stat_words")
1173  ,self::KEY_FIGURE_WIKI_WORDS_AVG => $lng->txt("wiki_stat_words_avg")
1174  ,self::KEY_FIGURE_WIKI_CHARS => $lng->txt("wiki_stat_chars")
1175  ,self::KEY_FIGURE_WIKI_CHARS_AVG => $lng->txt("wiki_stat_chars_avg")
1176  ,self::KEY_FIGURE_WIKI_FOOTNOTES => $lng->txt("wiki_stat_footnotes")
1177  ,self::KEY_FIGURE_WIKI_FOOTNOTES_AVG => $lng->txt("wiki_stat_footnotes_avg")
1178  // page
1179  ,self::KEY_FIGURE_WIKI_PAGE_CHANGES => $lng->txt("wiki_stat_page_changes")
1180  ,self::KEY_FIGURE_WIKI_PAGE_CHANGES_AVG => $lng->txt("wiki_stat_page_changes_avg")
1181  ,self::KEY_FIGURE_WIKI_PAGE_USER_EDIT => $lng->txt("wiki_stat_page_user_edit")
1182  ,self::KEY_FIGURE_WIKI_PAGE_READ => $lng->txt("wiki_stat_page_read")
1183  ,self::KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS => $lng->txt("wiki_stat_page_internal_links")
1184  ,self::KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS => $lng->txt("wiki_stat_page_external_links")
1185  ,self::KEY_FIGURE_WIKI_PAGE_WORDS => $lng->txt("wiki_stat_page_words")
1186  ,self::KEY_FIGURE_WIKI_PAGE_CHARS => $lng->txt("wiki_stat_page_characters")
1187  ,self::KEY_FIGURE_WIKI_PAGE_FOOTNOTES => $lng->txt("wiki_stat_page_footnotes")
1188  ,self::KEY_FIGURE_WIKI_PAGE_RATINGS => $lng->txt("wiki_stat_page_ratings")
1189  );
1190 
1191  return $map[$a_figure];
1192  }
$lng
global $lng
Definition: privfeed.php:40
+ 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.

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

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

References $ilDB, $res, and $row.

536  {
537  global $ilDB;
538 
539  $res = array();
540  $deleted = null;
541 
542  $sql = "SELECT ts_day, ".sprintf($a_aggr_value, $a_field)." ".$a_field;
543  if($a_table == "wiki_stat_page" && $a_sub_field)
544  {
545  $sql .= ", MAX(deleted) deleted";
546  }
547  $sql .= " FROM ".$a_table.
548  " WHERE wiki_id = ".$ilDB->quote($a_wiki_id, "integer").
549  " AND ts_day >= ".$ilDB->quote($a_day_from, "text").
550  " AND ts_day <= ".$ilDB->quote($a_day_to, "text");
551  if(!$a_build_full_period)
552  {
553  // to build full period data we need all values in DB
554  $sql .= " AND ".$a_field." > ".$ilDB->quote(0, "integer").
555  " AND ".$a_field." IS NOT NULL";
556  }
557  if($a_sub_field)
558  {
559  $sql .= " AND ".$a_sub_field." = ".$ilDB->quote($a_sub_id, "integer");
560  }
561  $sql .= " GROUP BY ts_day".
562  " ORDER BY ts_day";
563  $set = $ilDB->query($sql);
564  while($row = $ilDB->fetchAssoc($set))
565  {
566  $res[$row["ts_day"]] = $row[$a_field];
567 
568  $deleted = max($row["deleted"], $deleted);
569  }
570 
571  if($a_build_full_period)
572  {
573  $period_first = $a_day_from;
574  $period_last = $a_day_to;
575 
576  // check if sub was deleted in period
577  if($a_table == "wiki_stat_page" && $a_sub_field && $deleted)
578  {
579  $sql = "SELECT MAX(ts_day) last_day, MIN(ts_day) first_day".
580  " FROM ".$a_table.
581  " WHERE wiki_id = ".$ilDB->quote($a_wiki_id, "integer").
582  " AND ".$a_sub_field." = ".$ilDB->quote($a_sub_id, "integer");
583  $set = $ilDB->query($sql);
584  $row = $ilDB->fetchAssoc($set);
585  $last_day = $row["last_day"];
586  if($last_day < $period_last)
587  {
588  $period_last = $last_day;
589  }
590  $first_day = $row["first_day"];
591  if($first_day > $period_first)
592  {
593  $period_first = $first_day;
594  }
595  }
596 
597  $last_before_period = null;
598  if(!$res[$a_day_from])
599  {
600  $last_before_period = self::getWikiLast($a_wiki_id, $a_day_from, $a_table, $a_field, $a_sub_field, $a_sub_id);
601  }
602 
603  // no need to allow zero here as we are not building averages
604  self::buildFullPeriodData($res, $period_first, $period_last, $last_before_period);
605  }
606 
607  return $res;
608  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

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

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

632  {
633  global $ilDB;
634 
635  $res = array();
636 
637  if(!$a_build_full_period)
638  {
639  $sql = "SELECT ts_day, ".sprintf($a_aggr_value, $a_field)." ".$a_field.
640  " FROM (".
641  // subquery to build average per $a_aggr_by
642  " SELECT ts_day, ".sprintf($a_aggr_sub, $a_field)." ".$a_field.
643  " FROM ".$a_table.
644  " WHERE wiki_id = ".$ilDB->quote($a_wiki_id, "integer").
645  " AND ts_day >= ".$ilDB->quote($a_day_from, "text").
646  " AND ts_day <= ".$ilDB->quote($a_day_to, "text").
647  " AND ".$a_field." > ".$ilDB->quote(0, "integer").
648  " AND ".$a_field." IS NOT NULL";
649  if($a_sub_field)
650  {
651  $sql .= " AND ".$a_sub_field." = ".$ilDB->quote($a_sub_id, "integer");
652  }
653  $sql .= " GROUP BY ts_day, ".$a_aggr_by.
654  ") aggr_sub".
655  " GROUP BY ts_day".
656  " ORDER BY ts_day";
657  $set = $ilDB->query($sql);
658  while($row = $ilDB->fetchAssoc($set))
659  {
660  $res[$row["ts_day"]] = $row[$a_field];
661  }
662  }
663  else
664  {
665  $tmp = $all_aggr_ids = $deleted_in_period = $first_day_in_period = array();
666 
667  if($a_table != "wiki_stat_page")
668  {
669  echo "can only build full period averages for wiki_stat_page";
670  exit();
671  }
672 
673  // as current period can be totally empty, gather existing subs
674  $sql = " SELECT *".
675  " FROM (".
676  " SELECT ".$a_aggr_by.", MAX(deleted) deleted, MAX(ts_day) last_day, MIN(ts_day) first_day".
677  " FROM ".$a_table.
678  " WHERE wiki_id = ".$ilDB->quote($a_wiki_id, "integer").
679  " GROUP BY ".$a_aggr_by.
680  ") aggr_sub".
681  " WHERE first_day <= ".$ilDB->quote($a_day_to, "text"). // not created after period
682  " AND (last_day >= ".$ilDB->quote($a_day_from, "text"). // (deleted in/after period
683  " OR deleted = ".$ilDB->quote(0, "integer").")"; // or still existing)
684  $set = $ilDB->query($sql);
685  while($row = $ilDB->fetchAssoc($set))
686  {
687  $all_aggr_ids[] = $row[$a_aggr_by];
688 
689  // if deleted in period we need the last day
690  if($row["deleted"] && $row["last_day"] < $a_day_to)
691  {
692  $deleted_in_period[$row[$a_aggr_by]] = $row["last_day"];
693  }
694  // if created in period we need the first day
695  if($row["first_day"] > $a_day_from)
696  {
697  $first_day_in_period[$row[$a_aggr_by]] = $row["first_day"];
698  }
699  }
700 
701  // we need to build average manually after completing period data (zero is valid)
702  $sql = " SELECT ts_day, ".$a_aggr_by.", ".sprintf($a_aggr_sub, $a_field)." ".$a_field.
703  " FROM ".$a_table.
704  " WHERE wiki_id = ".$ilDB->quote($a_wiki_id, "integer").
705  " AND ts_day >= ".$ilDB->quote($a_day_from, "text").
706  " AND ts_day <= ".$ilDB->quote($a_day_to, "text");
707  $sql .= " GROUP BY ts_day, ".$a_aggr_by;
708  $set = $ilDB->query($sql);
709  while($row = $ilDB->fetchAssoc($set))
710  {
711  if(!in_array($row[$a_aggr_by], $all_aggr_ids))
712  {
713  var_dump("unexpected wiki_stat_page_entry", $row);
714  }
715  $tmp[$row[$a_aggr_by]][$row["ts_day"]] = $row[$a_field];
716  }
717 
718  // build full period for each sub
719  foreach($all_aggr_ids as $aggr_by_id)
720  {
721  // last of entry of sub is before period
722  if(!is_array($tmp[$aggr_by_id]))
723  {
724  $tmp[$aggr_by_id] = array();
725  }
726 
727  // get last value before period to add missing entries in period
728  $last_before_period = null;
729  if(!$tmp[$aggr_by_id][$a_day_from])
730  {
731  $last_before_period = self::getWikiLast($a_wiki_id, $a_day_from, $a_table, $a_field, $a_aggr_by, $aggr_by_id);
732  }
733 
734  // if sub was created in period (see above), shorten period accordingly
735  $first_period_day = isset($first_day_in_period[$aggr_by_id])
736  ? $first_day_in_period[$aggr_by_id]
737  : $a_day_from;
738 
739  // if sub was deleted in period (see above), shorten period accordingly
740  $last_period_day = isset($deleted_in_period[$aggr_by_id])
741  ? $deleted_in_period[$aggr_by_id]
742  : $a_day_to;
743 
744  // allow zero as we need to correct number of valid subs per day (see below - AVG)
745  self::buildFullPeriodData($tmp[$aggr_by_id], $first_period_day, $last_period_day, $last_before_period, true);
746 
747  // distribute sub to days
748  foreach($tmp[$aggr_by_id] as $day => $value)
749  {
750  $res[$day][$aggr_by_id] = $value;
751  }
752  }
753 
754  // build average over subs
755  foreach($res as $day => $values)
756  {
757  switch($a_aggr_value)
758  {
759  case "AVG(%s)":
760  $res[$day] = array_sum($values)/sizeof($values);
761  break;
762 
763  case "SUM(%s)":
764  $res[$day] = array_sum($values);
765  break;
766 
767  default:
768  var_dump("unsupport aggr ".$a_aggr_value);
769  break;
770  }
771  }
772  }
773 
774  return $res;
775  }
exit
exit
Definition: login.php:54
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getWikiCharacters()

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

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

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

◆ getWikiCharactersAvg()

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

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

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

◆ getWikiDeletedPages()

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

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

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

◆ getWikiEditPagesAvg()

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

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

References $ilDB, $res, and $row.

869  {
870  global $ilDB;
871 
872  $res = array();
873 
874  $sql = "SELECT ts_day, AVG(num_changed_pages) num_changed_pages".
875  " FROM (".
876  // subquery to build average per user
877  " SELECT ts_day, COUNT(DISTINCT(page_id)) num_changed_pages".
878  " FROM wiki_stat_page_user".
879  " WHERE wiki_id = ".$ilDB->quote($a_wiki_id, "integer").
880  " AND ts_day >= ".$ilDB->quote($a_day_from, "text").
881  " AND ts_day <= ".$ilDB->quote($a_day_to, "text").
882  " AND changes > ".$ilDB->quote(0, "integer").
883  " AND changes IS NOT NULL".
884  " GROUP BY ts_day, user_id".
885  ") aggr_user".
886  " GROUP BY ts_day".
887  " ORDER BY ts_day";
888  $set = $ilDB->query($sql);
889  while($row = $ilDB->fetchAssoc($set))
890  {
891  $res[$row["ts_day"]] = $row["num_changed_pages"];
892  }
893 
894  return $res;
895  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getWikiEditPagesSum()

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

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

References $ilDB, $res, and $row.

845  {
846  global $ilDB;
847 
848  $res = array();
849 
850  $sql = "SELECT ts_day, COUNT(DISTINCT(page_id)) num_changed_pages".
851  " FROM wiki_stat_page_user".
852  " WHERE wiki_id = ".$ilDB->quote($a_wiki_id, "integer").
853  " AND ts_day >= ".$ilDB->quote($a_day_from, "text").
854  " AND ts_day <= ".$ilDB->quote($a_day_to, "text").
855  " AND changes > ".$ilDB->quote(0, "integer").
856  " AND changes IS NOT NULL".
857  " GROUP BY ts_day".
858  " ORDER BY ts_day";
859  $set = $ilDB->query($sql);
860  while($row = $ilDB->fetchAssoc($set))
861  {
862  $res[$row["ts_day"]] = $row["num_changed_pages"];
863  }
864 
865  return $res;
866  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getWikiExternalLinks()

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

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

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

◆ getWikiExternalLinksAvg()

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

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

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

◆ getWikiFootnotes()

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

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

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

◆ getWikiFootnotesAvg()

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

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

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

◆ getWikiInternalLinks()

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

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

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

◆ getWikiInternalLinksAvg()

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

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

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

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

References $ilDB.

611  {
612  global $ilDB;
613 
614  // get last existing value before period (zero is valid)
615  $sql = "SELECT MAX(".$a_field.") latest".
616  " FROM ".$a_table.
617  " WHERE wiki_id = ".$ilDB->quote($a_wiki_id, "integer").
618  " AND ts_day < ".$ilDB->quote($a_day_from, "text");
619  if($a_sub_field)
620  {
621  $sql .= " AND ".$a_sub_field." = ".$ilDB->quote($a_sub_id, "integer");
622  }
623  $sql .= " GROUP BY ts_day".
624  " ORDER BY ts_day DESC";
625  $ilDB->setLimit(1);
626  $set = $ilDB->query($sql);
627  $last_before_period = $ilDB->fetchAssoc($set);
628  return $last_before_period["latest"];
629  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getWikiNewPagesAvg()

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

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

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

◆ getWikiNewPagesSum()

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

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

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

◆ getWikiNumPages()

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

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

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

◆ getWikiNumRating()

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

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

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

◆ getWikiNumRatingAvg()

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

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

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

◆ getWikiPageChanges()

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

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

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

◆ getWikiPageChangesAvg()

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

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

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

◆ getWikiPageCharacters()

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

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

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

◆ getWikiPageExternalLinks()

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

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

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

◆ getWikiPageFootnotes()

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

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

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

◆ getWikiPageInternalLinks()

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

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

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

◆ getWikiPageRatings()

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

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

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

◆ getWikiPageRead()

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

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

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

◆ getWikiPageUserEdit()

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

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

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

◆ getWikiPageWords()

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

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

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

◆ getWikiRatingAvg()

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

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

References $res.

965  {
966  $res = self::getWikiAggr($a_wiki_id, $a_day_from, $a_day_to, "wiki_stat", "avg_rating", "AVG(%s)");
967 
968  foreach(array_keys($res) as $day)
969  {
970  // int-to-float
971  $res[$day] = $res[$day]/100;
972  }
973 
974  return $res;
975  }

◆ getWikiReadPages()

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

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

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

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

References $ilDB, $res, and $row.

898  {
899  global $ilDB;
900 
901  $res = array();
902 
903  $sql = "SELECT ts_day, COUNT(DISTINCT(user_id)) num_changed_users".
904  " FROM wiki_stat_page_user".
905  " WHERE wiki_id = ".$ilDB->quote($a_wiki_id, "integer").
906  " AND ts_day >= ".$ilDB->quote($a_day_from, "text").
907  " AND ts_day <= ".$ilDB->quote($a_day_to, "text").
908  " AND changes > ".$ilDB->quote(0, "integer").
909  " AND changes IS NOT NULL";
910  if($a_sub_field)
911  {
912  $sql .= " AND ".$a_sub_field." = ".$ilDB->quote($a_sub_id, "integer");
913  }
914  $sql .= " GROUP BY ts_day".
915  " ORDER BY ts_day";
916  $set = $ilDB->query($sql);
917  while($row = $ilDB->fetchAssoc($set))
918  {
919  $res[$row["ts_day"]] = $row["num_changed_users"];
920  }
921 
922  return $res;
923  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getWikiUserEditPagesAvg()

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

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

References $ilDB, $res, and $row.

926  {
927  global $ilDB;
928 
929  $res = array();
930 
931  $sql = "SELECT ts_day, AVG(num_changed_users) num_changed_users".
932  " FROM (".
933  // subquery to build average per page
934  " SELECT ts_day, COUNT(DISTINCT(user_id)) num_changed_users".
935  " FROM wiki_stat_page_user".
936  " WHERE wiki_id = ".$ilDB->quote($a_wiki_id, "integer").
937  " AND ts_day >= ".$ilDB->quote($a_day_from, "text").
938  " AND ts_day <= ".$ilDB->quote($a_day_to, "text").
939  " AND changes > ".$ilDB->quote(0, "integer").
940  " AND changes IS NOT NULL".
941  " GROUP BY ts_day, page_id".
942  ") aggr_user".
943  " GROUP BY ts_day".
944  " ORDER BY ts_day";
945  $set = $ilDB->query($sql);
946  while($row = $ilDB->fetchAssoc($set))
947  {
948  $res[$row["ts_day"]] = $row["num_changed_users"];
949  }
950 
951  return $res;
952  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ getWikiWords()

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

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

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

◆ getWikiWordsAvg()

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

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

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

◆ 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.

References $ilUser.

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

136  {
137  global $ilUser;
138 
139  if(!$a_user_id)
140  {
141  $a_user_id = $ilUser->getId();
142  }
143  if(!$a_user_id || $a_user_id == ANONYMOUS_USER_ID)
144  {
145  return;
146  }
147 
148  switch((int)$a_event)
149  {
150  case self::EVENT_PAGE_CREATED:
151  self::handlePageCreated($a_page_obj, $a_user_id);
152  break;
153 
154  case self::EVENT_PAGE_UPDATED:
155  self::handlePageUpdated($a_page_obj, $a_user_id, $a_additional_data);
156  break;
157 
158  case self::EVENT_PAGE_READ:
159  self::handlePageRead($a_page_obj, $a_user_id);
160  break;
161 
162  case self::EVENT_PAGE_DELETED:
163  self::handlePageDeletion($a_page_obj, $a_user_id);
164  break;
165 
166  case self::EVENT_PAGE_RATING:
167  self::handlePageRating($a_page_obj, $a_user_id);
168  break;
169 
170  default:
171  return;
172  }
173  }
$ilUser
global $ilUser
Definition: imgupload.php:15
+ 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 385 of file class.ilWikiStat.php.

References ilWikiPage\getWikiId().

386  {
387  // wiki: num_pages (count)
388  self::writeStat($a_page_obj->getWikiId(),
389  array(
390  "num_pages" => array("integer", self::countPages($a_page_obj->getWikiId()))
391  ));
392 
393  // user: new_pages+1
394  self::writeStatUser($a_page_obj->getWikiId(), $a_user_id,
395  array(
396  "new_pages" => array("increment", 1)
397  ));
398  }
ilWikiPage\getWikiId
getWikiId()
Get Wiki Object Id.
Definition: class.ilWikiPage.php:76
+ Here is the call 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 447 of file class.ilWikiStat.php.

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

448  {
449  global $ilDB;
450 
451  // copy last entry to have deletion timestamp
452  $sql = "SELECT * ".
453  " FROM wiki_stat_page".
454  " WHERE wiki_id = ".$ilDB->quote($a_page_obj->getWikiId(), "integer").
455  " AND page_id = ".$ilDB->quote($a_page_obj->getId(), "integer");
456  " ORDER BY ts DESC";
457  $ilDB->setLimit(1);
458  $set = $ilDB->query($sql);
459 
460  // #15748
461  if($ilDB->numRows($set))
462  {
463  $data = $ilDB->fetchAssoc($set);
464 
465  // see self::handlePageUpdated()
466  $values = array(
467  "int_links" => array("integer", $data["int_links"]),
468  "ext_links" => array("integer", $data["ext_links"]),
469  "footnotes" => array("integer", $data["footnotes"]),
470  "num_words" => array("integer", $data["num_words"]),
471  "num_chars" => array("integer", $data["num_chars"]),
472  "num_ratings" => array("integer", $data["num_ratings"]),
473  "avg_rating" => array("integer", $data["avg_rating"]),
474  );
475  self::writeStatPage($a_page_obj->getWikiId(), $a_page_obj->getId(), $values);
476  }
477 
478  // mark all page entries as deleted
479  $ilDB->manipulate("UPDATE wiki_stat_page".
480  " SET deleted = ".$ilDB->quote(1, "integer").
481  " WHERE page_id = ".$ilDB->quote($a_page_obj->getId(), "integer").
482  " AND wiki_id = ".$ilDB->quote($a_page_obj->getWikiId(), "integer"));
483 
484  // wiki: del_pages+1, num_pages (count), avg_rating
485  $rating = self::getAverageRating($a_page_obj->getWikiId());
486  self::writeStat($a_page_obj->getWikiId(),
487  array(
488  "del_pages" => array("increment", 1),
489  "num_pages" => array("integer", self::countPages($a_page_obj->getWikiId())),
490  "avg_rating" => array("integer", $rating["avg"]*100)
491  ));
492  }
ilWikiPage\getWikiId
getWikiId()
Get Wiki Object Id.
Definition: class.ilWikiPage.php:76
$ilDB
global $ilDB
Definition: storeScorm2004.php:16
+ Here is the call 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 500 of file class.ilWikiStat.php.

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

501  {
502  // do page first!
503  $rating = self::getAverageRating($a_page_obj->getWikiId(), $a_page_obj->getId());
504 
505  // wiki_stat_page: num_ratings, avg_rating
506  self::writeStatPage($a_page_obj->getWikiId(), $a_page_obj->getId(),
507  array(
508  "num_ratings" => array("integer", $rating["cnt"]),
509  "avg_rating" => array("integer", $rating["avg"]*100),
510  ));
511 
512  $rating = self::getAverageRating($a_page_obj->getWikiId());
513 
514  // wiki_stat: avg_rating
515  $is_update = self::writeStat($a_page_obj->getWikiId(),
516  array(
517  "avg_rating" => array("integer", $rating["avg"]*100)
518  ));
519 
520  if(!$is_update)
521  {
522  // wiki: num_pages (count)
523  self::writeStat($a_page_obj->getWikiId(),
524  array(
525  "num_pages" => array("integer", self::countPages($a_page_obj->getWikiId()))
526  ));
527  }
528  }
ilWikiPage\getWikiId
getWikiId()
Get Wiki Object Id.
Definition: class.ilWikiPage.php:76
+ Here is the call 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 432 of file class.ilWikiStat.php.

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

433  {
434  // page_user: read_events+1
435  self::writeStatPageUser($a_page_obj->getWikiId(), $a_page_obj->getId(), $a_user_id,
436  array(
437  "read_events" => array("increment", 1)
438  ));
439  }
ilWikiPage\getWikiId
getWikiId()
Get Wiki Object Id.
Definition: class.ilWikiPage.php:76
+ Here is the call 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 407 of file class.ilWikiStat.php.

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

408  {
409  // page_user: changes+1
410  self::writeStatPageUser($a_page_obj->getWikiId(), $a_page_obj->getId(), $a_user_id,
411  array(
412  "changes" => array("increment", 1)
413  ));
414 
415  // page: see ilWikiPage::afterUpdate()
416  $values = array(
417  "int_links" => array("integer", $a_page_data["int_links"]),
418  "ext_links" => array("integer", $a_page_data["ext_links"]),
419  "footnotes" => array("integer", $a_page_data["footnotes"]),
420  "num_words" => array("integer", $a_page_data["num_words"]),
421  "num_chars" => array("integer", $a_page_data["num_chars"])
422  );
423  self::writeStatPage($a_page_obj->getWikiId(), $a_page_obj->getId(), $values);
424  }
ilWikiPage\getWikiId
getWikiId()
Get Wiki Object Id.
Definition: class.ilWikiPage.php:76
+ Here is the call 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.

References $columns, $ilDB, and ilDB\LOCK_WRITE.

196  {
197  global $ilDB;
198 
199  $tstamp = self::getTimestamp();
200  $a_primary["ts"] = array("timestamp", $tstamp);
201 
202  $ilDB->lockTables(array(0 => array('name' => $a_table, 'type' => ilDB::LOCK_WRITE)));
203 
204  $primary = array();
205  foreach($a_primary as $column => $value)
206  {
207  $primary[] = $column." = ".$ilDB->quote($value[1], $value[0]);
208  }
209  $primary = implode(" AND ", $primary);
210 
211  $set = $ilDB->query("SELECT ts FROM ".$a_table.
212  " WHERE ".$primary);
213 
214  $is_update = (bool)$ilDB->numRows($set);
215 
216  // update (current timeframe)
217  if($is_update)
218  {
219  $values = array();
220  foreach($a_values as $column => $value)
221  {
222  if($value[0] == "increment")
223  {
224  $values[] = $column." = ".$column."+1";
225  }
226  else if($value[0] == "decrement")
227  {
228  $values[] = $column." = ".$column."-1";
229  }
230  else
231  {
232  $values[] = $column." = ".$ilDB->quote($value[1], $value[0]);
233  }
234  }
235  $values = implode(", ", $values);
236 
237  $sql = "UPDATE ".$a_table.
238  " SET ".$values.
239  " WHERE ".$primary;
240  }
241  // insert (no entry yet for current time frame)
242  else
243  {
244  $a_values = array_merge($a_primary, $a_values);
245  $a_values["ts_day"] = array("text", substr($tstamp, 0, 10));
246  $a_values["ts_hour"] = array("integer", (int)substr($tstamp, 11, 2));
247 
248  $values = array();
249  foreach($a_values as $column => $value)
250  {
251  $columns[] = $column;
252  if($value[0] == "increment")
253  {
254  $value[0] = "integer";
255  }
256  else if($value[0] == "decrement")
257  {
258  $value[0] = "integer";
259  $value[1] = 0;
260  }
261  $values[] = $ilDB->quote($value[1], $value[0]);
262  }
263  $values = implode(", ", $values);
264  $columns = implode(", ", $columns);
265 
266  $sql = "INSERT INTO ".$a_table.
267  " (".$columns.")".
268  " VALUES (".$values.")";
269  }
270  $ilDB->manipulate($sql);
271 
272  $ilDB->unlockTables();
273 
274  return $is_update;
275  }
ilDB\LOCK_WRITE
const LOCK_WRITE
Definition: class.ilDB.php:30
$ilDB
global $ilDB
Definition: storeScorm2004.php:16
$columns
if(! $in) $columns
Definition: Utf8Test.php:46

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

284  {
285  $primary = array(
286  "wiki_id" => array("integer", $a_wiki_id)
287  );
288  self::writeData("wiki_stat", $primary, $a_values);
289  }

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

299  {
300  $primary = array(
301  "wiki_id" => array("integer", $a_wiki_id),
302  "page_id" => array("integer", $a_page_id),
303  );
304  self::writeData("wiki_stat_page", $primary, $a_values);
305  }

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

316  {
317  $primary = array(
318  "wiki_id" => array("integer", $a_wiki_id),
319  "page_id" => array("integer", $a_page_id),
320  "user_id" => array("integer", $a_user_id)
321  );
322  self::writeData("wiki_stat_page_user", $primary, $a_values);
323  }

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

333  {
334  $primary = array(
335  "wiki_id" => array("integer", $a_wiki_id),
336  "user_id" => array("integer", $a_user_id)
337  );
338  self::writeData("wiki_stat_user", $primary, $a_values);
339  }

Field Documentation

◆ EVENT_PAGE_CREATED

const ilWikiStat::EVENT_PAGE_CREATED = 1

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

Referenced by ilWikiPage\create().

◆ EVENT_PAGE_DELETED

const ilWikiStat::EVENT_PAGE_DELETED = 4

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

Referenced by ilWikiPage\delete().

◆ EVENT_PAGE_RATING

const ilWikiStat::EVENT_PAGE_RATING = 5

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

Referenced by ilWikiPageGUI\updateStatsRating().

◆ EVENT_PAGE_READ

const ilWikiStat::EVENT_PAGE_READ = 3

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

Referenced by ilWikiPageGUI\increaseViewCount().

◆ EVENT_PAGE_UPDATED

const ilWikiStat::EVENT_PAGE_UPDATED = 2

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

Referenced by ilWikiPage\afterUpdate().

◆ KEY_FIGURE_WIKI_CHARS

const ilWikiStat::KEY_FIGURE_WIKI_CHARS = 19

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_CHARS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_CHARS_AVG = 20

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_DELETED_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_DELETED_PAGES = 6

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_EDIT_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_EDIT_PAGES = 4

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_EDIT_PAGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_EDIT_PAGES_AVG = 5

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

◆ KEY_FIGURE_WIKI_EXTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_EXTERNAL_LINKS = 15

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_EXTERNAL_LINKS_AVG = 16

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_FOOTNOTES

const ilWikiStat::KEY_FIGURE_WIKI_FOOTNOTES = 21

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_FOOTNOTES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_FOOTNOTES_AVG = 22

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_INTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_INTERNAL_LINKS = 13

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_INTERNAL_LINKS_AVG = 14

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_NEW_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_NEW_PAGES = 2

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_NEW_PAGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_NEW_PAGES_AVG = 3

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

◆ KEY_FIGURE_WIKI_NUM_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_NUM_PAGES = 1

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

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

◆ KEY_FIGURE_WIKI_NUM_RATING

const ilWikiStat::KEY_FIGURE_WIKI_NUM_RATING = 10

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_NUM_RATING_AVG

const ilWikiStat::KEY_FIGURE_WIKI_NUM_RATING_AVG = 11

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

◆ KEY_FIGURE_WIKI_PAGE_CHANGES

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_CHANGES = 23

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

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

◆ KEY_FIGURE_WIKI_PAGE_CHANGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_CHANGES_AVG = 24

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

◆ KEY_FIGURE_WIKI_PAGE_CHARS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_CHARS = 30

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_EXTERNAL_LINKS = 28

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_FOOTNOTES

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_FOOTNOTES = 31

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_INTERNAL_LINKS = 27

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_RATINGS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_RATINGS = 32

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_READ

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_READ = 26

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_USER_EDIT

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_USER_EDIT = 25

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_PAGE_WORDS

const ilWikiStat::KEY_FIGURE_WIKI_PAGE_WORDS = 29

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_RATING_AVG

const ilWikiStat::KEY_FIGURE_WIKI_RATING_AVG = 12

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_READ_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_READ_PAGES = 7

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_USER_EDIT_PAGES

const ilWikiStat::KEY_FIGURE_WIKI_USER_EDIT_PAGES = 8

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG

const ilWikiStat::KEY_FIGURE_WIKI_USER_EDIT_PAGES_AVG = 9

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

◆ KEY_FIGURE_WIKI_WORDS

const ilWikiStat::KEY_FIGURE_WIKI_WORDS = 17

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

Referenced by ilWikiStatGUI\renderGraph().

◆ KEY_FIGURE_WIKI_WORDS_AVG

const ilWikiStat::KEY_FIGURE_WIKI_WORDS_AVG = 18

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

Referenced by ilWikiStatGUI\renderGraph().

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