Guriddo » guriddo.support's Replies

guriddo.support

Guriddo

Forum Replies Created

Viewing 15 replies - 1,021 through 1,035 (of 1,092 total)

← 1 2 3 … 68 69 70 71 72 73 →

Author

Replies

June 23, 2015 at 9:30 am in reply to: Ajax data cannot be accessed #123940

guriddo.support

Participant

Hello,

Can you please post you full code or send a link to the page that do this?

With this information we can not help.

Thank you

Kind Regards,

Will

Guriddo Support Team

June 23, 2015 at 9:28 am in reply to: Typescript definition for JqGrid #123939

guriddo.support

Participant

Hello,

Thank you for this question.

Currently there is no typescript definition for jqGrid.

I hope we will do this ASAP, but before this we need to finish the mobile version and update the documentation.

We can expect this to be available at September this year.

Kind Regards,

Will

Guriddo Support Team

June 19, 2015 at 9:00 am in reply to: Stored procedure + SQL Server 2008 + jqGrid #123936

guriddo.support

Participant

Hello,

We do not support stored procedures in query.

The reason is that we pass additional important parameters to the query which can not be used.

Moreover we modify the original SQL query so that we make paging sorting and etc.

One possible solution is to get the dataset from stored procedure and use the array driver to pass it to the grid. This of course will slow down the process of loading the data into the grid

Kind Regards,

Will

Guriddo Support Team

June 11, 2015 at 8:56 am in reply to: Date-timepicker not appear. #123911

guriddo.support

Participant

Hello,

In the current implementation the modal plugin try to focus on the first visible input element. We will fix this in the next release setting a option not to focus at all or to focus on certain input element.

Sorry that we can not fix this so quick, since it is not so easy to manipulate the modal plugin.

Kind Regards,

Will

Guriddo Support Team

June 10, 2015 at 9:12 am in reply to: Master detail with two parameters #123908

guriddo.support

Participant

Hello,

This is partially correct.
To work this you will need to pass the parameters to renderGrid too


