首页 > Java > bootstrap table 导出数据格式,前端日期排序

bootstrap table 导出数据格式,前端日期排序

2018年1月16日 admin 发表评论 阅读评论

先看插件说明,再看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
                  },
                  ......
分类: Java 标签:
  1. 本文目前尚无任何评论.
  1. 本文目前尚无任何 trackbacks 和 pingbacks.