chamilo / chamilo-lms

            $sql = "SELECT * FROM ".$tbl_global_agenda." WHERE MONTH(start_date) = ".$month." AND YEAR(start_date) = ".$year."  AND access_url_id = $current_access_url_id ORDER BY start_date ASC";

        }

        // 2. creating the SQL statement for getting the personal agenda items in WEEK view

        if ($type == "week_view") { // we are in week view

            $start_end_day_of_week = self::calculate_start_end_of_week($week, $year);

            $start_day = $start_end_day_of_week['start']['day'];

            $start_month = $start_end_day_of_week['start']['month'];

            $start_year = $start_end_day_of_week['start']['year'];

            $end_day = $start_end_day_of_week['end']['day'];

            $end_month = $start_end_day_of_week['end']['month'];

            $end_year = $start_end_day_of_week['end']['year'];

            // in sql statements you have to use year-month-day for date calculations

            $start_filter = $start_year."-".$start_month."-".$start_day." 00:00:00";

            $start_filter = api_get_utc_datetime($start_filter);

            $end_filter = $end_year."-".$end_month."-".$end_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 ";

        }

        // 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

        // 2. creating the SQL statement for getting the personal agenda items in WEEK view

        // we are in week view

        if ($type == "week_view") {

            $start_end_day_of_week = self::calculate_start_end_of_week($week, $year);

            $start_day = $start_end_day_of_week['start']['day'];

            $start_month = $start_end_day_of_week['start']['month'];

            $start_year = $start_end_day_of_week['start']['year'];

            $end_day = $start_end_day_of_week['end']['day'];

            $end_month = $start_end_day_of_week['end']['month'];

            $end_year = $start_end_day_of_week['end']['year'];

            // in sql statements you have to use year-month-day for date calculations

            $start_filter = $start_year."-".$start_month."-".$start_day." 00:00:00";

            $start_filter  = api_get_utc_datetime($start_filter);

            $end_filter = $end_year."-".$end_month."-".$end_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."'";

        }

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

        if ($type == "day_view") {

            // we are in day view