Guriddo » guriddo.support's Replies

guriddo.support

Guriddo

Forum Replies Created

Viewing 15 replies - 436 through 450 (of 1,092 total)

← 1 2 3 … 29 30 31 … 71 72 73 →

Author

Replies

November 28, 2017 at 11:59 am in reply to: Search Dialog not in dialog #126461

guriddo.support

Participant

Hello,

Thank you for the feedback and solution provided.

Kind Regards,

Will

Guriddo Support Team

November 28, 2017 at 11:53 am in reply to: Pass parameter to main grid for sql where clause #126458

guriddo.support

Participant

Hello,

It seems you make a wrong combination.
To note when you set the parameter with grid options you will need to use postData.

Bellow is the full source code without using postData, but setUrl, which you should do in order this to work. Please note the use of setUrl parameter

&lt;!--?php include_once &#039;jq-config.php&#039;; 
// include the jqGrid Class 
require_once &#039;../javascript/jqgrid/php/jqGrid.php&#039;; 
// include the PDO driver class 
require_once &#039;../javascript/jqgrid/php/jqGridPdo.php&#039;; 

if(!isset($TestID) ) { 
    $TestID = jqGridUtils::GetParam(&#039;id&#039;, &#039;&#039;); 
} 
$id = $TestID; 

// Connection to the server 
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD); 

// Create the jqGrid instance 
$grid = new jqGridRender($conn); 

