Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Martin on Jan 02, 2010 05:30
open dhtmlx forum
Scheduler Multiple users of resources & SQL

Hi

I am trying the dhtmlx schedular, which looks very nice. The only thing I can't figure out is using the 'units' example in combination with an excel database. It gives me an XML error, possibly because I don't have the correct tables in my SQL databse.

Is there a mapping of which tables and names are used by the schedular, and on top of that, is it user configurable.
This is needed, because I have multiple units to view in a calendar, but I also wan't to be able to let users change only there own entry, and not others. Also, overlapping of calendar items should not be allowed..

A lot of questions, hop you can anwser them for me

Thanks
Martin
(From the Netherlands)
Answer posted by Stanislav (support) on Jan 04, 2010 04:05
Second parameter of createUnitsView call is the name of XML tag ( or attribute ) which must contain info with unit ID

            scheduler.createUnitsView("unit","section_id",sections); 

<event....
     <section_id>12</section_id>

The names of units are not fetched automatically, you are form them on client side with any kind of custom code. 
http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxscheduler:units_view

>>Also, overlapping of calendar items should not be allowed
You can assign code to the onEventAdded handler , which will call getEvents for time range of newly added events, and delete it ( or show some kind of warning ) if there are more than one event for such time range.