Hi
First off all nice scheduller!
Im new on jquery and im having a problem to create an event for multiples resources.
Let me see if can explain myself.
On normal view(day,week,month) i create an event, and in lightbox i choose the resources that i want to associate the event (+/- like this example docs.dhtmlx.com/scheduler/sample … tions.html).
The problem is when i add the Units view.
I wanted to apper an event for each resource i previously enter on the others view.
Can u give a guide line, i can do it separate, but when i join the units view its a mess.
Btw i use 3 tables
events table:
CREATE TABLE IF NOT EXISTS events_ms (
event_id int(11) NOT NULL AUTO_INCREMENT,
event_name varchar(127) NOT NULL,
start_date datetime NOT NULL,
end_date datetime NOT NULL,
details text NOT NULL,
PRIMARY KEY (event_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=124 ;
relation table events users
CREATE TABLE IF NOT EXISTS event_user (
event_user_id int(11) NOT NULL AUTO_INCREMENT,
event_id int(11) NOT NULL,
user_id int(11) NOT NULL,
PRIMARY KEY (event_user_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=142 ;
Table user
CREATE TABLE IF NOT EXISTS user (
user_id int(11) NOT NULL AUTO_INCREMENT,
username varchar(255) NOT NULL,
PRIMARY KEY (user_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;