Support

March 21, 2024 at 12:47 pm

Hi there,

I need to check if the id (reference #) has been entered before by another user in a custom payment method i have developed.

Hang on a second here, if the user entered a reference during the payment options step, that’s not going to be used as the EE_Transaction ID (TXN_ID)…. the transaction would already have been created at that point and will alread have an ID from the autoincremnting TXN_ID column.

So before we start walk down the wrong path, where is this reference stored and what is it?

EEM_Transaction::instance()->get_all(array(‘TXN_ID’ => $reference));
EEM_Transaction::instance()->get_one(array(‘TXN_ID’ => $reference));

Neither of those are correct as your adding the TXN_ID as a query_param and not as a WHERE condition within the query_params (really simple fix).

You need to work through the docs here:

https://github.com/eventespresso/event-espresso-core/tree/master/docs/G–Model-System

Once you understand how the model system works, querying for EE data becomes much easier.

March 22, 2024 at 5:31 am

Ok, so that’s usually intended to be the payment merchants TXN/Payment ID they return when yo request a caputre/sale/etc and its saved on the EE_Payment object itself, it’s not the TXN_ID for the EE_Transaction.

$payment_txn_id = 12345;

$previous_payment = EEM_Payment::instance()->get_payment_by_txn_id_chq_nmbr($payment_txn_id);

if ($previous_payment instanceof EEI_Payment) {
    // Do something with the payment object here
}

EE_Payments are assigned to an EE_Transaction, so if you have the EE_Transaction object you can pull all related payments using:

$payments = $transaction->payments();

But that’s not really what is needed above, just some additional info.

March 25, 2024 at 5:32 am

You’re most welcome 🙂

Any further questions just let me know.