chamilo / chamilo-lms

        $today = new DateTime('now', new DateTimeZone('UTC'));

        switch ($timeFilter) {

            case 'last_7_days':

                $newDate = new DateTime('-7 day', new DateTimeZone('UTC'));

                $condition_time = " AND (login_date >= '{$newDate->format('Y-m-d H:i:s')}'";

                $condition_time .= " AND logout_date <= '{$today->format('Y-m-d H:i:s')}') ";

                break;

            case 'last_30_days':

                $newDate = new DateTime('-30 days', new DateTimeZone('UTC'));

                $condition_time = " AND (login_date >= '{$newDate->format('Y-m-d H:i:s')}'";

                $condition_time = " AND (login_date >= '{$newDate->format('Y-m-d H:i:s')}'";

                $condition_time .= " AND logout_date <= '{$today->format('Y-m-d H:i:s')}') ";

                break;

            case 'last_30_days':

                $newDate = new DateTime('-30 days', new DateTimeZone('UTC'));

                $condition_time = " AND (login_date >= '{$newDate->format('Y-m-d H:i:s')}'";

                $condition_time .= "AND logout_date <= '{$today->format('Y-m-d H:i:s')}') ";

                break;

            case 'custom':

                if (!empty($start_date) && !empty($end_date)) {

                    $start_date = Database::escape_string($start_date);