datatables.js 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899
  1. import 'tailwindcss';
  2. import $ from 'jquery';
  3. import 'laravel-datatables-vite';
  4. import JSZip from 'jszip'; // Required for Excel and CSV export
  5. import 'datatables.net';
  6. import 'datatables.net-buttons';
  7. import 'datatables.net-buttons/js/buttons.html5.js'; // For HTML5 export buttons
  8. import 'datatables.net-buttons/js/buttons.print.min.js'; // For the print button
  9. import 'datatables.net-responsive';
  10. import 'pdfmake/build/pdfmake.js'; // Required for PDF export
  11. import 'pdfmake/build/vfs_fonts.js'; // Required for PDF export
  12. import './dataTables.tailwindcss.js';
  13. import 'datatables.net-responsive-dt';
  14. // Ensure jQuery is available globally
  15. window.$ = window.jQuery = $;
  16. window.JSZip = JSZip;
  17. // Initialize DataTable
  18. let dataTableInstance;
  19. var livewireSearchTerms ={};
  20. function initializeDataTable() {
  21. var dataTableName = document.getElementById('datatable-config').dataset.datatableName;
  22. var dataTableColumnsConfig = JSON.parse(document.getElementById('datatable-config').dataset.datatableColumnsConfig);
  23. if ($.fn.DataTable.isDataTable(`#${dataTableName}-table`)) {
  24. dataTableInstance.destroy();
  25. $(`#${dataTableName}-table tbody`).empty(); // Clear rows to prevent residue
  26. }
  27. dataTableInstance = $(`#${dataTableName}-table`).DataTable({
  28. responsive: true,
  29. retrieve: true,
  30. searching: false,
  31. processing: true,
  32. serverSide: true,
  33. orderCellsTop: true,
  34. fixedHeader: true,
  35. ajax: {
  36. url: '/api/report-data/' + dataTableName,
  37. type: 'POST',
  38. dataSrc: function (json) {
  39. console.log('Returned rows:', json.data);
  40. return json.data;
  41. },
  42. data: function (d) {
  43. d.searchTerms = livewireSearchTerms || {};
  44. }
  45. },
  46. columns: dataTableColumnsConfig,
  47. dom: 'lBfrtip',
  48. buttons: [
  49. { extend: 'copyHtml5', className: 'dt-button' },
  50. { extend: 'csvHtml5', className: 'dt-button' },
  51. { extend: 'excelHtml5', className: 'dt-button' },
  52. { extend: 'pdfHtml5', className: 'dt-button' },
  53. { extend: 'print', className: 'dt-button' },
  54. ],
  55. layout: {
  56. topStart: 'buttons'
  57. },
  58. columnDefs: [
  59. { responsivePriority: 1, targets: 0 },
  60. { responsivePriority: 2, targets: -1 }
  61. ]
  62. });
  63. }
  64. document.addEventListener('livewire:init', function () {
  65. console.log('Initializing DataTable');
  66. initializeDataTable();
  67. Livewire.on('search-terms-updated', (searchTerms) => {
  68. livewireSearchTerms = searchTerms || {};
  69. setTimeout(() => {
  70. initializeDataTable();
  71. }, 50); // Slight delay gives Livewire time to patch DOM
  72. });
  73. });
  74. document.addEventListener('DOMContentLoaded', () => {
  75. console.log("datatables.js is working!");
  76. });