...
$grid-&gt;renderGrid(&quot;#detail&quot;,&quot;#pgdetail&quot;, true, $summaryrow, array(&amp;$COL1,&amp;$COL2), true,true);
...

...

$grid->renderGrid("#detail","#pgdetail", true, $summaryrow, array(&$COL1,&$COL2), true,true);

...

Kind Regards,
Will

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

Guriddo Support Team

June 10, 2015 at 9:07 am in reply to: Date-timepicker not appear. #123906

guriddo.support

Participant

Hello,

Definitely this is a problem with a focus in datetimepicker plugin.
The same problem does not appear when jQuery UI datepicker is used.

In order to solve the problem I suggest you 2 approaches

1. Try not to use setTimeout in the dataInit event (or set the timeout to 0)

$grid-&gt;setColProperty(&#039;date_at&#039;, 
        array(&quot;label&quot;=&gt;&quot;Date modif&quot;,&quot;align&quot;=&gt;&quot;center&quot;,	&quot;width&quot;=&gt;190,&quot;formatter&quot;=&gt;&quot;date&quot;,
            &quot;formatoptions&quot;=&gt;array(&quot;reformatAfterEdit&quot;=&gt;true, &quot;srcformat&quot;=&gt;&quot;Y-m-d H:i:s&quot;, &quot;newformat&quot;=&gt;&quot;m/d/Y H:i&quot;),
// Ok. We use some trick here to create the datepicer on dataInit event
// when the element is created. Note the js: before the function.
// this instruct the grid to put a javascript code without additional formating
            &quot;editoptions&quot;=&gt;array(&quot;dataInit&quot;=&gt;
                &quot;js:function(elm){
                    jQuery(elm).datetimepicker({dateFormat:&#039;mm/dd/yy&#039;});
                    jQuery(&#039;.ui-datepicker&#039;).css({&#039;font-size&#039;:&#039;75%&#039;});
                }&quot;)
            ));

$grid->setColProperty('date_at',

array("label"=>"Date modif","align"=>"center", "width"=>190,"formatter"=>"date",

"formatoptions"=>array("reformatAfterEdit"=>true, "srcformat"=>"Y-m-d H:i:s", "newformat"=>"m/d/Y H:i"),

// Ok. We use some trick here to create the datepicer on dataInit event

// when the element is created. Note the js: before the function.

// this instruct the grid to put a javascript code without additional formating

"editoptions"=>array("dataInit"=>

"js:function(elm){

jQuery(elm).datetimepicker({dateFormat:'mm/dd/yy'});

jQuery('.ui-datepicker').css({'font-size':'75%'});

}")

));

2. As you say move the date filed at 3 or 4 place in SQL Query.

Kind Regards,
Will

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

Guriddo Support Team

June 8, 2015 at 12:24 pm in reply to: MySQL query #123892

guriddo.support

Participant

Hello,

Try to execute the query command in the SQL console in order to see if there is a error.

I’m not sure that your query is correct when use GROUP BY in a variable this way.

Kind Regards,

Will

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

Guriddo Support Team

June 8, 2015 at 12:20 pm in reply to: JQGrid with grails #123891

guriddo.support

Participant

Hello,

Version of jqGrid to 4.7 are MIT/GPL licensed.

If you want to use the jqGrid from version 4.7.1 for commercial purposes you will need to obtain a license.

Kind Regards,

Will

Guriddo Support Team

June 4, 2015 at 7:57 am in reply to: Edit option in sub subgrid #123888

guriddo.support

Participant

Hello,

Thanks for the feedback. This will be very usefully for other having the same problem.

Kind Regards,

Will

Guriddo Support Team

June 3, 2015 at 8:39 am in reply to: Edit option in sub subgrid #123884

guriddo.support

Participant

Hello,

At first look I do not see setting of primary key in the subgrids.

For the second and third level try to set setPrimaryKeyId

Also for easy debugging you can set in the last subgrid

$grid->debug = true;

ind see in the jqGrid.log file what is happen when you try to insert or update the record.

Kind Regards,

Will

Guriddo Support Team

June 1, 2015 at 2:13 pm in reply to: Tinymce #123871

guriddo.support

Participant

Hello,

Sorry for delay. Here is the demo.

Please let us know if you need more advice on this example.

Thank you.

Kind Regards,

Will

Guriddo Support Team

June 1, 2015 at 9:50 am in reply to: JQGrid with grails #123870

guriddo.support

Participant

Hello,

The version of jqGrid you use with Grails is too old. It is no more supported.
You can use the latest version of jqGrid, but we are not sure what will be.

In all cases you can try.

Please let us us know (in case you try) if everything is working as expected.

Kind Regards,
Will

Guriddo Support Team

May 22, 2015 at 3:09 pm in reply to: Master detail with two parameters #123854

guriddo.support

Participant

Hello,

Yes, this is possible.
The idea is when the row is selected in a onSelectRow to get the data on the row columns and then pass it in the posData array.

This can be done something like this: (on Master)

$selectorder = &lt;&lt;&lt;ORDER
function(rowid, selected)
{
    if(rowid != null) {
        rowdata = jQuery(this).jqGrid(&#039;getRowData&#039;, rowid);
        // suppose COL1 and COL2 exists
        jQuery(&quot;#detail&quot;).jqGrid(&#039;setGridParam&#039;,{postData:{COL1: rowdata.COL1, COL2 : rowdata.COL2}});
        jQuery(&quot;#detail&quot;).trigger(&quot;reloadGrid&quot;);
    }
}
ORDER;
$grid-&gt;setGridEvent(&#039;onSelectRow&#039;, $selectorder);

$selectorder = <<<ORDER

function(rowid, selected)

{

if(rowid != null) {

rowdata = jQuery(this).jqGrid('getRowData', rowid);

// suppose COL1 and COL2 exists

jQuery("#detail").jqGrid('setGridParam',{postData:{COL1: rowdata.COL1, COL2 : rowdata.COL2}});

jQuery("#detail").trigger("reloadGrid");

}

ORDER;

$grid->setGridEvent('onSelectRow', $selectorder);

Then you can accept these parameters in detail PHP. See demo.

Kind Regards,
Will

Guriddo Support Team

May 21, 2015 at 10:55 am in reply to: Blank pages after changing number of rows per page #123849

guriddo.support

Participant

Hello Carlos,

I’m very sorry to say this, but we do not support versions 3.x.
I hope that in some other newer versions this problem is resolved.

Please try to upgrade to the more newer version.

You can try with some 3.X versions.
You can download them from here

Scroll to the end of the page.

Kind Regards,
Will

Guriddo Support Team

May 21, 2015 at 10:49 am in reply to: Pass Parameters to filter SQL Query #123848

guriddo.support

Participant

Hello,

Glad to hear that everything is going as expected.

Kind Regards,
Will

Guriddo Support Team

Author

Replies

Viewing 15 replies - 1,021 through 1,035 (of 1,092 total)

← 1 2 3 … 68 69 70 71 72 73 →