|
static | isActive () |
| Is session statistics active at all? More...
|
|
static | createRawEntry ($a_session_id, $a_session_type, $a_timestamp, $a_user_id) |
| Create raw data entry. More...
|
|
static | closeRawEntry ($a_session_id, $a_context=null, $a_expired_at=null) |
| Close raw data entry. More...
|
|
static | aggretateRaw ($a_now) |
| Aggregate raw session data (older than given time) More...
|
|
static | aggregateRawHelper ($a_begin, $a_end) |
| Aggregate statistics data for one slot. More...
|
|
static | getLastMaxedOut () |
| Get latest slot during which sessions were maxed out. More...
|
|
static | getMaxedOutDuration ($a_from, $a_to) |
| Get maxed out duration in given timeframe. More...
|
|
static | getNumberOfSessionsByType ($a_from, $a_to) |
| Get session counters by type (opened, closed) More...
|
|
static | getActiveSessions ($a_from, $a_to) |
| Get active sessions aggregated data. More...
|
|
static | getLastAggregation () |
| Get timestamp of last aggregation. More...
|
|
static | getLimitForSlot ($a_timestamp) |
| Get max session setting for given timestamp. More...
|
|
static | updateLimitLog ($a_new_value) |
| Log max session setting. More...
|
|
◆ aggregateRawHelper()
static ilSessionStatistics::aggregateRawHelper |
( |
|
$a_begin, |
|
|
|
$a_end |
|
) |
| |
|
static |
Aggregate statistics data for one slot.
- Parameters
-
timestamp | $a_begin | |
timestamp | $a_end | |
Definition at line 286 of file class.ilSessionStatistics.php.
References $ilSetting, ilSession\SESSION_CLOSE_EXPIRE, ilSession\SESSION_CLOSE_FIRST, ilSession\SESSION_CLOSE_IDLE, ilSession\SESSION_CLOSE_LIMIT, ilSession\SESSION_CLOSE_LOGIN, and ilSession\SESSION_CLOSE_USER.
299 $closed_counter = $events = array();
301 foreach(self::getRawData($a_begin, $a_end) as $item)
311 if($item[
"start_time"] >= $a_begin)
314 $events[$item[
"start_time"]][] = 1;
317 if($item[
"end_time"] && $item[
"end_time"] <= $a_end)
319 if(in_array($item[
"end_context"], $separate_closed))
321 $closed_counter[$item[
"end_context"]]++;
325 $closed_counter[0]++;
327 $events[$item[
"end_time"]][] = -1;
332 $active_begin = self::getNumberOfActiveRawSessions($a_begin-1);
333 $active_end = $active_min = $active_max = $active_avg = $active_begin;
338 $last_update_avg = $a_begin-1;
339 $slot_seconds = self::SLOT_SIZE*60;
344 foreach($events as $ts => $actions)
347 foreach($actions as $action)
362 if($active_end > $active_max)
364 $active_max = $active_end;
368 if($active_end < $active_min)
370 $active_min = $active_end;
374 $diff = $ts-$last_update_avg;
375 $active_avg += $diff/$slot_seconds*$active_end;
376 $last_update_avg = $ts;
381 if($last_update_avg < $a_end)
383 $diff = $a_end-$last_update_avg;
384 $active_avg += $diff/$slot_seconds*$active_end;
387 $active_avg = round($active_avg);
394 $max_sessions = self::getLimitForSlot($a_begin);
398 "active_min" => array(
"integer", $active_min),
399 "active_max" => array(
"integer", $active_max),
400 "active_avg" => array(
"integer", $active_avg),
401 "active_end" => array(
"integer", $active_end),
402 "opened" => array(
"integer", $opened_counter),
409 "closed_misc" => array(
"integer", (
int)$closed_counter[0]),
410 "max_sessions" => array(
"integer", (
int)$max_sessions)
412 $ilDB->update(
"usr_session_stats", $fields,
413 array(
"slot_begin" => array(
"integer", $a_begin),
414 "slot_end" => array(
"integer", $a_end)));
const SESSION_CLOSE_LOGIN
const SESSION_CLOSE_EXPIRE
const SESSION_CLOSE_LIMIT
const SESSION_CLOSE_FIRST
◆ aggretateRaw()
static ilSessionStatistics::aggretateRaw |
( |
|
$a_now | ) |
|
|
static |
Aggregate raw session data (older than given time)
- Parameters
-
Definition at line 262 of file class.ilSessionStatistics.php.
Referenced by ilSession\_writeData(), and ilSessionStatisticsGUI\adminSync().
264 if(!self::isActive())
269 $slot = self::createNewAggregationSlot($a_now);
270 while(is_array($slot))
272 self::aggregateRawHelper($slot[0], $slot[1]);
273 $slot = self::createNewAggregationSlot($a_now);
277 self::deleteAggregatedRaw($a_now);
◆ closeRawEntry()
static ilSessionStatistics::closeRawEntry |
( |
|
$a_session_id, |
|
|
|
$a_context = null , |
|
|
|
$a_expired_at = null |
|
) |
| |
|
static |
Close raw data entry.
- Parameters
-
int | array | $a_session_id | |
int | $a_context | |
int | bool | $a_expired_at | |
Definition at line 72 of file class.ilSessionStatistics.php.
Referenced by ilSession\_destroy().
82 if(!is_array($a_session_id))
86 $end_time = $a_expired_at;
92 $sql =
"UPDATE usr_session_stats_raw".
93 " SET end_time = ".$ilDB->quote($end_time,
"integer");
96 $sql .=
",end_context = ".$ilDB->quote($a_context,
"integer");
98 $sql .=
" WHERE session_id = ".$ilDB->quote($a_session_id,
"text").
99 " AND end_time IS NULL";
100 $ilDB->manipulate($sql);
103 else if(!$a_expired_at)
105 $sql =
"UPDATE usr_session_stats_raw".
106 " SET end_time = ".$ilDB->quote(time(),
"integer");
109 $sql .=
",end_context = ".$ilDB->quote($a_context,
"integer");
111 $sql .=
" WHERE ".$ilDB->in(
"session_id", $a_session_id,
false,
"text").
112 " AND end_time IS NULL";
113 $ilDB->manipulate($sql);
118 foreach($a_session_id as $id => $ts)
120 $sql =
"UPDATE usr_session_stats_raw".
121 " SET end_time = ".$ilDB->quote($ts,
"integer");
124 $sql .=
",end_context = ".$ilDB->quote($a_context,
"integer");
126 $sql .=
" WHERE session_id = ".$ilDB->quote($id,
"text").
127 " AND end_time IS NULL";
128 $ilDB->manipulate($sql);
◆ createNewAggregationSlot()
static ilSessionStatistics::createNewAggregationSlot |
( |
|
$a_now | ) |
|
|
staticprotected |
Create new slot (using table lock)
- Parameters
-
- Returns
- array begin, end
Definition at line 230 of file class.ilSessionStatistics.php.
References ilDB\LOCK_WRITE.
235 $ilDB->lockTables(array(array(
"name"=>
"usr_session_stats",
"type"=>
ilDB::LOCK_WRITE)));
238 $slot = self::getCurrentSlot($a_now);
241 $ilDB->unlockTables();
247 "slot_begin" => array(
"integer", $slot[0]),
248 "slot_end" => array(
"integer", $slot[1]),
250 $ilDB->insert(
"usr_session_stats", $fields);
252 $ilDB->unlockTables();
◆ createRawEntry()
static ilSessionStatistics::createRawEntry |
( |
|
$a_session_id, |
|
|
|
$a_session_type, |
|
|
|
$a_timestamp, |
|
|
|
$a_user_id |
|
) |
| |
|
static |
Create raw data entry.
- Parameters
-
int | $a_session_id | |
int | $a_session_type | |
int | $a_timestamp | |
int | $a_user_id | |
Definition at line 40 of file class.ilSessionStatistics.php.
Referenced by ilSession\_writeData(), and ilSessionControl\checkCurrentSessionIsAllowed().
44 if(!$a_user_id || !$a_session_id || !self::isActive())
53 "usr_session_stats_raw",
55 "session_id" => array(
"text", $a_session_id)
58 "type" => array(
"integer", $a_session_type),
59 "start_time" => array(
"integer", $a_timestamp),
60 "user_id" => array(
"integer", $a_user_id)
◆ deleteAggregatedRaw()
static ilSessionStatistics::deleteAggregatedRaw |
( |
|
$a_now | ) |
|
|
staticprotected |
Remove already aggregated raw data.
- Parameters
-
Definition at line 422 of file class.ilSessionStatistics.php.
427 $cut = $a_now-(60*60*24*7);
429 $ilDB->manipulate(
"DELETE FROM usr_session_stats_raw".
430 " WHERE start_time <= ".$ilDB->quote($cut,
"integer"));
◆ getActiveSessions()
static ilSessionStatistics::getActiveSessions |
( |
|
$a_from, |
|
|
|
$a_to |
|
) |
| |
|
static |
Get active sessions aggregated data.
- Parameters
-
- Returns
- array
Definition at line 506 of file class.ilSessionStatistics.php.
References $res, and $row.
Referenced by ilSessionStatisticsGUI\buildData().
510 $sql =
"SELECT slot_begin, slot_end, active_min, active_max, active_avg,".
512 " FROM usr_session_stats".
513 " WHERE slot_end > ".$ilDB->quote($a_from,
"integer").
514 " AND slot_begin < ".$ilDB->quote($a_to,
"integer").
515 " ORDER BY slot_begin";
516 $res = $ilDB->query($sql);
518 while(
$row = $ilDB->fetchAssoc(
$res))
◆ getCurrentSlot()
static ilSessionStatistics::getCurrentSlot |
( |
|
$a_now | ) |
|
|
staticprotected |
Get next slot to aggregate.
- Parameters
-
- Returns
- array begin, end
Definition at line 139 of file class.ilSessionStatistics.php.
References $res, and $row.
144 $sql =
"SELECT MAX(slot_end) previous_slot_end".
145 " FROM usr_session_stats";
146 $res = $ilDB->query($sql);
148 $previous_slot_end =
$row[
"previous_slot_end"];
152 if(!$previous_slot_end)
154 $slot = floor(date(
"i")/self::SLOT_SIZE);
158 $current_slot_begin = mktime(date(
"H", $a_now)-1, 60-self::SLOT_SIZE, 0);
163 $current_slot_begin = mktime(date(
"H", $a_now), ($slot-1)*self::SLOT_SIZE, 0);
168 $current_slot_begin = $previous_slot_end+1;
171 $current_slot_end = $current_slot_begin+(60*self::SLOT_SIZE)-1;
174 if($current_slot_end < $a_now)
176 return array($current_slot_begin, $current_slot_end);
◆ getLastAggregation()
static ilSessionStatistics::getLastAggregation |
( |
| ) |
|
|
static |
◆ getLastMaxedOut()
static ilSessionStatistics::getLastMaxedOut |
( |
| ) |
|
|
static |
◆ getLimitForSlot()
static ilSessionStatistics::getLimitForSlot |
( |
|
$a_timestamp | ) |
|
|
static |
Get max session setting for given timestamp.
- Parameters
-
- Returns
- int
Definition at line 549 of file class.ilSessionStatistics.php.
References $ilSetting, $res, and ilSessionControl\DEFAULT_MAX_COUNT.
554 $sql =
"SELECT maxval FROM usr_session_log".
555 " WHERE tstamp <= ".$ilDB->quote($a_timestamp,
"integer").
556 " ORDER BY tstamp DESC";
557 $res = $ilDB->query($sql);
558 $val = $ilDB->fetchAssoc(
$res);
561 return (
int)$val[
"maxval"];
const DEFAULT_MAX_COUNT
default value for settings that have not been defined in setup or administration yet ...
◆ getMaxedOutDuration()
static ilSessionStatistics::getMaxedOutDuration |
( |
|
$a_from, |
|
|
|
$a_to |
|
) |
| |
|
static |
Get maxed out duration in given timeframe.
- Parameters
-
- Returns
- int seconds
Definition at line 460 of file class.ilSessionStatistics.php.
References $res, and $row.
Referenced by ilSessionStatisticsGUI\buildData().
464 $sql =
"SELECT SUM(slot_end-slot_begin) dur FROM usr_session_stats".
465 " WHERE active_max >= max_sessions".
466 " AND max_sessions > ".$ilDB->quote(0,
"integer").
467 " AND slot_end > ".$ilDB->quote($a_from,
"integer").
468 " AND slot_begin < ".$ilDB->quote($a_to,
"integer");
469 $res = $ilDB->query($sql);
◆ getNumberOfActiveRawSessions()
static ilSessionStatistics::getNumberOfActiveRawSessions |
( |
|
$a_time | ) |
|
|
staticprotected |
Count number of active sessions at given time.
- Parameters
-
- Returns
- integer
Definition at line 186 of file class.ilSessionStatistics.php.
References $res, $row, and ilSessionControl\$session_types_controlled.
190 $sql =
"SELECT COUNT(*) counter FROM usr_session_stats_raw".
191 " WHERE (end_time IS NULL OR end_time >= ".$ilDB->quote($a_time,
"integer").
")".
192 " AND start_time <= ".$ilDB->quote($a_time,
"integer").
194 $res = $ilDB->query($sql);
196 return $row[
"counter"];
static $session_types_controlled
◆ getNumberOfSessionsByType()
static ilSessionStatistics::getNumberOfSessionsByType |
( |
|
$a_from, |
|
|
|
$a_to |
|
) |
| |
|
static |
Get session counters by type (opened, closed)
- Parameters
-
- Returns
- array
Definition at line 484 of file class.ilSessionStatistics.php.
References $res.
Referenced by ilSessionStatisticsGUI\buildData().
488 $sql =
"SELECT SUM(opened) opened, SUM(closed_manual) closed_manual,".
489 " SUM(closed_expire) closed_expire, SUM(closed_idle) closed_idle,".
490 " SUM(closed_idle_first) closed_idle_first, SUM(closed_limit) closed_limit,".
491 " SUM(closed_login) closed_login, SUM(closed_misc) closed_misc".
492 " FROM usr_session_stats".
493 " WHERE slot_end > ".$ilDB->quote($a_from,
"integer").
494 " AND slot_begin < ".$ilDB->quote($a_to,
"integer");
495 $res = $ilDB->query($sql);
496 return $ilDB->fetchAssoc(
$res);
◆ getRawData()
static ilSessionStatistics::getRawData |
( |
|
$a_begin, |
|
|
|
$a_end |
|
) |
| |
|
staticprotected |
Read raw data for timespan.
- Parameters
-
integer | $a_begin | |
integer | $a_end | |
- Returns
- array
Definition at line 206 of file class.ilSessionStatistics.php.
References $res, $row, and ilSessionControl\$session_types_controlled.
210 $sql =
"SELECT start_time,end_time,end_context FROM usr_session_stats_raw".
211 " WHERE start_time <= ".$ilDB->quote($a_end,
"integer").
212 " AND (end_time IS NULL OR end_time >= ".$ilDB->quote($a_begin,
"integer").
")".
214 " ORDER BY start_time";
215 $res = $ilDB->query($sql);
217 while(
$row = $ilDB->fetchAssoc(
$res))
static $session_types_controlled
◆ isActive()
static ilSessionStatistics::isActive |
( |
| ) |
|
|
static |
◆ updateLimitLog()
static ilSessionStatistics::updateLimitLog |
( |
|
$a_new_value | ) |
|
|
static |
◆ SLOT_SIZE
const ilSessionStatistics::SLOT_SIZE = 15 |
The documentation for this class was generated from the following file: