我有一个选择下拉菜单和提交按钮。用户从选择下拉列表中进行选择并提交。然后它会调用ajax。如果找到数据,则该数据将显示在数据表中,否则将显示警报“未找到数据”。
上面的场景对我来说很完美,但问题是,
如果我从选择下拉列表中选择第二次,我的 ajax 第一次工作,然后我收到错误
DataTables warning: table id=report_list - Cannot reinitialise DataTable. For more information about this error, please see http://datatables.net/tn/3
.
我试过"bDestroy": true
或者$("#report_list").dataTable().fnDestroy();
但它不能正常工作。错误消失,但我的响应数据未显示。
$("form[name='reports']").validate({
rules: {
report_type:{required:true}
},
// errorElement: 'div',
submitHandler: function(form) {
var report_type = $('#report_type').val();
var fromDate = $('#fromDate').val();
var toDate = $('#toDate').val();
$.ajax({
url: baseUrl + "/Reports_control/Get_reports",
method: "POST",
//dataType: "json",
data: {report_type: report_type,fromDate:fromDate,toDate:toDate},
success: function(response) {
$('.search_record tbody tr').hide();
var data = JSON.parse(response);
if (data.status === 'error')
{
$('.report').hide();
alert(data.msg);
}
if (data.status === 'success') {
if ( $.fn.DataTable.isDataTable( '#report_list' ) ) {
$('#report_list').destroy();
}
//alert(data);
$('.company_report').show();
var trHTML = '';
$.each(data.records, function (i, o){
trHTML += '<tr><td>'+o.Sr_no+
'</td><td>' + o.cutomer_name +
'</td><td>' + o.o_product_brandname +
'</td><td>' + o.o_product_qty +
'</td><td>'+ o.o_order_no +
'</td><td>'+ o.created_by +
'</td><td>'+ o.order_status +
'</td><td>'+ o.action_order_status +
'</td></tr>';
});
$('.search_record tbody').append(trHTML);
$('#report_list').DataTable({
language: {
sLengthMenu: "Show _MENU_",// remove entries text
searchPlaceholder: "Search",
search:""
},
"ordering": false, // remove sorting effect from header
});
}
}
});
}
});
你能帮我解决这个问题吗?
您应该创建一个变量并在该变量中分配数据表。检查以下代码:
<script>
var reportListDatatable = '';
$("form[name='reports']").validate({
rules: {
report_type: {required: true}
},
submitHandler: function (form) {
var report_type = $('#report_type').val();
var fromDate = $('#fromDate').val();
var toDate = $('#toDate').val();
$.ajax({
url: baseUrl + "/Reports_control/Get_reports",
method: "POST",
//dataType: "json",
data: {report_type: report_type, fromDate: fromDate, toDate: toDate},
success: function (response) {
$('.search_record tbody tr').hide();
var data = JSON.parse(response);
if (data.status === 'error')
{
$('.report').hide();
alert(data.msg);
}
if (data.status === 'success') {
if ($.fn.DataTable.isDataTable('#report_list')) {
$('#report_list').dataTable().fnClearTable();
$('#report_list').dataTable().fnDestroy();
}
$('.company_report').show();
var trHTML = '';
$.each(data.records, function (i, o) {
trHTML += '<tr><td>' + o.Sr_no +
'</td><td>' + o.cutomer_name +
'</td><td>' + o.o_product_brandname +
'</td><td>' + o.o_product_qty +
'</td><td>' + o.o_order_no +
'</td><td>' + o.created_by +
'</td><td>' + o.order_status +
'</td><td>' + o.action_order_status +
'</td></tr>';
});
$('.search_record tbody').append(trHTML);
reportListDatatable = $('#report_list').DataTable({
language: {
sLengthMenu: "Show _MENU_", // remove entries text
searchPlaceholder: "Search",
search: ""
},
"ordering": false, // remove sorting effect from header
});
}
}
});
}
});
</script>
希望对你有帮助。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句