Support

March 6, 2015 at 10:06 am

Hi there,

Event Espresso 4 works a little differently since it supports multiple ticket / pricing options. That information should be available when you click on the show tickets link (grey link) in the ticket selector:

http://cl.ly/image/1z082b422Q0R

—
Lorenzo

March 9, 2015 at 2:26 pm

Hi, would something like this work for you?

http://cl.ly/image/0W273W2Z0K3q

If so, then see this tutorial:

https://gist.github.com/joshfeck/0e2e59c39a36b76cc65a3b92f9543c79

—
Lorenzo

March 10, 2015 at 4:22 am

Hi,

Capacity in EE4 is set in two places: the datetimes and the tickets.

So if you have two tickets, you can apply them to one datetime, and set the ticket limits both to 15 and the datetime limit to 15.

This means that when someone buys a ticket it reduces both the ticket capacity and the datetime and when the datetime fills up that’s it, no more tickets can be sold for that datetime. So you could sell 15 of ticket A or 7 of A and 8 of B and both those situations would then stop ticket sales.

It’s a little bit more complex than in EE3, but I think you can see that it is much more flexible.

Regarding the capacity, this is already shown in the ticket details area: http://take.ms/eKcIm

March 10, 2015 at 11:14 am

Okay, where on that page are you wanting to add that information? It would need to be near the ticket selector.

Thanks

—
Lorenzo

March 11, 2015 at 4:07 am

Hi,

I got to thinking and searching regarding this. We don’t currently have a way to display Available Spaces outside of the Ticket Selector.

Another customer, Paul Burwell, came up with some code that could do this.

I took this and modified it a bit as it wasn’t functioning in it’s current state and created a shortcode from it that will list each datetime and output the remaining spaces.

It’s only a basic example and could be built upon for more exact needs.

CODE
(I’ve requested this to be added to our snippet library (https://github.com/eventespresso/ee-code-snippet-library) but it’s awaiting acceptance at the moment of writing.

<?php
// Do not include the above opening PHP bracket unless this is at the start of the file
// The following function can be added to a themes functions.php file or a
// site specific plugin (https://eventespresso.com/wiki/create-site-specific-plugin-wordpress-site/)
// to call the shortcode use [show_capacity] in any EVENT (it won't work outside of an event post)

/**
*   Original code, props to Paul Burwell
*   https://eventespresso.com/topic/help-showing-capacity/page/5/
*   Updated and modified by Dean Robinson 10th March 2015
**/

function my_print_tickets_left_after_selector($atts) {
    global $wpdb;

    $EVT_ID = get_the_ID();

    //display a title
    $x = '<h4>Remaining spaces</h4>';
    $x .= '<ul style="margin-left:0;">';

        $sql = "SELECT * ";
        $sql .= "FROM {$wpdb->prefix}esp_datetime ";
        $sql .= "WHERE {$wpdb->prefix}esp_datetime.EVT_ID = %d";
         
        $datetimes = $wpdb->get_results( $wpdb->prepare( $sql, $EVT_ID ));
         
        $dt_frmt = get_option('date_format');

        //echo "<pre>" . print_r($datetimes,1) . "</pre>";

        foreach($datetimes as $datetime){
            //display as a list
            $x .= "<li>";
            //if datetime name shown, display
            $name = !empty($datetime->DTT_name) ? ($datetime->DTT_name) . ': ' : date($dt_frmt, strtotime($datetime->DTT_EVT_start) ) . ': ';
            $x .= $name;

            $limit = $datetime->DTT_reg_limit;
            $sold = $datetime->DTT_sold;
            $remainderp = $limit - $sold;
            $remain = $limit == -1 ? '' : $remainderp;
            if ( $limit == $sold ) :
                $x .= '<strong>Sold Out</strong>';
            else :
                $x .= $remain;
            endif;
            $x .= "</li>";
        }
    $x .= '</ul>';
 
    return $x;
 
}
add_shortcode('show_capacity','my_print_tickets_left_after_selector');

March 11, 2015 at 9:05 am

To do that you don’t need most of the code within the snippet Dean provided.

You can use something like this:

function my_print_tickets_left_after_selector($atts) {
    global $wpdb;

    $EVT_ID = get_the_ID();

    	$x = 'Remaining Spaces for this Camp: ';

        $sql = "SELECT * ";
        $sql .= "FROM {$wpdb->prefix}esp_datetime ";
        $sql .= "WHERE {$wpdb->prefix}esp_datetime.EVT_ID = %d";
         
        $datetimes = $wpdb->get_results( $wpdb->prepare( $sql, $EVT_ID ));
        
        $remaintotal = 0;

        foreach($datetimes as $datetime){
            $limit = $datetime->DTT_reg_limit;
            $sold = $datetime->DTT_sold;
            $remaintotal += $limit - $sold;
            $remain = $limit == -1 ? '' : $remaintotal;
        }

        $x .= $remain;
 
    return $x;
 
}
add_shortcode('show_capacity','my_print_tickets_left_after_selector');

Which will display ‘Remaining Spaces for this Camp: 99’ (99 being an example)

If you do happen to have multiple datetimes within an event, it will add the remaining spaces from each datetime to a total and display that total. This may not work as expected if tickets apply to multiple datetimes but if you are only using 1 it won’t matter, I added it in just to catch multiple datetimes.

March 11, 2015 at 9:42 am

Yes it’s the print_r() function wrapped in PRE tags that cause that. Commenting it out or removing it completely is fine.

I actually removed it from my reply right after adding it to the thread but you must have loaded the page before then 🙂