Term of Events

Hi Tuan,

we run 12-week terms of clubs. Each club is €11, but registrants needs to pay for the term up front, e.g. €132 for all clubs. It is ok for people to join at any time, i.e. if somebody misses the 1st club, they can register for the remaining 11 clubs by paying €121.

At the moment, each day, I need to update the events which have just occurred. This is very time consuming, and I'd love if you could add a feature for term of events.

A term of events would be set up as follows...
Start Date: 21/09/2017
Start Time: 18:00
End Time: 19:00
Capacity: 30 (This is the shared capacity for all events. Term is considered full once number of sales (e.g. 29 for 12 clubs + 1 for 10 clubs=30) reaches capacity)
Price per Event: €11
Number of Events in term: 12
Dates of Events: 28/09/2017, 05/10/2017, etc. (defined indivudally as there are midterm breaks, so the 12 weeks aren't concurrent)
Calculated Total Price: €132

At the end of each club, e.g. at 19:00 on 21/09/2017, the Next Club Date would update to, e.g. 28/09/2017 and the price would reduce by €11.

If somebody registered before the first club, they would pay €132, and if they registered after the first club, they would pay €121, then €110, etc. When the number of events remaining reaches 0, then the term of events is no longer listed.

It would be brilliant for me if you could implement a term of events as described above. I can't believe that I am the only person who uses EB for terms of events. I'd be willing to pay for the addition, depending on the cost. Are there any other users out there who would be prepared to help?

Regards,
Donal

Hi Donal

Just quick thought about it and could not see an easy solution. So if we were customizing the code, the price would be quite high (unsure about it yet). So for now, I think you will have to update it manually as how you are doing at the moment

If there are more customers need it, we will discuss about this further

Tuan

Tuan Pham Ngoc wrote: Hi Donal
Just quick thought about it and could not see an easy solution. So if we were customizing the code, the price would be quite high (unsure about it yet). So for now, I think you will have to update it manually as how you are doing at the moment

I have written some code to simulate the term of events, as I described above. Daily, I am running a cron job which calls some php, which basically runs the following SQL.
"UPDATE `dbprefix_eb_events` SET `event_date`=date_add(`event_date`, interval 7 day),`event_end_date`=date_add(`event_end_date`, interval 7 day),`individual_price`=`individual_price`-11 WHERE Date(`event_date`)=CURRENT_DATE";

My PHP has added intelligence to deal with mid-term and finishing date. It pretty much achieves what I need, with minimal work.

Look like it is simpler than I thought. I'm glad that you have it working now. Thanks for sharing, too, it might be helpful to other customers if they need it

Regards,

Tuan