index.php 3.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. <!doctype html>
  2. <html lang="en">
  3. <head>
  4. <!-- Required meta tags -->
  5. <meta charset="utf-8">
  6. <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  7. <!-- Bootstrap CSS -->
  8. <link rel="stylesheet" href="//stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
  9. <title>Hello, world!</title>
  10. </head>
  11. <body>
  12. <div class="container">
  13. <div class="row">
  14. <!-- <div class="col"> -->
  15. <h1>Afmeldingen</h1>
  16. <table class="table table-striped">
  17. <caption>Afmeldingen</caption>
  18. <thead>
  19. <tr>
  20. <th scope="col">#</th>
  21. <th scope="col">datum</th>
  22. <th scope="col">lijn</th>
  23. <th scope="col">naam</th>
  24. <th scope="col">afwezig</th>
  25. <th scope="col">partner</th>
  26. <th scope="col">invaller</th>
  27. <th scope="col">email</th>
  28. <th scope="col">opmerkingen</th>
  29. </tr>
  30. </thead>
  31. <tbody>
  32. </tbody>
  33. </table>
  34. <!-- </div> -->
  35. </div>
  36. </div>
  37. <script
  38. src="//code.jquery.com/jquery-3.4.1.min.js"
  39. integrity="sha256-CSXorXvZcTkaix6Yvo6HppcZGetbYMGWSFlBw8HfCJo="
  40. crossorigin="anonymous"></script>
  41. <script src="//cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
  42. <script src="//stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
  43. <script>
  44. $.getJSON('payload.json', (data) => {
  45. console.log(data);
  46. data.sort((a, b) => a.Lijn > b.Lijn ? 1 : -1);
  47. let items = [];
  48. $.each(data, (key, val) => {
  49. console.log('key:', key, ' val:', val);
  50. items.push( "<tr>" );
  51. items.push( "<td scope=\"row\">" + key+1 + "</td>" );
  52. items.push( "<td class=\""+key+"\">" + val["Datum"] + "</td>" );
  53. items.push( "<td class=\""+key+"\">" + val["Lijn"] + "</td>" );
  54. items.push( "<td class=\""+key+"\">" + val["Naam"] + "</td>" );
  55. items.push( "<td class=\""+key+"\">" + val["Afmelding/aanmelding"] + "</td>" );
  56. items.push( "<td class=\""+key+"\">" + val["Naam partner"] + "</td>" );
  57. items.push( "<td class=\""+key+"\">" + val["Naam invaller"] + "</td>" );
  58. items.push( "<td class=\""+key+"\">" + val["Email"] + "</td>" );
  59. items.push( "<td class=\""+key+"\">" + val["Toevoeging"] + "</td>" );
  60. items.push( "</tr>" );
  61. });
  62. $( "<tbody/>", {class: "mydata", html: items.join("")} ).appendTo( "table" );
  63. });
  64. </script>
  65. </body>
  66. </html>