<?php
require_once 'common.php';
check_roostermaker($_GET['secret']);
$koppel_query = <<<EOQ
SELECT CONCAT('<span style="display: inline-block"><input type="checkbox" name="entity_ids[]" value="',
\tentities.entity_id, '"', CASE WHEN entity_active = 1 THEN ' checked' ELSE '' END, '>',
\tentity_name, '</input></span>')
FROM entities WHERE entity_type != %i AND entity_type != %i AND entity_type != 0
ORDER BY entity_type, entity_name
EOQ;
$entities = mdb2_col(0, $koppel_query, LEERLING, LESGROEP);
header("Content-Type: text/html; charset=UTF-8");
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="UTF-8">
<title>Verberg entities in lijst</title>
<link rel="stylesheet" href="css/ui-lightness/jquery-ui-1.10.4.custom.min.css">
<style type="text/css"><!--
body {
font-size: 10px;
}
#content {
font-size: 13px;
}
--></style>
<script type="text/javascript" src="js/jquery-1.11.1.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.10.4.custom.min.js"></script>
<script type="text/javascript">
$defaultuntil = '';
}
$koppel_query = <<<EOQ
SELECT CONCAT('<span style="display: inline-block"><input type="checkbox" name="entity_ids[]" value="',
\tentities.entity_id, '"', CASE WHEN bericht_id IS NOT NULL THEN ' checked' ELSE '' END, '>',
\tentity_name, '</input></span>')
FROM entities
LEFT JOIN entities2berichten ON entities2berichten.entity_id = entities.entity_id AND entities2berichten.bericht_id = %i
WHERE (entity_active = 1 OR entities2berichten.entity_id IS NOT NULL) AND entity_type = %i ORDER BY entity_name
EOQ;
$koppel_count_query = <<<EOQ
SELECT COUNT(*) FROM entities2berichten JOIN entities ON entities.entity_id = entities2berichten.entity_id WHERE bericht_id = %i AND entity_type = %i
EOQ;
$k_stamklassen = mdb2_col(0, $koppel_query, $bericht_id, STAMKLAS);
$k_lesgroepen = mdb2_col(0, $koppel_query, $bericht_id, LESGROEP);
$k_categorieen = mdb2_col(0, $koppel_query, $bericht_id, CATEGORIE);
$count_stamklassen = mdb2_single_val($koppel_count_query, $bericht_id, STAMKLAS);
$count_lesgroepen = mdb2_single_val($koppel_count_query, $bericht_id, LESGROEP);
$count_categorieen = mdb2_single_val($koppel_count_query, $bericht_id, CATEGORIE);
header("Content-Type: text/html; charset=UTF-8");
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="UTF-8">
<title>Bericht</title>
<link rel="stylesheet" href="css/ui-lightness/jquery-ui-1.10.4.custom.min.css">
<style type="text/css"><!--
body {
font-size: 10px;
}
