table= $('#table').DataTable( {
destroy: true,
serverSide: true,
responsive: true,
deferRender: false,//设置延迟渲染,提高效率用
draw:false,
searching : false,
bLengthChange: false,
order: [[ 0, 'asc' ],[ 1, 'asc' ]],
ajax: {
url: "user/userList",
type: "POST",
data : function(d) {
var sentJson = GET_SENT_JSON_MORE(d);
return sentJson;
},
error: function (e) {
ALERT_ERROR(wthzTable,e);
},
},
lengthMenu: PAGELENGTH,
"language": LANGUAGESETTING,
"drawCallback": function (settings) {
var api = this.api();
var rows = api.rows({ page: 'current' }).nodes();
var idx = 0; // 第一列进行合并
var last = null;
var tr = null;
var ltd = null;
api.column(idx, { page: 'current' }).data().each(function (group, i) {
tr = $(rows[i]);
var td = $("td:eq(" + idx + ")", tr);
if (last !== group) {
td.attr("rowspan", 1);
td.text(group);
ltd = td;
last = group;
td.css("vertical-align", "middle");
} else {
ltd.attr("rowspan", parseInt(ltd.attr("rowspan")) + 1);
td.remove();
}
});
},
columnDefs : [
{ "targets": 0 ,"name":"id","title": "编号" ,"visible": true,"width": "10%" , orderable :true ,},
{ "targets": 1 ,"name":"name" ,"title": "名称", "visible": true,"width": "10%", orderable:false,},
{ "targets": 2 ,"name":"phone","title": "手机号" ,"visible": true,"width": "10%" , orderable :true ,},
{ "targets": 3 ,"name":"emial","title": "邮箱","visible": true, "width": "10%" , ordera5ble :true ,},
],
columns: [
{ data: 'lx' },
{ data: 'mc' },
{ data: 'fxwt' },
{ data: 'cjr' },
]
});
}
$('#table tbody tr').live('click', function(e) {
if(!e.isPropagationStopped()){
// 获取行选中数据
var aData = table.fnGetData(this);
wtArr.splice(0, userArr.length);
if ($(this).hasClass('selectedBgcolor') ) {
$(this).removeClass('selectedBgcolor');
} else {
userArr.push(aData);
rowClickBgcolor(table,$(this));
}
}
e.stopPropagation();
});
//鼠标移动添加背景颜色
mouseEvent("table");
DataTable合并行
最新推荐文章于 2024-09-09 13:16:15 发布