jQuery EasyUI DataGrid Filter Row showColumn hideColumn
HTML
<div class="easyui-panel" style="width:900px; height:350px; padding:6px;">
<div class="easyui-layout" data-options="fit:true">
<div data-options="region:'center', border:false">
<table id="dg"></table>
</div>
<div data-options="region:'south', split:false, border:false" style="padding:6px;">
<a href="#" class="easyui-linkbutton" iconCls="icon-add" plain="false" onclick="javascript:$('#dg').edatagrid('addRow')">New</a>
<a href="#" class="easyui-linkbutton" iconCls="icon-cancel" plain="false" onclick="$('#dg').edatagrid('cancelRow');">Cancel</a> </div>
</div>
</div>
CSS
</style>
<link rel="stylesheet" type="text/css" href="http://www.jeasyui.com/easyui/themes/default/easyui.css">
<link rel="stylesheet" type="text/css" href="http://www.jeasyui.com/easyui/themes/icon.css">
<link rel="stylesheet" type="text/css" href="http://www.jeasyui.com/easyui/demo/demo.css">
<script type="text/javascript" src="http://code.jquery.com/jquery-1.11.3.js"></script>
<script type="text/javascript" src="http://www.jeasyui.com/easyui/jquery.easyui.min.js"></script>
<script type="text/javascript" src="http://www.jeasyui.com/easyui/jquery.edatagrid.js"></script>
<script type="text/javascript" src="http://www.jeasyui.com/easyui/datagrid-filter.js"></script>
<style>
JavaScript
$(function(){
var dg = $('#dg').edatagrid();
dg.edatagrid({
title:"Test DataGrid",
fit: true,
pagination: true,
singleSelect:true,
striped:true,
rownumbers: true,
fitColumns: true,
nowrap: true,
data:data,
columns:[[ {field:'ck', checkbox:true, hidden: false},
{field:'itemid',title:'Item ID',
editor:{type:'textbox'}
},
{field:'productid',title:'Product',
editor:{type:'textbox'}
},
{field:'listprice',align:'right',title:'List Price',
editor:{type:'combobox'}
},
{field:'unitcost',align:'right',title:'Unit Cost',
editor:{type:'textbox'}
},
{field:'attr1',title:'Attribute',
editor:{type:'textbox'}
},
{field:'status',align:'center',title:'Status' },
]],
onAdd: function(index, row) {
var itemidEditor = $(this).edatagrid('getEditor',{index:index, field:'itemid'});
$(itemidEditor.target).textbox('textbox').focus();
}
});
//enable filter
dg.datagrid('enableFilter', [{
field:'listprice',
type:'numberbox',
options:{precision:1},
op:['equal','notequal','less','greater']
},{
field:'unitcost',
type:'numberbox',
options:{precision:1},
op:['equal','notequal','less','greater']
},{
field:'status',
type:'combobox',
options:{
panelHeight:'auto',
data:[{value:'',text:'All'},{value:'P',text:'P'},{value:'N',text:'N'}],
onChange:function(value){
if (value == ''){
dg.datagrid('removeFilterRule', 'status');
} else {
dg.datagrid('addFilterRule', {
field: 'status',
op: 'equal',
value: value
});
}
dg.datagrid('doFilter');
}
}
...