chamilo / chamilo-lms

        $dateCondition = null;

        if (!empty($start) && !empty($end)) {

            $dateCondition .= "AND (

                 agenda.start_date BETWEEN '".$start."' AND '".$end."' OR

                 agenda.end_date BETWEEN '".$start."' AND '".$end."' OR

                 (

                     agenda.start_date IS NOT NULL AND agenda.end_date IS NOT NULL AND

                     YEAR(agenda.start_date) = YEAR(agenda.end_date) AND

                     MONTH('$start') BETWEEN MONTH(agenda.start_date) AND MONTH(agenda.end_date)

                 )

            )";

        }

        $sql .= $dateCondition;

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

        $dateCondition = '';

        if (!empty($start) && !empty($end)) {

            $dateCondition .= "AND (

                 start_date BETWEEN '".$start."' AND '".$end."' OR

                 end_date BETWEEN '".$start."' AND '".$end."' OR

                 (

                     start_date IS NOT NULL AND end_date IS NOT NULL AND

                     YEAR(start_date) = YEAR(end_date) AND

                     MONTH('$start') BETWEEN MONTH(start_date) AND MONTH(end_date)

                 )

            )";

        }

        $access_url_id = api_get_current_access_url_id();