belha on storage query result into jqGrid object when use local data

Tue, 05 Nov 2013 17:39:25 +0200

Hello,

i know that jqGrid isn't optimized to be used with local data. But in my case, I use local data. to be more faster, I had a variable which stores result when I sort ou filter my grid. Is it possible to implement it, in the futur version of jqGrid for people like me which used local data.

below the code that I could add (in red)

$.fn.jqGrid = function( pin ) {
   if (typeof pin === 'string') {
       var fn = $.jgrid.getMethod(pin);
       if (!fn) {
           throw ("jqGrid - No such method: " + pin);
       }
       var args = $.makeArray(arguments).slice(1);
       return fn.apply(this,args);
   }
   return this.each( function() {
       if(this.grid) {return;}

       var p = $.extend(true,{
           url: "",
           height: 150,
           page: 1,
           rowNum: 20,
           rowTotal : null,
           records: 0,
           pager: "",
           pgbuttons: true,
           pginput: true,
           colModel: [],
           rowList: [],
           colNames: [],
           sortorder: "asc",
           sortname: "",
           allQueryResults: null,
           datatype: "xml",

in addJSONData

addJSONData = function(data,t, rcnt, more, adjust) {
...

            ts.p.lastpage = lp === undefined ? 1 : lp;
           ts.p.records = $.jgrid.getAccessor(data,dReader.records) || 0;
           ts.p.userData = $.jgrid.getAccessor(data,dReader.userdata) || {};
           ts.p.allQueryResults = $.jgrid.getAccessor(data,dReader.allQueryResults) || {};

in addLocalData

var svgAllQueryResults = queryResults;
           queryResults = queryResults.slice( (page-1)*recordsperpage , page*recordsperpage );
           query = null;
           cmtypes = null;
           retresult[ts.p.localReader.total] = totalpages;
           retresult[ts.p.localReader.page] = page;
           retresult[ts.p.localReader.records] = total;
           retresult[ts.p.localReader.root] = queryResults;
           retresult[ts.p.localReader.userdata] = ts.p.userData;
           retresult[ts.p.localReader.allQueryResults] = svgAllQueryResults;
           queryResults = null;
           return retresult;

ts.p.localReader = $.extend(true,{
           root: "rows",
           page: "page",
           total: "total",
           records: "records",
           repeatitems: false,
           cell: "cell",
           id: "id",
           allQueryResults: "allQueryResults",
           userdata: "userdata",
           subgrid: {root:"rows", repeatitems: true, cell:"cell"}
       },ts.p.localReader);

Regards

Belha

jQuery Grid Plugin - jqGrid - Topic: storage query result into jqGrid object when use local data

belha on storage query result into jqGrid object when use local data