+global\Event::eventRemoveVirtualCourseTime()

Complexity

Conditions	4
Paths	5

Size

Total Lines	48
Code Lines	27

Duplication

Lines	9
Ratio	18.75 %

Importance

Changes

0

<?php
    public static function eventRemoveVirtualCourseTime($courseId, $userId, $sessionId = 0, $virtualTime = '')
    {
        if (empty($virtualTime)) {
            return false;
        }
        $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);
        // Change $virtualTime format from hh:mm:ss to hhmmss which is the
        // format returned by SQL for a subtraction of two datetime values
        // @todo make sure this is portable between DBMSes
        if (preg_match('/:/', $virtualTime)) {
            list($h, $m, $s) = preg_split('/:/', $virtualTime);
            $virtualTime = $h * 3600 + $m * 60 + $s;
        } else {
            $virtualTime *= 3600;
        }

        // Get the current latest course connection register. We need that
        // record to re-use the data and create a new record.
        $sql = "SELECT course_access_id
                        FROM $courseTrackingTable
                        WHERE
                            user_id = $userId AND
                            c_id = $courseId  AND
                            session_id  = $sessionId AND
                            counter = 0 AND
                            (UNIX_TIMESTAMP(logout_course_date) - UNIX_TIMESTAMP(login_course_date)) = '$virtualTime'
                        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];
            $sql = "DELETE FROM $courseTrackingTable WHERE course_access_id = $courseAccessId";
            $result = Database::query($sql);

            return $result;
        }

        return false;
    }