Installation problem and New scheduler for J2.5

Hello!
First of all, thanks for your great job doing scheduler + joomla plugin.
I’m trying to install the component created by radyno, but a SQL error occurs:

‘jos_scheduler_options’ doesn’t exist SQL=SELECT * FROM jos_schduler_options WHERE name=‘scheduler_php’

May i suggest you to avoid describing all the included files in the “install.xml”
You just have to write first levels files and folders and Joomla will take all sub-folders and files automatically!

I’m also trying to create my own component and i got noob questions on the js scheduler:
1° Is there a way to handle a proper and native Joomla saving method (MVC) for events without using dhtmlxconnector? if yes could you please give me some help and ressources (links,docs, codes…) ?
2° Does a public repo exists on this project?

Thanks a lot!!

Hi,
thanks for your feedback.

Could you specify which version are you using?
I thinks error occurs because actual name of table is jos_scheduler_options, there is a mistake in table name. I tried to find it in code, but can’t locate it.

Good tip, thanks.

We doesn’t provide such solution, but yes, it may be implemented.
You have to implement getting data from database in correct format:
docs.dhtmlx.com/doku.php?id=dhtm … ntegration

and saving data according connector protocol (parse incoming data, check access rights configured in admin panel):
docs.dhtmlx.com/doku.php?id=dhtm … ol_details

Project doesn’t have public repo.

Thanks for feedbacks!

I’m using the version you gave in your sticky topic maybe there is another link i didn’t see?

According to the xml it’s v23

Thanks,
still scheduler plugin doesn’t work? Do you need any more help?

HI radyno,
By re installing i made the component working!

But know it seems that the component stays in read only mode even if i’m connected as a SuperAdmin…
I set proper authorisation and checked ‘Event creation onClick’ but it’s still not working…

I m also trying to make some changes to allow multiple unit views (meeting rooms and ressources) what i’d like to do in the form

  1. select an option (room or ressource)
  2. select a unit (room1, room2, room3…)
    I don’t understand where am i supposes to drop my custom code (in model,controller??)

I’m a Joomla component developper and I must admit your component is really weird ^^ but I like it!!
Thanks!

Hi,
The issue with access level is know and fix will be available with new scheduler plugin version (check your private message).

Please, update plugin to the last version (3.0). After that create two custom fields:
meet (type select with two options) and meet_child (type select with one default option).

Then open file yourjoomla/components/com_scheduler/scheduler_include.html and add the follow code inside:

<script>
	var parentfield = 'meet';
	var childfield = 'meet_child';

	var child_select_options = {
		meet_0: [
			{ key: 'room1', label: "Room 1" },
			{ key: 'room2', label: "Room 2" }
		],
		meet_1: [
			{ key: 'resource1', label: "Resource 1" },
			{ key: 'resource2', label: "Resource 2" },
			{ key: 'resource3', label: "Resource 3" }
		]
	};
	var parentindex = -1;

	var parent_onchange = function(event) {
		var new_child_options = child_select_options[this.value];
		update_select_options(scheduler.formSection(childfield).control, new_child_options);
	};

	var update_select_options = function(select, options) { // helper function
		select.options.length = 0;
		for (var i=0; i<options.length; i++) {
			var option = options[i];
			select[i] = new Option(option.label, option.key);
		}
	};

	scheduler.attachEvent("onBeforeLightbox", function(id){
		var ev = scheduler.getEvent(id);
		if (!ev[parentfield]) {
			var parent_id = parent_select_options[0].key;
		} else {
			var parent_id = ev[parentfield];
		}
		var new_child_options = child_select_options[parent_id];
		update_select_options(scheduler.formSection(childfield).node.getElementsByTagName('select')[0], new_child_options);
		return true;
	});

	scheduler.attachEvent("onTemplatesReady", function() {
		for (var i = 0; i < scheduler.config.lightbox.sections.length; i++) {
			if (scheduler.config.lightbox.sections[i].name == parentfield) {
				parentindex = i;
				break;
			}
		}
		scheduler.config.lightbox.sections[parentindex].onchange = parent_onchange;
		parent_select_options = scheduler.config.lightbox.sections[parentindex].options;
	});
</script>

By the way, our plugin is a little weird because it uses common codebase with wordpress. So it has a little unusual structure. The main logic is in codebase/dhtmlxSchedulerConfigurator.php file - it parses configuration and generates scheduler’s code.