Problem that an event doenst show after in started

I have a problem that an event doenst show up when the start date is in the past and the end date is in the future.
For example :
15-12-2011 (start date)
18-06-2012 (end date)

The reason why its not working i guess is that this component is not build for repeating events that happen for example every sunday.

Is there an possibility to change the start-date to end-date so it wil show even after the event started.
And disappears after the end-date so that the systems checks the end date instead of the start date.

Dear.
Fontijn

Hi Fontijn

I believe the reason is because you set "Hide Past Events" config option to Yes and when the current date passed the event start date, the event will be hided. The extension use event start date to check, not event end date. So in this case, I think the solution is that you go to Event Booking -> Configuration, set Hide Past Events config option to No and It should solve the problem

Regards,

Tuan

Tuan, this is not a solution to Fonijn's question. I also have the same issue.

I don't want past events to be shown, so "Hide Past Events" option is set to yes. A past event is an event that has past or finished, not an event that started yesterday and will finish next week and is still currently active. The end date needs tobe used to determin this, not the start date.

So Tuan, how to we change this so it looks at the end date and not the start date? We want events that are FINISHED not not show, not all events that started yesterday to disapear.

Thanks

Hi

Right now, the extension used event start date to determine whether to show/hide an event. The reason is because not all users enter event end date when creating event (event end date is not a required file). If you want to check it based on event end date, you will have to edit the code yourself. Please send me the link to the page you are talking about so that I can guide you how to edit code to meet your own need .

Tuan

Thanks Tuan. I'm not sure why you need my page, I just need to know the file and line numbers etc. I'm using version 1.4.4 on joomla 2.5
A test / developement copy of our website can temporarily be found at kingbiz.com.au. We have made allot of modifications to the code already.
Thanks

Hi ymedia

Unfortunately, the event_date is used on many places in the extension for checking to show events, for checking to see whether users can register for the current events..., so I cannot tell you which files of code, which line number you need to modify...You will need to find out it yourself or ask your developer to help you. A quick search on the coding result in the following files (just search for hide_past_event string)

- components/com_eventbooking/models/archive.php
- components/com_eventbooking/models/calendar.php
- components/com_eventbooking/models/category.php
- components/com_eventbooking/models/location.php
- components/com_eventbooking/models/search.php

Hope this give you alitle help .

Tuan

Thanks Tuan, That's a great help

Got this working for me.

For anyone else who is interested, My menu items point to a category view which meant I needed to edit the following file in two places:

components/com_eventbooking/models/category.php

Line 219

change this:
$where[] = ' DATE(a.event_date) >= CURDATE() ';

to this:
$where[] = ' DATE(a.event_end_date) >= CURDATE() ';

and

Line 328

change this:
$where[] = 'DATE(event_date) >= CURDATE()' ;

to this:
$where[] = 'DATE(event_end_date) >= CURDATE()' ;

We are basically just changing saying that we only want to hide past events if the current date is greater than the event end date, rather than the event start date.

Hope this helps someone.

Great. That's correct. Thanks so much for sharing the solution !

Tuan

Hi, I've also find that an event does not show up,
if in the configuration you set "Hide past events" to yes,
and the start date of that event is passed, but the end date is still to come.

this, as already written, happens because the WHERE cause is set to match the start date only.
But this is of course wrong, and could not be considered a feature,
since an event is not to be considered "past" unless the end date is not passed.

the solution posted solves this problem

to change from this:
to this:
but is it all right, or could the end date be empty?
since the end date could be empty, this feature (hide past event) is not to be considered solved, but with a "bug".

Since a new version has been released, I'd like to know if this problem is solved in the new release of the component.
Thank for your help,
Gabriella