// Call the dataTables jQuery plugin $(document).ready(function() { var patientTable = $('#dataTable').DataTable({ dom: 'Bfrtip', buttons: [ 'copy', 'csv', 'excel', 'pdf', 'print' ] }); $('#min, #max').keyup(function() { patientTable.draw(); }); var startdate; }); $('#reportrange').on('apply.daterangepicker', function(ev, picker) { var patientTable = $('#dataTable').DataTable(); startdate = picker.startDate.format('YYYY-MM-DD'); startdate = new Date(startdate); enddate = picker.endDate.format('YYYY-MM-DD'); enddate = new Date(enddate); $.fn.dataTableExt.afnFiltering.push( function(oSettings, aData, iDataIndex) { if (startdate != undefined) { let tempData = aData.length >= 6 ? new Date(aData[0]).toLocaleDateString() : new Date(aData[1]).toLocaleDateString(); var coldate = tempData.split("/"); var d = new Date(coldate[2], coldate[1] - 1, coldate[0]); var date = moment(d.toISOString()); date = date.format("YYYY-MM-DD"); date = new Date(date); dateMin = startdate //startdate.replace(/-/g, ""); dateMax = enddate //enddate.replace(/-/g, ""); // date = date.replace(/-/g, ""); if (dateMin.getTime() == "" && date.getTime() <= dateMax.getTime()) { return true; } else if (dateMin.getTime() == "" && date.getTime() <= dateMax.getTime()) { return true; } else if (dateMin.getTime() <= date.getTime() && "" == dateMax.getTime()) { return true; } else if (dateMin.getTime() <= date && date.getTime() <= dateMax.getTime()) { return true; } return false; } }); patientTable.draw(); }); $.fn.dataTable.ext.search.push( function(settings, data, dataIndex) { var min = parseInt($('#min').val(), 10); var max = parseInt($('#max').val(), 10); if (min !== "" || max !== "") { let tempData = data.length >= 5 ? data[3] : data[2]; var age = parseFloat(tempData.replace(/,/g, '').replace('$', '')) || 0; // use data for the age column console.log(age) if ((isNaN(min) && isNaN(max)) || (isNaN(min) && age <= max) || (min <= age && isNaN(max)) || (min <= age && age <= max)) { return true; } return false; } } ); $(document).ready(function() { $('#dataTableActivity').DataTable({ "order": [ [0, 'desc'] ] }); });