Thanks for sharing !

Hi, I tried a variation of this code. I do not need multiple amounts for a discount, just one discount of 5 dollars for each booking with a code. I have tried several different syntax groups, but entering the coupon code and clicking the submit button (takes a user to a paypal checkout), and the 5 dollar discount is not showing. Do you think you can help me out?

This is what I have now:

add_action('eme_insert_rsvp_action', 'my_eme_coupons',20,1);

/**
 * Custom function to calculate coupon code discounts for events
 */
function my_eme_coupons($booking) {
	global $wpdb;
	$bookings_table = $wpdb->prefix.BOOKINGS_TBNAME;
	$discount = 5;
	$where = array();
	$fields = array();

	// Grab the coupon code from the extra answers
	$event_id = $booking['event_id'];
	$booking_id = $booking['booking_id'];
	$answers = eme_get_answers($booking_id);
	$coupon = $answers[0]['answer'];

	// Collect the event categories
	$event_cat = eme_get_event_categories($event_id);

	// As long as the coupon code isn't empty, look for matches
	if ($coupon != '') {
			// If coupon code used, apply the appropriate price change
			if ($coupon == "WCMDCPrice") {
				$price = ($booking['booking_price']) - ($discount);
			}

			$fields['booking_price'] = $price;
			$where['booking_id'] = $booking['booking_id'];
			$wpdb->update($bookings_table, $fields, $where);
	}
	return;
}

I tried with the answer being 0, then again with answer being 1, since the form field for the coupon has an id of 1, like this, and it did not work:

function my_eme_coupons($booking) {
	global $wpdb;
	$bookings_table = $wpdb->prefix.BOOKINGS_TBNAME;
	$discount = 5;
	$where = array();
	$fields = array();

	// Grab the coupon code from the extra answers
	$event_id = $booking['event_id'];
	$booking_id = $booking['booking_id'];
	$answers = eme_get_answers($booking_id);
	$coupon = $answers[1]['answer'];

	// Collect the event categories
	$event_cat = eme_get_event_categories($event_id);

	// As long as the coupon code isn't empty, look for matches
	if ($coupon == "WCMDCPrice") {
			// If coupon code used, apply the appropriate price change
			$price = $booking['booking_price'] - $discount;
			
			$fields['booking_price'] = $price;
			$where['booking_id'] = $booking['booking_id'];
			$wpdb->update($bookings_table, $fields, $where);
	}
	return;

This is what the form HTML looks like:
<div id=’eme-rsvp-message’>
<form id=’eme-rsvp-form’ name=’booking-form’ method=’post’ action=’#eme-rsvp-message’>
<div class=’eme-rsvp-form’>
Name*:<br><input required=’required’ type=’text’ name=’bookerName’ value=’Webmaster’ /><div class=’eme-required-field’> (Required field)</div><br>
E-Mail*:<br><input required=’required’ type=’text’ name=’bookerEmail’ value=’tech@roguevalleyhosting.com’ /><div class=’eme-required-field’> (Required field)</div><br>
Phone number:<br><input type=’text’ name=’bookerPhone’ value=” /><br>
Seats*:<br><select id=’bookedSeats’ name=’bookedSeats’></select><br>
Member Coupon:<br><input type=’text’ name=’FIELD1′ value=” /><br>
Comment:<br><textarea name=’bookerComment’></textarea><br>
<input type=’submit’ value=’Continue’ />
</div><input type=”hidden” id=”eme_rsvp_nonce” name=”eme_rsvp_nonce” value=”34baac4e73″ /><span id=’honeypot_check’>Keep this field blank: <input type=’text’ name=’honeypot_check’ value=” /></span>
<p>(* marks a required field)</p>
<input type=’hidden’ name=’eme_eventAction’ value=’add_booking’ />
<input type=’hidden’ name=’event_id’ value=’10’ />
</form>

I also tried it this way: $coupon = $answers[FIELD1][‘answer’]; that did not work.

Any more help would be greatly appreciated. Thank you.

Thank you so much for your help, my coupon is up and running.

Did you register the action function using add_action? E.g.:
add_action('eme_insert_rsvp_action', 'my_eme_discount_function',20,1);

/**
 * Add a hook for the Events Made Easy system to allow for coupon codes
 */
add_action('eme_insert_rsvp_action', 'my_eme_coupons',20,1);

/**
 * Custom function to calculate coupon code discounts for events
 */

function my_eme_coupons($booking) {
	global $wpdb;
	$bookings_table = $wpdb->prefix.BOOKINGS_TBNAME;
	$discount = 15;
	$where = array();
	$fields = array();

	// Grab the coupon code from the extra answers
	$event_id = $booking['event_id'];
	$booking_id = $booking['booking_id'];
	$answers = eme_get_answers($booking_id);
	$coupon = "";
        foreach ($answers as $answer) {
            if ($answer['field_name'] == "Coupon") {
               $coupon = $answer['answer'];
            }
        }
	// As long as the coupon code isn't empty, look for matches
	if ($coupon == "DISCOUNT10" || $coupon == "discount10") {
		// If coupon code used, apply the appropriate price change
		$price = $booking['booking_price'] - $discount;
			
		$fields['booking_price'] = $price;
		$where['booking_id'] = $booking['booking_id'];
		$wpdb->update($bookings_table, $fields, $where);
	}
	return;
}

That is all I added!

Hello Franky,

Many thanks! It’s solved! The issue was typo in the Formular field itself so it could not match… Thanks again!

BTW: Is it possible to calculate the price with a discount of 10%?

Cheers
JK

$price = $booking['booking_price'] - ( $booking['booking_price'] * ($discount / 100)); does the job 😀

I bet it could also be done vv with

$coupon = strtoupper($coupon);
if ($coupon == “DISCOUNT10″)…

right? I did not tried it yet as my page is already live and currently I can’t test it!?

Great to know I’ll implement it now!
Thanks Frank!