Support

September 15, 2015 at 10:59 am

So, do I leave it active but choose not showing on the payment page, or deactivate? What’s the difference?

You can do either.

Hiding it from the payment page but leaving it active allows you to update the invoice settings without needing to re-activate/de-activate the Invoice gateway each time.

I also added our logo but I had an FPDF error – alpha channel not supported? The logo was in our media library.

That will be because your using a PNG with transparency, which is not supported within FPDF (the library EE uses to build the PDF’s). You can either use another PNG with no transparency, or switch to another format such as JPG for the logo.

September 16, 2015 at 2:15 am

You’re most welcome 🙂

September 21, 2015 at 6:37 am

The My Events section shows all events the user has registered onto to allow them to download invoices/receipts and view past events.

So it can be changed to order the events by start date for example, sorted ASC would show from the earliest to the latest.

Would that work?

If so around line 110 you’ll have this:

if ($wpdb->num_rows > 0) {
	$events = $wpdb->get_results(
		$wpdb->prepare(
			"SELECT e.id event_id, e.event_name, e.event_code, e.start_date, e.event_desc, e.display_desc, a.id attendee_id, a.event_time start_time, a.payment_status, a.payment_date, a.amount_pd, u.user_id user_id, a.registration_id, a.fname, a.lname, a.price_option, a.event_time
				FROM " . EVENTS_ATTENDEE_TABLE . " a
				JOIN " . EVENTS_MEMBER_REL_TABLE . " u ON u.attendee_id = a.id
				JOIN " . EVENTS_DETAIL_TABLE . " e ON e.id = u.event_id
				WHERE u.user_id = '%d' AND a.payment_status != 'Cancelled'",
			$current_user->ID
		)
	);

Change it to this:

if ($wpdb->num_rows > 0) {
	$events = $wpdb->get_results(
		$wpdb->prepare(
			"SELECT e.id event_id, e.event_name, e.event_code, e.start_date, e.event_desc, e.display_desc, a.id attendee_id, a.event_time start_time, a.payment_status, a.payment_date, a.amount_pd, u.user_id user_id, a.registration_id, a.fname, a.lname, a.price_option, a.event_time
				FROM " . EVENTS_ATTENDEE_TABLE . " a
				JOIN " . EVENTS_MEMBER_REL_TABLE . " u ON u.attendee_id = a.id
				JOIN " . EVENTS_DETAIL_TABLE . " e ON e.id = u.event_id
				WHERE u.user_id = '%d' AND a.payment_status != 'Cancelled'
				ORDER BY e.start_date DESC",
			$current_user->ID
		)
	);

It just changes the query by adding ‘ORDER BY e.start_date DESC’ to the end.

• This reply was modified 9 years ago by Tony. Reason: Change ASC to DESC

September 21, 2015 at 9:22 am

Ah, apologies.

I swapped them around when testing to double check, then posted what I had before changing. I’ll edit the post above in case anyone else uses it further down the line.