Guriddo » Topic: Formating

Formating

Guriddo
Formating

This topic has 13 replies, 2 voices, and was last updated 8 years, 3 months ago by guriddo.support.

Creator

Topic
January 24, 2018 at 12:21 pm #126591

ddandre
Participant

hi,

it is possible to format a gridcol and a form field differently?
Creator

Topic

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

Author

Replies

January 25, 2018 at 9:49 pm #126596

guriddo.support

Participant

Hello,

I’m not sure that I understand the question correct.

If you mean that the formatting of the field in grid can be different in form editing the answer is yes . Please let us know what exactly you want to do, so that we can give you the best answer.

Kind Regards,

Will

Guriddo Support Team

January 26, 2018 at 10:30 am #126603

ddandre

Participant

exacly. i have to format the grid and form edit field diffrently. to be precise, I would like to format a field in the grid and unformated it in the form field.

January 26, 2018 at 9:22 pm #126606

guriddo.support

Participant

Hello,

Sorry that we do not have explain what we want.

Do you use custom formatter or use a predefined one like date, currency and so on.

Can you please post a simple code what you do.

Note that if you use custom formatter you should define your own unformat function to get the raw value in edit.

Kind Regards,

Will

Guriddo Support Team

February 9, 2018 at 4:48 pm #126633

ddandre

Participant

i will try to explain better.

i have an column with an date in my grid with the following code:

        $grid-&gt;setUserDate(&quot;Y-m-d&quot;);
        $grid-&gt;setUserTime(&quot;Y-m-d&quot;);
        $grid-&gt;datearray = array(&quot;terminVon&quot;);
        $grid-&gt;setColProperty(&#039;terminID&#039;,
            [
                &#039;label&#039; =&gt; &#039;ID&#039;,
                &#039;hidden&#039; =&gt; true,
                &#039;width&#039; =&gt; 40,
                &quot;colmenu&quot; =&gt; false,
                &#039;editoptions&#039; =&gt; [
                    &#039;readonly&#039; =&gt; true]
            ]);

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

$grid->setUserTime("Y-m-d");

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

$grid->setColProperty('terminID',

[

'label' => 'ID',

'hidden' => true,

'width' => 40,

"colmenu" => false,

'editoptions' => [

'readonly' => true]

]);

All data is stored in in mysql database. the col with the date ist stored as the standard mysql type ‘date’.

All work fine so far. the date appears as YYYY-MM-DD, the html inputfield (type=”date”) use this format and the database use this format also. But in Germany we have DD.MM.YYYY as notation for date.

So I just want to format the date for the output in the grid in german notation. Otherwise, both in the editform and in the database the date format should be used “raw”.

I hope despite my bad English, I could explain my request.

This reply was modified 8 years, 3 months ago by ddandre.

February 12, 2018 at 3:01 pm #126638

guriddo.support

Participant

Hello,

You can try with these settings:

$grid-&gt;setUserDate(&quot;Y-m-d&quot;);
$grid-&gt;setUserTime(&quot;Y-m-d&quot;);
$grid-&gt;datearray = array(&quot;terminVon&quot;);
$grid-&gt;setColProperty(&#039;terminID&#039;,
   array(
      &#039;label&#039; =&gt; &#039;ID&#039;,
      &#039;width&#039; =&gt; 40,
      &quot;colmenu&quot; =&gt; false,
      &#039;editoptions&#039; =&gt; [&#039;readonly&#039; =&gt; true],
      &#039;formatter&#039;=&gt;&#039;date&#039;,
      &quot;formatoptions&quot;=&gt;array(&quot;srcformat&quot;=&gt;&quot;Y-m-d&quot;,&quot;newformat&quot;=&gt;&quot;d.m.Y&quot;),
      &quot;unformat&quot;=&gt;&quot;js:function(v){ return $.jgrid.parseDate.call(this, &#039;d.m.Y&#039;, v, &#039;Y-m-d&#039;) ; }&quot;,
 ));

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

$grid->setUserTime("Y-m-d");

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

$grid->setColProperty('terminID',

array(

'label' => 'ID',

'width' => 40,

"colmenu" => false,

'editoptions' => ['readonly' => true],

'formatter'=>'date',

"formatoptions"=>array("srcformat"=>"Y-m-d","newformat"=>"d.m.Y"),

"unformat"=>"js:function(v){ return $.jgrid.parseDate.call(this, 'd.m.Y', v, 'Y-m-d') ; }",

));

And you should ser reloadAfterSubmit to true in add and edit form.

Kind Regards,

Will

Guriddo Support Team

February 13, 2018 at 3:16 pm #126642

ddandre

Participant

Thanks. That works fine.
But the date fields are still in wrong format if i export to pdf.

February 13, 2018 at 3:42 pm #126643

guriddo.support

Participant

Hello,

When using PHP the export to PDF is done at the server using a external library TCPDF.

The problem here is that the date is converted to the user using JavaScript, while the export is done at the server with PHP – so the JavaScript code can not be converted to PHP one.

Instead of this there is a solution of the problem – just change the db user format when export is in action. To do so after setUserDate setUserTime do:

$grid-&gt;setUserDate(&quot;Y-m-d&quot;);
$grid-&gt;setUserTime(&quot;Y-m-d&quot;);
if($grid-&gt;oper  == &#039;pdf&#039;) {
    $grid-&gt;setUserDate(&quot;d.m.Y&quot;);
    $grid-&gt;setUserTime(&quot;d.m.Y&quot;);
}

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

$grid->setUserTime("Y-m-d");

if($grid->oper == 'pdf') {

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

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

}

Kind Regards,
Will

Guriddo Support Team

February 13, 2018 at 4:04 pm #126647

ddandre

Participant

OK. But it doesnt work for me. See Screenshot https://s14.postimg.org/tpyl5z8rl/screenshot.png

February 13, 2018 at 4:35 pm #126651

guriddo.support

Participant

Hello,

In which format do you want to export the date in PDF? I’m little confused.

The format you show us is in German date format.

Kind Regards,

Will

This reply was modified 8 years, 3 months ago by guriddo.support.
This reply was modified 8 years, 3 months ago by guriddo.support.

Guriddo Support Team

February 13, 2018 at 4:36 pm #126653

ddandre

Participant

the classic german notation dd.mm.yyyy.

the format is right in the pdf but the date itself is wrong.

This reply was modified 8 years, 3 months ago by ddandre.

February 13, 2018 at 4:39 pm #126656

guriddo.support

Participant

Which version of PHP is used?

Guriddo Support Team

February 13, 2018 at 4:41 pm #126657

ddandre

Participant

PHP 7.1.9.

so should look like: https://s14.postimg.org/sbasm41fl/screenshot2.png

February 13, 2018 at 4:44 pm #126658

guriddo.support

Participant

Hello,

You use maybe a version of Guriddo Suito PHP where this was problem exists in PHP 7.x. In PHP 5.x is fine. The problem is fixed in the upcoming release, which will be published tomorrow.

Formating

Search Forum

Recent Replies

Forum Statistics

UserOnline