tony on Changing a row value using drag and drop

Sun, 03 Jan 2010 19:13:47 +0200

Hello,

http://www.trirand.com/jqgridw.....ween_grids

Regards

Tony

finedesignz on Changing a row value using drag and drop

Fri, 01 Jan 2010 08:09:18 +0200

How do I change a row value when using the drag and drop between grids?

I have 3 grids, representing 3 "groups" of people. Each row (person) has fname, lname, and fsg_id, retrieved from a mysql database. When I drop the selected row from one grid to another grid, I would like the fsg_id of the row to update with the groupid of the target grid, and then reload all grids.

I'm still a little new to jqgrid... Can you post an example of how I can accomplish this?

Here's what I have so far:

var lastsel;
jQuery(document).ready(function(){
$("#fsg1").jqGrid({
url:'fsg/fsgget.php?q=1&groupid='+fsg1id,
colModel :[
{name:'lname', index:'lname', label:'Last', width:80},
{name:'fname', index:'fname', label:'First', width:80},
{name:'fsg_id', index:'fsg_id', label:'Group', editable:true, width:40},
],
pager: $('#pfsg1'),
caption: 'Group 1',

onSelectRow: function(id){ if(id && id!==lastsel){ $('#fsg1').jqGrid('saveRow',lastsel); $('#fsg1').jqGrid('editRow',id,true); lastsel=id; } },

}).navGrid('#pfsg1',
{add:false,edit:true,del:false,search:false}, //options
{width:300,reloadAfterSubmit:true,url:'fsg/fsgedit.php'}, // edit options
{width:300,}, // add options
{width:300}, // del options
{width:300} // search options
);

$("#fsg2").jqGrid({
    url:'fsg/fsgget.php?q=2&groupid=2',
    userdata: {fsgid:2},
    colModel :[
     {name:'lname', index:'lname', label:'Last', width:80},
      {name:'fname', index:'fname', label:'First', width:80},
      {name:'fsg_id', index:'fsg_id', label:'Group', editable:true, width:50},
    ],
    pager: $('#pfsg2'),
    caption: 'Group 2',
    onSelectRow: function(id){ if(id && id!==lastsel){ $('#fsg2').saveRow(lastsel); $('#fsg2').editRow(id,true); lastsel=id; } },

}).navGrid('#pfsg2',
            {add:false,edit:true,del:false,search:false}, //options
            {width:300,reloadAfterSubmit:true,url:'fsg/fsgedit.php'}, // edit options
            {width:300,}, // add options
            {width:300}, // del options
            {width:300} // search options
            );

jQuery("#fsg1").jqGrid('gridDnD',{connectWith:'#fsg2'});

jQuery("#fsg2").jqGrid('gridDnD',{connectWith:'#fsg1'});

Thanks in advance!

jQuery Grid Plugin - jqGrid - Topic: Changing a row value using drag and drop

tony on Changing a row value using drag and drop

finedesignz on Changing a row value using drag and drop