Hello good night, present the following error of the data table in codeigniter, I try to find the error but I have little experience in the script:
DataTables warning (table id = 'PRData'): Requested unknown parameter '13' from the data source for row 2
My script that loads the json
var oTable;
$(document).ready(function () {
oTable = $('#PRData').dataTable({
"aaSorting": [[2, "asc"], [3, "asc"]],
"aLengthMenu": [[10, 25, 50, 100, -1], [10, 25, 50, 100, "<?= lang('all') ?>"]],
"iDisplayLength": <?= $Settings->rows_per_page ?>,
'bProcessing': true, 'bServerSide': true,
'sAjaxSource': '<?= admin_url('products/getProducts'.($warehouse_id ? '/'.$warehouse_id : '').($supplier ? '?supplier='.$supplier->id : '')) ?>',
'fnServerData': function (sSource, aoData, fnCallback) {
aoData.push({
"name": "<?= $this->security->get_csrf_token_name() ?>",
"value": "<?= $this->security->get_csrf_hash() ?>"
});
$.ajax({'dataType': 'json', 'type': 'POST', 'url': sSource, 'data': aoData, 'success': fnCallback});
},
'fnRowCallback': function (nRow, aData, iDisplayIndex) {
var oSettings = oTable.fnSettings();
nRow.id = aData[0];
nRow.className = "product_link";
//if(aData[7] > aData[9]){ nRow.className = "product_link warning"; } else { nRow.className = "product_link"; }
return nRow;
},
"aoColumns": [
{"bSortable": false, "mRender": checkbox},
{"bSortable": false,"mRender": img_hl},
null,
null,
null,
null,
<?php if($Owner || $Admin) { echo '{"mRender": currencyFormat}, {"mRender": currencyFormat},'; } else { if($this->session->userdata('show_cost')) { echo '{"mRender": currencyFormat},'; } if($this->session->userdata('show_price')) { echo '{"mRender": currencyFormat},'; } } ?>
{"mRender": formatQuantity},
null,
<?php if(!$warehouse_id || !$Settings->racks) { echo '{"bVisible": false},'; } else { echo '{"bSortable": true},'; } ?>
{"mRender": formatQuantity},
null,
{"bSortable": false}
]
}).fnSetFilteringDelay().dtFilter([
{column_number: 2, filter_default_label: "[<?=lang('code');?>]", filter_type: "text", data: []},
{column_number: 3, filter_default_label: "[<?=lang('name');?>]", filter_type: "text", data: []},
{column_number: 4, filter_default_label: "[<?=lang('brand');?>]", filter_type: "text", data: []},
{column_number: 5, filter_default_label: "[<?=lang('category');?>]", filter_type: "text", data: []},
<?php $col = 5;
if($Owner || $Admin) {
echo '{column_number : 6, filter_default_label: "['.lang('cost').']", filter_type: "text", data: [] },';
echo '{column_number : 7, filter_default_label: "['.lang('price').']", filter_type: "text", data: [] },';
$col += 2;
} else {
if($this->session->userdata('show_cost')) { $col++; echo '{column_number : '.$col.', filter_default_label: "['.lang('cost').']", filter_type: "text", data: [] },'; }
if($this->session->userdata('show_price')) { $col++; echo '{column_number : '.$col.', filter_default_label: "['.lang('price').']", filter_type: "text, data: []" },'; }
}
?>
{column_number: <?php $col++; echo $col; ?>, filter_default_label: "[<?=lang('quantity');?>]", filter_type: "text", data: []},
{column_number: <?php $col++; echo $col; ?>, filter_default_label: "[<?=lang('unit');?>]", filter_type: "text", data: []},
<?php $col++; if($warehouse_id && $Settings->racks) { echo '{column_number : '. $col.', filter_default_label: "['.lang('rack').']", filter_type: "text", data: [] },'; } ?>
{column_number: <?php $col++; echo $col; ?>, filter_default_label: "[<?=lang('alert_quantity');?>]", filter_type: "text", data: []},
{column_number: <?php $col++; echo $col; ?>, filter_default_label: "[<?=lang('company');?>]", filter_type: "text", data: []},
], "footer");
});