Hello,

We would like to write a shortcode that displays an employees booking calendar on their BuddyPress profile page (the profile of an Amelia Employee).

1. We know that to display the correct calendar we need this shortcode: [ameliabooking employee=1] where 1 is the employee ID.

2. We know how to get the WordPress User ID of the profile page you are on: bp_displayed_user_id()

Are you able to provide any advice on how to get the Employer ID from a WordPress User ID please?

Many thanks!

But Employee's can have an associated WordPress account so somewhere that must be stored next to an Employee ID otherwise how would it know which WordPress user is associated to it?

We want the correct calendar to display on the users profile without our admin or the user having to manually add the correct shortcode or even see the shortcode for that matter. It's a user experience need to make the the displaying of an employees calendar automatic and just one bit of code that dynamically displays the correct one their profile.

We're trying to get Amelia to work and appear seamlessly with BuddyPress (well actually BuddyBoss) as currently we feel Amelia is the most comprehensive and user friendly booking system out there but it's too separated from WordPress user accounts. There is also no booking plugin for BuddyPress/Boss which is a huge gap in the market in my opinion.

I want to be careful here to not make it look like I'm asking for some custom code and digging beyond the realms of your support. I can see in the table amelia_users we have a 'provider' and there is a column externalID which is the WordPress user ID it's linked to. 

Is there an advised way to get this data?

Hi Team,

I found that I also needed a way to match employees to users, as the only way I could see to add meta information to providers, with tools that are currently available, is to add the custom meta to the `WP_User`, and then find the user by the provider ID.

For my integration, I ended up using a database query to obtain the necessary information:

$user_id = (int) $wpdb->get_var( $wpdb->prepare( "SELECT externalId FROM {$wpdb->prefix}amelia_users WHERE id = %s", $provider_id ) );

Of course, for Dan's original query, you could just as easily reverse the column names in the SQL statement, in order to find the employee from the user:

$provider_id = (int) $wpdb->get_var( $wpdb->prepare( "SELECT id FROM {$wpdb->prefix}amelia_users WHERE externalId = %s", $user_id ) );

I feel that some form of constructor, factory, or internal API, such as how we can use `get_user_by()` to get the `WP_User` object, would be beneficial. My suggestion would be for a new class to be created with a number of static functions for finding providers, or maybe an Employee class which can be used to read user meta. This way, if the table names or columns change in future, it won't immediately break legacy installations.

namespace AmeliaBooking;
class ProviderAPI {
    const USERS_TABLE = 'amelia_users';
    public static function get_id_from_user( $user_id ) {
        global $wpdb;
        $users_table = static::USERS_TABLE;
        return (int) $wpdb->get_var( $wpdb->prepare( "SELECT id FROM {$wpdb->prefix}{$users_table} WHERE externalId = %s", $user_id ) );
    }
}
$provider_id = \AmeliaBooking\ProviderAPI::get_id_from_user( $user_id );

Please us me know your thoughts, if you have any further suggestions or if you are able to provide documentation for features like this if they already exist.

Thank you all so much, I'll pass this onto our developer!

Bonjour,

I need to implent this great solution on my WP website... (Exactly the same issue) (I am a noob on WP!)
In what file I have to add "class ProviderAPI" ? Using Snippet ? in functions.php ? ...
How do I call this function on my user page ? with a shortcode ?
Thanks a lot for your reply 
Emmanuel

Hi Emmanuel,

The ProviderAPI class is only really necessary if you want to organise your functions into classes, otherwise you can easily just use the second snippet I gave in your author.php template for the same result. You just need to make sure that you call "global $wpdb;" before it.

If you still want to use the ProviderAPI class, then it should go into a new file in your theme, for example you could use the filename; /wp-content/themes/YOUR_THEME/includes/ameliabooking/providerapi.php

You would then move the last line from that snippet into your author.php template where you need to access $provider_id, and then on the line above it, you can include the providerapi.php file.

require_once( get_theme_file_path( 'includes/ameliabooking/providerapi.php' ) );
$provider_id = \AmeliaBooking\ProviderAPI::get_id_from_user( $user_id );
// Do stuff with $provider_id.

Thanks a lot Shaun !!!
it works good !!!

Bonjour, 

After updating with 4.5.1, the shortcode doesn't work anymore... Does it a relative issue?

Thanks,

Emmanuel

/**
 * Amelia booking for the current displayed Wordpress User
    */
add_shortcode("WPUserBooking","Booking4wpID");
function Booking4wpID(){

// Test si User loggé
$user = wp_get_current_user();
$aa = $user->exists();

// récupère ID UM
$user_id = um_profile_id();

// This is correct ????:  
$provider_id = \AmeliaBooking\ProviderAPI::get_id_from_user( $user_id );




if ($aa == 1) {
$value = "[ameliabooking employee=$provider_id]";
} else {$value = "<H3> Connectez-vous pour prendre RdV</H3>";

} 
return $value;
}

Amelia updates are why we need an API as part of the plug-in, to account for breaking changes such as this. I won't be able to confirm what the issue is, so best to wait for someone from Amelia to answer.

Bonjour, 

I used [WPUserBooking] before the update but after update ... it was not working any more:

add_shortcode("WPUserBooking","Booking4wpID");
function Booking4wpID(){
// Test si User loggé 
$user = wp_get_current_user();

    $aa = $user->exists();
// récupère ID 
UM
$user_id = um_profile_id();
    $provider_id = \AmeliaBooking\ProviderAPI::get_id_from_user( $user_id );
if ($aa == 1) {
$value = "[ameliabooking employee=$provider_id]";
} else {
$value = "<H3> Connectez-vous pour prendre RdV</H3>";
} 
return $value;
}

So I used SQL to find my info :

add_shortcode("WPUserID","Booking4wpIDsql");

function Booking4wpIDsql(){
//On établit la connexion
        $servername = "localhost";
        $username = "xxxxxxx";
        $password = "xxxxxxx";
        $db = "MMP1";
 $mysqli = new mysqli($servername, $username, $password, $db);

// ID du User de la page
$user_id = um_profile_id(); 
$requete = "SELECT * FROM wp_amelia_users WHERE externalId=".$user_id;
$resultat = $mysqli->query($requete);
 while ($ligne = $resultat->fetch_assoc()) { $value="[ameliabooking employee=".$ligne['id']."]"; }
$mysqli->close();
return $value;
}

1 - Could you tell me what is the best practice/what du you recon and what is the more reliable.

2 - I could you tell me what is wrong in API call in [WPUserBooking]

With best regards,

Emmanuel

Bonjour Aleksandar,

I worked around with a sql request instead of an API call...
Do you think it is a good practice?

Thanks again.

Emmanuel