In the manual of Connector I read
5. Formatting/Changing Data before Loading
In case you need to update values which were returned from database table or set some specific formatting before sending them to client side, you should use the “beforeRender” event handler. For more details see Events System chapter of this manual.
But I can’t find anywhere anything more about the beforeRender event handler.
Actually I need to implemetent the filter for the date field.
Mysql format is “Y-m-d” while I show and would search in “d-m-Y”
How can it be done. Of course the implementation of calendar into filter should be the even better.
But I can’t find anywhere anything more about the beforeRender event handler.
You can check
dhtmlx.com/docs/products/kb/inde … foreRender
Also, package contains
samples/grid/02_rendering_connector.php
which can be used as sample of usage
To have custom dates in grid you may have
function formatting($row){
//formatting date field
$data = $row->get_value(“other_field”);
$row->set_value(“other_field”,date(“d-m-Y”,strtotime($data)));
}
$grid->event->attach(“beforeRender”,“formatting”);
To have change filtering, you can use
function custom_filter($name,$value){
if ($name == “other_field”)
return " other_field > ".some_date_formatting_code($value);
}
$grid->event->attach(“beforeFilter”,“custom_filter”);
Where other_field - name of db field, which stores data