pascal asked 10 years ago
hello I cannot export date and time to the pdf.
$col = array();
$col["title"] = "Receive Date";
$col["name"] = "receive_date";
$col["width"] = "50";
$col["formoptions"] = array("rowpos"=>"1", "colpos"=>"2");
$col["searchoptions"]["sopt"] = array("cn"); // contains search for easy searching
# to make it date time
$col["formatter"] = "date";
# opts array can have these options: http://trentrichardson.com/examples/timepicker/#tp-options
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'Y-m-d',"opts" => array("timeFormat"=>""));
$col["show"] = array("list"=>true, "add"=>true, "edit"=>true, "view"=>true);
$col["export"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "Time";
$col["name"] = "receive_date";
$col["width"] = "50";
$col["formoptions"] = array("rowpos"=>"1", "colpos"=>"2");
$col["searchoptions"]["sopt"] = array("cn"); // contains search for easy searching
# to make it date time
$col["formatter"] = "date";
# opts array can have these options: http://trentrichardson.com/examples/timepicker/#tp-options
$col["formatoptions"] = array("srcformat"=>'Y-m-d H:i:s',"newformat"=>'H:i:s',"opts" => array("timeFormat"=>""));
$col["show"] = array("list"=>true, "add"=>true, "edit"=>true, "view"=>true);
$col["export"] = true;
$cols[] = $col;
$col = array();
Abu Ghufran answered 10 years ago
For displaying / export 2 columns with same field, you will need to alias this field again in select_command
$g->select_command = "SELECT i.id, receive_date,receive_date as receive_time, … FROM invheader";
And then use receive_time for second column.
Abu Ghufran answered 10 years ago
The aliased field will not be editable and may need custom on_update code for update.
