Guriddo » Topic: Master detail with two parameters

Master detail with two parameters

Guriddo
Master detail with two parameters

This topic has 6 replies, 2 voices, and was last updated 8 years, 5 months ago by cliv.

Creator

Topic
May 21, 2015 at 2:29 pm #123850
cliv
Participant
Can i pass two parameters from master grid to detail grid on select row event in master (using postData or other method)?

Please post a sample…

Thank you
- This topic was modified 8 years, 6 months ago by cliv.
- This topic was modified 8 years, 6 months ago by cliv.
Creator

Topic

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

Author

Replies

May 21, 2015 at 2:47 pm #123853

cliv

Participant

I want to select row on master and read COL1 and COl2 on selected row and then pass this parameters to SQL query on detail (Select from TABLE where id=COL1 and cod=COL2).

Can be done….?

May 22, 2015 at 3:09 pm #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

June 10, 2015 at 8:11 am #123905

cliv

Participant

OK! Thank you I understand how to send….but what is the code in detail.php to pass parametrs to sql query. This is correct?


...
$COL1 = jqGridUtils::GetParam(&quot;COL1&quot;);
$COL2 = jqGridUtils::GetParam(&quot;COL2&quot;);

$grid = new jqGridRender($conn);
$grid-&gt;SelectCommand = &quot;SELECT * FROM table WHERE COD1= ? AND COD2= ?&quot;;
$grid-&gt;dataType = &#039;json&#039;;

$grid-&gt;setColModel(null, array(&amp;$COL1,&amp;$COL2));
...

...

$COL1 = jqGridUtils::GetParam("COL1");

$COL2 = jqGridUtils::GetParam("COL2");

$grid = new jqGridRender($conn);

$grid->SelectCommand = "SELECT * FROM table WHERE COD1= ? AND COD2= ?";

$grid->dataType = 'json';

$grid->setColModel(null, array(&$COL1,&$COL2));

...

June 10, 2015 at 9:12 am #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 8 years, 5 months ago by guriddo.support.

Guriddo Support Team

June 19, 2015 at 8:05 am #123933

cliv

Participant

Thank you

June 19, 2015 at 8:26 am #123935

cliv

Participant

…but what about jqGrid and stored procedure on SQLServer…
POST HERE

Author

Replies

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

You must be logged in to reply to this topic.

Registered Users: 12,233
Forums: 7
Topics: 10,943
Replies: 23,132
Topic Tags: 323

8 Users Online

Users: 5 Guests, 3 Bots

Stay connected with us in your favorite flavor!

Master detail with two parameters

Search Forum

Recent Replies

Forum Statistics

UserOnline