JavaScript Grid

Invoke the getdisplayrows method of the jqxGrid. Author: http://jqwidgets.com

by Thor Arne Johansen

HTML

<script src="http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/generatedata.js"></script>
<link rel="stylesheet" href="http://jqwidgets.com/public/jqwidgets/styles/jqx.base.css">
<link rel="stylesheet" href="http://jqwidgets.com/public/jqwidgets/styles/jqx.energyblue.css">
<script src="http://jqwidgets.com/public/jqwidgets/jqx-all.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/underscore.js/1.5.2/underscore-min.js"></script>
<div id='jqxWidget'>
    <div id="jqxgrid"></div>
</div>

<span id="out"></span>

JavaScript

var data = generatedata(5);
 var source = {
     localdata: data,
     datafields: [{
         name: 'firstname',
         type: 'string'
     }, {
         name: 'lastname',
         type: 'string'
     }, {
         name: 'productname',
         type: 'string'
     }, {
         name: 'date',
         type: 'date'
     }, {
         name: 'quantity',
         type: 'number'
     }, {
         name: 'price',
         type: 'number'
     }],
     datatype: "array"
 };

 var adapter = new $.jqx.dataAdapter(source);
 $("#jqxgrid").jqxGrid({
     width: 700,
     height: 200,
     theme: 'energyblue',
     source: adapter,
     sortable: true,
     selectionmode: 'checkbox',
     filterable: true,
     showfilterrow: true,
     columns: [{
         text: 'First Name',
         datafield: 'firstname',
         columngroup: 'Name',
         width: 90
     }, {
         text: 'Last Name',
         columngroup: 'Name',
         datafield: 'lastname',
         width: 90
     }, {
         text: 'Product',
         datafield: 'productname',
         width: 170
     }, {
         text: 'Order Date',
         datafield: 'date',
         width: 160,
         cellsformat: 'dd-MMMM-yyyy'
     }, {
         text: 'Quantity',
         datafield: 'quantity',
         width: 80,
         cellsalign: 'right'
     }, {
         text: 'Unit Price',
         datafield: 'price',
         cellsalign: 'right',
         cellsformat: 'c2'
     }]
 });

$("#jqxgrid").on('filter', function(event){    
    var grid = event.args.owner;
    var rows = getSelectedAndVisibleRows(grid);
    $("#out").text(_.pluck(rows, 'firstname').join(',')); 
});

$("#jqxgrid").on('rowunselect', function(event){    
    var grid = event.args.owner;
    var rows = getSelectedAndVisibleRows(grid);
    $("#out").text(_.pluck(rows, 'firstname').join(',')); 
});

$("#jqxgrid").on('rowselect', function(event){    
    var grid = event.args.owner;
    var rows = getSelectedAndVisibleRows(grid);
   ...