Function Reference: geodir_event_function_widget_events_where
Summary
This function has not been documented yet.
Source File
geodir_event_function_widget_events_where() is located in geodir_event_manager/gdevents_template_functions.php [Line: 1419]
Source Code
function geodir_event_function_widget_events_where( $where ) { global $wpdb, $plugin_prefix, $gd_query_args; if ( empty( $gd_query_args ) || empty( $gd_query_args['is_geodir_loop'] ) ) { return $where; } $table = $plugin_prefix . 'gd_event_detail'; $date_now = date_i18n( 'Y-m-d' ); if ( !empty( $gd_query_args ) && !empty( $gd_query_args['event_related_id'] ) ) { $where .= " AND " . $table . ".geodir_link_business = " . (int)$gd_query_args['event_related_id']; } if ( !empty( $gd_query_args ) && isset( $gd_query_args['geodir_event_type'] ) ) { if ( $gd_query_args['geodir_event_type'] == 'feature' ) { $where .= " AND ( " . EVENT_SCHEDULE . ".event_date >= '" . $date_now . "' OR ( " . EVENT_SCHEDULE . ".event_date <= '" . $date_now . "' AND " . EVENT_SCHEDULE . ".event_enddate >= '" . $date_now . "' ) ) "; } if ( $gd_query_args['geodir_event_type'] == 'past' ) { $where .= " AND " . EVENT_SCHEDULE . ".event_date < '" . $date_now . "' "; } if ( $gd_query_args['geodir_event_type'] == 'upcoming' ) { $where .= " AND ( " . EVENT_SCHEDULE . ".event_date >= '" . $date_now . "' OR ( " . EVENT_SCHEDULE . ".event_date <= '" . $date_now . "' AND " . EVENT_SCHEDULE . ".event_enddate >= '" . $date_now . "' ) ) "; } if ( $gd_query_args['geodir_event_type'] == 'today' ) { $where .= " AND ( " . EVENT_SCHEDULE . ".event_date LIKE '" . $date_now . "%%' OR ( " . EVENT_SCHEDULE . ".event_date <= '" . $date_now . "' AND " . EVENT_SCHEDULE . ".event_enddate >= '" . $date_now . "' ) ) "; } } if ( !empty( $gd_query_args ) && !empty( $gd_query_args['gd_location'] ) && function_exists( 'geodir_default_location_where' ) ) { $where = geodir_default_location_where( $where,$table ); } return $where; }