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?
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)