使用Events Calendar Pro动态填充GF下拉列表

Question

I have a dynamically populated GF form that pulls a CPT from Events Calendar Pro. I am trying to sort the events by ascending title and I would also like to hide all past events. I have done a lot of trial and error as I am not a PHP developer. I have been trying to add the sorting & hiding for a while and I am just spinning my wheels at this point. TIA. Any help is appreciated.

Here is the code that pulls the CPT and displays it in the dropdown correctly.

add_filter( 'gform_pre_render_1', 'populate_posts' );
add_filter( 'gform_pre_validation_1', 'populate_posts' );
add_filter( 'gform_pre_submission_filter_1', 'populate_posts' );
add_filter( 'gform_admin_pre_render_1', 'populate_posts' );
function populate_posts( $form ) {

foreach ( $form['fields'] as &$field ) {

    if ( $field->type != 'select' || strpos( $field->cssClass, 'populate-posts' ) === false ) {
        continue;
    }

    // you can add additional parameters here to alter the posts that are retrieved
    // more info: http://codex.wordpress.org/Template_Tags/get_posts

    $posts = get_posts ('post_type=tribe_events&numberposts=-1' );

    $choices = array();

    foreach ( $posts as $post ) {
        $choices[] = array( 'text' => $post->post_title, 'value' => $post->post_title,);
    }

    // update 'Select a Post' to whatever you'd like the instructive option to be
    $field->placeholder = 'Select an Event';
    $field->choices = $choices;

}

return $form;

}

Answer 1

You can use tribe_get_events() function instead of get_posts() https://theeventscalendar.com/knowledgebase/using-tribe_get_events/

<?php
add_filter( 'gform_pre_render_1', 'populate_posts' );
add_filter( 'gform_pre_validation_1', 'populate_posts' );
add_filter( 'gform_pre_submission_filter_1', 'populate_posts' );
add_filter( 'gform_admin_pre_render_1', 'populate_posts' );
function populate_posts( $form ) {
    foreach ( $form['fields'] as &$field ) {
        if ( $field->type != 'select' || strpos( $field->cssClass, 'populate-posts' ) === false ) {
            continue;
        }

        // you can add additional parameters here to alter the posts that are retrieved
        // more info: http://codex.wordpress.org/Template_Tags/get_posts

        // Retrieve all upcoming events
        $events = tribe_get_events( array(
            'posts_per_page' => -1,
            'start_date'     => date( 'Y-m-d H:i:s' ),
        ) );

        $choices = array();

        foreach ( $events as $event ) {
            $choices[] = array(
                'text'  => $event->post_title,
                'value' => $event->post_title
            );
        }

        // update 'Select a Post' to whatever you'd like the instructive option to be
        $field->placeholder = 'Select an Event';
        $field->choices = $choices;
    }

    return $form;
}