Support

October 24, 2018 at 11:36 am

Hi Tony,

Sort of correct, same principle.

There are 10 datetimes with 5 assigned to 2 of each of the tickets (evening and morning classes). All datetimes have a limit of 12. The tickets also have a limit of 12 each.

https://www.dropbox.com/s/x00x6nty8p5egal/Screenshot%202018-10-24%2010.31.08.png?dl=0

https://www.dropbox.com/s/rysbvpu3ot9lryq/Screenshot%202018-10-24%2010.31.13.png?dl=0

Perhaps this isn’t new, come to think of it, I’m not sure if we have sold out datetimes before the 2nd (later) ticket became available – I’m not sure.

At any rate, I suppose it’s not a big deal. Ideally I would like only the available tickets show, based on their available dates, even if they are sold out. So I’d like it to show this ticket only:

Advance Pricing 6pm-8pm - Goes to $185 Nov 1 (5 Classes) (1 left...)

Easy to implement? If not, let’s not worry about it – I can just go in and manually mess around with the tickets as this comes up (i.e. delete the 2nd/later ticket or change the dates to an earlier date to hide the first one).

Thanks, Derek

October 24, 2018 at 1:27 pm

Unfortunately, I think that will remove all ‘sold-out’ tickets, will it not?

I just want the ones that are unavailable based on set availability to be hidden.

Thanks, Derek

October 24, 2018 at 1:48 pm

I have 2 tickets for each set of date times. When one becomes unavailable (per availability dates set for each ticket), the other becomes available at the same time. It’s a less expensive ticket purchased before a certain date. So for example on Nov 1, the early priced ticket will expire and the regular price ticket will become available.

Currently, the ones that are not ‘on sale’ yet are hidden, unless sold out, as the topic of this thread.

However, as the earlier ticket sold out, EE is showing both tickets as sold out even though the 2nd one is not available per the dates set in the ticket. I would prefer it only showed the one that is available (per date) now, not the one that comes available Nov 1.

I just remembered how this was done and used this code provided:

/**
 * The purpose of this snippet is to filter the event archive (and event taxonomy archive) pages so that they exclude events
 * that have tickets no longer on sale.
 *
 *  NOTE: This query is only valid for Event Espresso 4.8+
 *
 * To Implement this code, add it to the bottom of your themes functions.php file, or add it to a site specific plugin.
 *
 */
function de_ee_tweak_event_list_exclude_ticket_expired_events_where( $SQL, WP_Query $wp_query ) {
	if ( isset( $wp_query->query_vars['post_type'] ) && ( $wp_query->query_vars['post_type'] == 'espresso_events'  || ( is_array( $wp_query->query_vars['post_type'] ) && in_array( 'espresso_events', $wp_query->query_vars['post_type'] ) ) ) && ! $wp_query->is_singular ) {
		$SQL .= ' AND Ticket.TKT_end_date > "' . current_time( 'mysql', true ) . '" AND Ticket.TKT_deleted=0';
	}
	return $SQL;
}
add_filter( 'posts_where', 'de_ee_tweak_event_list_exclude_ticket_expired_events_where', 15, 2 );
function de_ee_tweak_event_list_exclude_ticket_expired_events_join( $SQL, $wp_query ) {
	if ( isset( $wp_query->query_vars['post_type'] ) && ( $wp_query->query_vars['post_type'] == 'espresso_events'  || ( is_array( $wp_query->query_vars['post_type'] ) && in_array( 'espresso_events', $wp_query->query_vars['post_type'] ) ) ) && ! $wp_query->is_singular ) {
		if ( ! $wp_query->is_espresso_event_archive && ! $wp_query->is_espresso_event_taxonomy  ) {
			$SQL .= ' INNER JOIN ' . EEM_Datetime::instance()->table() . ' ON ( ' . EEM_Event::instance()->table() . '.ID = ' . EEM_Datetime::instance()->table() . '.' . EEM_Event::instance()->primary_key_name() . ' ) ';
		}
		$SQL .= ' INNER JOIN ' . EEM_Datetime_Ticket::instance()->table() . ' AS Datetime_Ticket ON ( Datetime_Ticket.DTT_ID=' . EEM_Datetime::instance()->table() . '.' . EEM_Datetime::instance()->primary_key_name() . ' ) INNER JOIN ' . EEM_Ticket::instance()->table()  . ' AS Ticket ON ( Datetime_Ticket.TKT_ID=Ticket.' . EEM_Ticket::instance()->primary_key_name() . ' ) ';
	}
	return $SQL;
}
add_filter( 'posts_join', 'de_ee_tweak_event_list_exclude_ticket_expired_events_join', 3, 2 );

As mentioned, if it’s a pain, then I can work around it another way.

Thanks,

Derek