duntech on Master Detail with 3 grids

Fri, 14 Jan 2011 07:18:57 +0200

I have attempted to use the master detail feature however it only allows me to map one grid as a child. I will have 3 grids, the main one has a customer list, a second grid will contain internet circuits the customer has from us and the third grid will have phone circuits they have from us. So what I would like is when a customer is selected it then updates the other two grids with circuit and phone number information. I can get this to work with select a customer and see phone information as well as select a customer and see internet circuit information. I cannot however get it to work with both together.

I am using the stock grid.php and have copied the stock detail.php to vlan_detail.php and tdm_detail.php. If I remove vlan_detail.php it shows everything perfect minus vlan_detail.php info. If I remove tdm_detail.php it shows everything perfect. I would like it to show both vlan_detail.php AND tdm_detail.php.

My page looks like this:

          <b>Customers</b>
          <?php include ("grid.php");?>
      </div>
      <div>
          <b>VLAN Information</b>
          <?php include ("vlan_detail.php");?>

<b>TDM Information</b>
<?php include ("tdm_detail.php");?>

UPDATE: I got it to work with the tech support help below..

There is nothing special, but maybe you will need to pay attention on some things:
Considering this example:
http://www.trirand.com/blog/ph.....efault.php

1. you will need to modify the onselect event in MASTER GRID so that it affect both grids
Suppose you have detail1 and detail2 subgrids

$selectorder = <<<ORDER
function(rowid, selected)
{
    if(rowid != null) {
        jQuery("#detail1").jqGrid('setGridParam',{postData:{CustomerID:rowid}});
        jQuery("#detail1").trigger("reloadGrid");

jQuery("#detail2").jqGrid('setGridParam',{postData:{CustomerID:rowid}});
jQuery("#detail2").trigger("reloadGrid");

// Enable CRUD buttons in navigator when a row is selected
}
}
ORDER;

2. When constructing the second grid be a sure that they have different id

for detayl1 grid do this

$grid->renderGrid("#detail1","#pgdetail1", true, $summaryrow, array(&$rowid), true,true);

for detail2 grid

$grid->renderGrid("#detail2","#pgdetail2", true, $summaryrow, array(&$rowid), true,true);

Also don't forget to define the table on the detail pages.

$grid->table = "table name";

jQuery Grid Plugin - jqGrid - Topic: Master Detail with 3 grids

duntech on Master Detail with 3 grids