// setUrl 
$grid-&gt;setUrl(&#039;getTestQuestionsFO.php?id=&#039;.$TestID);

// the actual query for the grid data

$grid-&gt;SelectCommand = &quot;SELECT
tr_cyotestquestion.TestID,
tr_cyotestquestion.FixedOrder,
tr_cyoquestion.Title,
tr_cyoquestion.CYOQuestionID
FROM
tr_cyoquestion
INNER JOIN tr_cyotestquestion ON tr_cyotestquestion.CYOQuestionID = tr_cyoquestion.CYOQuestionID
WHERE
tr_cyotestquestion.FixedOrder IS NOT NULL and
tr_cyotestquestion.TestID = &quot;.$id;

<!--?php include_once 'jq-config.php';

// include the jqGrid Class

require_once '../javascript/jqgrid/php/jqGrid.php';

// include the PDO driver class

require_once '../javascript/jqgrid/php/jqGridPdo.php';

if(!isset($TestID) ) {

$TestID = jqGridUtils::GetParam('id', '');

}

$id = $TestID;

// Connection to the server

$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Create the jqGrid instance

$grid = new jqGridRender($conn);

// setUrl

$grid->setUrl('getTestQuestionsFO.php?id='.$TestID);

// the actual query for the grid data

$grid->SelectCommand = "SELECT

tr_cyotestquestion.TestID,

tr_cyotestquestion.FixedOrder,

tr_cyoquestion.Title,

tr_cyoquestion.CYOQuestionID

FROM

tr_cyoquestion

INNER JOIN tr_cyotestquestion ON tr_cyotestquestion.CYOQuestionID = tr_cyoquestion.CYOQuestionID

WHERE

tr_cyotestquestion.FixedOrder IS NOT NULL and

tr_cyotestquestion.TestID = ".$id;

Kind Regards,
Will

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

Guriddo Support Team

November 27, 2017 at 4:48 pm in reply to: Search Dialog not in dialog #126453

guriddo.support

Participant

Hello,

Thank you for the good question.

To do what you want you will need to disable using jqModal, which is done when this parameter is set to false.

Currently there is a small problem with this combibnation and the overlay, so the solution is with the following code


&lt;div id=&quot;search_layer&quot;&gt;&lt;/div&gt;

jQuery(&quot;#allsitesgrid&quot;).jqGrid(&#039;navGrid&#039;,&#039;#allsitesgridnav&#039;,
  {search:true, add:false,edit:false,del:false, searchtext: &#039;Filter&#039;}, //options
  {}, // edit options
  {}, // add options
  {}, // del options
  {
    overlay: 0, 
    layer: &#039;search_layer&#039;,
    jqModal : false,
    afterShowSearch : 	function() {
        $(&quot;.jqgrid-overlay&quot;).hide();
    }
  } // search options
);

jQuery("#allsitesgrid").jqGrid('navGrid','#allsitesgridnav',

{search:true, add:false,edit:false,del:false, searchtext: 'Filter'}, //options

{}, // edit options

{}, // add options

{}, // del options

{

overlay: 0,

layer: 'search_layer',

jqModal : false,

afterShowSearch : function() {

$(".jqgrid-overlay").hide();

}

} // search options

);

Kind Regards,
Will

This reply was modified 8 years, 4 months ago by guriddo.support. Reason: Missing adding jqModal

Guriddo Support Team

November 27, 2017 at 4:21 pm in reply to: Pass parameter to main grid for sql where clause #126452

guriddo.support

Participant

Hello,

The code

if(!isset($TestID) ) {
$TestID = jqGridUtils::GetParam($TestID);
}

if(!isset($TestID) ) {

$TestID = jqGridUtils::GetParam($TestID);

}

does not correspond to


$grid-&gt;setUrl(‘getTestQuestionsFO.php?id=’.$TestID);
..

$grid->setUrl(‘getTestQuestionsFO.php?id=’.$TestID);

Replace

if(!isset($TestID) ) {
$TestID = jqGridUtils::GetParam($TestID);
}

if(!isset($TestID) ) {

$TestID = jqGridUtils::GetParam($TestID);

}

with

if(!isset($TestID) ) {
$TestID = jqGridUtils::GetParam(&#039;id&#039;);
}

if(!isset($TestID) ) {

$TestID = jqGridUtils::GetParam('id');

}

TestID is variable, while id you set in the url is parameter.

Kind Regards,
Will

Guriddo Support Team

November 27, 2017 at 1:31 pm in reply to: Pass parameter to main grid for sql where clause #126446

guriddo.support

Participant

Hello,

As you correctly mentioned we do two pass – one for creation of the grid script and the another to obtain the data. If the grid file is included in a index file which contain some variables used, then these variabls does not exists when a second call is made.

To overcome this problem you can set these variables to be passed throught the grid url (using the options of the grid) below is a possible solution of the problem:

include_once &#039;jq-config.php&#039;;

// include the jqGrid Class
require_once &quot;../javascript/jqgrid/php/jqGrid.php&quot;;
// include the PDO driver class
require_once “../javascript/jqgrid/php/jqGridPdo.php”;

if(!isset($TestID) ) {
    $TestID = jqGridUtils::GetParam(&#039;MyParam&#039;,&#039;Deafult_Value&#039;);
}

$id = $TestID;

// Connection to the server
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Create the jqGrid instance
$grid = new jqGridRender($conn);

// options
$grid-&gt;setGridOptions(array(&quot;postData&quot;=&gt;array(&quot;MyParam&quot;=&gt;$TestID)));

// the actual query for the grid data
$grid-&gt;SelectCommand = &quot;SELECT
tr_cyotestquestion.TestID,
tr_cyotestquestion.FixedOrder,
tr_cyoquestion.Title,
tr_cyoquestion.CYOQuestionID
FROM
tr_cyoquestion
INNER JOIN tr_cyotestquestion ON tr_cyotestquestion.CYOQuestionID = tr_cyoquestion.CYOQuestionID
WHERE
tr_cyotestquestion.FixedOrder IS NOT NULL and
tr_cyotestquestion.TestID = &quot;.$id;

...

include_once 'jq-config.php';

// include the jqGrid Class

require_once "../javascript/jqgrid/php/jqGrid.php";

// include the PDO driver class

require_once “../javascript/jqgrid/php/jqGridPdo.php”;

if(!isset($TestID) ) {

$TestID = jqGridUtils::GetParam('MyParam','Deafult_Value');

}

$id = $TestID;

// Connection to the server

$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Create the jqGrid instance

$grid = new jqGridRender($conn);

// options

$grid->setGridOptions(array("postData"=>array("MyParam"=>$TestID)));

// the actual query for the grid data

$grid->SelectCommand = "SELECT

tr_cyotestquestion.TestID,

tr_cyotestquestion.FixedOrder,

tr_cyoquestion.Title,

tr_cyoquestion.CYOQuestionID

FROM

tr_cyoquestion

INNER JOIN tr_cyotestquestion ON tr_cyotestquestion.CYOQuestionID = tr_cyoquestion.CYOQuestionID

WHERE

tr_cyotestquestion.FixedOrder IS NOT NULL and

tr_cyotestquestion.TestID = ".$id;

...

or add MyParam to the grid url

$grid-&gt;setUrl(&quot;grid.php?MyParam=&quot;.$TestID);
...

1 2	$grid->setUrl("grid.php?MyParam=".$TestID); ...

Hope this helps

Kind Regards,
WIll

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

Guriddo Support Team

November 27, 2017 at 1:11 pm in reply to: PivotGrid Reload Example #126445

guriddo.support

Participant

Hello,

Sorry for the wrong command provided. Instead of destroy a unload function should be used – i.e replace

$.jgrid.gridDestroy( grid );
...

1 2	$.jgrid.gridDestroy( grid ); ...

with

$.jgrid.gridUnload( grid );
...

1 2	$.jgrid.gridUnload( grid ); ...

Below is a demo

Guriddo Support Team

November 27, 2017 at 12:32 pm in reply to: Multi Y Dimension #126444

guriddo.support

Participant

Hello,

You have a e-mail.

Kind Regards,
Will

Guriddo Support Team

November 24, 2017 at 3:03 pm in reply to: Multi Y Dimension #126440

guriddo.support

Participant

Hello,

First of all thank you very much for the test case and demo and that you find these problems.

1.Currently there is a problem when rowTotal is set to true. We will try to fix this ASAP. In order to achieve what you want temporary set this parameter to false – i.e:

$pivot-&gt;setPivotOptions(array(
&quot;rowTotals&quot; =&gt; false,
&quot;colTotals&quot; =&gt; true
));

$pivot->setPivotOptions(array(

"rowTotals" => false,

"colTotals" => true

));

2. The code for the buttons in pivot is fixed in JavaScript in GitHub. If you have difficulties to get it, please let us know

Kind Regards,
Will

Guriddo Support Team

November 20, 2017 at 11:07 am in reply to: Colmenu outside viewport #126433

guriddo.support

Participant

Hello,

Thank you for reporting this problem.

We will try to fix the problem during this week and we will let you know.

Kind Regards,

Will

Guriddo Support Team

November 17, 2017 at 4:21 pm in reply to: Printing jqGrid #126431

guriddo.support

Participant

Hello,

We have develop a new method exportToHtml with ability to print. If you are interested you ca get this new feature from GitHub.

Kind Regards,

Will

Guriddo Support Team

November 14, 2017 at 12:20 pm in reply to: Search/refresh buttons missing from pager #126430

guriddo.support

Participant

Hello,

In your example when use setTimeout it is working. Anyway we will document this behavior in our docs.

Thank you again for your feedback

Kind Regards

Will

Guriddo Support Team

November 7, 2017 at 3:28 pm in reply to: Search/refresh buttons missing from pager #126424

guriddo.support

Participant

Thanks for the example.

We always ask for the demo, since we where not able to reproduce at our end.

Now with your example it is clear – this is not a bug, but a way the setRegional works.

In order this to work you will need to enclose the setRegional in setTimeout function immediate after reloading the grid (100 ms is enough) .

We will describe in the docs that when calling after reloading the grid setRegional should be enclosed in setTimeout.

Thank you very much for your investigations and recommendations.

Kind Regards,

Will

Guriddo Support Team

November 7, 2017 at 1:19 pm in reply to: Search/refresh buttons missing from pager #126420

guriddo.support

Participant

Hello,

Thank you very much for the feedback and investigations.

Could you please prepare a simple demo or sequence of functions calling which demonstrates the problem and send it to us.?

Thank you in advance.

Kind Regards,

Will

Guriddo Support Team

November 3, 2017 at 10:51 am in reply to: Multi Y Dimension #126417

guriddo.support

Participant

We will try to reproduce the proble, but could you please send to us a small working example, which demonstrates the problem.

Also which version of the JavaScript is used?

Kind Regards,

Will

Guriddo Support Team

November 3, 2017 at 10:46 am in reply to: Search/refresh buttons missing from pager #126416

guriddo.support

Participant

Hello,

Thank you for the example and the test case.

One possible reason for this is that you have update the jqGrid file, but not the language file (grid.locale-en.js by example). Be a sure that this file is upgraded too.

Try to clear your browser cache reload all the needed files and try.

Do not have any other idea.

If possible install the non minified version jquery.jqGrid.js and try to debug the code using a javascript debugger, but this maybe will be very hard to do.

Kind Regards,

WIll

Guriddo Support Team

Author

Replies

Viewing 15 replies - 436 through 450 (of 1,092 total)

← 1 2 3 … 29 30 31 … 71 72 73 →