Load sections from db

Scheduler Javascript
#1

Hi,

Is there an way to load the (room) sections array from a db?
I’ve got a table called Engineers with Columns: ID , Firstname.

Is there also a way to display the unit tab, when loading the scheduler with AttachScheduler?

Thanks !

#2

Hi,

check this article
docs.dhtmlx.com/doku.php?id=dhtm … s_fetching

you can define markup of the scheduler and attach it to the tab. attachScheduler can take container id as parameter
.attachScheduler(date, mode, container_id);

	<div id="scheduler_here" class="dhx_cal_container" style='width:100%; height:100%;'>
		...
			<div class="dhx_cal_tab" name="day_tab" style="right:204px;"></div>
			<div class="dhx_cal_tab" name="week_tab" style="right:140px;"></div>
			<div class="dhx_cal_tab" name="unit_tab" style="right:280px;"></div>
			<div class="dhx_cal_tab" name="month_tab" style="right:76px;"></div>
		...
	</div>[/code][code]
tab.attachScheduler(new Date(), "week", "scheduler_here");
#3

Hi,

Thanks for your reply, but that won’t load the sections from the engineers table?
I want to be able to create/delete sections when engineers are added and go.

Engineers:
ID,Name,Active

Thanks

#4

never mind, never noticed the OptionsConnector part.
Thanks!

#5

how can I load this into templates.even_text?

scheduler.templates.event_text=function(start,end,event){
return “: “+event.CustomerID+”
”+" “+event.PropertyID+”
"+" Type: "+event.text;
}

I’ve already got this working:
var customers= scheduler.serverList(“CustomerID”);

scheduler.config.lightbox.sections=[
{name:“description”, height:130, map_to:“text”, type:“textarea” , focus:true},
{name:“custom_engineer”, height:23, type:“select”, options:sections, map_to:“EngineerID” },
{name:“custom_customer”, height:23, type:“select”, options:customers, map_to:“CustomerID” },
{name:“custom_property”, height:23, type:“select”, options:properties, map_to:“PropertyID” },
{name:“time”, height:72, type:“time”, map_to:“auto”}
]

#6

and when i use this:

scheduler.createUnitsView(“unit”,“EngineerID”,sections);
scheduler = dhxLayout.cells(“a”).view(“Scheduler”).attachScheduler(new Date(), “unit”, “scheduler_here”);

I just get the text: scheduler_here instead of the navigation buttons, is that because i’m using unit view?

Thanks!

#7

I found that part online :slight_smile: