jQuery Grid Plugin - jqGrid

Tony,

I pulled the code with firebug so it's not formatted very well. But, you'll see 4 fields with the 1st and 4th field marked as hidden. They do not sho up on the edit form.

I have an additional bug (sorry to list it here but it may be related). The first record I delete recieves the "exParams" that I add. The second time I delete without refreshing the screen the first data is sent, even though the exParams have been updated with the correct values.

I've been to Sophia a few times, nice place. Can't speak the language but enjoy the Shopska salads.

 $("#list9").jqGrid({
     url:"/baserules/code/griddata?layout=internal&cd_table=L1",
     datatype: "xml",
     type: "GET",
     colNames:[ "ID", "Code", "Description", "table id"],
     colModel :[
     { name: "cd_id", index: "cd_id", width: "30", align:"left", hidden:true, editable: false, editrules:{edithidden:false} },
     { name: "cd_code", index: "cd_code", width: "120", align:"left", editable:true, editrules:{edithidden:true} },
     { name: "cd_description", index: "cd_description", width: "200", align:"left", editable:true, editrules:{edithidden:true} },
     { name: "cd_table", index: "cd_table", width: "20", align:"left", hidden:true, editable: false, editrules:{edithidden:false}       } ],
     rowNum:-1,
     imgpath: "/css/jqGrid-themes/basic/images",
     pager: $("#list9pager"),
     sortname: "%user%",
     viewrecords: true,
     sortorder: "",
     pginput: true,
     editurl:"/baserules/code/savedata",
     height:265
     }).attr( "ts_savedata", "{ 'cd_table': 'L1' }");

 $("#list9add").click(function(){
     sdata = $("#list9").attr("ts_savedata");
     props = {};
     //eval(sdata);
     eval( 'x = ' + sdata);
     // jqgrid needs editData set to return to host
     props['editData'] = x;
     $("#list9").editGridRow( "new", props );
 });

 $("#list9edit").click(function(){
    editRow( "#list9" );
 });

 $("#list9clicker").dblclick(function(){
     editRow( "#list9" );
 });

 });

 function upit( cellvalue, options, cellobject)
 {
     return cellvalue.toString().toUpperCase();
 }

 function deleteRow( gridId )
 {
     var gr = $(gridId).getGridParam("selrow");
     if( gr != null ) {
         var data = $(gridId).getRowData( gr );
         exData = {};
         var i = 0;
         for(var key in data)
         {
             if (i == 0) exData[key] = data[key];
             break;
         }
       
         var ref = $("#delete").attr("href") + gr;
         $(gridId).delGridRow(gr,
             {top: 200, left:300, width:320, height:120,
             mtype: "POST",
             msg:"Delete record?",
             processData: "Processing...",
             reloadAfterSubmit:true,
             delData:exData
             } );
         return true;
     }
     else {
         alert("Please select a row.");
         return false;
     }
 }

 function clickedSubmit( options, gridId )
 {
     exParam = {};
     var gr = $(gridId).getGridParam("selrow");
     if( gr != null ) {
         var data = $(gridId).getRowData( gr );
         var i = 0;
         for(var key in data)
         {
             if (i == 0) exParam[key] = data[key];
             break;
         }
     }
     return exParam;
 }

 function editRow( gridId )
 {
     var gr = $(gridId).getGridParam("selrow");
     if( gr != null ) {
        var data = $(gridId).getRowData( gr );
         exParam = {};
         var i = 0;
         for(var key in data)
         {
             if (i == 0) exParam[key] = data[key];
             break;
         }
   
         $(gridId).editGridRow( gr,{ editData: exParam,
                                onclickSubmit: function(options) { clickedSubmit( options, gridId ) }
                        } );
        return true;
     }
    else {
     alert("Please select a row.");
     return false;
    }
 }

Doug

Mark,

Thanks that worked! The hidden fields are on the form. Unfortunately, the data posted to the server is incorrect. The posted data for the hidden fields is the first record displayed in the form. As you scroll those data elements aren't being updated. I'm still in the same situation as I am with the delete function. The hidden elements can only be set once.

Firebug - net tab

Post header for first record

(cd_table and cd_id are hidden)

I scroll back to the previous record and hit submit and get

The code, description and your id are all correct but the 2 hidden fields reflect what was in the first record, specifically cd_id which is the primary key.

Doug

Ok, I found a solution but don't fully understand why the original code doesn't work.

I changed out line 1187 in grid.formedit.js  on v3.5.2

from

                            var postd = $.extend({oper:"del", id:postdata}, p.delData, onCS);

to

                            var postd = $.extend({oper:"del", id:postdata}, rp_ge.delData, onCS);

and it works. After the modal dialog is presented "p" comes back with the old delData.

Tony,

The lines listed above were for the delgridrow, does 3.6 fix the edit issue as well? I'm assuming it's something similar?

Doug