Auto-disallow conflicting entries

nick · Joined: 07 Sep 2006 Posts: 13

Hi

We're using the calendar to allow users to book a meeting room but don't want to rely on them remembering to use the 'conflict checking' option (because they won't remember to).

Where would I need to edit in order to prevent entries being entered that overlap with existing ones? I'd like to be able to bounce the user back with a basic "You can't do that" message.

Thanks,

Nick

esoft_ian · Joined: 12 Sep 2005 Posts: 5511

Hi,

In include/events.php around line:626, before if(!$_cal_event->save()) you can check for a conflicting event:

global $cal;

require_once(_CAL_BASE_PATH_."include/classes/class.calendar.php");

$cal or $cal = new calendar();
$cal->set("calendar", $_cal_event->calendar);
$cal->set("filter", "id != ". intval($_cal_event->id));

list($events) = $cal->get_event_list("day", $_cal_event->starttime);

foreach($events as $e) {

if(($e->starttime < $_cal_event->endtime) && ($e->endtime > $_cal_event->starttime)) {

echo("You can't do that!");
return;
}
}

Something like that should do it or at least be a starting point. Let me know if you have any questions / trouble.

nick · Joined: 07 Sep 2006 Posts: 13

Hello again Ian!

Thanks for the code. As it is, it is causing the script to die just after writing the "bounding_table" , returning the following error message:

Fatal error: Call to undefined function: set() in D:\Webs\intranet\calendar\include\events.php on line 631

Any thoughts?

Cheers,

Nick

esoft_ian · Joined: 12 Sep 2005 Posts: 5511

Ah.. in all the code I entered, replace $cal with $eventcal

nick · Joined: 07 Sep 2006 Posts: 13

Hmmm - no joy. No error messages, but it allows conflicting entries to be added. Just to make sure I've got it right, these are my lines 625 - 644:

esoft_ian · Joined: 12 Sep 2005 Posts: 5511

Le'ts try that again:

nick · Joined: 07 Sep 2006 Posts: 13

Works like a charm!

Thanks again, Ian. I owe you a cyberbeer.

Cheers,

Nick

harpistic · Joined: 06 Feb 2008 Posts: 5

Hi,

how would I amend this to check to see if there's a conflict in category as well? (As we're using the categories as individual meeting rooms).

I've tried the below (and variations on) but the 'type' (and 'etype') parameters are being overlooked:

foreach($events as $e) {

$e = new _cal_event_minimal($e);

if(($_cal_event->allday || $e->allday) ||
(($e->starttime < $_cal_event->ends_at) && ($e->ends_at > $_cal_event->starttime) && ($e_type == $_cal_event->type))) {

echo('Sorry, this slot has already been taken. Please try again later');

esoft_ian · Joined: 12 Sep 2005 Posts: 5511

Hi,

You should be able to add this:

$eventcal->set("event_types", intval($_cal_event->type));

after this:

$eventcal->set("filter", "id != ". intval($_cal_event->id));

Leaving the rest of the code the same.

Let me know if this isn't what you are looking for.

machold · Joined: 10 Mar 2009 Posts: 2

Hi,

If I were wanting to disallow conflicting events but only for certain calendars, is there a way to name them such that I can put this block of code into an if statement?

Thanks,

Dan