Support

June 24, 2024 at 6:32 am

Hi there,

So the issue related to the specific error here is relatively simple, REG_code is the incorrect value to use for the link, you need REG_url_link.

So SELECT REG_url_link ... (Side note, why not use the models to pull this in without having to handle the query yourself?)

However, there are also some other issues with what you have here.

Something I should note early on is ATT_ID is NOT the WordPress user_id, based on your code I can’t say for sure if that’s how you are trying to use it but user_id implies it so just make sure that is not. ATT_ID is the EE_Contact ID, it can be related to a WP User account but it is NOT the ID of that WP User.

So then when you have this WHERE ATT_ID = %d AND STS_ID = 'RIC'

You’re looking for a registration linked to a specific EE Contact ID (ATT_ID) with a STS_ID of RIC which is short for Registration InCcomplete. A RIC Registration is one that doesn’t have an ATT_ID assigned to it, it’s an incomplete registration because it doesn’t have the attendee data. So this query will never return anything, because you’ll never have a valid ATT_ID on a RIC registration.

I think what you are looking for is an abandoned transaction, which is an EE_Transaction with a status of TAB.

So presumably you want the ‘last’ abandoned transaction link to a user?

What data do you have for that user when generating the email?

June 24, 2024 at 9:07 am

As for what is available, I believe the entire user object should be available or something similar. I was using it in my shortcode like this with the WordPress User ID {contact.user_id}

Yeah, but what is contact in that context, where is that pulling the data from?

—

I’ll give you some details, but what/how you use them depends on your setup.

If you are using the WP User integration add-on and users are required to log in to start a registration within EE then you can using something like:

$att_id = get_user_option('EE_Attendee_ID', get_current_user_id());

To pull in the ATT_ID related to the current user (if indeed there is one).

Then just use the Registrations models to pull in the registration linked to a transaction with a status of TAB (I hightly recommend digging into the models, it makes much more complex queries relatively simple to do. If doing anything within EE you cangeneral use the models to get the data quickly and ‘easily’), like so:

$att_id = get_user_option('EE_Attendee_ID', get_current_user_id());

if(empty($att_id) ) {
    return;
} 

$where = [
    'ATT_ID' => $att_id,
    'Transaction.STS_ID' => 'TAB'
];

$reg = EEM_Registration::instance()->get_one([
	$where,
	'order' => 'DESC'
]);

$reg will be the ‘last’ registration created for that registration where the TXN Status is currently abandoned (ordered by the REG ID desc).

This gets more complex when you don’t require login and/or don’t use the WP user integration add-on to sync the ATT_ID to the WP user, you then need to use the data you have available to try and find the correct Attendee (EE_Contact). Which is possible, but can be error prone depending on your setup.

But… the models make these queries easier than you would expect. So lets say we only have the email address, we want the same as above but all we have is an email, meaning in English we want ‘The registration linked to an abandoned transaction if its linked to an EE_Contact with the email address of {X}’

$where = [
    'Attendee.ATT_email' => 'bob@example.com',
    'Transaction.STS_ID' => 'TAB'
];
$reg = EEM_Registration::instance()->get_one([
	$where,
	'order' => 'DESC'
]);

(Note we don’t use ATT_ID anymore, we don’t have that in this example)

Done.

Narrow it down more with more attendee data like first name, last name etc.

Oh, and grabbing the REG_url_link from the EE_Registration you’ll get from above (in both of my examples) is done with:

$reg_url_link = $reg->reg_url_link();