Hi,
acoording to two articles (docs.dhtmlx.com/scheduler/recurr … nglightbox) we have made a test project using javaPlanner and Oracle database. Some details are confusing:
- Dragging all sequence - not working as expected
Example - let make a sequence, starting at 2-nd of June and repeating every week. Single event duration is two days. In database the record, representing sequence looks like this:
ID = 32
START_DATE = 2014-06-02 00:00
END_DATE = 9999-02-01 00:00:00 (no end defined)
TEXT = some text
REC_TYPE = week_1___1#no
EVENT_PID = 0
EVENT_LENGHT = 172800
We have included the javascript given in second article
scheduler.attachEvent("onBeforeEventChanged",function(dev){
var parts = this._drag_id.toString().split("#");
if (parts.length > 1) {
this._drag_id= parts[0];
var ev = this.getEvent(parts[0]);
ev._end_date = ev.end_date;
ev.start_date = dev.start_date;
ev.end_date = dev.end_date;
}
return true;
});
for dragging all sequence. This is done by setBeforeInit method. If i try to move all sequence from 2-nd to 3-rd of June by dragging , it disappears. Here goes the updated record in database:
ID = 32
START_DATE = 2014-06-03 00:00
END_DATE = 2014-06-05 00:00:00 (???)
TEXT = some text
REC_TYPE = week_1___1#no (not updated to week_1___2#no. In given javascript there is nothing about rec_type)
EVENT_PID = 0
EVENT_LENGHT = 172800
It looks like moving a single event.
If i move sequence not by dragging , but editing all sequence ,updated record looks fine:
ID = 32
START_DATE = 2014-06-03 00:00
END_DATE = 9999-02-01 00:00:00
TEXT = some text
REC_TYPE = week_1___2#no
EVENT_PID = 0
EVENT_LENGHT = 172800
and displays correct.
Are we missing something to make dragging sequence work? We have tried the same with the demoapp_jsp example and including javascript for dragging all sequence - also not working the same way.
-
What is the meaning of symbols after # sign in rec_type?
-
For some reasons we want to check for collisions on server side. It is clear how to make it for single events. But for recurring events rec_type must be analyzed. And if there are single occurrences changed … Is there a method for collision check on server side (Java)?