Foppe
/
afmeldingen


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
							<!doctype html>
<html lang="en">
<head>
	<!-- Required meta tags -->
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

	<!-- Bootstrap CSS -->
	<link rel="stylesheet" href="//stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">

	<title>Afmeldingen</title>
    <style>
        .container-fluid {
            /* reset width: 100% */
            width: auto;
            margin: 25px 50px;
            padding: 5px 10px;
        }
    </style>
</head>
<body>
<div class="container-fluid">
    <div class="row">
        <!-- <div class="col"> -->
            <h1>Afmeldingen</h1>
            <table class="table table-striped">
                <caption>Afmeldingen</caption>
                <thead>
                    <tr>
                        <th scope="col">#</th>
                        <th scope="col">datum</th>
                        <th scope="col">lijn</th>
                        <th scope="col">naam</th>
                        <th scope="col">afwezig</th>
                        <th scope="col">partner</th>
                        <th scope="col">invaller</th>
                        <th scope="col">email</th>
                        <th scope="col">opmerkingen</th>
                    </tr>
                </thead>
                <tbody>
                </tbody>
            </table>
        <!-- </div> -->
    </div>
</div>
<script
	src="//code.jquery.com/jquery-3.4.1.min.js"
	integrity="sha256-CSXorXvZcTkaix6Yvo6HppcZGetbYMGWSFlBw8HfCJo="
	crossorigin="anonymous"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="//stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
<script src="//momentjs.com/downloads/moment.min.js"></script>
<!--suppress JSUnresolvedVariable -->
<script>
    let _debug = false;
    function log(...text) {
        if (_debug) {
            return console.log(...text);
        }
    }
</script>
<script>
    _debug = true;
    $.getJSON('payload.json', (data) => {
        log(data);
        let c = (date) => {
            let regex = /^(\d{2})-(\d{2})-(\d{4})$/;
            let match = date.match(regex);
            let reversed_date = '1970-01-01';
            if (match) {
                let d = match[1];
                let m = match[2];
                let y = match[3];
                reversed_date = y + '-' + m + '-' + d;
            }
            return reversed_date;
        };
        // let c = comparable_date; // Abbreviation
        data.sort((a, b) => c(a.Datum) > c(b.Datum) ? 1 : (c(a.Datum) === c(b.Datum)) ? ((a.Lijn > b.Lijn) ? 1 : -1) : -1);
        let items = [];
        $.each(data, (key, val) => {
            log('key:', key, ' val:', val);
            log(c(val["Datum"])+' '+moment(c(val["Datum"]), 'YYYY-MM-DD').add(10, 'days').format('YYYY-MM-DD'));
            if (c(val["Datum"]) > moment(c(val["Datum"]), 'YYYY-MM-DD').add(10, 'days').format('YYYY-MM-DD')) {
                return;
            }
            items.push( "<tr>" );
            items.push( "<td scope=\"row\">" + (parseInt(key)+1) + "</td>" );
            items.push( "<td class=\""+key+"\">" + val["Datum"] + "</td>" );
            items.push( "<td class=\""+key+"\">" + val["Lijn"] + "</td>" );
            items.push( "<td class=\""+key+"\">" + val["Naam"] + "</td>" );
            items.push( "<td class=\""+key+"\">" + val["Afmelding/aanmelding"] + "</td>" );
            items.push( "<td class=\""+key+"\">" + val["Naam partner"] + "</td>" );
            items.push( "<td class=\""+key+"\">" + val["Naam invaller"] + "</td>" );
            items.push( "<td class=\""+key+"\">" + val["Email"] + "</td>" );
            items.push( "<td class=\""+key+"\">" + val["Toevoeging"] + "</td>" );
            items.push( "</tr>" );
        });
        $( "<tbody/>", {class: "mydata", html: items.join("")} ).appendTo( "table" );
    });
</script>
</body>
</html>