ezhidze on cellEdit + setGridParam data + sort

Mon, 06 Sep 2010 20:34:50 +0300

Hi!

I'm trying to made a local data self-expandible table with cellEdit and auto-sorting.

I.e. last row of the table is always blank, and when user fills the first cell in that line, table must reorder itself and add a blank row at the end. After every edit the hidden input's value must be set to ensure that I can catch entrie array via $_POST.

While I experimented with just 'clientSide', all was almost good – except for one thing: when reordering the data in the lines were mixed in some strange order.

Then I formed data array, and set .setGridParam({ data: … }) to it.

Row adding still works, but data isn't saved anymore.

Second question is how I can made table hard order itself by the first column (len) without letting user to sort any othe way?

var pr3mdl1 = new Array ();
pr3mdl1[0] = {name:'len',index:'len',label:'Len,"', width:60, sortable:true, sorttype:'int', resizable:false, editable:true,editrules:{number:true}};

pr3tbl1Grid = jQuery("#pr3tbl1″).jqGrid({
   datatype: "clientSide",
   colModel: pr3mdl1,
   loadonce: true,
   height: "100%",

cellEdit: true,
cellsubmit: 'clientArray',

viewsortcols: [false,'vertical',false],

caption:"Length, yd:",

sortname: 'len',
sortorder: 'desc',

   afterSaveCell: function(rowid,celname,value,iRow,iCol) {
       if(this.reccount <= rowid) {
           rowLen = jQuery("#"+this.id).getCell(rowid, 'len');
           if (rowLen != "") {
               jQuery("#"+this.id).setGridParam({sortname:'len'}).trigger('reloadGrid');
               jQuery("#"+this.id).addRowData(this.reccount + 1,{len:"",w1:"",w2:"",w3:""},'last');
           }
       }
       jQuery("#table1input").val(pr3tbl1Data.toJSON());
   }
});

var pr3tbl1Data = [
   {len:"24",w1:"1",w2:"35",w3:"24.24"},
   {len:"50",w1:"2",w2:"35",w3:"50.50"},
   {len:"45",w1:"3",w2:"45",w3:""},
   {len:"",w1:"",w2:"",w3:""}
];

pr3tbl1Grid.setGridParam({ data: pr3tbl1Data });
pr3tbl1Grid[0].refreshIndex();
pr3tbl1Grid.trigger("reloadGrid");

</script>

jQuery Grid Plugin - jqGrid - Topic: cellEdit + setGridParam data + sort

ezhidze on cellEdit + setGridParam data + sort