Function Reference: geodir_event_count_reviews_by_term_sql

Summary

Filter reviews sql query fro upcomin events.

Global Values

$wpdb

(object) (required) WordPress Database object.

Default: None

$plugin_prefix

(string) (required) Geodirectory plugin table prefix.

Default: None

Parameters

$sql

(string) (required) Database sql query.

Default: None

$term_id

(int) (required) The term ID.

Default: None

$taxonomy

(int) (required) The taxonomy Id.

Default: None

$post_type

(string) (required) The post type.

Default: None

Return Values

(string)

• Database sql query.

Change Log

Since: 1.2.4

Source File

geodir_event_count_reviews_by_term_sql() is located in geodir_event_manager/gdevents_functions.php [Line: 2036]

Source Code

function geodir_event_count_reviews_by_term_sql($sql, $term_id, $taxonomy, $post_type) {
	if ($term_id > 0 && $post_type == 'gd_event') {
		global $wpdb, $plugin_prefix;
		
		$listing_table = $plugin_prefix . $post_type . '_detail';
		
		$current_date = date_i18n( 'Y-m-d', current_time( 'timestamp' ) );
		
		$sql = "SELECT COALESCE(SUM(ed.rating_count),0) FROM `" . $listing_table . "` AS ed INNER JOIN " . EVENT_SCHEDULE . " AS es ON (es.event_id = ed.post_id) WHERE ed.post_status = 'publish' AND ed.rating_count > 0 AND FIND_IN_SET(" . $term_id . ", ed." . $taxonomy . ")";
		$sql .= " AND (es.event_date >= '" . $current_date . "' OR (es.event_date <= '" . $current_date . "' AND es.event_enddate >= '" . $current_date . "'))";
	}
	
	return $sql;
}