Search

$(document).ready(function () { var empTable = $('#reportTable').dataTable({ "aaSorting": [[0, "asc"]], "iDisplayLength": , "aLengthMenu": [[10, 25, 50, 100, -1], [10, 25, 50, 100, ""]], 'bProcessing': true, 'bServerSide': true, "scrollX": true, 'sAjaxSource': 'payment/getAmountData', 'fnServerData': function (sSource, aoData, fnCallback) { $.ajax({ 'dataType': 'json', 'type': 'POST', 'url': sSource, 'data': aoData, 'success': fnCallback }); }, 'fnRowCallback': function (nRow, aData, iDisplayIndex) { var oSettings = empTable.fnSettings(); nRow.id = aData[0]; var nCells = nRow.getElementsByTagName('td'); var basic_pay = reduce(aData[4]); var total = ceiling(parseFloat(aData[4]) + parseFloat(aData[5])); var total_salary = ceiling(parseFloat(total) + parseFloat(aData[6]) + parseFloat(aData[7]) + parseFloat(aData[8]) + parseFloat(aData[9]) + parseFloat(aData[10])); var begin_total = 0; var gpf = 0; var final_total = 0; nCells[6].innerHTML = currencyFormat(basic_pay); nCells[6].innerHTML = currencyFormat(total); nCells[12].innerHTML = currencyFormat(total_salary); return nRow; }, "aoColumns": [ { "bSortable": false }, { "bSortable": false }, { "bSortable": false }, { "bSortable": false }, { "bSortable": false, "mRender": currencyFormat }, { "bSortable": false, "mRender": currencyFormat }, { "bSortable": false, "mRender": currencyFormat }, { "bSortable": false, "mRender": currencyFormat }, { "bSortable": false, "mRender": currencyFormat }, { "bSortable": false, "mRender": currencyFormat }, { "bSortable": false, "mRender": currencyFormat }, { "bSortable": false, "mRender": currencyFormat }, { "bSortable": false, "mRender": currencyFormat }, { "bSortable": false, "mRender": currencyFormat }, { "bSortable": false, "mRender": currencyFormat }, { "bSortable": false, "mRender": currencyFormat } // , { // "bSortable": false // } ] }); }); try { $this->load->library('datatables'); $query = $this->datatables->select(' employee_info.employee_id as employee_id, employee_info.employee_name, e.designation_name, scale_pay.name, employee_info.basic_pay, employee_info.grade_pay, 0 as total, c.da, c.hra, c.ta, c.da_on_ta, c.fma, 0 as total_salary, 0 as begin_total, 0 as gpf, 0 as final_total ')->from('employee_info') ->join('scale_pay ', 'scale_pay.id = employee_info.scale_of_pay', 'left') ->join('designation e', 'e.designation_id = employee_info.designation_id') ->join('month_pay c', 'c.employee_id = employee_info.employee_id') ->join('monthly_deduction f', 'f.employee_id = employee_info.employee_id AND f.monthyear') // ->group_by('employee_info.employee_id') // ->group_by('employee_info.basic_pay') ->where($where); echo $this->datatables->generate(); } catch (Exception $e) { throw new Exception("Error Processing Request", 1); }

Ex: showing 1 to 10 of 39 entries showing 11 to 20 of 39 entries showing 21 to 30 of 39 entries showing 31 to 39 of 39 entries

Hi, i'm currently learning javascript. I have a project for testing purpose, i wanted to setup mongodb as the data source and use datatables as to display the data on electron framework. So electron, mongodb, datatables combined. async function getName() { let result = [] try{ const name = await loadCollection() await name.aggregate({$match: {founded_year:2010}},{$group : {_id:"$name"}}).forEach(function(u) { result.push(u.name) }) } catch(e){ console.log(e) } console.log(result) return result } let datas = getName().then(function(x){ $('#table1').DataTable({ data : x })}) I have had a success on connecting those 3 modules. However, datatables is only getting the first letters of each data. here as you can see, in the console log my function outputs the array correctly which i believe means that there is nothing wrong with the backend. I can't find where the problem is. Hoping to get answers from you guys soon! Thank you

when i click the button (index):1311 Uncaught TypeError: $(...).DataTable is not a function at initial ((index):1311) at HTMLButtonElement. ((index):1304) at HTMLButtonElement.dispatch (VM1584 index.js:3074) at HTMLButtonElement.elemData.handle (VM1584 index.js:2750) it will show

when i try to make an excel files from the datatable, always the excell come with ltr option . how i can change it to rtl by default when i make a excel file from my datatable options

I'm creating a project, which looks for information in the Oracle 11g database, I make connection usually using php, I can return the information from the database. Okay until this moment everything is working. I can not create a php to call with ajax so that it fits together with the dataTable site examples. I checked that there are tutorials teaching the ajax connection using mysql, I can handle mysql because its commands are known on the internet. Oracle are different and finding them is very difficult. I would like to see with some members, if you have already performed projects that require oracle and ajax at the same time. Exemplo abaixo utilizando mysql More detailed in this link, has the source codes https://www.webslesson.info/2018/09/add-server-side-datatables-custom-filter-using-php-with-ajax.html If you can provide me with a project that does the same function as above link, using oracle I am grateful

I have implemented data tables (1.10.13) and used buttons.HTML5 , dataTables.buttons.min(1.2.4) plugin to export pdf,csv functionality. I am facing one issue like, in Some of IE Browsers PDF or csv working fine (IE 11 Update version 11.0.40 or greater and less than 60). where as pdf or csv is not exported properly in IE Update base verison i.e, 11.0.7 or less than 11.0.40 and greater than 11.0.60 for ex: 11.0.80. Export pdf of csv is not working. I am getting message PDF/csv couldn't be downloaded issue. is it IE issue or the library is not supporting export? Regards, Suresh V

lt;/div> </div> <table class="table table-bordered datatable" id="table_export"> <thead> <tr>

Hi, I hope you can guide me. I wonder if this is possible using datatables? (dummy data) using the rowgroup extension the most I've got is this: excuse my bad english

Hello, as the title says, I am using columnDefs to assign classes to my columns. However, those classes also get applied to the column headers. Is there a way to avoid that, or set classes specifically for the headers?