+global\Event::eventAddVirtualCourseTime()

Complexity

Conditions	3
Paths	3

Size

Total Lines	78
Code Lines	46

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function eventAddVirtualCourseTime(
        $courseId,
        $userId,
        $sessionId,
        $virtualTime = '',
        $ip = ''
    ) {
        $courseTrackingTable = Database::get_main_table(TABLE_STATISTIC_TRACK_E_COURSE_ACCESS);
        $time = $loginDate = $logoutDate = api_get_utc_datetime();

        $courseId = intval($courseId);
        $userId = intval($userId);
        $sessionId = intval($sessionId);
        $ip = Database::escape_string($ip);

        // Get the current latest course connection register. We need that
        // record to re-use the data and create a new record.
        $sql = "SELECT *
                FROM $courseTrackingTable
                WHERE
                    user_id = ".$userId." AND
                    c_id = ".$courseId."  AND
                    session_id  = ".$sessionId." AND
                    login_course_date > '$time' - INTERVAL 3600 SECOND
                ORDER BY login_course_date DESC LIMIT 0,1";
        $result = Database::query($sql);

        // Ignore if we didn't find any course connection record in the last
        // hour. In this case it wouldn't be right to add a "fake" time record.
        if (Database::num_rows($result) > 0) {
            // Found the latest connection
            $row = Database::fetch_row($result);
            $courseAccessId = $row[0];
            $courseAccessLoginDate = $row[3];
            $counter = $row[5];
            $counter = $counter ? $counter : 0;
            // Insert a new record, copy of the current one (except the logout
            // date that we update to the current time)
            $sql = "INSERT INTO $courseTrackingTable(
                    c_id,
                    user_ip, 
                    user_id, 
                    login_course_date, 
                    logout_course_date, 
                    counter, 
                    session_id
                ) VALUES(
                    $courseId, 
                    '$ip', 
                    $userId, 
                    '$courseAccessLoginDate', 
                    '$logoutDate', 
                    $counter, 
                    $sessionId
                )";
            Database::query($sql);

            $loginDate = ChamiloApi::addOrSubTimeToDateTime(
                $virtualTime,
                $courseAccessLoginDate,
                false
            );
            // We update the course tracking table
            $sql = "UPDATE $courseTrackingTable  
                    SET 
                        login_course_date = '$loginDate',
                        logout_course_date = '$courseAccessLoginDate',
                        counter = 0
                    WHERE 
                        course_access_id = ".intval($courseAccessId)." AND 
                        session_id = ".$sessionId;
            Database::query($sql);

            return true;
        }

        return false;
    }
    /**