Support

October 1, 2014 at 12:26 pm

disclaimer: I don’t know about the security of this plugin. Thanks in advance if someone can comment on that.

get the plugin-
The nice thing here is you get a shortcode for your query, and you can put that on a password protected page on your site for staff access.

Here is a query that will show yesterday’s sales. It shows each transaction just once, and can be used to count how many tickets were sold. It also shows how it was paid, and the customer’s name and email. The query isn’t optimal, but should be a good starting point. It doesn’t export to CSV, but it cut and pastes well, and can also be pulled using Excel Web Data Source.

SELECT DISTINCT wp_esp_registration.EVT_ID, wp_esp_transaction.TXN_ID, wp_esp_registration.REG_date, wp_esp_payment.PAY_amount, wp_esp_payment.PAY_via_admin, wp_esp_registration.REG_group_size, wp_esp_payment.PAY_method, wp_posts.post_title, wp_esp_attendee_meta.ATT_fname, wp_esp_attendee_meta.ATT_lname, wp_esp_attendee_meta.ATT_email

From wp_esp_registration

RIGHT JOIN wp_esp_payment
ON wp_esp_registration.TXN_ID=wp_esp_payment.TXN_ID

RIGHT JOIN wp_posts
ON wp_esp_registration.EVT_ID=wp_posts.ID

RIGHT JOIN wp_esp_transaction
ON wp_esp_payment.TXN_ID=wp_esp_transaction.TXN_ID

RIGHT JOIN wp_esp_attendee_meta
ON wp_esp_registration.ATT_ID=wp_esp_attendee_meta.ATT_ID

WHERE REG_date BETWEEN SUBDATE(CURDATE(),1) AND CURDATE()

ORDER BY EVT_ID ASC