php - 导出按钮未显示在数据表中
问题描述
我做了一个ajax调用来获取动态数据,其中标题不固定有多少列,在获取以下格式的数据后,无法导出或限制行数,标题可以超过30个。任何帮助将不胜感激。
这是我的 html 代码:
<div class="table-responsive" id="live_tracking_table_cantainer">
<table class="table table-striped table-bordered dataTable livertrackingtable">
</table>
</div>
Ajax call :
$(".livetracking").click(function () {
var data = $("#livetrackingform").serialize();
$.ajax({
type: 'post',
url: '/getcampaigndata',
data: data,
success: function (dataSet) {
if (dataSet == '' || dataSet == 'undefined') {
$("#live_tracking_table_cantainer").css('text-align', 'center');
$("#live_tracking_table_cantainer").html('No data found');
return;
}
var my_columns = [];
$.each(dataSet[0], function (key, value) {
var my_item = {};
my_item.data = key;
my_item.title = key;
my_columns.push(my_item);
});
$('#live_tracking_table_cantainer').empty();
$table = $('<table style="width: 100%">');
$table.addClass("table table-striped table-bordered dataTable livertrackingtable");
$($table).DataTable({
data: dataSet,
"columns": my_columns,
"order": [],
"columnDefs": [{
"targets": 'no-sort',
"orderable": false,
}],
"aLengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
dom: 'Bfrtip',
buttons: [
'copy', 'csv', 'excel', 'pdf', 'print'
]
});
$table.appendTo('#live_tracking_table_cantainer');
},
error: function (data) {
console.log(data);
}
});
});
What I am getting from ajax call :
[{created_at: "23-04-2019 05:22 PM", Name: "Test", Designation: "ZSM", Zone: "North", Region: "",…},…]
0: {created_at: "23-04-2019 05:22 PM", Name: "Test", Designation: "ZSM", Zone: "North", Region: "",…}
1: {created_at: "23-04-2019 05:28 PM", Name: "Test", Designation: "ZSM", Zone: "North", Region: "",…}
2: {created_at: "23-04-2019 05:30 PM", Name: "Test", Designation: "ZSM", Zone: "North", Region: "",…}
3: {created_at: "25-04-2019 05:24 PM", Name: "Test", Designation: "ZSM", Zone: "North", Region: "",…}
4: {created_at: "29-04-2019 06:23 PM", Name: "Test", Designation: "ZSM", Zone: "North", Region: "",…}
5: {created_at: "29-04-2019 06:24 PM", Name: "Test", Designation: "ZSM", Zone: "North", Region: "",…}
解决方案
推荐阅读
- clockify - PBI 中的 Clockify API
- python - 从多个网站抓取文本并分别保存在文本文件中
- xcode - 与 Xcode 9.2 相比,Xcode 10 列出了更多方案
- angular - 被效果捕获的 Angular 6 ngrx 存储动作仍然落入减速器
- unit-testing - 在不运行 @SpringBootApplication 的情况下测试 Spring Boot 服务
- python - 在圆内寻找轮廓
- php - Laravel 5 - 如何使用 $this->app->when()
- sqlplus - 我需要确保我的编码正确地解决了这些问题
- oracle - 如何从 plsql 上的文件中获取创建日期
- xamarin - Xamarin MSAL NuGet 错误 - 检测到 Xamarin.Android.Support.Compat 的版本冲突