Using getData() to get immediate next occurrence

Scheduler Javascript
#1

Hello,
I have be working with the Scheduler and come across some difficulties.

Basically, I am trying to get the data (start and end date) of the first occurrence in a Recurring event. I have tried using the Helper class and have not succeeded.

Could anyone please advise me how to sort this out?

#2

Hello,

Please specify how you tried to get dates of event.
You can get required event object by getEvent method and its dates. For example:
docs.dhtmlx.com/scheduler/snippet/094ed2da

#3

Hi Polina,

Thanks for your response.

I am using the PHP Scheduler Helper Class.

require_once "./SchedulerHelper.php";
use DHTMLX_Scheduler\Helper;

  $helper = new Helper(
    array(
      "dbsm" => "mysql", // optional, "mysql" by default
      "host" => "localhost", // optional, "localhost" by default
      "db_name" => "oilexvsl5",
      "user" => "oilexvsluser_co",
      "password" => "*****",
      "table_name" => "tasks" // name of the table that contains data of recurring events 
    )
  );
  
    $helper->setFieldsNames(array(helper::FLD_ID => "id",));
  $data = $helper->getData("2017-07-02 00:00:00", "2018-07-01 00:00:00");
   var_dump($data);

This returns a blank screen. But the $helper->deleteById(32950) correctly deletes the event.

My plan is to get the recurrent events then retrieve the next event in the series and display it as the next event date.

I have attached my DB design.

db.png854×413 39 KB

#4

Here is an error log i get when i run this $helper->getData("2017-07-02 00:00", "2018-07-01 00:00");

#5

Hi,

Recurring events are saved in db like one event and displayed in Scheduler like recurring one according to ‘rec_type’ value. So you can’t get every recurrent event of the series from db.