chamilo / chamilo-lms

            $sql = " SELECT * FROM ".$tbl_global_agenda." WHERE start_date>='".$start_filter."' AND start_date<='".$end_filter."' AND  access_url_id = $current_access_url_id ";

        }

        // 3. creating the SQL statement for getting the personal agenda items in DAY view

        if ($type == "day_view") { // we are in day view

            // we could use mysql date() function but this is only available from 4.1 and higher

            $start_filter = $year."-".$month."-".$day." 00:00:00";

            $start_filter = api_get_utc_datetime($start_filter);

            $end_filter = $year."-".$month."-".$day." 23:59:59";

            $end_filter = api_get_utc_datetime($end_filter);

            $sql = " SELECT * FROM ".$tbl_global_agenda." WHERE start_date>='".$start_filter."' AND start_date<='".$end_filter."'  AND  access_url_id = $current_access_url_id";

        }

        $result = Database::query($sql);

            $sql = " SELECT * FROM ".$tbl_personal_agenda." WHERE user='".$user_id."' AND date>='".$start_filter."' AND date<='".$end_filter."'";

        }

        // 3. creating the SQL statement for getting the personal agenda items in DAY view

        if ($type == "day_view") {

            // we are in day view

            // we could use mysql date() function but this is only available from 4.1 and higher

            $start_filter = $year."-".$month."-".$day." 00:00:00";

            $start_filter  = api_get_utc_datetime($start_filter);

            $end_filter = $year."-".$month."-".$day." 23:59:59";

            $end_filter  = api_get_utc_datetime($end_filter);

            $sql = " SELECT * FROM ".$tbl_personal_agenda." WHERE user='".$user_id."' AND date>='".$start_filter."' AND date<='".$end_filter."'";

        }

        $result = Database::query($sql);

        while ($item = Database::fetch_array($result, 'ASSOC')) {