Collaboration diagram for ilOnlineTracking:

Static Public Member Functions
static	getOnlineTime (int $a_user_id)

static	addUser (int $a_user_id)

static	updateAccess (ilObjUser $user)

Static Protected Attributes
static int	$last_access_time = null
	This static variable is used to prevent two database request (addUser and updateAccess) on login. More...

Detailed Description

Definition at line 27 of file class.ilOnlineTracking.php.

Member Function Documentation

◆ addUser()

static ilOnlineTracking::addUser ( int $a_user_id )

static

Definition at line 51 of file class.ilOnlineTracking.php.

                                                  : bool
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $res = $ilDB->query(
            'SELECT access_time FROM ut_online WHERE usr_id = ' . $ilDB->quote(
                $a_user_id,
                'integer'
            )
        );
        if ($ilDB->numRows($res)) {
            $row = $ilDB->fetchAssoc($res);
            self::$last_access_time = (int) $row['access_time'];
            return false;
        }
 
        $ilDB->manipulateF(
            'INSERT INTO ut_online (usr_id, access_time) VALUES (%s, %s)',
            array('integer', 'integer'),
            array($a_user_id, time())
        );
        self::$last_access_time = time();
        return true;
    }

References $DIC, $ilDB, $res, and ILIAS\Repository\int().

Referenced by ilAuthFrontend\handleAuthenticationSuccess().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getOnlineTime()

static ilOnlineTracking::getOnlineTime ( int $a_user_id )

static

Definition at line 34 of file class.ilOnlineTracking.php.

                                                        : int
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $res = $ilDB->query(
            'SELECT online_time FROM ut_online WHERE usr_id = ' . $ilDB->quote(
                $a_user_id,
                'integer'
            )
        );
        while ($row = $ilDB->fetchAssoc($res)) {
            return (int) $row['online_time'];
        }
        return 0;
    }

References $DIC, $ilDB, and $res.

◆ updateAccess()

static ilOnlineTracking::updateAccess ( ilObjUser $user )

static

Definition at line 77 of file class.ilOnlineTracking.php.

                                                        : bool
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $ilSetting = $DIC->settings();
 
        if (null === self::$last_access_time) {
            $query = 'SELECT access_time FROM ut_online WHERE usr_id = ' . $ilDB->quote(
                $user->getId(),
                'integer'
            );
            $res = $ilDB->query($query);
            if (!$ilDB->numRows($res)) {
                return false;
            }
            $row = $ilDB->fetchAssoc($res);
            self::$last_access_time = (int) $row['access_time'];
        }
 
        $time_span = (int) $ilSetting->get('tracking_time_span', '300');
        if (($diff = time() - self::$last_access_time) <= $time_span) {
            $ilDB->manipulateF(
                'UPDATE ut_online SET online_time = online_time + %s, access_time = %s WHERE usr_id = %s',
                array('integer', 'integer', 'integer'),
                array($diff, time(), $user->getId())
            );
        } else {
            $ilDB->manipulateF(
                'UPDATE ut_online SET access_time = %s WHERE usr_id = %s',
                array('integer', 'integer'),
                array(time(), $user->getId())
            );
        }
        return true;
    }