bootstrap table 导出数据格式,前端日期排序
先看插件说明,再看options的设置即可.
排序主要看:
sorter:numberSort
导出文件格式化主要看:
showExport:true, exportOptions:{ fileName:"例子后端常规监控", worksheetName:"例子后端常规监控", onCellData:function(cell, row, col, data){ if(row == 0){ return data; }else{ return data.replace(/\([^\)]*\)/g,""); } } },
https://github.com/wenzhixin/bootstrap-table/tree/master/src/extensions/export
https://github.com/hhurz/tableExport.jquery.plugin#options
//数据排序算法 function numberSort(a,b){ a = a.replace(/\([^\)]*\)/g,"");//正则 去掉小括号及里边的内容 b = b.replace(/\([^\)]*\)/g,""); var numa = parseFloat(a); var numb = parseFloat(b); return a - b; } //日期排序算法 sorter:function(a, b){ var d1 = new Date(a.replace(/\-/g, "\/")); var d2 = new Date(b.replace(/\-/g, "\/")); if(a != "" && b != ""){ return d1 - d2; } } //bootstrap table初始化函数 $('#table').bootstrapTable({ showToggle:false, showPaginationSwitch:true, // showColumns:true, //可选列按钮 iconsPrefix:"glyphicon", //图标样式 iconSize:"sm", //图标大小 striped:true, classes:"table table-striped table-bordered table-hover", pagination:true, //底部分页 sidePagination:"client", showExport:true, exportOptions:{ fileName:"例子后端常规监控", worksheetName:"例子后端常规监控", onCellData:function(cell, row, col, data){ if(row == 0){ return data; }else{ return data.replace(/\([^\)]*\)/g,""); } } }, search:true, undefinedText:"无", pageSize: 20, //每页的记录行数(*) pageList: [20, 50, 100, 150], //可供选择的每页的行数(*) //sortable: true, //是否启用排序 //sortName:"stat_dt", //sortOrder:"desc", columns:[ { field:"stat_dt", title:"统计日期", sortable:true, sorter:function(a, b){ var d1 = new Date(a.replace(/\-/g, "\/")); var d2 = new Date(b.replace(/\-/g, "\/")); if(a != "" && b != ""){ return d1 - d2; } } }, { field:"platform", title:"平台", sortable:true }, { field:"app_name", sortable:true, title:"APP名称", formatter:function(value,row,index){ if(value == "other"){ return "无"; } return value; } }, { field:"order_num", sortable:true, title:"例子订单量", sorter:numberSort }, ......
抱歉,暂停评论。