TOPIC: Values of Group combobox to be populated with the different table

Hi,


I want to populate the group dropdown with the values from different mysql table ,so i am stuck with the code as in how to implement,i have implemented the form by referring the customtemplate.html file using the following code for populating data:i am not getting from where these parameters are passed to this function (obj, groups, allday),as in while loading the calendar we just mention the events to be called.also how the group dropdown gets the data from mysql table,n how we change it to get the data from different mysql table


function onNewEvent(obj, groups, allday)
{
var st = new UTC(obj.startTime);
var ed = new UTC(obj.endTime);
var newevt=jQuery(\"#customNewEventTemplate\");
//Clear out and reset form
newevt.find(\"#eventDesc\").val(\"\").end()
.find(\"#eventName\").val(\"\").focus().end()
.find(\"#eventStartDate\").val( st.toStandardFormat()).end()
.find(\"#eventEndDate\").val(ed.toStandardFormat() ).end();

if(allday)
newevt.find(\"#allDayEvent\").attr(\"checked\", true).end()
.find(\"#eventStartTime\").val(\"\").end()
.find(\"#eventEndTime\").val(\"\");
else
newevt.find(\"#allDayEvent\").attr(\"checked\", false).end()
.find(\"#eventStartTime\").val( st.toNiceTime() ).end()
.find(\"#eventEndTime\").val( ed.toNiceTime() );

//display a list of groups to select from.
var groupDD=newevt.find(\"#eventGroup\").get(0);
removeAllOptions(groupDD);
for(var g in groups)
{
if(!groups.hasOwnProperty(g))continue;
var gId = groups[g].groupId;
addOption(groupDD, groups[g].groupName,groups[g].groupId,false);
}
if(obj.group && obj.group.groupId)
newevt.find(\"#eventGroup\").val(obj.group.groupId);

newevt.find(\"#newEvAddEventBtn\").show().end()
.find(\"#newEvUpdateEventBtn\").hide();
}


Does anyone have any idea regarding this.Pls help

Thanks in advance

Shirish, I don\'t understand your question.

Do you want to populate the Groups Drop down with your own values?

If yes, then it should be simple to update the drop down with your own values with the above method.

If your question is how onNewEvent is invoked, it is a callback method invoked by Calendar.

Hope this answers your question. If not, explain more.

Thanks alammm.but still i am not clear,

My question is that i am using a different fields in mysql table say for eg:- I am haiving Bookings table(mysql) and i am having the dropdown of hotel rooms to be booked which is to be populated from rooms column in bookings table..so how do i populate it in the dropdown.


what i have understood is this chunk of code populates the data in group dropdown in customtemplate.html


//display a list of groups to select from.
var groupDD=newevt.find(\"#eventGroup\").get(0);
removeAllOptions(groupDD);
for(var g in groups)
{
if(!groups.hasOwnProperty(g))continue;
var gId = groups[g].groupId;
addOption(groupDD, groups[g].groupName,groups[g].groupId,false);
}
if(obj.group && obj.group.groupId)
newevt.find(\"#eventGroup\").val(obj.group.groupId);

newevt.find(\"#newEvAddEventBtn\").show().end()
.find(\"#newEvUpdateEventBtn\").hide();
}

But where is the data retrieved from database...there has to be query to the mysql table to populate in dropdown....i hope you got my question else i would explain it more

Thanks in advance

Ok this is very simple. There are a couple of ways to do this. What I understand is you need a set of records for loading into a drop down. You don\'t want to use the Groups List provided as a param to callback method.

1. This drop down can be loaded as any other drop down in a normal page. (On Load retrieve list, loop and create the drop down).
2. in onNewEvent you can make an Ajax Call to get the records.

Let me know if this is clear now.

Thanks....the issue got solved...

In customtemplates.html,inside function editMyEvent(eventId) there is function call getEventById(eventId); i wanted to know where is this js function defined can\'t able to recollect.