Advertisement
Guest User

Untitled

a guest
May 15th, 2017
611
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.96 KB | None | 0 0
  1. <html>
  2.  
  3. <head>
  4. <meta charset="utf-8">
  5. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6. <meta name="viewport" content="width=device-width, initial-scale=1">
  7. <!-- The above 3 meta tags *must* come first in the head; any other head
  8. content must come *after* these tags -->
  9. <meta name="description" content="">
  10. <meta name="author" content="Álvaro Grisolfi">
  11. <meta name="keywords" content="Tabela, Filtro, DataTable, Bootstrap">
  12. <title>Tabela Com Filtro</title>
  13. <!-- HTML5 shim and Respond.js for IE8 support
  14. of HTML5 elements and media queries -->
  15. <!--[if lt IE 9]>
  16. <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
  17. <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  18. <![endif]-->
  19. <link rel="stylesheet" type="text/css" href="assets/dist/css/bootstrap.min.css" media="all">
  20.  
  21. <script type="text/javascript" src="assets/dist/js/bootstrap.min.js"></script>
  22. <script type="text/javascript" src="assets/dist/js/jquery.js"></script>
  23.  
  24. <script type="text/javascript" src="assets/dist/js/jquery.dataTables.min.js"></script>
  25. <script type="text/javascript" src="assets/dist/js/dataTables.bootstrap.min.js"></script>
  26. <script>
  27. $(document).ready(function() {
  28. $('#tabela').DataTable( {
  29. initComplete: function () {
  30.  
  31. var coluna_filtro = 0;
  32.  
  33. this.api().columns().every( function (mostra) {
  34.  
  35. var column = this;
  36. coluna_filtro += 1;
  37. if (coluna_filtro==4){
  38. var select = $('<select><option value=""></option></select>')
  39. .appendTo( $(column.footer()).empty() )
  40. .on( 'change', function () {
  41. var val = $.fn.dataTable.util.escapeRegex($(this).val());
  42.  
  43. column
  44. .search( val ? '^'+val+'$' : '', true, false )
  45. .draw();
  46. } );
  47.  
  48. column.data().unique().sort().each( function ( d, j ) {
  49. select.append( '<option value="'+d+'">'+d+'</option>' )
  50.  
  51. } );
  52. }
  53.  
  54. } );
  55. }
  56. } );
  57. } );
  58. </script>
  59. </head>
  60.  
  61. <body>
  62. <div class="container-fluid">
  63.  
  64.  
  65. <h2>DataTable Bootstrap com filtro em uma coluna (uma o mais colunas)</h2>
  66. <table id="tabela" class="table table-striped table-bordered" cellspacing="0"
  67. width="100%">
  68. <thead>
  69. <tr>
  70. <th>Nome</th>
  71. <th>eMail</th>
  72. <th>Celular</th>
  73. <th>Status</th>
  74. </tr>
  75. </thead>
  76. <tfoot>
  77. <tr>
  78. <th id="nome">Nome</th>
  79. <th id="email">eMail</th>
  80. <th id="cel">Celular</th>
  81. <th id="status">Status</th>
  82. </tr>
  83. </tfoot>
  84. <tbody>
  85. <tr>
  86. <td>Antonio</td>
  87. <td>email@teste1.com</td>
  88. <td>(92) 92929-2929</td>
  89. <td>Teste</td>
  90. </tr>
  91. <tr>
  92. <td>Pedro</td>
  93. <td>email@teste2.com</td>
  94. <td>(92) 3523-9299</td>
  95. <td>Ativo</td>
  96. </tr>
  97. <tr>
  98. <td>Pacheco</td>
  99. <td>email@teste3.com</td>
  100. <td>(92) 9292-4324</td>
  101. <td>Ativo</td>
  102. </tr>
  103. <tr>
  104. <td>Juca Pinto</td>
  105. <td>email@teste4.com</td>
  106. <td>(92) 5563-9299</td>
  107. <td>Ativo</td>
  108. </tr>
  109. <tr>
  110. <td>Marcos</td>
  111. <td>email@teste5.com</td>
  112. <td>(92) 92929-2929</td>
  113. <td>Inativo</td>
  114. </tr>
  115. <tr>
  116. <td>Silva Sauro</td>
  117. <td>email@teste6.com</td>
  118. <td>(92) 3224-9299</td>
  119. <td>Ativo</td>
  120. </tr>
  121. <tr>
  122. <td>Pafuncio</td>
  123. <td>email@teste7.com</td>
  124. <td>(92) 9292-1887</td>
  125. <td>Ativo</td>
  126. </tr>
  127. <tr>
  128. <td>Zeca Diabo</td>
  129. <td>email@teste8.com</td>
  130. <td>(92) 5563-9299</td>
  131. <td>Ativo</td>
  132. </tr>
  133. <tr>
  134. <td>Mauro</td>
  135. <td>email@teste9.com</td>
  136. <td>(92) 92929-2929</td>
  137. <td>Ativo</td>
  138. </tr>
  139. <tr>
  140. <td>Mauricio</td>
  141. <td>email@testea.com</td>
  142. <td>(92) 9292-9867</td>
  143. <td>Ativo</td>
  144. </tr>
  145. <tr>
  146. <td>Silvano</td>
  147. <td>email@testeb.com</td>
  148. <td>(92) 9292-9299</td>
  149. <td>Ativo</td>
  150. </tr>
  151. <tr>
  152. <td>Abelardo Pinto</td>
  153. <td>email@testec.com</td>
  154. <td>(92) 5563-9299</td>
  155. <td>Ativo</td>
  156. </tr>
  157. <tr>
  158. <td>Maciel</td>
  159. <td>email@tested.com</td>
  160. <td>(92) 92929-2929</td>
  161. <td>Inativo</td>
  162. </tr>
  163. <tr>
  164. <td>Justiniano Sauro</td>
  165. <td>email@testee.com</td>
  166. <td>(92) 9292-7465</td>
  167. <td>Ativo</td>
  168. </tr>
  169. <tr>
  170. <td>Gaucho da Fronteira</td>
  171. <td>email@testef.com</td>
  172. <td>(92) 9292-2775</td>
  173. <td>Ativo</td>
  174. </tr>
  175. <tr>
  176. <td>Pedro Pilintra</td>
  177. <td>email@testeg.com</td>
  178. <td>(92) 5563-9299</td>
  179. <td>Inativo</td>
  180. </tr>
  181. </tbody>
  182. </table>
  183. </div>
  184.  
  185. </div>
  186. </body>
  187.  
  188. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement