Advertisement
wansyahi1

Fetch data to datatable

Dec 16th, 2019
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.23 KB | None | 0 0
  1. <script type="text/javascript">
  2. $(document).ready(function(){
  3.  
  4. fill_datatable();
  5.  
  6. function fill_datatable(dataGender = '',ethnicity='',area ='',state='',namaDUN='')
  7. {
  8. var dataTable = $('#table_data').DataTable({
  9. processing: true,
  10. serverSide: true,
  11.  
  12. "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
  13. ajax:{
  14. url:'/filter-result',
  15. data:{dataGender:dataGender,ethnicity:ethnicity,area:area,state:state,namaDUN:namaDUN}
  16. },
  17.  
  18. columns: [
  19. {
  20. data:'id',
  21. name:'id'
  22. },
  23. {
  24. data:'First_name',
  25. name:'First_name'
  26. },
  27. {
  28. data:'Last_name',
  29. name:'Last_name'
  30. },
  31. {
  32. data:'Umur',
  33. name:'Umur'
  34. },
  35. {
  36. data:'Phonenum',
  37. name:'Phonenum'
  38. },
  39. {
  40. data:'TarikhLahir',
  41. name:'TarikhLahir'
  42. },
  43. {
  44. data:'Negeri',
  45. name:'Negeri'
  46. },
  47. {
  48. data:'Country',
  49. name:'Country'
  50. },
  51. {
  52. data:'postcode',
  53. name:'postcode'
  54. },
  55. {
  56. data:'Ct',
  57. name:'Ct'
  58. },
  59. {
  60. data:'Jantina',
  61. name:'Jantina'
  62. }
  63.  
  64. ]
  65.  
  66. });
  67.  
  68. }
  69.  
  70.  
  71. $('#filter').click(function(){
  72. var table = $('#table_data').DataTable();
  73. var age = $('#age').val();
  74. var dataGender = $('#dataGender').val();
  75. var ethnicity = $('#ethnicity').val();
  76. var area = $('#area').val();
  77. var state = $('#state').val();
  78. var namaDUN = $('#namaDUN').val();
  79.  
  80.  
  81. if( $.fn.DataTable.isDataTable('#table_data')){
  82. table.destroy();
  83. $('#table_data').empty();
  84. alert('haha')
  85. var dataTable = $('#table_data').DataTable({
  86. processing: true,
  87. serverSide: true,
  88.  
  89. "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
  90. ajax:{
  91. url:'/filter-result',
  92. data:{dataGender:dataGender,ethnicity:ethnicity,area:area,state:state,namaDUN:namaDUN}
  93. },
  94.  
  95. columns: [
  96. {
  97. data:'id',
  98. name:'id'
  99. },
  100. {
  101. data:'First_name',
  102. name:'First_name'
  103. },
  104. {
  105. data:'Last_name',
  106. name:'Last_name'
  107. },
  108. {
  109. data:'Umur',
  110. name:'Umur'
  111. },
  112. {
  113. data:'Phonenum',
  114. name:'Phonenum'
  115. },
  116. {
  117. data:'TarikhLahir',
  118. name:'TarikhLahir'
  119. },
  120. {
  121. data:'Negeri',
  122. name:'Negeri'
  123. },
  124. {
  125. data:'Country',
  126. name:'Country'
  127. },
  128. {
  129. data:'postcode',
  130. name:'postcode'
  131. },
  132. {
  133. data:'Ct',
  134. name:'Ct'
  135. },
  136. {
  137. data:'Jantina',
  138. name:'Jantina'
  139. }
  140.  
  141. ]
  142.  
  143. });
  144.  
  145.  
  146. }
  147. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement