Scheduler Helper Problem

Hello,

I am using the SchedulerHelper.php class to try and get an array of recurring events. However, It is returning far more events than the database says it should.

For example: If I have an event on Nov 22, 2013 from 10:00am to 12:00pm and have that repeat 3 times, I would expect only 3 returned events from the “get_dates()” method. However I am getting about 8-9 events, whose end dates go far past when I specified to complete.

Any idea what is going on?

-Brandon

Problem confirmed.
We will release the updated helper in the nearest time.

I have the same problem. Is there an update of SchedularHelper.php?
Kind regards.

Unfortunately the updated version still not available.

is the problem was solved plz?

Check github.com/DHTMLX/scheduler-helper-php

Hi,
I created a recurring event repeated 5 times then I delete one occurrence but S-helper return 6 recurrences.
It should return (5-1) events !? or not ?

I think there are 2 problème :
1- for rec_type like day_1___#5 : it returned 6 occurrences ( should be 4 occurences )
2- the deleted recurrences are not detected. (return 6 occurrences )

Hello ,

I’m having issues with the scheduler helper please help ,

Here’s what i wrote :

[code] public function index() {

    $helper = new Helper(
        array(
            "dbsm" => "mysql", // optional, "mysql" by default
            "host" => "localhost", // optional, "localhost" by default
            "db_name" => "msa_new_db",
            "user" => "root",
            "password" => "",
            "table_name" => "time_slots" // name of the table that contains data of recurring events
        )
    );


    $helper->setFieldsNames(array(
        helper::FLD_ID => "time_slot_id",
    ));

    $red = $helper->getData("2015-01-01 09:00:00", "2020-01-02 07:00:00");

    var_dump($red);
}[/code]

SQL :

CREATE TABLE `time_slots` ( `time_slot_id` int(11) NOT NULL AUTO_INCREMENT, `block_online` tinyint(1) DEFAULT NULL, `agenda_id` int(11) DEFAULT NULL, `title` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `description` text COLLATE utf8_unicode_ci, `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `event_type` char(1) COLLATE utf8_unicode_ci DEFAULT NULL, `rec_type` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `event_pid` int(11) DEFAULT NULL, `event_length` int(11) DEFAULT '0', `color` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`time_slot_id`), KEY `FK_Reference_33` (`agenda_id`), CONSTRAINT `FK_Reference_33` FOREIGN KEY (`agenda_id`) REFERENCES `agendas` (`agenda_id`) ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

what’s missing ? am i doing something wrong ?

for more info please check the image joined.
Thank you.


Sorry I forget to indicate the result .
Normaly S-Helper should returns 5 occurrences but it returns 7 , see below.

array (size=7)
  0 => 
    array (size=12)
      'time_slot_id' => string '33' (length=2)
      'block_online' => string '0' (length=1)
      'agenda_id' => string '1' (length=1)
      'title' => string 'AAA' (length=3)
      'description' => string 'AAA' (length=3)
      'start_date' => string '2015-10-07 07:40:00' (length=19)
      'end_date' => string '2015-10-07 10:45:00' (length=19)
      'event_type' => string 'p' (length=1)
      'rec_type' => string 'day_1___#6' (length=10)
      'event_pid' => string '0' (length=1)
      'event_length' => string '11100' (length=5)
      'color' => string '#90EE90' (length=7)
  1 => 
    array (size=12)
      'time_slot_id' => string '33' (length=2)
      'block_online' => string '0' (length=1)
      'agenda_id' => string '1' (length=1)
      'title' => string 'AAA' (length=3)
      'description' => string 'AAA' (length=3)
      'start_date' => string '2015-10-08 07:40:00' (length=19)
      'end_date' => string '2015-10-08 10:45:00' (length=19)
      'event_type' => string 'p' (length=1)
      'rec_type' => string 'day_1___#6' (length=10)
      'event_pid' => string '0' (length=1)
      'event_length' => string '11100' (length=5)
      'color' => string '#90EE90' (length=7)
  2 => 
    array (size=12)
      'time_slot_id' => string '33' (length=2)
      'block_online' => string '0' (length=1)
      'agenda_id' => string '1' (length=1)
      'title' => string 'AAA' (length=3)
      'description' => string 'AAA' (length=3)
      'start_date' => string '2015-10-09 07:40:00' (length=19)
      'end_date' => string '2015-10-09 10:45:00' (length=19)
      'event_type' => string 'p' (length=1)
      'rec_type' => string 'day_1___#6' (length=10)
      'event_pid' => string '0' (length=1)
      'event_length' => string '11100' (length=5)
      'color' => string '#90EE90' (length=7)
  3 => 
    array (size=12)
      'time_slot_id' => string '33' (length=2)
      'block_online' => string '0' (length=1)
      'agenda_id' => string '1' (length=1)
      'title' => string 'AAA' (length=3)
      'description' => string 'AAA' (length=3)
      'start_date' => string '2015-10-10 07:40:00' (length=19)
      'end_date' => string '2015-10-10 10:45:00' (length=19)
      'event_type' => string 'p' (length=1)
      'rec_type' => string 'day_1___#6' (length=10)
      'event_pid' => string '0' (length=1)
      'event_length' => string '11100' (length=5)
      'color' => string '#90EE90' (length=7)
  4 => 
    array (size=12)
      'time_slot_id' => string '33' (length=2)
      'block_online' => string '0' (length=1)
      'agenda_id' => string '1' (length=1)
      'title' => string 'AAA' (length=3)
      'description' => string 'AAA' (length=3)
      'start_date' => string '2015-10-11 07:40:00' (length=19)
      'end_date' => string '2015-10-11 10:45:00' (length=19)
      'event_type' => string 'p' (length=1)
      'rec_type' => string 'day_1___#6' (length=10)
      'event_pid' => string '0' (length=1)
      'event_length' => string '11100' (length=5)
      'color' => string '#90EE90' (length=7)
  5 => 
    array (size=12)
      'time_slot_id' => string '33' (length=2)
      'block_online' => string '0' (length=1)
      'agenda_id' => string '1' (length=1)
      'title' => string 'AAA' (length=3)
      'description' => string 'AAA' (length=3)
      'start_date' => string '2015-10-12 07:40:00' (length=19)
      'end_date' => string '2015-10-12 10:45:00' (length=19)
      'event_type' => string 'p' (length=1)
      'rec_type' => string 'day_1___#6' (length=10)
      'event_pid' => string '0' (length=1)
      'event_length' => string '11100' (length=5)
      'color' => string '#90EE90' (length=7)
  6 => 
    array (size=12)
      'time_slot_id' => string '33' (length=2)
      'block_online' => string '0' (length=1)
      'agenda_id' => string '1' (length=1)
      'title' => string 'AAA' (length=3)
      'description' => string 'AAA' (length=3)
      'start_date' => string '2015-10-13 07:40:00' (length=19)
      'end_date' => string '2015-10-13 10:45:00' (length=19)
      'event_type' => string 'p' (length=1)
      'rec_type' => string 'day_1___#6' (length=10)
      'event_pid' => string '0' (length=1)
      'event_length' => string '11100' (length=5)
      'color' => string '#90EE90' (length=7)