Support

December 30, 2013 at 12:06 pm

Hey Peter, thanks for your patience. We’ve tested and reproduced the problem and found the fix for it. In gateways/process_payments.php on line 47 is the function espresso_get_total_cost. You can either make the changes to that function, or override it using the code here. If you override it, you can add this code to one of the following:
1 – Your theme’s functions.php file. It may get overwritten the next time you update your theme.
2 – The EE custom files add-on in the custom_functions.php file.
3 – Use this blank plugin to hold the custom function.
If you make the changes directly to gateways/process_payments.php, then change line 56 to:

$sql = "SELECT a.final_price, a.quantity, a.amount_pd FROM " . EVENTS_ATTENDEE_TABLE . " a ";

then after line 60:

$total_quantity = 0;

place this line:

$amount_pd = 0;

then after line 66:

$total_quantity += $ticket['quantity'];

place this line:

$amount_pd += $ticket['amount_pd'];

and after line 81:

$payment_data['quantity'] = $total_quantity;

place these lines:

$payment_data['amount_pd'] = number_format( $amount_pd, 2, '.', '' );
	$payment_data['amount_owed'] = number_format( $total_cost-$amount_pd, 2, '.', '');

Finally, whether you override that function or change it directly, go down and find (approximately line 199):

if ( $payment_data['payment_status'] != 'Completed' && $payment_data['payment_status'] != 'Refund' ) {

and change it to:

if ( $payment_data['amount_owed'] > 0.00 && $payment_data['payment_status'] != 'Refund' ) {

Note that line numbers are approximate, since I’m looking in EE 3.1.37-Alpha, so I’ve included the old code or the line above where you need to insert code to help you locate where to make the changes.
Also, if you are using paypal pro or any other gateway, you might want to go into includes/process-registration/payment_page.php, find line 411:

if ( $payment_data['payment_status'] != 'Completed' && $payment_data['payment_status'] != 'Refund' ) {

and make the same change to it:

if ( $payment_data['amount_owed'] > 0.00 && $payment_data['payment_status'] != 'Refund' ) {

December 30, 2013 at 4:10 pm

Thanks. What we found was that it was adding the free event to the cart first that set it off. Since that determined the order of the events on the page where you enter the attendee information, and the first attendee on that page is marked as the primary attendee. It’s the primary attendee’s payment status that was being checked when the IPN message came back from paypal.