项目需求是表头三行,动态获取,数据封装和第三行的属性得对应(核心)
<link rel="stylesheet" href="/fixed-columns/css/bootstrap.min.css">
<link rel="stylesheet" href="/fixed-columns/css/bootstrap-table.css">
<link rel="stylesheet" href="/fixed-columns/css/bootstrap-table-fixed-columns.css">
<script src="/fixed-columns/js/jquery.min.js"></script>
<script src="/fixed-columns/js/bootstrap.min.js"></script>
<script src="/fixed-columns/js/bootstrap-table.js"></script>
<script src="/fixed-columns/js/bootstrap-table-fixed-columns.js"></script>
<table id="table" data-height="700" data-show-columns="true"></table>
function buildTable() {
var
columnsone = [],
columnstwo = [],
columnsthree = [],
datayk = [],
columnsboot = [];
var columnlist;
//获取表头第一行
//获取表头
$.ajax({
url: "/columns/column/gettlcolumn",//获取动态的列名数据url
type: 'get',
data:{colnum:1},
dataType: "json",
async: false,
success: function (returnValue) {
$.each(returnValue, function(i, item) {
/*alert(item.field);*/
columnsone.push({
field: item.field,
title: item.title,
colspan:item.colspan,
rowspan: item.rowspan,
align: 'center',
valign: 'middle',
})
});
}
});
//获取表头第二行
//获取表头
$.ajax({
url: "/columns/column/gettlcolumn",//获取动态的列名数据url
type: 'get',
data:{colnum:2},
dataType: "json",
async: false,
success: function (returnValue) {
$.each(returnValue, function(i, item) {
/*alert(item.field);*/
columnstwo.push({
field: item.field,
title: item.title,
colspan:item.colspan,
rowspan: item.rowspan,
align: 'center',
valign: 'middle',
})
});
}
});
//获取表头第三行
//获取表头
$.ajax({
url: "/columns/column/gettlcolumn",//获取动态的列名数据url
type: 'get',
data:{colnum:3},
dataType: "json",
async: false,
success: function (returnValue) {
$.each(returnValue, function(i, item) {
/*alert(item.field);*/
columnsthree.push({
field: item.field,
title: item.title,
colspan:item.colspan,
rowspan: item.rowspan,
})
});
//展示列的长度和名称
columnlist=returnValue;
}
});
//获取数据
//data包装列
$.ajax({
url: "/columns/column/gettltaizhanglist",//获取动态的列名数据url
type: 'get',
dataType: "json",
async: false,
success: function (returnValue) {
$.each(returnValue, function(i, item) {
var rowyk = {};
$.each(columnlist, function(i, itemclu) {
if(itemclu.field==""){
}else{
var sss="item."+itemclu.field;
var ss=eval(sss);
if(itemclu.field=="remarks"){
console.log("woshi");
console.log(ss);
}
rowyk[itemclu.field] = ss;
}
});
datayk.push(rowyk);
});
}
});
columnsboot.push(columnsone);
columnsboot.push(columnstwo);
columnsboot.push(columnsthree);
$('#table').bootstrapTable('destroy').bootstrapTable({
columns: columnsboot,
data: datayk,
search: true,
//toolbar: '.toolbar',
fixedColumns: true,
fixedNumber: 1, //固定列的个数
//rowStyle:rowStyle
});
}