1:静态页面
<table id='partnerlistall' class="table table-hover table-striped table-bordered table-advanced tablesorter" style="display:none;position:absolute;left:-99999999px;margin-top: 10px" >
<thead>
<tr class="topnav">
<th>序号</th>
<th>ID</th>
<th>微信昵称</th>
<th>姓名</th>
<th>性别</th>
<th>手机号</th>
<th>等级名称</th>
<th>推荐人/推荐人ID</th>
<th>加入时间</th>
<th>所属区域</th>
<th>状态</th>
</tr>
</thead>
<tbody id="education-news-data2"> </tbody>
</table>
2:js
//把数据渲染到education-news-data2里面
var dataParam1 = {
page: 1,
rows: 999,
}
$('#user_id').val() && (dataParam1.user = $('#user_id').val())
$('#up_user_id').val() && (dataParam1.up_user = $('#up_user_id').val())
$('#user_type').val() && (dataParam1.level_no = $('#level-name').find('option:selected').attr('data-level_no'))
$('#user_type').val() && (dataParam1.classify_id = $('#user_type').val())
$.ajax({
url: interface_url + "filter/queryDistributorPageByCnd.do",
type: 'post',
dataType: 'json',
data: JSON.stringify(dataParam1),
contentType: 'application/json;charset=UTF-8',
success: function (data) {
console.log('导出的数据')
console.log(data)
if (data.retCode === 0) {
renderTable1(data.data.list)
} else {
toastr.error(data.message);
}
},
error: function () {
}
});
function renderTable1(list) {
var str = ''
var arr_name = ""
$.each(list.list, function (index, obj) {
var areaStr = ''
console.log(obj)
$.each(obj.areaList, function (index2, obj2) {
console.log(obj2)
/*
var pro_name = obj2.pro_name || '';
var city_name = obj2.city_name || '';
var region_name = obj2.region_name || '';
var str = pro_name == city_name ? pro_name : (pro_name + city_name)
areaStr += '<p><span>' + (index2 + 1) + '、</span> ' + str + region_name +'</p>'
*/
areaStr += '<p><span>' + (index2 + 1) + '、</span> ' + (obj2.pro_name || '') + (obj2.city_name || '') + (obj2.region_name || '') + '</p>'
})
str += '<tr data-level_no = "' + obj.level_no + '" data-user_id="' + obj.user_id + '" data-distributor_id="' + obj.distributor_id + '">'
str += '<td>' + (index + 1) + '</td>'
str += '<td>' + (obj.user_id || '') + '</td>'
str += '<td>' + (obj.user_name || '') + '</td>'
str += '<td>' + (obj.reality_name || '') + '</td>'
str += '<td>' + obj.sex_str + '</td>'
str += '<td>' + (obj.user_phone || '') + '</td>'
str += '<td>' + (obj.level_name || '') + '</td>'
if (obj.up_user_id && obj.up_user_name) {
str += '<td>' + (obj.up_user_name + '/' + obj.up_user_id || '') + '</td>'
} else {
str += '<td>' + (obj.up_user_name + ' ' + obj.up_user_id || '') + '</td>'
}
str += '<td>' + (obj.create_time || '') + '</td>'
str += '<td>' + areaStr + '</td>'
str += '<td>' + obj.status_str + '</td>'
str += '</tr>'
return obj;
});
if (list.length === 0) str = '<tr><td colspan="10" align="center">空</td></tr>'
$("#education-news-data2").html(str);
}
3:最后一步是导出表格了
var print_page2=1;
$("#partnerlist").click(function(){
$("#partnerlistall").table2excel({
// 不被导出的表格行的CSS class类
exclude: ".noExl",
// 导出的Excel文档的名称,(没看到作用)
name: "Excel Document Name",
// Excel文件的名称
filename: "分销合伙人" + print_page2 + "页.xlsx"
});
})