Support

December 13, 2017 at 4:02 pm

Thanks Josh. This is a production site. We already have implemented some waitlist mods. When an event is sold out, a waitlist form is displayed on the event page. We have the table template add-on modified to show the text “waitlist” with a link to the event page. The last change we need is to have a waitlist button display in the regular event listings. Can you point me in the right direction to get started?

Thanks,
Troy

December 14, 2017 at 3:18 pm

Hey Josh – Sorry I wasn’t clear. We aren’t using the waitlist add-on because it’s a live production site and you advised against that. We do already have a waitlist functionality set up on the event detail page, where a ninja form is displayed if the event is sold out. All we want to do now is replace the sold out text in the event listing with a waitlist button that links to the event detail page.

December 15, 2017 at 10:23 am

We actually have the listings on the venue page:
http://tinytechsclub.com/venues/booksin-elementary/
using this in a custom plugin:

//Event Espresso Venue Event Listing

function ee_list_upcoming_events_for_a_venue( $post ) {
    // query the events for this venue using EE_Venue's events() method
    // http://code.eventespresso.com/classes/EE_Venue.html#method_events
    if ( ! is_singular() ) {
        return; // get out if this is a list of venues
    }
    $query_params = array( 
        array( 
          //  'status' => 'publish', 
            'Datetime.DTT_EVT_start' => array( 
                '>', 
                date( current_time( 'mysql' ) ), 
                'Datetime.DTT_EVT_end' => array(
                    '<', 
                    date( current_time( 'mysql' ) )
                ) 
            )
        )
    );
    $events = EEH_Venue_View::get_venue( $post->ID )->events( $query_params );
    // start the output
    if ( $events ) {
        echo '<h3>Upcoming events at this location</h3>';
        // the loop
        foreach ( $events as $event ) {
            $post_id = $event->get( 'EVT_ID' );
            $post_object = get_post( $post_id );
            ?>
            <header class="event-header">
            <h4 class="entry-title">
                <a class="" href="<?php echo get_the_permalink( $post_id ); ?>">
                    <?php echo get_the_title( $post_id ); ?>
                </a>
            </h4>
            </header>
            <!-- .event-header -->
            <div class="event-content">
                <?php echo $post_object->post_content;?>
            </div>
            <!-- .event-content -->
            <div class="event-datetimes">
                <?php espresso_list_of_event_dates( $post_id );?>
            </div>
            <!-- .event-datetimes -->
            <div class="event-tickets ee-clearfix">
                <?php espresso_ticket_selector( $event ); ?>
            </div>

            <!-- .event-tickets -->
        <?php
        } // the loop
    } else {
        echo '<h3>No upcoming events at this location</h3>';
    }
    // end the output
}

// next, add the above to an action found in the venue template
// you could instead use 'AHEE__content_espresso_venues_details_template__before_the_content' to put the list before the content
add_action( 'AHEE__content_espresso_venues_details_template__before_the_content', 'ee_list_upcoming_events_for_a_venue' );

// display a contact form when the event is sold out
// for waitlists
function espresso_clean_event_status( $EVT_ID ) {
    $event = EEH_Event_View::get_event( $EVT_ID );
    $status = $event instanceof EE_Event ? $event->get_active_status() : 'inactive';
    return $status;
}
add_action( 'AHEE_event_details_after_the_content', 'ee_special_sold_out_message' );
function ee_special_sold_out_message( $post ) {
    if ( espresso_clean_event_status( $post->ID ) == 'DTS' ){
        if( function_exists( 'ninja_forms_display_form' ) ){ ninja_forms_display_form( 1 ); }
		//echo "look at me";
    }
}

/* Stop Adding Functions */

December 18, 2017 at 3:44 pm

Thanks Josh – I already have the waitlist form displayed on the event detail page, so really just wanted to link to that. I originally though I’d replace the “sold out” text with a “waitlist” link but I ended up just adding a link to the end of the event data, displayed conditionally based on the ‘status’ variable.