jQuery Grid Plugin - jqGrid - Topic: Get data from selected row of Master to send with Detail http://www.trirand.com/blog/?page_id=393/help/get-data-from-selected-row-of-master-to-send-with-detail Simple:Press Version 5.7.5.3 finedesignz on Get data from selected row of Master to send with Detail http://www.trirand.com/blog/?page_id=393/help/get-data-from-selected-row-of-master-to-send-with-detail#p7020 Help http://www.trirand.com/blog/?page_id=393/help/get-data-from-selected-row-of-master-to-send-with-detail#p7020 I'm not sure if my post is clear, but all I need is this:

When I add a row to the detail grid using the navGrid add button (formedit method), I want to send the rowid of selected row of the master grid to the server in the POST automatically.

Can anyone help me with this? 

Thanks in advance.

]]> Tue, 02 Jun 2009 17:33:29 +0300 finedesignz on Get data from selected row of Master to send with Detail http://www.trirand.com/blog/?page_id=393/help/get-data-from-selected-row-of-master-to-send-with-detail#p7014 Help http://www.trirand.com/blog/?page_id=393/help/get-data-from-selected-row-of-master-to-send-with-detail#p7014 I actually only need the rowid selected… I've read all the posts after searching for master, but none of them work.  Here's my code:

jQuery(document).ready(function(){
  $(”#list”).jqGrid({
    url:'data/dashboard.php',
    datatype: 'xml',
    mtype: 'GET',
    colModel :[
      {name:'fname', index:'fname', label:'First Name', width:130, editable:true,editoptions:{size:30}},
      {name:'lname', index:'lname', label:'Last Name', width:150, editable:true,editoptions:{size:30}},
      {name:'logon', index:'logon', label:'Last Logon', width:120, align:'center',editable:false},
      {name:'start', index:'start', label:'Start Date', width:120, align:'center',editable:true,editoptions:{size:20}},
      {name:'userid', index:'userid', label:'User ID', width:150,editable:true,editoptions:{size:40}},
      {name:'note', index:'note', label:'Notes', width:150, sortable:false,editable:true,edittype:"textarea", editoptions:{rows:"3",cols:"50"}}
    ],
    pager: $('#pager'),
    rowNum:60,
    rowList:[20,40,60],
    sortname: 'lname',
    sortorder: “asc”,
    viewrecords: true,
    imgpath: 'themes/steel/images',
    caption: 'Customers',
    height:300,
    onSelectRow: function(ids) {

        if(ids == null) {
        ids=0;
        if(jQuery(”#list_detail”).getGridParam('records') > 0 ) {
            jQuery(”#list_detail”).setGridParam({url:”data/subgrid.php?&q=1&id=”+ids,page:1})
            .setCaption(”License Detail: “+ids)
            .trigger('reloadGrid');
        }
        } else {
        jQuery(”#list_detail”).setGridParam({url:”data/subgrid.php?&q=1&id=”+ids,page:1})
        .setCaption(”License Detail: “+ids)
        .trigger('reloadGrid');
        }
    }
  }).navGrid('#pager',
            {add: true, edit: true, del: true, search: true}, //options
            {editCaption:'Edit License', height:200,width:600,reloadAfterSubmit:false,url:'useredit.php'}, // edit options
            {editCaption:'Add License', height:200,width:600,reloadAfterSubmit:false,url:'useredit.php'}, // add options
            {caption:'Delete License', reloadAfterSubmit:false,url:'useredit.php'}, // del options
            {width:600} // search options
            );
    $(”#license”).click(function(){
        var gr = jQuery(”#list”).getGridParam('selrow');
        if( gr != null ) jQuery(”#list”).editGridRow(gr,{height:280,reloadAfterSubmit:false});
        else alert(”Please Select a Customer if you would like to Add a New License”);
    });

// Begin License Subgrid

  $(”#list_detail”).jqGrid({
      height: 100,
      width:851,
      url:'data/subgrid.php?q=1&id=0',
      datatype: “xml”,
      mtype: “GET”,
      colModel:[
      {name:'user_id',index:'user_id', label:'User', align:'center', hidden:true, edittype:"text", editrules:{number:true}, width:180, editable:true, editoptions:{value:""+user_id, size:30}},
      {name:'app',index:'app', label:'Application', width:200, align:'center', editable:true, edittype:"select",
      editoptions:{value:"<?php include 'includes/dbconfig.inc.php';
$con = mysql_connect($dbhost, $dbuser, $dbpassword) or die("Connection Error: " . mysql_error());
mysql_select_db($database) or die("Error connecting to db.");
$query  = "SELECT id,app FROM appid";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
  echo $row['id'] . “:” . $row['app'] . “;”;
}
mysql_close($con); ?>”}},
      {name:'expiration',index:'expiration', label:'Expires', align:'center', editrules:{date:true}, datefmt:'yyyy-mm-dd', width:180, editable:true,editoptions:{size:30}}
      ],
      rowNum:5,
      rowList:[5,10,20],
        imgpath: 'themes/steel/images',
      pager: jQuery('#pager_detail'),
      sortname: 'app',
      viewrecords: true,
      sortorder: “asc”,
      caption:”License Detail”
  }).navGrid('#pager_detail',
            {add:true,edit:true,del:true,search:false}, //options
            {height:200,width:600,reloadAfterSubmit:true,url:'licenseedit.php'}, // edit options
            {height:200,width:600,reloadAfterSubmit:false,url:'licenseedit.php'}, // add options
            {reloadAfterSubmit:false,url:'licenseedit.php'}, // del options
            {width:600} // search options
            );
});

I've tried this option from another post, but I'm using only navGrid for editing (no inline editing):

jQuery(”#detail”).jqGrid({…}).navGrid(”#pgdetail”,{…},

{…}, //edit

{…

beforeShowForm: function(formid) {

// we should get the id of the master here

mid = jQuery(”#master”).getGridParam(”selrow”);

if (mid != null ) {

// now we can set it in editurl

jQuery(”#detail”).setGridParam({editurl:”myurlhere.php?masterid=”+mid});

}

}

….

How do I set the "add" url only?

]]> Tue, 02 Jun 2009 08:37:04 +0300 finedesignz on Get data from selected row of Master to send with Detail http://www.trirand.com/blog/?page_id=393/help/get-data-from-selected-row-of-master-to-send-with-detail#p7008 Help http://www.trirand.com/blog/?page_id=393/help/get-data-from-selected-row-of-master-to-send-with-detail#p7008 I have a Master/Detail grid setup, each pulls data from a different table with a common key. The master grid contains a unique “user_id” value for each row.

How do I pass this “user_id” value from the selected row of the master grid AUTOMATICALLY when I'm adding a record to the detail grid?

I don't want to have to add the same “user_id” each time a record is added to the detail grid… it should be automatically entered according to the row they've selected in the Master Grid.

]]> Mon, 01 Jun 2009 15:38:05 +0300