index.php 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  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. <!--suppress JSUnresolvedVariable -->
  44. <script>
  45. $.getJSON('payload.json', (data) => {
  46. console.log(data);
  47. data.sort((a, b) => a.Lijn > b.Lijn ? 1 : (a.Datum === b.Datum) ? ((a.Lijn > b.Lijn) ? 1 : -1) : -1);
  48. let items = [];
  49. $.each(data, (key, val) => {
  50. console.log('key:', key, ' val:', val);
  51. items.push( "<tr>" );
  52. items.push( "<td scope=\"row\">" + key+1 + "</td>" );
  53. items.push( "<td class=\""+key+"\">" + val["Datum"] + "</td>" );
  54. items.push( "<td class=\""+key+"\">" + val["Lijn"] + "</td>" );
  55. items.push( "<td class=\""+key+"\">" + val["Naam"] + "</td>" );
  56. items.push( "<td class=\""+key+"\">" + val["Afmelding/aanmelding"] + "</td>" );
  57. items.push( "<td class=\""+key+"\">" + val["Naam partner"] + "</td>" );
  58. items.push( "<td class=\""+key+"\">" + val["Naam invaller"] + "</td>" );
  59. items.push( "<td class=\""+key+"\">" + val["Email"] + "</td>" );
  60. items.push( "<td class=\""+key+"\">" + val["Toevoeging"] + "</td>" );
  61. items.push( "</tr>" );
  62. });
  63. $( "<tbody/>", {class: "mydata", html: items.join("")} ).appendTo( "table" );
  64. });
  65. </script>
  66. </body>
  67. </html>