set_col_default

Questionsset_col_default
David Zinda asked 3 years ago

I have not been able to get
$g->set_col_default('jobdate', '2017-02-03');
to work and it's not even as complicated as I need it to be.

What I need is THIS during an "ADD RECORD operation".
$g->set_col_default('jobdate', insert todays date into the record);

Every time I put this statement into the code and launch the page, I get a blank white screen.

$g = new jqgrid($db_conf);

$grid["caption"] = "<b>JOBS</b>";
$grid["toolbar"] = "bottom";
$grid["pgbuttons"] = false;
$grid["pgtext"] = null;
$grid["width"] = "1080";
$grid["sortable"] = true;
$grid["sortname"] = "done";
$grid["rowNum"] = 999; // or any of your desired rec/page FINALLY! this works!
$grid["rowList"] = array();

$g->set_options($grid);

$g->table = "jobs";

$col = array();
$col["name"] = "jobid";
$col["title"] = "JobID";
$col["fixed"] = true;
$col["width"] = "60";
$col["editable"] = false;
$cols[] = $col;

$col = array();
$col["name"] = "custid";
$col["title"] = "CustID";
$col["fixed"] = true;
$col["width"] = "60";
$col["editable"] = false;
$cols[] = $col;

$col = array();
$col["name"] = "jobdate";
$col["title"] = "Date";
$col["fixed"] = true;
$col["width"] = "94";
$col["formatter"] = "date";
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'m/d/Y');
$col["align"] = "right";
$cols[] = $col;

$col = array();
$col["name"] = "year";
$col["title"] = "Year";
$col["fixed"] = true;
$col["width"] = "60";
$col["align"] = "right";
$cols[] = $col;

$col = array();
$col["name"] = "make";
$col["title"] = "Make";
$col["fixed"] = true;
$col["width"] = "100";
$cols[] = $col;

$col = array();
$col["name"] = "model";
$col["title"] = "Model";
$col["fixed"] = true;
$col["width"] = "174";
$cols[] = $col;

$col = array();
$col["name"] = "engine";
$col["title"] = "Engine";
$col["fixed"] = true;
$col["width"] = "110";
$cols[] = $col;

$col = array();
$col["name"] = "mileage";
$col["title"] = "Mileage";
$col["align"] = "right";
$col["fixed"] = true;
$col["width"] = "80";
$cols[] = $col;

$col = array();
$col["name"] = "license";
$col["title"] = "License";
$col["align"] = "right";
$col["fixed"] = true;
$col["width"] = "90";
$cols[] = $col;

$col = array();
$col["name"] = "done";
$col["title"] = "Done";
$col["search"] = false;
$col["align"] = "center";
$col["fixed"] = true;
$col["width"] = "60";
$cols[] = $col;

$col = array();
$col["name"] = "memo";
$col["title"] = "Memo";
$col["fixed"] = true;
$col["width"] = "90";
$col["sortable"] = false;
$cols[] = $col;

$col = array();
$col["name"] = "staxrate";
$col["hidden"] = true;
$cols[] = $col;

$col = array();
$col["name"] = "vin";
$col["hidden"] = true;
$cols[] = $col;

$col = array();
$col["title"] = "Action";
$col["name"] = "act";
$col["fixed"] = true;
$col["width"] = "70";
$col["align"] = "center";
$cols[] = $col;

$g->set_columns($cols,true);

$outjobs = $g->render("list1");
//$g->set_col_default('jobdate', '2017-02-03'); // supposed to be used only for add record
// End of JOBS grid definition

1 Answers
Abu Ghufran answered 3 years ago

Hi,

The function set_col_default does not exist in our library.
Please http://phpgrid.prg/docs for help.

For default value, you need to set: $col["editoptions"]["defaultValue"]

$col = array();
$col["name"] = "jobdate";
$col["title"] = "Date";
$col["fixed"] = true;
$col["width"] = "94";
$col["formatter"] = "date";

$col["editoptions"]["defaultValue"] = '2017-02-03';

$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'m/d/Y');
$col["align"] = "right";
$cols[] = $col;

Your Answer

2 + 0 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?