EasyUI DataGrid中loadFilter 属性的用法
来源:互联网 发布:js 向数组添加对象 编辑:程序博客网 时间:2024/04/27 06:45
DataGrid属性中有一个用于过滤数据的属性loadFilter
可以根据需求进行过滤,示例如下:
$('#dg_fc').datagrid({
fit : true,
method : 'post',
url : rootPath + 'overdue_query_list.xhtml',
rownumbers : true,
toolbar :'#toolbar_fc', //指定toolbar
singleSelect : true,
nowrap : true,
striped : true,
remoteSort :false,
pagination : true,
pageSize : 15,
pageList : [5,10,15,20,25,30,35,40,45,50],
frozenColumns:[[{field:'id', checkbox:true}]],
columns : columns_fc,
loadFilter : function(data){
//过滤数据
var value={
total:data.total,
rows:[]
};
var x=0;
for (var i = 0; i < data.rows.length; i++) {
if(data.rows[i].tranModel.productType=="01"){
value.rows[x++]=data.rows[i];
}
}
return value;
},
onLoadSuccess : function() {
//在数据加载成功的时候触发
$('#dg_fc').datagrid('clearChecked');
$("#dg_fc").datagrid('tooltip'); //数据过长会浮动显示
}
fit : true,
method : 'post',
url : rootPath + 'overdue_query_list.xhtml',
rownumbers : true,
toolbar :'#toolbar_fc', //指定toolbar
singleSelect : true,
nowrap : true,
striped : true,
remoteSort :false,
pagination : true,
pageSize : 15,
pageList : [5,10,15,20,25,30,35,40,45,50],
frozenColumns:[[{field:'id', checkbox:true}]],
columns : columns_fc,
loadFilter : function(data){
//过滤数据
var value={
total:data.total,
rows:[]
};
var x=0;
for (var i = 0; i < data.rows.length; i++) {
if(data.rows[i].tranModel.productType=="01"){
value.rows[x++]=data.rows[i];
}
}
return value;
},
onLoadSuccess : function() {
//在数据加载成功的时候触发
$('#dg_fc').datagrid('clearChecked');
$("#dg_fc").datagrid('tooltip'); //数据过长会浮动显示
}
}};
中:
loadFilter : function(data){
//过滤数据
var value={
total:data.total,
rows:[]
};
var x=0;
for (var i = 0; i < data.rows.length; i++) {
if(data.rows[i].tranModel.productType=="01"){
value.rows[x++]=data.rows[i];
}
}
return value;
}
//过滤数据
var value={
total:data.total,
rows:[]
};
var x=0;
for (var i = 0; i < data.rows.length; i++) {
if(data.rows[i].tranModel.productType=="01"){
value.rows[x++]=data.rows[i];
}
}
return value;
}
可以使用自己逻辑进行过滤数据,用于在data中展示。
原数据如下:
{
"total": 1,
"rows": [
{
"tid": "30",
"name": "小四",
"no": "500240198408085770",
"surplusamount": null,
"maxamount": null,
"creditpoint": null,
"phone": "12300000000",
"tranModel": {
"id": 30,
"userId": 1,
"state": 8,
"errorMsg": null,
"loanInitRate": 0.0005,
"loanRealRate": 0.0005,
"loanInitManageRate": 0.001333,
"loanRealManageRate": 0.001333,
"loanReceipts": "tjk012016011500006",
"transReceipts": "075598712016000000027-013",
"loanPrincipal": 1000,
"loanDate": 1452443160000,
"planRepayDays": 7,
"planRepayDate": 1452960000000,
"planRepayInterest": 54.99,
"planRepayAccrual": 15,
"planRepayFee": 39.99,
"planRepayAmount": 1054.99,
"fixThirdpartyCost": 2,
"loanSysCardID": 1,
"loanUserCardID": 1,
"reviewDate": 1452788760000,
"reviewSysUser": 9999,
"transferDate": 1452443160000,
"transferSysUser": 9999,
"leftAmount": 1000,
"leftRepayInterest": 0,
"realRepayDate": null,
"realRepayDays": 9,
"realRepayInterest": null,
"realRepayAccrual": null,
"realRepayFee": null,
"realRepayOverDueAccrual": null,
"realRepayOverDueFee": null,
"realRepayAmount": null,
"realRepayPrincipal": null,
"realThirdpartyCost": null,
"repaySysCardID": null,
"failCause": null,
"contractSignature": "",
"contractState": 1,
"oldState": null,
"repayReceipts": null,
"discountAmount": 0,
"discountType": null,
"couponNo": null,
"comments": null,
"version": 1,
"productType": "01",
"overdueRate": 0.0002,
"overdueManageRate": 0.0005332,
"phasedNums": null,
"repayTimes": 0,
"isLoanNormCheck": 1,
"illegalUseAdd": null,
"overDueAdd": null,
"iVersion": 2,
"thirdpartyRepayFeeRate": null
},
"bankCard": "中国银行 尾号0000",
"bankCode": 3,
"accountNo": "6212480000000000",
"msgCount": null,
"apartDay": null,
"loanPoundage": 54.99,
"overdueAmount": 5.13,
"overdueDay": 3,
"bankName": "中国银行",
"prmList": null,
"reviewSysUserStr": null,
"apartDayFQ": null,
"currentTime": null
}
]
}
"total": 1,
"rows": [
{
"tid": "30",
"name": "小四",
"no": "500240198408085770",
"surplusamount": null,
"maxamount": null,
"creditpoint": null,
"phone": "12300000000",
"tranModel": {
"id": 30,
"userId": 1,
"state": 8,
"errorMsg": null,
"loanInitRate": 0.0005,
"loanRealRate": 0.0005,
"loanInitManageRate": 0.001333,
"loanRealManageRate": 0.001333,
"loanReceipts": "tjk012016011500006",
"transReceipts": "075598712016000000027-013",
"loanPrincipal": 1000,
"loanDate": 1452443160000,
"planRepayDays": 7,
"planRepayDate": 1452960000000,
"planRepayInterest": 54.99,
"planRepayAccrual": 15,
"planRepayFee": 39.99,
"planRepayAmount": 1054.99,
"fixThirdpartyCost": 2,
"loanSysCardID": 1,
"loanUserCardID": 1,
"reviewDate": 1452788760000,
"reviewSysUser": 9999,
"transferDate": 1452443160000,
"transferSysUser": 9999,
"leftAmount": 1000,
"leftRepayInterest": 0,
"realRepayDate": null,
"realRepayDays": 9,
"realRepayInterest": null,
"realRepayAccrual": null,
"realRepayFee": null,
"realRepayOverDueAccrual": null,
"realRepayOverDueFee": null,
"realRepayAmount": null,
"realRepayPrincipal": null,
"realThirdpartyCost": null,
"repaySysCardID": null,
"failCause": null,
"contractSignature": "",
"contractState": 1,
"oldState": null,
"repayReceipts": null,
"discountAmount": 0,
"discountType": null,
"couponNo": null,
"comments": null,
"version": 1,
"productType": "01",
"overdueRate": 0.0002,
"overdueManageRate": 0.0005332,
"phasedNums": null,
"repayTimes": 0,
"isLoanNormCheck": 1,
"illegalUseAdd": null,
"overDueAdd": null,
"iVersion": 2,
"thirdpartyRepayFeeRate": null
},
"bankCard": "中国银行 尾号0000",
"bankCode": 3,
"accountNo": "6212480000000000",
"msgCount": null,
"apartDay": null,
"loanPoundage": 54.99,
"overdueAmount": 5.13,
"overdueDay": 3,
"bankName": "中国银行",
"prmList": null,
"reviewSysUserStr": null,
"apartDayFQ": null,
"currentTime": null
}
]
}
该例子中以字段json中productType进行过滤,返回满足条件的数据,去除不符合条件数据。
注意:这个函数必须返回包含'total'和'rows'属性的标准数据对象。
0 0
- EasyUI DataGrid中loadFilter 属性的用法
- EasyUI DataGrid中loadFilter 属性的用法
- EasyUI DataGrid的loadFilter属性使用
- easyui datagrid loadFilter loadData
- 简单总结easyUI中datagrid的用法
- easyui的datagrid中一些用法
- easyUI中datagrid的column属性的介绍
- easyui中datagrid如何显示子对象的属性
- easyui中datagrid的row
- easyui 中datagrid的使用方法
- EasyUI中datagrid的样式
- EasyUI中datagrid的样式
- Easyui-tree 加载json数据及loadFilter的使用
- Easyui-tree 加载json数据及loadFilter的使用
- easyUI中datagrid如何展示对象下属性的多个子属性
- EasyUI-datagrid属性formatter
- easyUi datagrid 属性
- jquery easyui datagrid 用法
- SpringMVC Valication的使用
- Main函数参数argc,argv说明
- shell脚本结构示例
- 依赖倒置原则
- 阐述二维码的原理以及使用google api和PHP QR Code来生成二维码
- EasyUI DataGrid中loadFilter 属性的用法
- 表格提交中出现的中文乱码问题
- 第一次使用Android Studio时你应该知道的一切配置
- GPUImage
- Codeforces 570D Tree Requests 题解&代码
- XAudio2学习一之平台搭建
- 关于java反序列化漏洞(java deserialization vulnerability)
- [Leetcode]Count of Smaller Numbers After Self
- ARM汇编编程基础(一) -- ARM CPU寄存器