Guriddo » Topic: Need help for using date field in form edit

Need help for using date field in form edit

Guriddo
Need help for using date field in form edit

This topic has 5 replies, 2 voices, and was last updated 5 years, 12 months ago by guriddo.support.

Creator

Topic

May 27, 2016 at 10:16 am #125212

ddandre

Participant

Hello Guys,

i have an date field in my edit form like this:

$grid->setColProperty('newsDate', array("label"=>"Datum","align"=>"center","width"=>120,"datefmt"=>"U","formatter"=>"date","formatoptions"=>array("srcformat"=>"U","newformat"=>"d.m.Y H:i")));

1	$grid->setColProperty('newsDate', array("label"=>"Datum","align"=>"center","width"=>120,"datefmt"=>"U","formatter"=>"date","formatoptions"=>array("srcformat"=>"U","newformat"=>"d.m.Y H:i")));

this should be stored in db as a unixtimestamp. How can i do this?

Thanks

This topic was modified 5 years, 12 months ago by ddandre.

Creator

Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author

Replies

May 27, 2016 at 10:57 am #125214

guriddo.support

Participant

Hello,

Please refer to this documentation here

In your case you will need to use the user and database date settings.

Kind Regards,

Will

Guriddo Support Team

May 27, 2016 at 11:11 am #125215

ddandre

Participant

i have already tried this.

 $grid->setUserDate("d.m.Y");
 $grid->setUserTime("d.m.Y H:i");
 $grid->setDbDate('u');
 $grid->setDbTime('u');
 $grid->setDatepicker('newsDate');
 $grid->datearray = array("newsDate");

$grid->setUserDate("d.m.Y");

$grid->setUserTime("d.m.Y H:i");

$grid->setDbDate('u');

$grid->setDbTime('u');

$grid->setDatepicker('newsDate');

$grid->datearray = array("newsDate");

but the database will be filled wrong.

May 27, 2016 at 2:36 pm #125216

guriddo.support

Participant

Hello,

Using the description from PHP date the following is written:

u – Microseconds (added in PHP 5.2.2). Note that date() will always generate 000000 since it takes an integer parameter, whereas DateTime::format() does support microseconds if DateTime was created with microseconds.

U – Seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)

u and U are different

Kind Regards,

Will

Guriddo Support Team

May 27, 2016 at 2:50 pm #125217

ddandre

Participant

Indeed,

but it doesnt mater which u i use.. It will be the same result.

May 27, 2016 at 3:38 pm #125219

guriddo.support

Participant

Hello,

Sorry for my first post.

I totally forgot that the Unixdate is stored as number (or string), but jqGrid automatically detect the field types – so this code will not work.

One possible solution is to convert the date field to unix date and post it to the server.

This can be done using serializeEditData (suppose you use form edit)

$serializeDate = <<<DATETOUNIX
function( postEditData )
{
postEditData.newsDate = $.jgrid.parseDate('d.m.Y H:i', postEditData.newsDate, 'U');

return postEditData

}
DATETOUNIX;

$grid->setNavEvent('add','serializeEditData', $serializeDate);
$grid->setNavEvent('edit','serializeEditData', $serializeDate);

$serializeDate = <<<DATETOUNIX

function( postEditData )

{

postEditData.newsDate = $.jgrid.parseDate('d.m.Y H:i', postEditData.newsDate, 'U');

return postEditData

}

DATETOUNIX;

$grid->setNavEvent('add','serializeEditData', $serializeDate);

$grid->setNavEvent('edit','serializeEditData', $serializeDate);

Kind Regards,
Will

Guriddo Support Team

Author

Replies

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

Registered Users: 12,188
Forums: 7
Topics: 10,913
Replies: 23,038
Topic Tags: 313

12 Users Online

Users: 6 Guests, 6 Bots

Stay connected with us in your favorite flavor!

Need help for using date field in form edit

Search Forum

Recent Replies

Forum Statistics

UserOnline