Events list – We are open today – Hollidays

[Whittard]

Events Calendar Pro version:
Is it possible to set opening hours / recurring events to be overruled by hollidays?
Example:
Recurring event, every week, Friday, shop open from 9:00 till 18:00
This will result in [We are open on Friday december 25th]
Need:
Recurring event, every week, Friday, shop open from 9:00 till 18:00, except on hollidays

Also is it possible to show in a widget if the shop is open or closed:
Mondays 13:00 till 18:00
Thuesday ~Friday 9:00 till 18:00
Saturday 9:00 till 17:00

During this time a (single line) widget showing [We are open for business] else [Sorry we are closed]

[Nico]

Hi there Whittard,

Thanks for reaching out and for you interest in Events Calendar PRO!

Recurring event, every week, Friday, shop open from 9:00 till 18:00, except on hollidays

Regarding this questions, yes it’s possible to add exclusion rules per event. You can exclude particular dates like ‘December 25th’ or more complex patterns.

Also is it possible to show in a widget if the shop is open or closed (…). During this time a (single line) widget showing [We are open for business] else [Sorry we are closed]

Well, I guess this custom behaviour requires a bit of coding on your side. We actually don’t have a widget that does exactly what you describe. If you are willing to code a bit we can point you in the right direction.

Please let me know if there’s anything else I can help you with,
Best,
Nico

[Whittard]

>Yes it’s possible to add exclusion rules per event.
As I understand this, I will have to exclude the specific dates for each recurring event.

It would be nice if I can exclude a range (category) of already entered events:
Create a category [holiday] with days like Christmas and Easter (full day events), Ascension Day and Christmas Eve (part day events).
Then create a recurring event and exclude all entries in category [holidays]

>If you are willing to code a bit we can point you in the right direction.
Nice, I already had a glance at the database:
Select post_id FROM wp_postmeta
Where (meta_key = ‘_EventStartDate’ or meta_key = ‘_EventEndDate’)
and meta_value BETWEEN ‘2015-12-24 00:00:00’ AND ‘2015-12-26 23:59:59’ Order by post_id;

Results in Christmas Eve 16:00 ~ 23:59:59, Christmas Day 00:00 ~ 23:59:59 and Boxing day 00:00 ~ 23:59:59

But I guess (hope) you have a function for this?

Regards, Whittard

[Nico]

Hey Withard,

Thanks for following up on this!

As I understand this, I will have to exclude the specific dates for each recurring event.

Yes! Your idea to exclude from a category sounds like something nice to have, your are welcome to suggest that feature in The Events Calendar user voice page . There’s the place where we collect feature requests and ideas from our community.

Regarding the SQL code it looks good, but we don’t actually do support on the pre-sales forum. You might want to give that a try and then open a new thread (in the premium forums if you hold a license or in the .org forums if you don’t) if you have specific doubts about it.

But I guess (hope) you have a function for this?

Not sure what you are expecting of the function. Please let me know about this.

Best,
Nico

[Nico]

Hey Withard,

I’m closing this thread due to the lack of reply. Feel free to open a new one if this is still an issue for you.

Best,
Nico

[Author]

Posts