dhtml scheduler - date and time

Discontinued products Uncategorized discussions
#1

Is there a way to store the start date and time seperately in a table?

#2


It is possible to use sevaral tables.


But you should use render_sql instead of render_table method dhtmlx.com/dhxdocs/doku.php? … iting_data


And moreover you need to use onBeforeProcessing event to save the event data.

#3

Alex, thank you for the quick response.  I am having problems getting the date time to seperate in the start_date and end_date.  If it is not to much trouble may I please see an example.

#4


The example for scheduler rendering:


scheduler->event->attach(“beforeRender”,doBeforeRender);



function doBeforeRender($data){
$temp1 = $data->get_value(“date_start”);
$temp2 = $data->get_value(“time_start”);
$data->set_value($temp1." ".$temp2);
}


scheduler->render_sql(“SELECT * from tableA INNER JOIN tableB ON tableA.ida=tableB.idb”, “ida”,“date_start,date_end, text”, “time_start,time_end”, “”);


In order to save the date and time seperately you can use beforeProcessing event:



scheduler->event->attach(“beforeProcessing”,doBeforeProcessing);



function doBeforeProcessing($action){
$date1 = $action->get_value(“date_start”);
$time1 = $data->get_value(“time_start”);
…/*code that updates these values in the database */
}


#5

Wow you rock!!  Would I need a function for the update and delete as well?