function eme_get_events($o_limit = 0, $scope = "future", $order = "ASC", $o_offset = 0, $location_id = "", $category = "", $author = "", $contact_person = "", $show_ongoing = 1, $notcategory = "", $show_recurrent_events_once = 0, $extra_conditions = "") { global $wpdb, $eme_timezone; $events_table = $wpdb->prefix . EVENTS_TBNAME; $bookings_table = $wpdb->prefix . BOOKINGS_TBNAME; if (strpos($o_limit, "=")) { // allows the use of arguments $defaults = array('o_limit' => 0, 'scope' => 'future', 'order' => 'ASC', 'o_offset' => 0, 'location_id' => '', 'category' => '', 'author' => '', 'contact_person' => '', 'show_ongoing' => 1, 'notcategory' => '', 'show_recurrent_events_once' => 0, 'extra_conditions' => ''); $r = wp_parse_args($o_limit, $defaults); extract($r); } if ($o_limit === "") { $o_limit = get_option('eme_event_list_number_items'); } if ($o_limit > 0) { $limit = "LIMIT " . intval($o_limit); } else { $limit = ""; } if ($o_offset > 0) { if ($o_limit == 0) { $limit = "LIMIT " . intval($o_offset); } $offset = "OFFSET " . intval($o_offset); } else { $offset = ""; } if ($order != "DESC") { $order = "ASC"; } $eme_date_obj = new ExpressiveDate(null, $eme_timezone); $start_of_week = get_option('start_of_week'); $eme_date_obj->setWeekStartDay($start_of_week); $today = $eme_date_obj->getDate(); $this_time = $eme_date_obj->getTime(); $this_datetime = $eme_date_obj->getDateTime(); $conditions = array(); // extra sql conditions we put in front, most of the time this is the most // effective place if ($extra_conditions != "") { $conditions[] = $extra_conditions; } // if we're not in the admin itf, we don't want draft events if (!is_admin()) { if (is_user_logged_in()) { $conditions[] = "event_status IN (" . STATUS_PUBLIC . "," . STATUS_PRIVATE . ")"; } else { $conditions[] = "event_status=" . STATUS_PUBLIC; } if (get_option('eme_rsvp_hide_full_events')) { // COALESCE is used in case the SUM returns NULL // this is a correlated subquery, so the FROM clause should specify events_table again, so it will search in the outer query for events_table.event_id $conditions[] = "(event_rsvp=0 OR (event_rsvp=1 AND event_seats > (SELECT COALESCE(SUM(booking_seats),0) AS booked_seats FROM {$bookings_table} WHERE {$bookings_table}.event_id = {$events_table}.event_id)))"; } if (get_option('eme_rsvp_hide_rsvp_ended_events')) { $conditions[] = "(event_rsvp=0 OR (event_rsvp=1 AND (event_end_date < '{$today}' OR UNIX_TIMESTAMP(CONCAT(event_start_date,' ',event_start_time))-rsvp_number_days*60*60*24-rsvp_number_hours*60*60 > UNIX_TIMESTAMP()) ))"; } } if (preg_match("/^[0-9]{4}-[0-9]{2}-[0-9]{2}\$/", $scope)) { //$conditions[] = " event_start_date like '$scope'"; if ($show_ongoing) { $conditions[] = " ((event_start_date LIKE '{$scope}') OR (event_start_date <= '{$scope}' AND event_end_date >= '{$scope}'))"; } else { $conditions[] = " (event_start_date LIKE '{$scope}') "; } } elseif (preg_match("/^--([0-9]{4}-[0-9]{2}-[0-9]{2})\$/", $scope, $matches)) { $limit_start = $matches[1]; if ($show_ongoing) { $conditions[] = " (event_start_date < '{$limit_start}') "; } else { $conditions[] = " (event_end_date < '{$limit_start}') "; } } elseif (preg_match("/^\\+\\+([0-9]{4}-[0-9]{2}-[0-9]{2})\$/", $scope, $matches)) { $limit_start = $matches[1]; $conditions[] = " (event_start_date > '{$limit_start}') "; } elseif (preg_match("/^0000-([0-9]{2})\$/", $scope, $matches)) { $month = $matches[1]; $eme_date_obj->setMonth($month); $number_of_days_month = $eme_date_obj->getDaysInMonth(); $limit_start = "{$year}-{$month}-01"; $limit_end = "{$year}-{$month}-{$number_of_days_month}"; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "this_week") { // this comes from global wordpress preferences $start_of_week = get_option('start_of_week'); $eme_date_obj->setWeekStartDay($start_of_week); $limit_start = $eme_date_obj->startOfWeek()->format('Y-m-d'); $limit_end = $eme_date_obj->endOfWeek()->format('Y-m-d'); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "next_week") { // this comes from global wordpress preferences $start_of_week = get_option('start_of_week'); $eme_date_obj->setWeekStartDay($start_of_week); $eme_date_obj->addOneWeek(); $limit_start = $eme_date_obj->startOfWeek()->format('Y-m-d'); $limit_end = $eme_date_obj->endOfWeek()->format('Y-m-d'); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "this_month") { $limit_start = $eme_date_obj->startOfMonth()->format('Y-m-d'); $limit_end = $eme_date_obj->endOfMonth()->format('Y-m-d'); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "this_year") { $year = $eme_date_obj->getYear(); $limit_start = "{$year}-01-01"; $limit_end = "{$year}-12-31"; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "next_month") { $eme_date_obj->addOneMonth(); $limit_start = $eme_date_obj->startOfMonth()->format('Y-m-d'); $limit_end = $eme_date_obj->endOfMonth()->format('Y-m-d'); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif (preg_match("/^([0-9]{4}-[0-9]{2}-[0-9]{2})--([0-9]{4}-[0-9]{2}-[0-9]{2})\$/", $scope, $matches)) { $limit_start = $matches[1]; $limit_end = $matches[2]; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif (preg_match("/^([0-9]{4}-[0-9]{2}-[0-9]{2})--today\$/", $scope, $matches)) { $limit_start = $matches[1]; $limit_end = $today; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif (preg_match("/^today--([0-9]{4}-[0-9]{2}-[0-9]{2})\$/", $scope, $matches)) { $limit_start = $today; $limit_end = $matches[1]; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif (preg_match("/^\\+(\\d+)d\$/", $scope, $matches)) { $days = $matches[1]; $limit_start = $today; $limit_end = $eme_date_obj->addDays($days)->getDate(); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif (preg_match("/^\\-(\\d+)d\$/", $scope, $matches)) { $days = $matches[1]; $limit_start = $eme_date_obj->minusDays($days)->getDate(); $limit_end = $today; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif (preg_match("/^(\\-?\\+?\\d+)d--(\\-?\\+?\\d+)d\$/", $scope, $matches)) { $day1 = $matches[1]; $day2 = $matches[2]; $limit_start = $eme_date_obj->copy()->modifyDays($day1)->getDate(); $limit_end = $eme_date_obj->copy()->modifyDays($day2)->getDate(); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif (preg_match("/^relative\\-(\\d+)d--([0-9]{4}-[0-9]{2}-[0-9]{2})\$/", $scope, $matches)) { $days = $matches[1]; $limit_end = $matches[2]; $eme_date_obj->setTimestampFromString($limit_end . " " . $eme_timezone); $limit_start = $eme_date_obj->minusDays($days)->getDate() . " " . $eme_timezone; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif (preg_match("/^([0-9]{4}-[0-9]{2}-[0-9]{2})--relative\\+(\\d+)d\$/", $scope, $matches)) { $limit_start = $matches[1]; $days = $matches[2]; $eme_date_obj->setTimestampFromString($limit_start . " " . $eme_timezone); $limit_end = $eme_date_obj->addDays($days)->getDate() . " " . $eme_timezone; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif (preg_match("/^\\+(\\d+)m\$/", $scope, $matches)) { $months_in_future = $matches[1]++; $limit_start = $eme_date_obj->startOfMonth()->format('Y-m-d'); $eme_date_obj->addMonths($months_in_future); $limit_end = $eme_date_obj->endOfMonth()->format('Y-m-d'); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif (preg_match("/^\\-(\\d+)m\$/", $scope, $matches)) { $months_in_past = $matches[1]++; $limit_start = $eme_date_obj->copy()->minusMonths($months_in_past)->startOfMonth()->format('Y-m-d'); $limit_end = $eme_date_obj->copy()->minusOneMonth()->endOfMonth()->format('Y-m-d'); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif (preg_match("/^(\\-?\\+?\\d+)m--(\\-?\\+?\\d+)m\$/", $scope, $matches)) { $months1 = $matches[1]; $months2 = $matches[2]; $limit_start = $eme_date_obj->copy()->modifyMonths($months1)->startOfMonth()->format('Y-m-d'); $limit_end = $eme_date_obj->copy()->modifyMonths($months2)->endOfMonth()->format('Y-m-d'); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "today--this_week") { $limit_start = $today; $limit_end = $eme_date_obj->endOfWeek()->format('Y-m-d'); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "today--this_week_plus_one") { $limit_start = $today; $limit_end = $eme_date_obj->endOfWeek()->addOneDay()->format('Y-m-d'); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "today--this_month") { $limit_start = $today; $limit_end = $eme_date_obj->endOfMonth()->format('Y-m-d'); if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "today--this_year") { $limit_start = $today; $limit_end = "{$year}-12-31"; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "this_week--today") { $limit_start = $eme_date_obj->startOfWeek()->format('Y-m-d'); $limit_end = $today; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "this_month--today") { $limit_start = $eme_date_obj->startOfMonth()->format('Y-m-d'); $limit_end = $today; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "this_year--today") { $limit_start = "{$year}-01-01"; $limit_end = $today; if ($show_ongoing) { $conditions[] = " ((event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_end_date BETWEEN '{$limit_start}' AND '{$limit_end}') OR (event_start_date <= '{$limit_start}' AND event_end_date >= '{$limit_end}'))"; } else { $conditions[] = " (event_start_date BETWEEN '{$limit_start}' AND '{$limit_end}')"; } } elseif ($scope == "tomorrow--future") { if ($show_ongoing) { $conditions[] = " (event_start_date > '{$today}' OR (event_end_date > '{$today}' AND event_end_date != '0000-00-00' AND event_end_date IS NOT NULL))"; } else { $conditions[] = " (event_start_date > '{$today}')"; } } elseif ($scope == "past") { //$conditions[] = " (event_end_date < '$today' OR (event_end_date = '$today' and event_end_time < '$this_time' )) "; // not taking the hour into account until we can enter timezone info as well if ($show_ongoing) { $conditions[] = " event_end_date < '{$today}'"; } else { $conditions[] = " event_start_date < '{$today}'"; } } elseif ($scope == "today") { if ($show_ongoing) { $conditions[] = " (event_start_date = '{$today}' OR (event_start_date <= '{$today}' AND event_end_date >= '{$today}'))"; } else { $conditions[] = " (event_start_date = '{$today}')"; } } elseif ($scope == "tomorrow") { $tomorrow = $eme_date_obj->addOneDay()->getDate(); if ($show_ongoing) { $conditions[] = " (event_start_date = '{$tomorrow}' OR (event_start_date <= '{$tomorrow}' AND event_end_date >= '{$tomorrow}'))"; } else { $conditions[] = " (event_start_date = '{$tomorrow}')"; } } elseif ($scope == "ongoing") { // only shows ongoing events, for this we try to use the date and time, but it might be incorrect since there's no user timezone info $conditions[] = " (CONCAT(event_start_date,' ',event_start_time)<='{$this_datetime}' AND CONCAT(event_end_date,' ',event_end_time)>= '{$this_datetime}')"; } else { if ($scope != "all") { $scope = "future"; } if ($scope == "future") { //$conditions[] = " ((event_start_date = '$today' AND event_start_time >= '$this_time') OR (event_start_date > '$today') OR (event_end_date > '$today' AND event_end_date != '0000-00-00' AND event_end_date IS NOT NULL) OR (event_end_date = '$today' AND event_end_time >= '$this_time'))"; // not taking the hour into account until we can enter timezone info as well if ($show_ongoing) { $conditions[] = " (event_start_date >= '{$today}' OR (event_end_date >= '{$today}' AND event_end_date != '0000-00-00' AND event_end_date IS NOT NULL))"; } else { $conditions[] = " (event_start_date >= '{$today}')"; } } } // when used inside a location description, you can use this_location to indicate the current location being viewed if ($location_id == "this_location" && get_query_var('location_id')) { $location_id = get_query_var('location_id'); } if (is_numeric($location_id)) { if ($location_id > 0) { $conditions[] = " location_id = {$location_id}"; } } elseif ($location_id == "none") { $conditions[] = " location_id = ''"; } elseif (preg_match('/,/', $location_id)) { $location_ids = explode(',', $location_id); $location_conditions = array(); foreach ($location_ids as $loc) { if (is_numeric($loc) && $loc > 0) { $location_conditions[] = " location_id = {$loc}"; } elseif ($loc == "none") { $location_conditions[] = " location_id = ''"; } } $conditions[] = "(" . implode(' OR', $location_conditions) . ")"; } elseif (preg_match('/\\+/', $location_id)) { $location_ids = explode('+', $location_id); $location_conditions = array(); foreach ($location_ids as $loc) { if (is_numeric($loc) && $loc > 0) { $location_conditions[] = " location_id = {$loc}"; } } $conditions[] = "(" . implode(' AND', $location_conditions) . ")"; } elseif (preg_match('/ /', $location_id)) { // url decoding of '+' is ' ' $location_ids = explode(' ', $location_id); $location_conditions = array(); foreach ($location_ids as $loc) { if (is_numeric($loc) && $loc > 0) { $location_conditions[] = " location_id = {$loc}"; } } $conditions[] = "(" . implode(' AND', $location_conditions) . ")"; } if (get_option('eme_categories_enabled')) { if (is_numeric($category)) { if ($category > 0) { $conditions[] = " FIND_IN_SET({$category},event_category_ids)"; } } elseif ($category == "none") { $conditions[] = "event_category_ids = ''"; } elseif (preg_match('/,/', $category)) { $category = explode(',', $category); $category_conditions = array(); foreach ($category as $cat) { if (is_numeric($cat) && $cat > 0) { $category_conditions[] = " FIND_IN_SET({$cat},event_category_ids)"; } elseif ($cat == "none") { $category_conditions[] = " event_category_ids = ''"; } } $conditions[] = "(" . implode(' OR', $category_conditions) . ")"; } elseif (preg_match('/\\+/', $category)) { $category = explode('+', $category); $category_conditions = array(); foreach ($category as $cat) { if (is_numeric($cat) && $cat > 0) { $category_conditions[] = " FIND_IN_SET({$cat},event_category_ids)"; } } $conditions[] = "(" . implode(' AND ', $category_conditions) . ")"; } elseif (preg_match('/ /', $category)) { // url decoding of '+' is ' ' $category = explode(' ', $category); $category_conditions = array(); foreach ($category as $cat) { if (is_numeric($cat) && $cat > 0) { $category_conditions[] = " FIND_IN_SET({$cat},event_category_ids)"; } } $conditions[] = "(" . implode(' AND ', $category_conditions) . ")"; } } if (get_option('eme_categories_enabled')) { if (is_numeric($notcategory)) { if ($notcategory > 0) { $conditions[] = " NOT FIND_IN_SET({$notcategory},event_category_ids)"; } } elseif ($notcategory == "none") { $conditions[] = "event_category_ids != ''"; } elseif (preg_match('/,/', $notcategory)) { $notcategory = explode(',', $notcategory); $category_conditions = array(); foreach ($notcategory as $cat) { if (is_numeric($cat) && $cat > 0) { $category_conditions[] = " NOT FIND_IN_SET({$cat},event_category_ids)"; } elseif ($cat == "none") { $category_conditions[] = " event_category_ids != ''"; } } $conditions[] = "(" . implode(' OR', $category_conditions) . ")"; } elseif (preg_match('/\\+/', $notcategory)) { $notcategory = explode('+', $notcategory); $category_conditions = array(); foreach ($notcategory as $cat) { if (is_numeric($cat) && $cat > 0) { $category_conditions[] = " NOT FIND_IN_SET({$cat},event_category_ids)"; } } $conditions[] = "(" . implode(' AND ', $category_conditions) . ")"; } elseif (preg_match('/ /', $notcategory)) { // url decoding of '+' is ' ' $notcategory = explode(' ', $notcategory); $category_conditions = array(); foreach ($notcategory as $cat) { if (is_numeric($cat) && $cat > 0) { $category_conditions[] = " NOT FIND_IN_SET({$cat},event_category_ids)"; } } } } // now filter the author ID if ($author != '' && !preg_match('/,/', $author)) { $authinfo = get_user_by('login', $author); $conditions[] = " event_author = " . $authinfo->ID; } elseif (preg_match('/,/', $author)) { $authors = explode(',', $author); $author_conditions = array(); foreach ($authors as $authname) { $authinfo = get_user_by('login', $authname); $author_conditions[] = " event_author = " . $authinfo->ID; } $conditions[] = "(" . implode(' OR ', $author_conditions) . ")"; } // now filter the contact ID if ($contact_person != '' && !preg_match('/,/', $contact_person)) { $authinfo = get_user_by('login', $contact_person); $conditions[] = " event_contactperson_id = " . $authinfo->ID; } elseif (preg_match('/,/', $contact_person)) { $contact_persons = explode(',', $contact_person); $contact_person_conditions = array(); foreach ($contact_persons as $authname) { $authinfo = get_user_by('login', $authname); $contact_person_conditions[] = " event_contactperson_id = " . $authinfo->ID; } $conditions[] = "(" . implode(' OR ', $contact_person_conditions) . ")"; } // extra conditions for authors: if we're in the admin itf, return only the events for which you have the right to change anything $current_userid = get_current_user_id(); if (is_admin() && !current_user_can(get_option('eme_cap_edit_events')) && !current_user_can(get_option('eme_cap_list_events')) && current_user_can(get_option('eme_cap_author_event'))) { $conditions[] = "(event_author = {$current_userid} OR event_contactperson_id= {$current_userid})"; } $where = implode(" AND ", $conditions); if ($show_recurrent_events_once) { if ($where != "") { $where = " AND " . $where; } $sql = "SELECT * FROM {$events_table}\n WHERE (recurrence_id>0 {$where})\n group by recurrence_id union all\n SELECT * FROM {$events_table}\n WHERE (recurrence_id=0 {$where})\n ORDER BY event_start_date {$order} , event_start_time {$order}\n {$limit} \n {$offset}"; } else { if ($where != "") { $where = " WHERE " . $where; } $sql = "SELECT * FROM {$events_table}\n {$where}\n ORDER BY event_start_date {$order} , event_start_time {$order}\n {$limit} \n {$offset}"; } $wpdb->show_errors = true; $events = $wpdb->get_results($sql, ARRAY_A); $inflated_events = array(); if (!empty($events)) { //$wpdb->print_error(); foreach ($events as $this_event) { $this_event = eme_get_event_data($this_event); array_push($inflated_events, $this_event); } if (has_filter('eme_event_list_filter')) { $inflated_events = apply_filters('eme_event_list_filter', $inflated_events); } } return $inflated_events; }
function eme_get_calendar($args = "") { global $wp_locale; global $wpdb, $eme_timezone; // the calendar is being used, so we need the jquery for the calendar global $eme_need_calendar_js; $eme_need_calendar_js = 1; $defaults = array('category' => 0, 'notcategory' => 0, 'full' => 0, 'month' => '', 'year' => '', 'echo' => 1, 'long_events' => 0, 'author' => '', 'contact_person' => '', 'location_id' => '', 'template_id' => 0); $r = wp_parse_args($args, $defaults); extract($r); $echo = $echo === "true" || $echo === "1" ? true : $echo; $full = $full === "true" || $full === "1" ? true : $full; $long_events = $long_events === "true" || $long_events === "1" ? true : $long_events; $echo = $echo === "false" || $echo === "0" ? false : $echo; $full = $full === "false" || $full === "0" ? false : $full; $long_events = $long_events === "false" || $long_events === "0" ? false : $long_events; // this comes from global wordpress preferences $start_of_week = get_option('start_of_week'); $eme_date_obj = new ExpressiveDate(null, $eme_timezone); if (get_option('eme_use_client_clock') && isset($_SESSION['eme_client_mday']) && isset($_SESSION['eme_client_month']) && isset($_SESSION['eme_client_fullyear'])) { // these come from client unless their clock is wrong $iNowDay = sprintf("%02d", $_SESSION['eme_client_mday']); $iNowMonth = sprintf("%02d", $_SESSION['eme_client_month']); $iNowYear = sprintf("%04d", $_SESSION['eme_client_fullyear']); } else { // Get current year, month and day list($iNowYear, $iNowMonth, $iNowDay) = explode('-', $eme_date_obj->getDate()); } $iSelectedYear = $year; $iSelectedMonth = $month; if ($iSelectedMonth == '') { $iSelectedMonth = $iNowMonth; } if ($iSelectedYear == '') { $iSelectedYear = $iNowYear; } $iSelectedMonth = sprintf("%02d", $iSelectedMonth); // Get name and number of days of specified month $eme_date_obj->setDay(1); $eme_date_obj->setMonth($iSelectedMonth); $eme_date_obj->setYear($iSelectedYear); // Get friendly month name, but since DateTime::format doesn't respect the locale, we need eme_localised_date if ($full) { list($sMonthName, $iDaysInMonth) = explode('-', eme_localised_date($eme_date_obj->getDate(), 'F-t')); } else { list($sMonthName, $iDaysInMonth) = explode('-', eme_localised_date($eme_date_obj->getDate(), 'M-t')); } // take into account some locale info: some always best show full month name, some show month after year, some have a year suffix $locale_code = substr(get_locale(), 0, 2); $showMonthAfterYear = 0; $yearSuffix = ""; switch ($locale_code) { case "hu": $showMonthAfterYear = 1; break; case "ja": $showMonthAfterYear = 1; $sMonthName = eme_localised_date($eme_date_obj->getDate(), 'F'); $yearSuffix = "年"; break; case "ko": $showMonthAfterYear = 1; $sMonthName = eme_localised_date($eme_date_obj->getDate(), 'F'); $yearSuffix = "년"; break; case "zh": $showMonthAfterYear = 1; $sMonthName = eme_localised_date($eme_date_obj->getDate(), 'F'); $yearSuffix = "年"; break; } if ($showMonthAfterYear) { $cal_datestring = "{$iSelectedYear}{$yearSuffix} {$sMonthName}"; } else { $cal_datestring = "{$sMonthName} {$iSelectedYear}{$yearSuffix}"; } // Get previous year and month $iPrevYear = $iSelectedYear; $iPrevMonth = $iSelectedMonth - 1; if ($iPrevMonth <= 0) { $iPrevYear--; $iPrevMonth = 12; // set to December } $iPrevMonth = sprintf("%02d", $iPrevMonth); // Get next year and month $iNextYear = $iSelectedYear; $iNextMonth = $iSelectedMonth + 1; if ($iNextMonth > 12) { $iNextYear++; $iNextMonth = 1; } $iNextMonth = sprintf("%02d", $iNextMonth); // Get number of days of previous month $eme_date_obj2 = new ExpressiveDate(null, $eme_timezone); $eme_date_obj2->setDay(1); $eme_date_obj2->setMonth($iPrevMonth); $eme_date_obj2->setYear($iPrevYear); $iPrevDaysInMonth = (int) $eme_date_obj2->getDaysInMonth(); // Get numeric representation of the day of the week of the first day of specified (current) month // remember: first day of week is a Sunday // if you want the day of the week to begin on Monday: start_of_week=1, Tuesday: start_of_week=2, etc ... // So, if e.g. the month starts on a Sunday and start_of_week=1 (Monday), then $iFirstDayDow is 6 $iFirstDayDow = (int) $eme_date_obj->getDayOfWeekAsNumeric() - $start_of_week; if ($iFirstDayDow < 0) { $iFirstDayDow += 7; } // On what day the previous month begins $iPrevShowFrom = $iPrevDaysInMonth - $iFirstDayDow + 1; // we'll look for events in the requested month and 7 days before and after $calbegin = "{$iPrevYear}-{$iPrevMonth}-{$iPrevShowFrom}"; $calend = "{$iNextYear}-{$iNextMonth}-07"; $events = eme_get_events(0, "{$calbegin}--{$calend}", "ASC", 0, $location_id, $category, $author, $contact_person, 1, $notcategory); $eventful_days = array(); if ($events) { //Go through the events and slot them into the right d-m index foreach ($events as $event) { if ($event['event_status'] == STATUS_PRIVATE && !is_user_logged_in()) { continue; } $eme_date_obj_end = new ExpressiveDate($event['event_end_date'] . " " . $event['event_end_time'], $eme_timezone); $eme_date_obj_now = new ExpressiveDate(null, $eme_timezone); if (get_option('eme_cal_hide_past_events') && $eme_date_obj_end->lessThan($eme_date_obj_now)) { continue; } if ($long_events) { //If $long_events is set then show a date as eventful if there is an multi-day event which runs during that day $eme_date_obj_tmp = new ExpressiveDate($event['event_start_date'] . " " . $event['event_start_time'], $eme_timezone); if ($eme_date_obj_end->lessThan($eme_date_obj_tmp)) { $eme_date_obj_end = $eme_date_obj_tmp->copy(); } $day_count = 0; while ($eme_date_obj_tmp->lessOrEqualTo($eme_date_obj_end)) { $event_eventful_date = $eme_date_obj_tmp->getDate(); //Only show events on the day that they start if (isset($eventful_days[$event_eventful_date]) && is_array($eventful_days[$event_eventful_date])) { $eventful_days[$event_eventful_date][] = $event; } else { $eventful_days[$event_eventful_date] = array($event); } $eme_date_obj_tmp->addOneDay(); } } else { //Only show events on the day that they start if (isset($eventful_days[$event['event_start_date']]) && is_array($eventful_days[$event['event_start_date']])) { $eventful_days[$event['event_start_date']][] = $event; } else { $eventful_days[$event['event_start_date']] = array($event); } } } } // we found all the events for the wanted days, now get them in the correct format with a good link if ($template_id) { $event_format = eme_get_template_format($template_id); } else { $event_format = get_option('eme_full_calendar_event_format'); } $event_title_format = get_option('eme_small_calendar_event_title_format'); $event_title_separator_format = get_option('eme_small_calendar_event_title_separator'); $cells = array(); foreach ($eventful_days as $day_key => $events) { // Set the date into the key $events_titles = array(); foreach ($events as $event) { $events_titles[] = eme_replace_placeholders($event_title_format, $event, "text"); } $link_title = implode($event_title_separator_format, $events_titles); $cal_day_link = eme_calendar_day_url($day_key); // Let's add the possible options // template_id is not being used per event if (!empty($location_id)) { $cal_day_link = add_query_arg(array('location_id' => $location_id), $cal_day_link); } if (!empty($category)) { $cal_day_link = add_query_arg(array('category' => $category), $cal_day_link); } if (!empty($notcategory)) { $cal_day_link = add_query_arg(array('notcategory' => $scope), $cal_day_link); } if (!empty($author)) { $cal_day_link = add_query_arg(array('author' => $author), $cal_day_link); } if (!empty($contact_person)) { $cal_day_link = add_query_arg(array('contact_person' => $contact_person), $cal_day_link); } $event_date = explode('-', $day_key); $event_day = ltrim($event_date[2], '0'); $cells[$day_key] = "<a title='{$link_title}' href='{$cal_day_link}'>{$event_day}</a>"; if ($full) { $cells[$day_key] .= "<ul class='eme-calendar-day-event'>"; foreach ($events as $event) { $cells[$day_key] .= eme_replace_placeholders($event_format, $event); } $cells[$day_key] .= "</ul>"; } } // If previous month $isPreviousMonth = $iFirstDayDow > 0; // Initial day on the calendar $iCalendarDay = $isPreviousMonth ? $iPrevShowFrom : 1; $isNextMonth = false; $sCalTblRows = ''; // Generate rows for the calendar for ($i = 0; $i < 6; $i++) { // 6-weeks range if ($isNextMonth) { continue; } $sCalTblRows .= "<tr>"; for ($j = 0; $j < 7; $j++) { // 7 days a week // we need the calendar day with 2 digits for the planned events $iCalendarDay_padded = sprintf("%02d", $iCalendarDay); if ($isPreviousMonth) { $calstring = "{$iPrevYear}-{$iPrevMonth}-{$iCalendarDay_padded}"; } elseif ($isNextMonth) { $calstring = "{$iNextYear}-{$iNextMonth}-{$iCalendarDay_padded}"; } else { $calstring = "{$iSelectedYear}-{$iSelectedMonth}-{$iCalendarDay_padded}"; } // each day in the calendar has the name of the day as a class by default $eme_date_obj = new ExpressiveDate($calstring, $eme_timezone); $sClass = $eme_date_obj->format('D'); if (isset($cells[$calstring])) { if ($isPreviousMonth) { $sClass .= " eventful-pre event-day-{$iCalendarDay}"; } elseif ($isNextMonth) { $sClass .= " eventful-post event-day-{$iCalendarDay}"; } elseif ($calstring == "{$iNowYear}-{$iNowMonth}-{$iNowDay}") { $sClass .= " eventful-today event-day-{$iCalendarDay}"; } else { $sClass .= " eventful event-day-{$iCalendarDay}"; } $sCalTblRows .= '<td class="' . $sClass . '">' . $cells[$calstring] . "</td>\n"; } else { if ($isPreviousMonth) { $sClass .= " eventless-pre"; } elseif ($isNextMonth) { $sClass .= " eventless-post"; } elseif ($calstring == "{$iNowYear}-{$iNowMonth}-{$iNowDay}") { $sClass .= " eventless-today"; } else { $sClass .= " eventless"; } $sCalTblRows .= '<td class="' . $sClass . '">' . $iCalendarDay . "</td>\n"; } // Next day $iCalendarDay++; if ($isPreviousMonth && $iCalendarDay > $iPrevDaysInMonth) { $isPreviousMonth = false; $iCalendarDay = 1; } if (!$isPreviousMonth && !$isNextMonth && $iCalendarDay > $iDaysInMonth) { $isNextMonth = true; $iCalendarDay = 1; } } $sCalTblRows .= "</tr>\n"; } $weekdays = array(__('Sunday'), __('Monday'), __('Tuesday'), __('Wednesday'), __('Thursday'), __('Friday'), __('Saturday')); $sCalDayNames = ""; // respect the beginning of the week offset for ($i = $start_of_week; $i < $start_of_week + 7; $i++) { $j = $i; if ($j == 7) { $j -= 7; } if ($full) { $sCalDayNames .= "<td>" . $wp_locale->get_weekday_abbrev($weekdays[$j]) . "</td>"; } else { $sCalDayNames .= "<td>" . $wp_locale->get_weekday_initial($weekdays[$j]) . "</td>"; } } // the real links are created via jquery when clicking on the prev-month or next-month class-links $previous_link = "<a class='prev-month' href=\"#\"><<</a>"; $next_link = "<a class='next-month' href=\"#\">>></a>"; $random = rand(100, 200); $full ? $class = 'eme-calendar-full' : ($class = 'eme-calendar'); $calendar = "<div class='{$class}' id='eme-calendar-{$random}'>"; if ($full) { $fullclass = 'fullcalendar'; $head = "<td class='month_name' colspan='7'>{$previous_link} {$next_link} {$cal_datestring}</td>\n"; } else { $fullclass = ''; $head = "<td>{$previous_link}</td><td class='month_name' colspan='5'>{$cal_datestring}</td><td>{$next_link}</td>\n"; } // Build the heading portion of the calendar table $calendar .= "<table class='eme-calendar-table {$fullclass}'>\n" . "<thead>\n<tr>\n" . $head . "</tr>\n</thead>\n" . "<tr class='days-names'>\n" . $sCalDayNames . "</tr>\n"; $calendar .= $sCalTblRows; $calendar .= "</table>\n</div>"; // we generate the onclick javascript per calendar div // this is important if more than one calendar exists on the page $calendar .= "<script type='text/javascript'>\n jQuery('#eme-calendar-" . $random . " a.prev-month').click(function(e){\n e.preventDefault();\n tableDiv = jQuery('#eme-calendar-" . $random . "');\n loadCalendar(tableDiv, '{$full}', '{$long_events}','{$iPrevMonth}','{$iPrevYear}','{$category}','{$author}','{$contact_person}','{$location_id}','{$notcategory}','{$template_id}');\n } );\n jQuery('#eme-calendar-" . $random . " a.next-month').click(function(e){\n e.preventDefault();\n tableDiv = jQuery('#eme-calendar-" . $random . "');\n loadCalendar(tableDiv, '{$full}', '{$long_events}','{$iNextMonth}','{$iNextYear}','{$category}','{$author}','{$contact_person}','{$location_id}','{$notcategory}','{$template_id}');\n } );\n </script>"; $output = $calendar; if ($echo) { echo $output; } else { return $output; } }