Rico LiveGrid-JavaScript Buffer
Rico.loadModule('LiveGridAjax','LiveGridMenu','greenHdg.css');
var grid, buffer;
Rico.onLoad( function() {
var opts = {
frozenColumns : 1,
useUnformattedColWidth: false,
columnSpecs : [{width:200}]
};
buffer=new Rico.Buffer.AjaxSQL(jsfetch);
grid=new Rico.LiveGrid ('jsgrid', buffer, opts);
grid.menu=new Rico.GridMenu();
});
function jsfetch(options) {
Rico.writeDebugMsg("jsfetch");
var newRows=[], totrows=500;
var offset=options.parameters.offset;
var limit=Math.min(totrows-offset,options.parameters.page_size)
for (var r=0; r
row.push(new Date().toString());
row.push(offset.toString());
for (var c=2; c<5; c++)
row.push('cell '+(r+offset)+':'+c);
newRows.push(row);
}
options.onComplete(newRows,false,totrows);
}
div.ricoLG_cell { white-space: nowrap; }
This example demonstrates how to substitute a javascript
call for an AJAX request in the AjaxSQL buffer. Rather than
passing a string containing the url to the data provider,
you pass a function to the Rico.Buffer.AjaxSQL constructor.
buffer=new Rico.Buffer.AjaxSQL(jsfetch);
function jsfetch(options) {
var newRows=[], totrows=500;
var offset=options.parameters.offset;
var limit=Math.min(totrows-offset,options.parameters.page_size)
for (var r=0; r<limit; r++) {
var row=[];
row.push(new Date().toString());
row.push(offset.toString());
for (var c=2; c<5; c++) row.push('cell '+(r+offset)+':'+c);
newRows.push(row);
}
options.onComplete(newRows,false,totrows);
}