JetEngine Form - User Dropdown

user_2022193 0
Viewed 31

I am working with JetEngine forms and i need to add a dropdown of users to select from in one of the form.

is there any way to do this? i dont see any field type of users and also for the select option. if i choose filled dynamicly i have some pre build functions to get the data but none for the users?

How can I set this dropdown or build a function to be show as one of the dynamiclly generated options?

I have not found much on serching this issue and not in their documentation

jet-engine wordpress
1 Answers

As i did not find much info on the web, and there is no real good documentation for the JetEngine Plugins i started digging in the plugins' code. I found that the best solution for me was to create my own form generator - that would give me a custom function to select from when creating a new select field in the form builder.

This is the code i used for creating the custom generator:

add_filter( 'jet-form-builder/forms/options-generators', 'my_jet_form_custom_option_generator' ,10, 1);
add_filter( 'jet-engine/forms/options-generators', 'my_jet_form_custom_option_generator' ,10, 1);

function my_jet_form_custom_option_generator($instances) {
    require(plugin_dir_path(__FILE__). '/jetBuilder/generators/get-users.php');
    $instances[] = new Jet_Form_Builder\Generators\Get_Users();
    return $instances;
}

And this is the basic structure of the actual get-users generator:

namespace Jet_Form_Builder\Generators;

require_once(WP_PLUGIN_DIR.'/jetformbuilder/includes/generators/base.php'); 


class Get_Users extends Base {

    /**
     * Returns generator ID
     *
     * @return string
     */
    public function get_id() {
        return 'my_generator;
    }

    /**
     * Returns generator name
     *
     * @return string
     */
    public function get_name() {
        return __( 'My Cool Custom Generator', '' );
    }

    /**
     * Returns generated options list
     *
     * @param $args
     *
     * @return array
     */
    public function generate( $args ) {

        global $wpdb;
                
        // this is a dummy SQL....
        $sql = "SELECT {$wpdb->users}.user_email, {$wpdb->users}.display_name, {$wpdb->users}.ID, {$wpdb->usermeta}.meta_value
            FROM {$wpdb->users} INNER JOIN {$wpdb->usermeta} ON ({$wpdb->users}.ID = {$wpdb->usermeta}.user_id)
            WHERE 1=1 "; // CHANGE QUERY FOR YOUR NEEDS....

        $result = array();
        
        $table  = $wpdb->users;
        $rows   = $wpdb->get_results(
                            
            $wpdb->prepare( $sql , $field),
            ARRAY_A
        );

        if ( empty( $rows ) ) {
            return $result;
        }
        
        $result[] = array(
                'value' => 0,
                'label' => '-----------',
            );

        foreach ( $rows as $row ) {
            $result[] = array(
                'value' => $row['ID'],
                'label' => $row['display_name'],
            );
        }

        return $result;

    }

}

Hope this helps...

user_20221930
Related