Guriddo » ddandre's Replies

ddandre

Guriddo

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 24 total)

1 2 →

Author

Replies

March 7, 2022 at 7:13 pm in reply to: Docs not available #127906

ddandre

Participant

As reported at the time, the docs are again not accessible.

February 22, 2022 at 3:52 pm in reply to: Search function and SQL query #127900

ddandre

Participant

OK. I have found my mistake.

i sort by a column that is in the table but not in the select-statement.

E.g.

SQL SELECT col1, col2, col3, col8, col9 WHERE col8=1234 ORDER BY col11 DESC;

this is not working with toolbar search, since the system build the following query:

SQL SELECT * FROM ( SELECT col1, col2, col3, col8, col9 WHERE col8=1234 ORDER BY col11 DESC) gridsearch WHERE (col1 LIKE ?) ORDER BY col11 desc LIMIT 0, 100

February 22, 2022 at 11:46 am in reply to: Is this project still alive? #127899

ddandre

Participant

Sounds promising.
Thanks for the answer.

February 22, 2022 at 11:45 am in reply to: Docs not available #127898

ddandre

Participant

Ahh.

The links are copied from the page you suggest.
Now the links work again.

March 20, 2018 at 4:54 pm in reply to: Fixed Column width in responsive design #126786

ddandre

Participant

i will answer myself 😀

use the colmodel option “fixed” => true.

February 28, 2018 at 9:55 am in reply to: customize export buttons #126706

ddandre

Participant

that is it. Thanks for fast response.

February 13, 2018 at 4:41 pm in reply to: Formating #126657

ddandre

Participant

PHP 7.1.9.

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

February 13, 2018 at 4:36 pm in reply to: Formating #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 5 years, 9 months ago by ddandre.

February 13, 2018 at 4:04 pm in reply to: Formating #126647

ddandre

Participant

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

February 13, 2018 at 3:16 pm in reply to: Formating #126642

ddandre

Participant

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

February 9, 2018 at 4:48 pm in reply to: Formating #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 5 years, 10 months ago by ddandre.

February 7, 2018 at 12:45 pm in reply to: REQUEST form edit input type #126627

ddandre

Participant

OK.
Is an exact date for release known?

January 26, 2018 at 10:30 am in reply to: Formating #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.

August 25, 2017 at 9:56 am in reply to: header alignment #126349

ddandre

Participant

Thanks.

is there an method in php?

May 9, 2017 at 9:59 am in reply to: row format depending on col value #126071

ddandre

Participant

Works fine. thx

Author

Replies

Viewing 15 replies - 1 through 15 (of 24 total)

1 2 →