Support

January 30, 2014 at 6:08 pm

And here’s the part that gave the error:

<pre class=”brush: php; gutter: true; first-line: 1; highlight: []; html-script: false”><?php
/**
* Plugin Name: Custom Functions Plugin
* Plugin URI: http://staging.eventespresso.com
* Description: A blank plugin where you can put custom functions
* Version: 1.0
* Author: Sidney Harrell
* Author URI: http://sidneyharrell.com
* License: GPL2
*/

<?php
function espresso_get_total_cost_custom($payment_data) {
remove_filter(‘filter_hook_espresso_get_total_cost’, ‘espresso_get_total_cost’);
global $wpdb;
//if for some reason attendee_session isn’t setin the payment data, set it now
if(!array_key_exists(‘attendee_session’,$payment_data) || empty($payment_data[‘attendee_session’])){
$SQL = “SELECT attendee_session FROM ” . EVENTS_ATTENDEE_TABLE . ” WHERE id=%d”;
$session_id = $wpdb->get_var( $wpdb->prepare( $SQL, $payment_data[‘attendee_id’] ));
$payment_data[‘attendee_session’]=$session_id;
}
//find all the attendee rows
$sql = “SELECT a.final_price, a.quantity, a.amount_pd FROM ” . EVENTS_ATTENDEE_TABLE . ” a “;
$sql .= ” WHERE a.attendee_session='” . $payment_data[‘attendee_session’] . “‘ ORDER BY a.id ASC”;
$tickets = $wpdb->get_results($sql, ARRAY_A);
$total_cost = 0;
$total_quantity = 0;
$amount_pd = 0;

//sum up their final_prices, as this should already take into account discounts
foreach ($tickets as $ticket) {
$total_cost += $ticket[‘quantity’] * $ticket[‘final_price’];
$total_quantity += $ticket[‘quantity’];
$amount_pd += $ticket[‘amount_pd’];
}

// if (!empty($tickets[0][‘coupon_code_price’])) {
// if ($tickets[0][‘use_percentage’] == ‘Y’) {
// $payment_data[‘total_cost’] = $total_cost * (1 – ($tickets[0][‘coupon_code_price’] / 100));
// } else {
// $payment_data[‘total_cost’] = $total_cost – $tickets[0][‘coupon_code_price’];
// }
// } else {
// $payment_data[‘total_cost’] = $total_cost;
// }

$payment_data[‘total_cost’] = number_format( $total_cost, 2, ‘.’, ” );
$payment_data[‘quantity’] = $total_quantity;
$payment_data[‘amount_pd’] = number_format( $amount_pd, 2, ‘.’, ” );
$payment_data[‘amount_owed’] = number_format( $total_cost-$amount_pd, 2, ‘.’, ”);
//printr( $payment_data, ‘$payment_data’ );
return $payment_data;
}
add_filter(‘filter_hook_espresso_get_total_cost’, ‘espresso_get_total_cost_custom’,5);