|
James Simon
|
March 5, 2014 at 7:12 am
Dean, In a previous post I saw you mentioned some code that you had done that could possibly allow users to be checked in via a laptop.
The code was listed here: https://github.com/Apina/ee-checkin
But has been removed.
I am very interested in trying to implement something like this.
Would it be possible for you to share that code so I can take a peak?
Thanks so much!
|
|
Dean
|
March 6, 2014 at 2:21 am
Hi,
I am very sorry, but it seems that in a moment of madness I tidied up my github account and removed that repository AND had failed to check that I had a local copy.
I did an extensive search but it seems those files are now gone 🙁
If I remember rightly, I had created a shortcode that listed out the attendees (probably based on the LISTATTENDEES shortcode) and added in a button that ran an AJAX command to update the database accordingly.
Though I’m guessing you wanted a front end system, both EE3 and EE4 do allow you to check users in from the admin panel.
|
|
James Simon
|
March 6, 2014 at 8:15 am
Maybe you could help me with the actual SQL needed to check someone in. That should be enough to get me started.
I found some useful code in edit_list_attendees.php that starts here
// MARKING USERS AS ATTENDED (OR NOT)
I believe its around line 50
Just can’t figure out what SQL is used to actually check a user in.
I can’t use the admin feature to check someone in as our instructors don’t want to have that responsibility. All our classes are virtual so I can’t use the other app you guys developed either. So if I can determine the SQL to check someone in I can develop some custom code to get this done.
Love Event Espresso you guys have done a fantastic job. Keep up the great work and I can’t wait for addons to be integrated into the new 4 version.
Thanks for all your help. The support provided has been fabulous in helping me tweak Event Espresso to do everything we need.
|
|
Dean
|
March 6, 2014 at 8:21 am
Hi,
I just got in touch with the awesome staff at Github and the repository has been restored.
https://github.com/Apina/ee-checkin
Please make sure you read the readme! It is intended to be used as a base, so you may still need a developer to tweak it.
|
|
James Simon
|
March 7, 2014 at 11:43 am
Wonderful! I got it up and running on my test server.
A couple of questions.
It returns a list with checkin and checkout buttons but they don’t do anything.
You click and nothing happens.
I was hoping at the very least I would be able to pull the query that actually checks the person in to the event.
Could you point me in the right direction?
Thanks
|
|
James Simon
|
March 7, 2014 at 12:46 pm
OK so would this SQL work or would I need to modify other tables?
UPDATE wp_events_attendee set checked_in = 1, checked_in_quantity = 1 where registration_id = ‘1-531a0726562ec’
|
|
Sidney Harrell
|
March 7, 2014 at 5:42 pm
It makes an entry in the events_attendee_checkin table as well. Look in includes/admin-reports/event_list_attendees.php at line 83:
//Add the date checked-out into the events_attendee_checkin table
right below that you’ll see some code for inserting the entry.
|
|
James Simon
|
March 7, 2014 at 8:41 pm
This is perfect! Thanks so much.
INSERT INTO wp_events_attendee_checkin (attendee_id,registration_id,event_id,checked_in,date_scanned,method,type) VALUES (2,’1-531a0726562ec’,1,1,’2014-03-07 22:40:25′,’website’,’checkin’)
|
