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;
}