jQuery Grid Plugin - jqGridForum

Topic RSS

Changing a row value using drag and drop

01/01/2010
08:09

finedesignz

Member

Members

Forum Posts: 12

Member Since:
30/05/2009

Offline

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? Confused

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!

03/01/2010
19:13

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

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

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
51 Guest(s)

Currently Browsing this Page:
1 Guest(s)