$grid->setColProperty('TGL', array("label"=>"Tgl","formatter" => "date", "width"=>85,
"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "Y-m-d"),
"editoptions" => array("defaultValue" => "js:function(elm){return tgl===null?'':tgl; }",
"dataInit" => "js:function(elm){
jQuery(elm).datepicker({dateFormat:'yy-m-d'});
jQuery('.ui-datepicker').css({'zIndex':'1200','font-size':'75%'});}")
));
$grid->setColProperty('JTH_TEMPO', array("label"=>"Jth Tgl","formatter" => "date", "width"=>85,
"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "Y-m-d"),
"editoptions" => array("defaultValue" => "js:function(elm){return tgl===null?'':tgl; }",
"dataInit" => "js:function(elm){
jQuery(elm).datepicker({dateFormat:'yy-m-d'});
jQuery('.ui-datepicker').css({'zIndex':'1201','font-size':'75%'});}")
));
$grid->setColProperty("SUPPLIERID", array("label"=>"SUPPLIERID", "hidden"=>true ));
$grid->setColProperty("SUPPLIER", array("label"=>"Supplier", "searchoptions"=>array("sopt"=>array('cn', 'nc'))));
$grid->setAutocomplete("SUPPLIER","#SUPPLIERID","
SELECT pr.SUPPLIER, pr.SUPPLIER, pr.supplierid
FROM supplier pr
WHERE upper(pr.SUPPLIER) like '%' || upper( ? ) || '%'
ORDER BY pr.SUPPLIER ",array("itemLength"=>50), true, true);